I_PurgDocumentPartnerEnh

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_PurgDocumentPartnerEnh.
-- 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: IPURGDOCPARTNENH

CREATE VIEW I_PurgDocumentPartnerEnh AS
SELECT
  I_PurchasingDocumentPartner.PurchasingDocument AS PurchasingDocument,
  I_PurchasingDocumentPartner.PurchasingDocumentItem AS PurchasingDocumentItem,
  I_PurchasingDocumentPartner.PurchasingOrganization AS PurchasingOrganization,
  I_PurchasingDocumentPartner.SupplierSubrange AS SupplierSubrange,
  I_PurchasingDocumentPartner.Plant AS Plant,
  I_PurchasingDocumentPartner.PartnerFunction AS PartnerFunction,
  I_PurchasingDocumentPartner.PartnerCounter AS PartnerCounter,
  I_PurchasingDocumentPartner.PurchasingDocumentCategory AS PurchasingDocumentCategory,
  I_PurchasingDocumentPartner.PurchasingDocumentType AS PurchasingDocumentType,
  I_PurchasingDocumentPartner.CreatedByUser AS CreatedByUser,
  I_PurchasingDocumentPartner.CreationDate AS CreationDate,
  PurchasingDocumentPartnerType,
  I_PurchasingDocumentPartner.Supplier AS Supplier,
  I_PurchasingDocumentPartner.SupplierContact AS SupplierContact,
  I_PurchasingDocumentPartner.PersonWorkAgreement AS PersonWorkAgreement,
  I_PurchasingDocumentPartner.EmploymentInternalID AS EmploymentInternalID,
  I_PurchasingDocumentPartner.DefaultPartner AS DefaultPartner
FROM I_PurchasingDocumentPartner
LEFT OUTER JOIN I_SuplrContactCard AS _SupplierContactCard ON _SupplierContactCard.ContactCardID = Supplier  -- association [0..1]
LEFT OUTER JOIN P_ContactCardSupplierContact AS _ContactCardSupplierContact ON _ContactCardSupplierContact.ContactCardSemanticObjectType = 'SupplierContact' AND _ContactCardSupplierContact.ContactCardSemanticObjectID = SupplierContact AND _ContactCardSupplierContact.ContactCardType = 'SupplierContact'  -- association [0..1]
LEFT OUTER JOIN I_PartnerTypeText AS _PartnerTypeText ON _PartnerTypeText.PurchasingDocumentPartnerType = PurchasingDocumentPartnerType  -- association [0..*]
;