C_CntrlPurContrHdrDistr

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_CntrlPurContrHdrDistr.
-- 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: CCNTRLPCHDRDIS

CREATE VIEW C_CntrlPurContrHdrDistr AS
SELECT
  CentralPurchaseContract,
  DistributionKey,
  _CentralPurchaseContract.ActivePurchasingDocument AS ActivePurchasingDocument,
  PurchasingDocumentCategory AS ProcmtHubPurgDocItmCategory,
  CntrlPurContrDistributionPct,
  CntrlPurContrDistributionPct AS CntrlPurContrItmDistrPct,
  '0.000' AS CntrlPurContrGRConsumptionPct,
  PurchasingOrganization AS ProcmtHubPurchasingOrg,
  CompanyCode AS ProcmtHubCompanyCode,
  Plant,
  StorageLocation,
  PurchasingDocumentType AS PurgDocumentDistributionType,
  PurchasingGroup AS ProcmtHubPurchasingGroup,
  ReferenceHeaderDistributionKey,
  PurchasingInfoRecordUpdateCode,
  Currency,
  PaymentTerms,
  LogicalSystem,
  ProcurementHubSourceSystem,
  cast(' ' as mmpur_d_source_sys ) AS ProcurementHubSourceSystemName,
  _PurgDocumentCatText.PurchasingDocumentCategoryName AS PurchasingDocumentCategoryName,
  _ProcmtHubPurgOrgVH.ProcmtHubPurgOrgName AS ProcmtHubPurgOrgName,
  _ProcmtHubCompanyCodeVH.ProcmtHubCompanyCodeName AS ProcmtHubCompanyCodeName,
  _ProcmtHubPlantVH.ProcmtHubPlantName AS ProcmtHubPlantName,
  _ProcmtHubStorageLocationVH.StorageLocationName AS StorageLocationName,
  _ProcmtHubSchedgAgrmtTypeVH.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  _ProcmtHubPurgGrpVH.PurchasingGroupName AS PurchasingGroupName,
  SourceListIsUpdated,
  _CentralPurchaseContract.Supplier AS Supplier,
  _CentralPurchaseContract.PurchasingOrganization AS PurchasingOrganization,
  _CentralPurchaseContract.PurchasingGroup AS PurchasingGroup,
  _CentralPurchaseContract.CompanyCode AS CompanyCode,
  _CentralPurchaseContractTP.PurchasingProcessingStatus AS CntrlPurContrOvrlDistrStsTxt,
  _CentralPurchaseContractTP.CntrlPurContrOvrlDistrStsTxt AS PurchasingProcessingStatus,
  _CentralPurchaseContractTP.PurchasingProcessingStatus AS PurchasingDocumentStatus,
  _CentralPurchaseContract.ValidityEndDate AS ValidityEndDate,
  _CentralPurchaseContract.ValidityStartDate AS ValidityStartDate,
  _CentralPurchaseContract.PurchaseContractType AS PurchaseContractType,
  cast ('' as matnr) AS Material,
  cast ('' as matkl) AS MaterialGroup,
  cast ('' as producttype) AS ProductType,
  cast ('' as product_type) AS ProductTypeCode,
  cast ('' as abap.char( 120 )) AS InternalComment,
  cast ('' as abap.sstring( 1332 )) AS PurchasingDocInclusionList,
  cast ('' as abap.sstring( 1332 )) AS PurchasingDocExclusionList,
  cast ('' as abap.char( 1 )) AS PurOrdItemsAreSelected,
  cast ('' as abap.char( 1 )) AS PurOrdHeadersAreSelected,
  cast ('' as xfeld) AS ContrHdrDistrIsCreated,
  cast(IsDeleted as boolean) AS TextIsDeleted,
  cast( ' ' as rscod ) AS PurchasingDocVersionReasonCode,
  _PurchaseNote.Content AS PurgDocNoteText
FROM I_CntrlPurContrDistribution
LEFT OUTER JOIN I_PurgDocumentCategoryText AS _PurgDocumentCatText ON ProcmtHubPurgDocItmCategory = _PurgDocumentCatText.PurchasingDocumentCategory AND _PurgDocumentCatText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubSchedgAgrmtTypeVH AS _ProcmtHubSchedgAgrmtTypeVH ON _ProcmtHubSchedgAgrmtTypeVH.PurchasingDocumentType = PurgDocumentDistributionType AND _ProcmtHubSchedgAgrmtTypeVH.LogicalSystem = LogicalSystem  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubCompanyCodeVH AS _ProcmtHubCompanyCodeVH ON _ProcmtHubCompanyCodeVH.ProcmtHubCompanyCode = ProcmtHubCompanyCode AND _ProcmtHubCompanyCodeVH.ProcurementHubSourceSystem = ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubPlantVH AS _ProcmtHubPlantVH ON _ProcmtHubPlantVH.ProcmtHubPlant = Plant AND _ProcmtHubPlantVH.ProcmtHubCompanyCode = ProcmtHubCompanyCode AND _ProcmtHubPlantVH.ProcurementHubSourceSystem = ProcurementHubSourceSystem  -- association [1..1]
LEFT OUTER JOIN C_ProcmtHubPurgOrgVH AS _ProcmtHubPurgOrgVH ON _ProcmtHubPurgOrgVH.ProcmtHubPurchasingOrg = ProcmtHubPurchasingOrg AND _ProcmtHubPurgOrgVH.ProcurementHubSourceSystem = ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubCntrlContrPurgGrpVH AS _ProcmtHubPurgGrpVH ON _ProcmtHubPurgGrpVH.PurchasingGroup = ProcmtHubPurchasingGroup AND _ProcmtHubPurgGrpVH.ProcurementHubSourceSystem = ProcurementHubSourceSystem  -- association [1..1]
LEFT OUTER JOIN C_ProcmtHubStorageLocationVH AS _ProcmtHubStorageLocationVH ON _ProcmtHubStorageLocationVH.StorageLocation = StorageLocation AND _ProcmtHubStorageLocationVH.Plant = Plant AND _ProcmtHubStorageLocationVH.ProcurementHubSourceSystem = ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_CentralPurchaseContractTP AS _CentralPurchaseContractTP ON CentralPurchaseContract = _CentralPurchaseContractTP.CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN I_PurgInfoRecordUpdateCode AS _PurgInfoRecordUpdateCode ON PurchasingInfoRecordUpdateCode = _PurgInfoRecordUpdateCode.PurchasingInfoRecordUpdateCode  -- association [1..1]
LEFT OUTER JOIN P_SGBT_NTE_CDS_APITP AS _PurchaseNote ON CentralPurchaseContract = _PurchaseNote.ObjectID AND _PurchaseNote.ObjectNodeType = 'CentralPurchaseContract' AND _PurchaseNote.NoteType = 'CH16' AND _PurchaseNote.LanguageCode = $session.system_language  -- association [0..1]
;