C_CPurConHierItmDistrMassUpdt

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_CPurConHierItmDistrMassUpdt.
-- 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: CHCTRITMDISTMU

CREATE VIEW C_CPurConHierItmDistrMassUpdt AS
SELECT
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  DistributionKey AS PurgDocItemDistributionKey,
  _CentralPurchaseContract.ActivePurchasingDocument AS ActivePurchasingDocument,
  cast (concat(concat(_CentralPurchaseContract.ActivePurchasingDocument, '/'), CentralPurchaseContractItem) as formattedcontractitem) AS FormattedPurchaseContractItem,
  PurchasingDocumentCategory AS ProcmtHubPurgDocItmCategory,
  DistributionType,
  CntrlPurContrDistributionPct,
  CntrlPurContrDistributionPct AS CntrlPurContrItmDistrPct,
  cast ( 0 as mmpur_gr_consumption_pct) AS CntrlPurContrGRConsumptionPct,
  TargetQuantity,
  ProcmtHubCompanyCodeGroupingID,
  CompanyCode AS ProcmtHubCompanyCode,
  Plant,
  PurchasingDocumentType,
  PurchasingOrganization AS ProcmtHubPurchasingOrg,
  PurchasingGroup AS ProcmtHubPurchasingGroup,
  StorageLocation,
  PaymentTerms,
  PurchasingInfoRecordUpdateCode,
  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,
  _ProcmtHubCompanyCodeGroup.ProcmtHubCoCodeGroupingName AS ProcmtHubCoCodeGroupingName,
  _CntrlPurContrHierHdrTP.PurchasingProcessingStatus AS CntrlPurContrOvrlDistrStsTxt,
  _CntrlPurContrHierHdrTP.CntrlPurContrOvrlDistrStsTxt AS PurchasingProcessingStatus,
  _CntrlPurContrHierHdrTP.PurchasingProcessingStatus AS PurchasingDocumentStatus,
  _CentralPurchaseContract.ValidityEndDate AS ValidityEndDate,
  _CentralPurchaseContract.ValidityStartDate AS ValidityStartDate,
  _CentralPurchaseContract.PurchaseContractType AS PurchaseContractType,
  _CntrlPurchaseContractItem.PurchasingCentralMaterial AS Material,
  _CntrlPurchaseContractItem.MaterialGroup AS MaterialGroup,
  _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 boole_d) 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 = PurchasingDocumentType 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_CntrlPurContrHierHdrTP AS _CntrlPurContrHierHdrTP ON CentralPurchaseContract = _CntrlPurContrHierHdrTP.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 I_ProcmtHubCompanyCodeGroup AS _ProcmtHubCompanyCodeGroup ON _ProcmtHubCompanyCodeGroup.ProcmtHubCompanyCodeGroupingID = ProcmtHubCompanyCodeGroupingID  -- association [1..1]
;