C_CntrlPurContrHierItemDistrTP

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_CntrlPurContrHierItemDistrTP.
-- 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: CPCHIERITMDISTR

CREATE VIEW C_CntrlPurContrHierItemDistrTP AS
SELECT
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  DistributionKey,
  cast ( '' as abap.char(10) ) AS CntrlPurContrDistributionLevel,
  ProcmtHubCompanyCodeGroupingID,
  PurchasingDocumentCategory,
  CompanyCode,
  PurchasingDocumentType,
  IsExtPurgScenario,
  ProcmtHubPurchaseRequisition,
  ProcmtHubPurRequisitionItem,
  PurchasingInfoRecordUpdateCode,
  PurchasingOrganization,
  Plant,
  StorageLocation,
  SourceListIsUpdated,
  SourceListRestriction,
  LogicalSystem,
  Currency,
  PurchasingGroup,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  ShippingInstruction,
  IncotermsClassification,
  IncotermsLocation1,
  Material,
  MaterialGroup,
  CntrlPurContrDistributionPct,
  TargetQuantity,
  TargetAmount,
  ExtContractForPurg,
  ExtContractItemForPurg,
  ExtContractItemDistrForPurg,
  ItemDistributionStatus,
  IsDeleted,
  cast(IsDeleted as boolean) AS TextIsDeleted,
  OutlineAgrmtItmIsBlocked,
  OutlineAgrmtItmBlockedText,
  OrderQuantityUnit,
  DocumentCurrency,
  ContractNetPriceAmount,
  ExternalRefDocCategory,
  ExternalReferenceDocument,
  ExternalReferenceDocumentItem,
  ProcmtHubPredecessorDocCat,
  ProcmtHubPredecessorDocument,
  ProcmtHubPredecessorDocItem,
  DistributionType,
  ItemDistributionIsRelevant,
  CntrlPurContrItmDistrIsBlocked,
  ReferenceHeaderDistributionKey,
  ManualDeliveryAddressID,
  ProcmtHubDelivAddressTypeCode,
  ReferenceDeliveryAddressID,
  ProcmtHubSubcontractor,
  ProcmtHubSuplrIsSubcontractor,
  FormOfAddress,
  ProcmtHubBusinessPartnerName1,
  ProcmtHubBusinessPartnerName2,
  ProcmtHubBusinessPartnerName3,
  ProcmtHubBusinessPartnerName4,
  ProcmtHubStreetName,
  ProcmtHubHouseNumber,
  ProcmtHubPostalCode,
  ProcmtHubCityName,
  ProcmtHubCountry,
  ProcmtHubRegion,
  PurchasingDocumentItemCategory,
  ProcurementHubSourceSystem,
  ProcmtHubPrdcssrDocUUID,
  ProcmtHubPrdcssrDocItemUUID,
  ProcmtHubPrdcssrDocObjType,
  ProcmtHubPrdcssrDocObjNodeType,
  cast ( '' as mmpur_spqtn_frmtditem ) AS SrcgProjQtnItemFrmtdTxt,
  _CntrlDistrdPurContrStatusTxt.ItemDistributionStatusName AS ItemDistributionStatusName,
  _ContrHierItmDistrEnhancedFld.ReleaseOrderItemQuantityUnit AS ReleaseOrderItemQuantityUnit,
  _ContrHierItmDistrEnhancedFld.CntrlPurContractGRQuantity AS CntrlPurContractGRQuantity,
  _ContrHierItmDistrEnhancedFld.ReleaseOrderCurrency AS ReleaseOrderCurrency,
  _ContrHierItmDistrEnhancedFld.CntrlPurContractGRAmount AS CntrlPurContractGRAmount,
  _ContrHierItmDistrEnhancedFld.ContractConsumptionInPct AS ContractConsumptionInPct,
  _ContrHierItmDistrEnhancedFld.CntrlPurContrGRConsumptionPct AS CntrlPurContrGRConsumptionPct,
  _ProcmtHubAddressTypeVH.AddressTypeDesc AS AddressTypeDesc,
  _PurgDocItmBlkRsnCodesVH.PurgDocItmBlkRsnDesc AS PurgDocItmBlkRsnDesc,
  _SrcgProjQtnItem.SourcingProjectQuotation AS SourcingProjectQuotation,
  _SrcgProjQtnItem.FormattedItemID AS FormattedItemID,
  _SrcgProjQtnItem.SourcingProjectQuotationItem AS SourcingProjectQuotationItem
