C_CntrlPurContrItmDistr

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_CntrlPurContrItmDistr.
-- 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: CCNTRLPCITMDIS

CREATE VIEW C_CntrlPurContrItmDistr AS
SELECT
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  DistributionKey,
  _CentralPurchaseContract.ActivePurchasingDocument AS ActivePurchasingDocument,
  cast (concat(concat(_CentralPurchaseContract.ActivePurchasingDocument, '/'), CentralPurchaseContractItem) as formattedcontractitem) AS FormattedPurchaseContractItem,
  PurchasingDocumentCategory AS ProcmtHubPurgDocItmCategory,
  DistributionType,
  CntrlPurContrDistributionPct,
  CntrlPurContrDistributionPct AS CntrlPurContrItmDistrPct,
  '0.000' AS CntrlPurContrGRConsumptionPct,
  TargetQuantity,
  CompanyCode AS ProcmtHubCompanyCode,
  Plant,
  PurchasingDocumentType AS PurgDocumentDistributionType,
  PurchasingOrganization AS ProcmtHubPurchasingOrg,
  PurchasingGroup AS ProcmtHubPurchasingGroup,
  StorageLocation,
  PaymentTerms,
  PurchasingInfoRecordUpdateCode,
  CntrlPurContrItmDistrIsBlocked,
  ReferenceHeaderDistributionKey,
  cast ( '' as abap.char(10) ) AS CntrlPurContrDistributionLevel,
  OrderQuantityUnit AS PurchaseOrderQuantityUnit,
  LogicalSystem,
  IncotermsClassification,
  IncotermsLocation1,
  _PurgDocumentCatText.PurchasingDocumentCategoryName AS PurchasingDocumentCategoryName,
  _PurgDocumentCatText.Language AS Language,
  _CntrlPurContrDistrTypeVH.PurgDocDistributionTypeDesc AS PurgDocDistributionTypeDesc,
  ProcurementHubSourceSystem,
  _ProcmtHubCompanyCodeVH.ProcmtHubCompanyCodeName AS CompanyCodeName,
  _ProcmtHubPlantVH.ProcmtHubPlantName AS PurOrdItemPlantName,
  _ProcmtHubSchedgAgrmtTypeVH.PurchasingDocumentTypeName AS MKT_AgreementTypeName,
  _ProcmtHubPurgOrgVH.ProcmtHubPurgOrgName AS ComparisonPurchasingOrgName,
  _PurchasingGroupValueHelp.PurchasingGroupName AS ComparisonPurchasingGroupName,
  _ProcmtHubStorageLocationVH.StorageLocationName AS StorageLocationName,
  SourceListIsUpdated,
  TargetAmount,
  Currency,
  _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,
  _CntrlPurchaseContractItem.PurchasingCentralMaterial AS Material,
  _CntrlPurchaseContractItem.MaterialGroup AS MaterialGroup,
  _CntrlPurchaseContractItem.ProductType AS ProductType,
  _CntrlPurchaseContractItem.ProductTypeCode 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 xfeld) AS ContrItmDistrIsCreated,
  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 I_CntrlPurContrDistrTypeText AS _CntrlPurContrDistrTypeVH ON _CntrlPurContrDistrTypeVH.DistributionType = DistributionType AND _CntrlPurContrDistrTypeVH.Language = $session.system_language  -- 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 [0..1]
LEFT OUTER JOIN C_ProcmtHubPurgOrgVH AS _ProcmtHubPurgOrgVH ON _ProcmtHubPurgOrgVH.ProcmtHubPurchasingOrg = ProcmtHubPurchasingOrg AND _ProcmtHubPurgOrgVH.ProcurementHubSourceSystem = ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_PurchasingGroupValueHelp AS _PurchasingGroupValueHelp ON _PurchasingGroupValueHelp.PurchasingGroup = ProcmtHubPurchasingGroup  -- association [0..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]
LEFT OUTER JOIN E_CntrlPurContrDistribution AS _CntrlPurContrItmDistExtension ON _CntrlPurContrItmDistExtension.PurchasingDocument = CentralPurchaseContract AND _CntrlPurContrItmDistExtension.PurchasingDocumentItem = CentralPurchaseContractItem AND _CntrlPurContrItmDistExtension.DistributionKey = DistributionKey  -- association [1..1]
;