A_CePuCoDistrdOutlineAgrmt

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 A_CePuCoDistrdOutlineAgrmt.
-- 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: ACNTRLPCDISTROA

CREATE VIEW A_CePuCoDistrdOutlineAgrmt AS
SELECT
  CentralPurchaseContract,
  ExtContractForPurg,
  ProcurementHubSourceSystem,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  PaymentTerms,
  Currency,
  PurgDocItemDistributionStatus,
  SourceListIsUpdated,
  SourceListChangeConfStatus
FROM I_CntrlPurContrDistribution
LEFT OUTER JOIN A_CentralPurchaseContract AS _CentralPurchaseContract ON CentralPurchaseContract = _CentralPurchaseContract.CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN A_CePuCoDistrdContrPaytTrms AS _DistributedPaymentTerms ON CentralPurchaseContract = _DistributedPaymentTerms.CentralPurchaseContract AND ExtContractForPurg = _DistributedPaymentTerms.ExtContractForPurg AND ProcurementHubSourceSystem = _DistributedPaymentTerms.ProcurementHubSourceSystem  -- association [1..1]
;