C_CntrlPurContrHdrDistrTP

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 C_CntrlPurContrHdrDistrTP.
-- 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: CCNTRLPCHDRDISTR

CREATE VIEW C_CntrlPurContrHdrDistrTP AS
SELECT
  CentralPurchaseContract,
  DistributionKey,
  CentralPurchaseContractItem,
  _CentralPurchaseContract.ActivePurchasingDocument AS ActivePurchasingDocument,
  _CentralPurchaseContract.PurchasingDocumentName AS PurchasingDocumentName,
  _CentralPurchaseContract.PurgDocChangeRequestStatus AS PurgDocChangeRequestStatus,
  PurchasingDocumentCategory,
  PurchasingDocumentType,
  PurchasingInfoRecordUpdateCode,
  PurchasingOrganization,
  CompanyCode,
  Plant,
  StorageLocation,
  DocumentCurrency,
  Currency,
  PurchasingGroup,
  SourceListIsUpdated,
  SourceListRestriction,
  LogicalSystem,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  ShippingInstruction,
  IncotermsClassification,
  IncotermsLocation1,
  CntrlPurContrDistributionPct,
  TargetAmount,
  cast(IsDeleted as boolean) AS TextIsDeleted,
  ProcurementHubSourceSystem,
  ProcurementHubSourceSystem AS ProcmtHubLogicalSystem
FROM I_CntrlPurContrHdrDistrTP
LEFT OUTER JOIN C_CentralPurchaseContractTP AS _CentralPurchaseContractTP ON _CentralPurchaseContractTP.CentralPurchaseContract = CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN C_ProcmtHubPlantVH AS _ProcmtHubPlantVH ON _ProcmtHubPlantVH.ProcmtHubPlant = Plant AND _ProcmtHubPlantVH.ProcurementHubSourceSystem = ProcurementHubSourceSystem AND _ProcmtHubPlantVH.ProcmtHubCompanyCode = CompanyCode  -- association [1..1]
LEFT OUTER JOIN C_ProcmtHubStorageLocationVH AS _ProcmtHubSLocVH ON _ProcmtHubSLocVH.Plant = Plant AND _ProcmtHubSLocVH.StorageLocation = StorageLocation AND _ProcmtHubSLocVH.ProcurementHubSourceSystem = ProcurementHubSourceSystem  -- association [1..1]
LEFT OUTER JOIN C_ProcmtHubCntrlContrPurgGrpVH AS _ProcmtHubPurgGrpVH ON _ProcmtHubPurgGrpVH.PurchasingGroup = PurchasingGroup AND _ProcmtHubPurgGrpVH.ProcurementHubSourceSystem = ProcurementHubSourceSystem  -- association [1..1]
LEFT OUTER JOIN C_ProcmtHubPurgOrgVH AS _ProcmtHubPurgOrgVH ON _ProcmtHubPurgOrgVH.ProcmtHubPurchasingOrg = PurchasingOrganization AND _ProcmtHubPurgOrgVH.ProcurementHubSourceSystem = ProcurementHubSourceSystem  -- association [1..1]
LEFT OUTER JOIN I_PaymentTermsText AS _PaymentTermsText ON PaymentTerms = _PaymentTermsText.PaymentTerms  -- association [0..*]
LEFT OUTER JOIN C_CntrlPurContrHdrPartnerTP AS _CntrlPurContrHdrPartnerTP ON CentralPurchaseContract = _CntrlPurContrHdrPartnerTP.CentralPurchaseContract AND DistributionKey = _CntrlPurContrHdrPartnerTP.DistributionKey  -- association [0..*]
LEFT OUTER JOIN C_CntrlPurContrHdrDistrAddrTP AS _CntrlPurContrHdrDistrAddrTP ON CentralPurchaseContract = _CntrlPurContrHdrDistrAddrTP.CentralPurchaseContract AND DistributionKey = _CntrlPurContrHdrDistrAddrTP.DistributionKey  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubSchedgAgrmtTypeVH AS _ProcmtHubSchedgAgrmtTypeVH ON _ProcmtHubSchedgAgrmtTypeVH.PurchasingDocumentType = PurchasingDocumentType AND _ProcmtHubSchedgAgrmtTypeVH.ProcurementHubSourceSystem = ProcurementHubSourceSystem  -- association [1..1]
LEFT OUTER JOIN R_CentralPurchaseContract AS _CentralPurchaseContract ON CentralPurchaseContract = _CentralPurchaseContract.CentralPurchaseContract  -- association [1..1]
;