I_CustProjSlsOrdPartner

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_CustProjSlsOrdPartner.
-- 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.
-- SQL view name: ICUSTPROJSOHP

CREATE VIEW I_CustProjSlsOrdPartner AS
SELECT
  CustProjSlsOrd.CustomerProject AS CustomerProject,
  SalesOrderPartner.PartnerFunction AS PartnerFunction,
  SalesOrderPartner.SalesOrder AS SalesOrder,
  SalesOrderPartner.Partner AS Partner,
  SalesOrderPartner.ContactPerson AS ContactPerson,
  SalesOrderPartner.AddressID AS AddressID,
  SalesOrderPartner.AddressPersonID AS AddressPersonID,
  SalesOrderPartner.AddressObjectType AS AddressObjectType,
  SalesOrderPartner.SDDocPartnerAddressRefType AS SDDocPartnerAddressRefType,
  SalesOrderPartner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  SalesOrderPartner.BPAddrDeterminationTransaction AS BPAddrDeterminationTransaction,
  SalesOrderPartner.BPRefAddressIDForDocSpcfcAddr AS BPRefAddressIDForDocSpcfcAddr,
  CustProjSlsOrd.SalesOrderType AS SalesOrderType,
  CustProjSlsOrd.OrganizationDivision AS OrganizationDivision,
  CustProjSlsOrd.SalesOrganization AS SalesOrganization,
  CustProjSlsOrd.DistributionChannel AS DistributionChannel,
  SalesOrderPartner._PartnerFunction AS _PartnerFunction,
  SalesOrderPartner._Address AS _Address,
  SalesOrderPartner._DfltAddrRprstn AS _DfltAddrRprstn,
  SalesOrderPartner._BusinessPartnerAddress AS _BusinessPartnerAddress,
  SalesOrderPartner._BPRefAddressForDocSpcfcAddr AS _BPRefAddressForDocSpcfcAddr
FROM I_SalesOrderPartner AS SalesOrderPartner
INNER JOIN I_CustProjSlsOrd AS CustProjSlsOrd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [1..1]
LEFT OUTER JOIN I_CustProjSlsOrd AS _CustProjSlsOrd ON CustomerProject = _CustProjSlsOrd.CustomerProject  -- association [1..1]
LEFT OUTER JOIN I_CustomerProject AS _CustomerProject ON CustomerProject = _CustomerProject.CustomerProject  -- association [1..1]
;