A_CntrlPurContrItmDistribution

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 A_CntrlPurContrItmDistribution.
-- 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: ACNTRLPCTRID

CREATE VIEW A_CntrlPurContrItmDistribution AS
SELECT
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  DistributionKey,
  CompanyCode AS ProcmtHubCompanyCode,
  Plant AS ProcmtHubPlant,
  PurchasingOrganization AS ProcmtHubPurchasingOrg,
  PurchasingGroup AS ProcmtHubPurchasingGroup,
  ProcmtHubCompanyCodeGroupingID,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  DistributionType,
  ExternalReferenceDocument,
  ExternalReferenceDocumentItem,
  ExternalRefDocCategory,
  PurchasingDocumentCategory,
  PurchasingDocumentType,
  StorageLocation,
  CntrlPurContrDistributionPct,
  TargetQuantity AS CntrlPurContrItmDistrQty,
  OrderQuantityUnit,
  TargetAmount AS CntrlPurContrItmDistrAmt,
  ProcurementHubSourceSystem,
  Material AS ProcmtHubProduct,
  MaterialGroup AS ProcmtHubProductGroup,
  ExtContractForPurg AS ProcmtHubPurchaseContract,
  ExtContractItemForPurg AS ProcmtHubPurchaseContractItem,
  ItemDistributionStatus,
  ReferenceHeaderDistributionKey,
  IsDeleted,
  OutlineAgrmtItmIsBlocked,
  PurgDocItmBlkRsnCode,
  PurchasingInfoRecordUpdateCode,
  ExtContractItemDistrForPurg AS ReferenceDistributionNumber,
  cast(SourceListIsUpdated as xfeld) AS SourceListIsUpdated,
  SourceListRestriction,
  IncotermsClassification,
  IncotermsLocation1,
  ShippingInstruction,
  ProcmtHubDelivAddressTypeCode,
  ReferenceDeliveryAddressID,
  ProcmtHubSubcontractor,
  ProcmtHubSuplrIsSubcontractor,
  FormOfAddress,
  ProcmtHubBusinessPartnerName1,
  ProcmtHubBusinessPartnerName2,
  ProcmtHubBusinessPartnerName3,
  ProcmtHubBusinessPartnerName4,
  ProcmtHubStreetName,
  ProcmtHubHouseNumber,
  ProcmtHubPostalCode,
  ProcmtHubCityName,
  ProcmtHubCountry,
  ProcmtHubRegion
FROM I_CntrlPurContrDistribution
LEFT OUTER JOIN A_CntrlPurchaseContractItem AS _CentralPurchaseContractItem ON CentralPurchaseContract = _CentralPurchaseContractItem.CentralPurchaseContract AND CentralPurchaseContractItem = _CentralPurchaseContractItem.CentralPurchaseContractItem  -- association [1..1]
LEFT OUTER JOIN A_CntrlPurContrItemPartner AS _CntrlPurContrItemPartner ON CentralPurchaseContract = _CntrlPurContrItemPartner.CentralPurchaseContract AND CentralPurchaseContractItem = _CntrlPurContrItemPartner.CentralPurchaseContractItem AND DistributionKey = _CntrlPurContrItemPartner.DistributionKey  -- association [0..*]
LEFT OUTER JOIN A_CentralPurchaseContract AS _CentralPurchaseContract ON CentralPurchaseContract = _CentralPurchaseContract.CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN E_CntrlPurContrDistribution AS _CntrlPurContrItmDistExtension ON _CntrlPurContrItmDistExtension.PurchasingDocument = CentralPurchaseContract AND _CntrlPurContrItmDistExtension.PurchasingDocumentItem = CentralPurchaseContractItem AND _CntrlPurContrItmDistExtension.DistributionKey = DistributionKey  -- association [1..1]
;