FROM I_CntrlPurContrDistributionTP AS CntrlPurContrDistributionTP
LEFT OUTER JOIN C_CntrlPurContrHierHdrTP AS _CentralPurchaseContractTP ON _CentralPurchaseContractTP.CentralPurchaseContract = CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN C_CntrlPurContrHierItemTP AS _CntrlPurchaseContractItemTP ON CentralPurchaseContract = _CntrlPurchaseContractItemTP.CentralPurchaseContract AND CentralPurchaseContractItem = _CntrlPurchaseContractItemTP.CentralPurchaseContractItem  -- association [1..1]
LEFT OUTER JOIN C_CntrlPurContrHierItmPartTP AS _CntrlPurContrItemPartnerTP ON _CntrlPurContrItemPartnerTP.CentralPurchaseContract = CentralPurchaseContract AND _CntrlPurContrItemPartnerTP.CentralPurchaseContractItem = CentralPurchaseContractItem AND _CntrlPurContrItemPartnerTP.DistributionKey = DistributionKey  -- association [0..*]
LEFT OUTER JOIN I_Plant AS _Plant ON _Plant.Plant = Plant  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON _PurchasingOrganization.PurchasingOrganization = PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubPlantVH AS _ProcmtHubPlantVH ON _ProcmtHubPlantVH.ProcmtHubPlant = Plant AND _ProcmtHubPlantVH.ProcmtHubCompanyCode = CompanyCode AND _ProcmtHubPlantVH.ProcurementHubSourceSystem = ProcurementHubSourceSystem  -- 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_CntrlPurContrDistrTypeVH AS _CntrlPurContrDistrTypeVH ON _CntrlPurContrDistrTypeVH.DistributionType = DistributionType  -- association [0..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 C_CntrlDistrdPurContrStatusTxt AS _CntrlDistrdPurContrStatusTxt ON _CntrlDistrdPurContrStatusTxt.ItemDistributionStatus = ItemDistributionStatus  -- association [0..1]
LEFT OUTER JOIN C_CntrlPurContrItmDistrRelHist AS _CntrlPurContrItmDistrRelHist ON CentralPurchaseContractItem = _CntrlPurContrItmDistrRelHist.CentralPurchaseContractItem AND CentralPurchaseContract = _CntrlPurContrItmDistrRelHist.CentralPurchaseContract AND DistributionKey = _CntrlPurContrItmDistrRelHist.DistributionKey  -- association [0..*]
LEFT OUTER JOIN I_ContrHierItmDistrEnhancedFld AS _ContrHierItmDistrEnhancedFld ON CentralPurchaseContractItem = _ContrHierItmDistrEnhancedFld.CentralPurchaseContractItem AND CentralPurchaseContract = _ContrHierItmDistrEnhancedFld.CentralPurchaseContract AND DistributionKey = _ContrHierItmDistrEnhancedFld.DistributionKey  -- association [0..1]
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 I_ProcmtHubCompanyCodeGroup AS _ProcmtHubCompanyCodeGroup ON _ProcmtHubCompanyCodeGroup.ProcmtHubCompanyCodeGroupingID = ProcmtHubCompanyCodeGroupingID  -- association [1..1]
LEFT OUTER JOIN C_ProcmtHubCompanyCodeVH AS _ProcmtHubCompanyCodeVH ON CompanyCode = _ProcmtHubCompanyCodeVH.ProcmtHubCompanyCode AND ProcurementHubSourceSystem = _ProcmtHubCompanyCodeVH.ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN C_ProcmtHubGroupCompanyCodeVH AS _ProcmtHubGroupCompanyCodeVH ON _ProcmtHubGroupCompanyCodeVH.ProcmtHubCompanyCodeGroupingID = ProcmtHubCompanyCodeGroupingID AND _ProcmtHubGroupCompanyCodeVH.ProcmtHubCompanyCode = CompanyCode AND _ProcmtHubGroupCompanyCodeVH.ProcurementHubSourceSystem = ProcurementHubSourceSystem  -- association [1..1]
LEFT OUTER JOIN C_ProcmtHubAddressTypeVH AS _ProcmtHubAddressTypeVH ON ProcmtHubDelivAddressTypeCode = _ProcmtHubAddressTypeVH.AddressType  -- association [0..1]
LEFT OUTER JOIN C_MM_RegionValueHelp AS _MM_RegionValueHelp ON ProcmtHubCountry = _MM_RegionValueHelp.Country AND ProcmtHubRegion = _MM_RegionValueHelp.Region  -- association [0..1]
LEFT OUTER JOIN C_PurgDocItmBlkRsnCodesVH AS _PurgDocItmBlkRsnCodesVH ON PurgDocItmBlkRsnCode = _PurgDocItmBlkRsnCodesVH.PurgDocItmBlkRsnCode AND _PurgDocItmBlkRsnCodesVH.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN R_SrcgProjQtnItem AS _SrcgProjQtnItem ON ProcmtHubPrdcssrDocUUID = _SrcgProjQtnItem.SourcingProjectQuotationUUID AND ProcmtHubPrdcssrDocItemUUID = _SrcgProjQtnItem.SrcgProjQtnItemUUID  -- association [0..1]
;