C_CntrlPurContrHierHdrDistrTP

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_CntrlPurContrHierHdrDistrTP.
-- 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: CPCHIERHDRDISTR

CREATE VIEW C_CntrlPurContrHierHdrDistrTP AS
SELECT
  CentralPurchaseContract,
  DistributionKey,
  ProcmtHubCompanyCodeGroupingID,
  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 AS CntrlPurContrHdrDistrTP
LEFT OUTER JOIN C_CntrlPurContrHierHdrTP 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 _ProcmtHubStorageLocationVH ON _ProcmtHubStorageLocationVH.Plant = Plant AND _ProcmtHubStorageLocationVH.StorageLocation = StorageLocation AND _ProcmtHubStorageLocationVH.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 I_Currency AS _DocumentCurrency ON _DocumentCurrency.Currency = Currency  -- association [0..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_CntrlPurContrHierHdrPartTP AS _CntrlPurContrHdrPartnerTP ON CentralPurchaseContract = _CntrlPurContrHdrPartnerTP.CentralPurchaseContract AND DistributionKey = _CntrlPurContrHdrPartnerTP.DistributionKey  -- association [0..*]
LEFT OUTER JOIN C_PurgDocCatForOutlineAgrmtVH AS _PurgDocCatForOutlineAgrmtVH ON _PurgDocCatForOutlineAgrmtVH.PurchasingDocumentCategory = PurchasingDocumentCategory  -- 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]
;