I_SchedgAgrmtPartner

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_SchedgAgrmtPartner.
-- 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: ISCHDGAGRMTPRTNR

CREATE VIEW I_SchedgAgrmtPartner AS
SELECT
  Partner.PurchasingDocument AS SchedulingAgreement,
  Partner.PurchasingDocumentItem AS SchedulingAgreementItem,
  Partner.PurchasingOrganization AS PurchasingOrganization,
  Partner.SupplierSubrange AS SupplierSubrange,
  Partner.Plant AS Plant,
  Partner.PartnerFunction AS PartnerFunction,
  Partner.PartnerCounter AS PartnerCounter,
  Partner.PurchasingDocumentPartner AS SchedgAgrmtPartner,
  Partner.PurchasingDocumentPartnerName AS SchedgAgrmtPartnerName,
  Partner.PurchasingDocumentCategory AS SchedgAgrmtCategory,
  Partner.PurchasingDocumentType AS SchedgAgrmtType,
  Partner.CreatedByUser AS CreatedByUser,
  Partner.CreationDate AS CreationDate,
  Partner.Supplier AS Supplier,
  Partner.SupplierContact AS SupplierContact,
  Partner.EmploymentInternalID AS EmploymentInternalID,
  Partner.PersonWorkAgreement AS PersonWorkAgreement,
  Partner.DefaultPartner AS DefaultPartner,
  Partner._PartnerFunction AS _PartnerFunction,
  Partner._PartnerFunctionText AS _PartnerFunctionText,
  Partner._PersonWorkAgreement AS _PersonWorkAgreement,
  Partner._Plant AS _Plant,
  Partner._PurchasingDocument AS _PurchasingDocument,
  Partner._PurchasingDocumentItem AS _PurchasingDocumentItem,
  Partner._PurchasingOrganization AS _PurchasingOrganization,
  Partner._Supplier AS _Supplier,
  Partner._SupplierContact AS _SupplierContact,
  _Schedgagrmthdr.PurchasingGroup AS PurchasingGroup,
  _Schedgagrmthdr.PurchasingDocumentType AS PurchasingDocumentType
FROM I_PurgDocumentPartnerEnh AS Partner
INNER JOIN I_Schedgagrmthdr ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Schedgagrmthdr AS _Schedgagrmthdr ON _Schedgagrmthdr.SchedulingAgreement = SchedulingAgreement  -- association [1..1]
LEFT OUTER JOIN I_SchedgAgrmtItm AS _SchedgAgrmtItm ON _SchedgAgrmtItm.SchedulingAgreement = SchedulingAgreement AND _SchedgAgrmtItm.SchedulingAgreementItem = SchedulingAgreementItem  -- association [0..1]
;