I_CustMgmtPartner

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CustMgmtPartner.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_CustMgmtPartner AS
SELECT
  objtype_h AS CustMgmtObjectType,
  object_id AS CustMgmtDocument,
  number_int AS CustMgmtDocumentItem,
  partner_fct AS CustMgmtPartnerFunction,
  partner_no AS CustMgmtPartner,
  no_type AS CustMgmtPartnerNumberType,
  partner_pft AS CustMgmtPartFunctionCategory,
  partner_id AS CustMgmtBusinessPartner,
  mainpartner AS CustMgmtPartnerIsMainPartner,
  addr_nr AS AddressID,
  addr_np AS AddressPersonID,
  addr_type AS AddressObjectType
FROM crms4d_partner
LEFT OUTER JOIN I_BusinessObjType AS _CustMgmtObjectType ON CustMgmtObjectType = _CustMgmtObjectType.BusinessObjectType  -- association [1..1]
LEFT OUTER JOIN I_CustMgmtPartnerFuncText AS _PartnerFunction ON CustMgmtPartnerFunction = _PartnerFunction.PartnerFunction  -- association [0..*]
LEFT OUTER JOIN I_BusinessPartner AS _BusinessPartner ON CustMgmtBusinessPartner = _BusinessPartner.BusinessPartner  -- association [0..1]
;