I_SalesDocumentPartner

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_SalesDocumentPartner.
-- 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_SalesDocumentPartner AS
SELECT
  cast(Partner.SDDocument as vbeln_va preserving type) AS SalesDocument,
  Partner.PartnerFunction AS PartnerFunction,
  Partner.Customer AS Customer,
  Partner.Supplier AS Supplier,
  Partner.Personnel AS Personnel,
  Partner.AddressID AS AddressID,
  Partner.AddressPersonID AS AddressPersonID,
  Partner.AddressObjectType AS AddressObjectType,
  Partner.SDDocPartnerAddrIsDocSpecific AS SDDocPartnerAddrIsDocSpecific,
  Partner.SDDocPartnerAddressRefType AS SDDocPartnerAddressRefType,
  Partner.BPAddrDeterminationTransaction AS BPAddrDeterminationTransaction,
  Partner.BPRefAddressIDForDocSpcfcAddr AS BPRefAddressIDForDocSpcfcAddr,
  Partner.ContactPerson AS ContactPerson,
  Partner.ReferenceBusinessPartner AS ReferenceBusinessPartner,
  Partner.VATRegistration AS VATRegistration,
  Partner.UnloadingPointName AS UnloadingPointName,
  SalesDocument.SDDocumentCategory AS SDDocumentCategory,
  case when Partner.Customer != '' then Partner.Customer when Partner.Supplier != '' then Partner.Supplier when Partner.Personnel != '00000000' then cast(Partner.Personnel as kunnr) when Partner.ContactPerson != '0000000000' then cast(Partner.ContactPerson as kunnr) else '' end as Partner AS ContactPersonaskunnrelseendasPartner,
  Partner._PartnerFunction AS _PartnerFunction,
  Partner._Address AS _Address,
  Partner._DfltAddrRprstn AS _DfltAddrRprstn,
  Partner._BusinessPartnerAddress AS _BusinessPartnerAddress,
  Partner._BPRefAddressForDocSpcfcAddr AS _BPRefAddressForDocSpcfcAddr,
  Partner._ContactPerson AS _ContactPerson,
  SalesDocument._SDDocumentCategory AS _SDDocumentCategory
FROM I_SDDocumentPartner AS Partner
INNER JOIN I_SalesDocumentBasic AS SalesDocument ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_WorkAssignment AS _WorkAssignment ON Personnel = _WorkAssignment.WorkAssignment  -- association [1]
LEFT OUTER JOIN I_OrganizationAddress AS _OrganizationAddress ON AddressID = _OrganizationAddress.AddressID AND AddressPersonID = _OrganizationAddress.AddressPersonID AND AddressObjectType = '1' AND _OrganizationAddress.AddressRepresentationCode is initial  -- association [0..1]
LEFT OUTER JOIN I_PersonAddress AS _PersonAddress ON AddressID = _PersonAddress.AddressID AND AddressPersonID = _PersonAddress.AddressPersonID AND AddressObjectType = '2' AND _PersonAddress.AddressRepresentationCode is initial  -- association [0..1]
LEFT OUTER JOIN I_PersonWorkplaceAddress AS _PersonWorkplaceAddress ON AddressID = _PersonWorkplaceAddress.AddressID AND AddressPersonID = _PersonWorkplaceAddress.AddressPersonID AND AddressObjectType = '3' AND _PersonWorkplaceAddress.AddressRepresentationCode is initial  -- association [0..1]
LEFT OUTER JOIN I_AddrOrgNamePostalAddress AS _OrgNamePostalAddress ON AddressID = _OrgNamePostalAddress.AddressID AND _OrgNamePostalAddress.AddressRepresentationCode is initial  -- association [0..1]
LEFT OUTER JOIN I_AddressPersonName AS _PersonName ON AddressPersonID = _PersonName.AddressPersonID AND _PersonName.AddressRepresentationCode is initial  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDfltLandlinePhoneNmbr AS _CurrentDfltLandlinePhoneNmbr ON AddressID = _CurrentDfltLandlinePhoneNmbr.AddressID AND AddressPersonID = _CurrentDfltLandlinePhoneNmbr.AddressPersonID  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDefaultEmailAddress AS _CurrentDfltEmailAddress ON AddressID = _CurrentDfltEmailAddress.AddressID AND AddressPersonID = _CurrentDfltEmailAddress.AddressPersonID  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDfltMobilePhoneNumber AS _CurrentDfltMobilePhoneNumber ON AddressID = _CurrentDfltMobilePhoneNumber.AddressID AND AddressPersonID = _CurrentDfltMobilePhoneNumber.AddressPersonID  -- association [0..1]
LEFT OUTER JOIN I_AddrCurDefaultFaxNumber AS _CurrentDfltFaxNumber ON AddressID = _CurrentDfltFaxNumber.AddressID AND AddressPersonID = _CurrentDfltFaxNumber.AddressPersonID  -- association [0..1]
;