P_SuplrCoCodePurgOrganization

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 P_SuplrCoCodePurgOrganization.
-- 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: PSUPPCOCOPUOR

CREATE VIEW P_SuplrCoCodePurgOrganization AS
SELECT
  _SupplierPurchasingOrg.Supplier AS Supplier,
  _SupplierCompany.CompanyCode AS CompanyCode,
  _SupplierPurchasingOrg.PurchasingOrganization AS PurchasingOrganization,
  _SupplierPurchasingOrg.PurOrdAutoGenerationIsAllowed AS PurOrdAutoGenerationIsAllowed,
  _SupplierPurchasingOrg.PurchasingGroup AS PurchasingGroup,
  cast (_SupplierPurchasingOrg.PaymentTerms as farp_dzterm_po preserving type) AS SupplierPurgOrgPaymentTerms,
  _SupplierPurchasingOrg.PurchasingIsBlockedForSupplier AS PurchasingIsBlockedForSupplier,
  cast (_SupplierPurchasingOrg.DeletionIndicator as supplist_loevm_m preserving type) AS SuplrIsDeltdPurgOrg,
  _SupplierPurchasingOrg.InvoiceIsGoodsReceiptBased AS InvoiceIsGoodsReceiptBased,
  _SupplierPurchasingOrg.PurchaseOrderCurrency AS PurchaseOrderCurrency,
  _SupplierPurchasingOrg.IncotermsClassification AS IncotermsClassification,
  _SupplierPurchasingOrg.IncotermsTransferLocation AS IncotermsTransferLocation,
  _SupplierPurchasingOrg._IncotermsClassification AS SupplierasSupplier,
  _SupplierPurchasingOrg._IncotermsClassification AS _IncotermsClassification
FROM I_SupplierPurchasingOrg AS _SupplierPurchasingOrg
INNER JOIN I_PurchasingOrganization AS _PurchasingOrgWithCoCode ON /* join condition not captured in parsed metadata */
INNER JOIN P_PlntCompanyCodePurchasingOrg AS _PlantCoCode ON /* join condition not captured in parsed metadata */
INNER JOIN I_SupplierCompany AS _SupplierCompany ON /* join condition not captured in parsed metadata */
INNER JOIN I_SupplierPurchasingOrg AS _SupplierPurchasingOrg ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_PlntCompanyCodePurchasingOrg AS _PlantCoCode ON _PlantCoCode.PurchasingOrganization = _SupplierPurchasingOrg.PurchasingOrganization  -- association [0..1]
-- UNION ALL with additional select branch(es): I_PurchasingOrganization, I_SupplierCompany
;