C_CntrlPurContrDistributionTP

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_CntrlPurContrDistributionTP.
-- 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: CCNTRLPCONDSTRTP

CREATE VIEW C_CntrlPurContrDistributionTP AS
SELECT
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  DistributionKey,
  PurchasingDocumentCategory,
  PurchasingDocumentType,
  IsExtPurgScenario,
  ProcmtHubPurchaseRequisition,
  ProcmtHubPurRequisitionItem,
  PurchasingInfoRecordUpdateCode,
  PurchasingOrganization,
  CompanyCode,
  Plant,
  StorageLocation,
  SourceListIsUpdated,
  SourceListRestriction,
  LogicalSystem,
  Currency,
  PurchasingGroup,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  ShippingInstruction,
  IncotermsClassification,
  IncotermsLocation1,
  Material,
  MaterialGroup,
  CntrlPurContrDistributionPct,
  TargetQuantity,
  TargetAmount,
  ReleaseOrderItemQuantityUnit,
  CntrlPurContractGRQuantity,
  ReleaseOrderCurrency,
  CntrlPurContractGRAmount,
  ExtContractForPurg,
  ExtContractItemForPurg,
  ItemDistributionStatus,
  IsDeleted,
  cast(IsDeleted as boolean) AS TextIsDeleted,
  OutlineAgrmtItmIsBlocked,
  OutlineAgrmtItmBlockedText,
  OrderQuantityUnit,
  DocumentCurrency,
  ContractNetPriceAmount,
  ExternalRefDocCategory,
  ExternalReferenceDocument,
  ExternalReferenceDocumentItem,
  ProcmtHubPredecessorDocCat,
  ProcmtHubPredecessorDocument,
  ProcmtHubPredecessorDocItem,
  DistributionType,
  ItemDistributionIsRelevant,
  CntrlPurContrItmDistrIsBlocked,
  ReferenceHeaderDistributionKey,
  ProcurementHubSourceSystem,
  ProcurementHubSourceSystem AS ProcmtHubLogicalSystem,
  cast ( '' as abap.char(10) ) AS CntrlPurContrDistributionLevel,
  ManualDeliveryAddressID,
  ProcmtHubDelivAddressTypeCode,
  ReferenceDeliveryAddressID,
  ProcmtHubSubcontractor,
  ProcmtHubSuplrIsSubcontractor,
  FormOfAddress,
  ProcmtHubBusinessPartnerName1,
  ProcmtHubBusinessPartnerName2,
  ProcmtHubBusinessPartnerName3,
  ProcmtHubBusinessPartnerName4,
  ProcmtHubStreetName,
  ProcmtHubHouseNumber,
  ProcmtHubPostalCode,
  ProcmtHubCityName,
  ProcmtHubCountry,
  ProcmtHubRegion,
  PurchasingDocumentItemCategory,
  ProcmtHubPrdcssrDocUUID,
  ProcmtHubPrdcssrDocItemUUID,
  ProcmtHubPrdcssrDocObjType,
  ProcmtHubPrdcssrDocObjNodeType,
  cast('' as vdm_sourcingprojectquotation) AS SourcingProjectQuotation,
  cast('' as vdm_formatteditemid) AS FormattedItemID,
  cast('' as vdm_srcgprojqtnitem) AS SourcingProjectQuotationItem,
  cast ( '' as mmpur_spqtn_frmtditem ) AS SrcgProjQtnItemFrmtdTxt,
  _CentralPurchaseContract.ActivePurchasingDocument AS ActivePurchasingDocument,
  _CentralPurchaseContract.PurchasingDocumentName AS PurchasingDocumentName,
  _CentralPurchaseContract.PurgDocChangeRequestStatus AS PurgDocChangeRequestStatus,
  _CntrlDistrdPurContrStatusTxt.ItemDistributionStatusName AS ItemDistributionStatusName,
  _CntrlPurContrDistrTypeText.PurgDocDistributionTypeDesc AS PurgDocDistributionTypeDesc,
  _ContrItmDistrEnhancedFields.ContractConsumptionInPct AS ContractConsumptionInPct,
  _ContrItmDistrEnhancedFields.CntrlPurContrGRConsumptionPct AS CntrlPurContrGRConsumptionPct,
  _ProcmtHubAddressTypeVH.AddressTypeDesc AS AddressTypeDesc,
  _ProcmtHubCompanyCodeVH.ProcmtHubCompanyCodeName AS ProcmtHubCompanyCodeName,
  _ProcmtHubSchedgAgrmtTypeVH.PurchasingDocumentTypeName AS PurchasingDocumentTypeName,
  _PurgDocItmBlkRsnCodesVH.PurgDocItmBlkRsnDesc AS PurgDocItmBlkRsnDesc,
  _PurgDocumentCategoryText.PurchasingDocumentCategoryName AS PurchasingDocumentCategoryName
FROM I_CntrlPurContrDistributionTP
LEFT OUTER JOIN C_CentralPurchaseContractTP AS _CentralPurchaseContractTP ON _CentralPurchaseContractTP.CentralPurchaseContract = CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN C_CntrlPurchaseContractItemTP AS _CntrlPurchaseContractItemTP ON CentralPurchaseContract = _CntrlPurchaseContractItemTP.CentralPurchaseContract AND CentralPurchaseContractItem = _CntrlPurchaseContractItemTP.CentralPurchaseContractItem  -- association [1..1]
LEFT OUTER JOIN C_CntrlPurContrItemPartnerTP AS _CntrlPurContrItemPartnerTP ON _CntrlPurContrItemPartnerTP.CentralPurchaseContract = CentralPurchaseContract AND _CntrlPurContrItemPartnerTP.CentralPurchaseContractItem = CentralPurchaseContractItem AND _CntrlPurContrItemPartnerTP.DistributionKey = DistributionKey  -- association [0..*]
LEFT OUTER JOIN C_CntrlPurContrItmDistrAddrTP AS _CntrlPurContrItmDistrAddrTP ON _CntrlPurContrItmDistrAddrTP.CentralPurchaseContract = CentralPurchaseContract AND _CntrlPurContrItmDistrAddrTP.CentralPurchaseContractItem = CentralPurchaseContractItem AND _CntrlPurContrItmDistrAddrTP.DistributionKey = DistributionKey  -- association [0..1]
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_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_ContrItmDistrEnhancedFields AS _ContrItmDistrEnhancedFields ON CentralPurchaseContractItem = _ContrItmDistrEnhancedFields.CentralPurchaseContractItem AND CentralPurchaseContract = _ContrItmDistrEnhancedFields.CentralPurchaseContract AND DistributionKey = _ContrItmDistrEnhancedFields.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 C_ProcmtHubCompanyCodeVH AS _ProcmtHubCompanyCodeVH ON CompanyCode = _ProcmtHubCompanyCodeVH.ProcmtHubCompanyCode AND ProcurementHubSourceSystem = _ProcmtHubCompanyCodeVH.ProcurementHubSourceSystem  -- association [0..1]
LEFT OUTER JOIN R_CentralPurchaseContract AS _CentralPurchaseContract ON CentralPurchaseContract = _CentralPurchaseContract.CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN C_PurgDocItmBlkRsnCodesVH AS _PurgDocItmBlkRsnCodesVH ON PurgDocItmBlkRsnCode = _PurgDocItmBlkRsnCodesVH.PurgDocItmBlkRsnCode AND _PurgDocItmBlkRsnCodesVH.Language = $session.system_language  -- 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]
;