I_CntrlPurContrHdrDistrTP

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 I_CntrlPurContrHdrDistrTP.
-- 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: ICNTRLPCHDRDISTR

CREATE VIEW I_CntrlPurContrHdrDistrTP AS
SELECT
  CentralPurchaseContract,
  DistributionKey,
  CentralPurchaseContractItem,
  PurchasingDocumentCategory,
  PurchasingDocumentType,
  PurchasingOrganization,
  CompanyCode,
  Plant,
  LogicalSystem,
  DocumentCurrency,
  Currency,
  PurchasingGroup,
  StorageLocation,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  Material,
  MaterialGroup,
  CntrlPurContrDistributionPct,
  TargetQuantity,
  TargetAmount,
  ExtContractForPurg,
  ExtContractItemForPurg,
  ItemDistributionStatus,
  IsDeleted,
  OrderQuantityUnit,
  DistributionType,
  DistrResponseMessageUUID,
  _CntrlPurchaseContractItem.ContractNetPriceAmount AS ContractNetPriceAmount,
  ProcurementHubSourceSystem,
  PurchasingInfoRecordUpdateCode,
  ProcmtHubCompanyCodeGroupingID,
  ExtContractItemDistrForPurg,
  cast(SourceListIsUpdated as xfeld) AS SourceListIsUpdated,
  SourceListRestriction,
  IncotermsClassification,
  IncotermsLocation1,
  ShippingInstruction
FROM I_CntrlPurContrDistribution
LEFT OUTER JOIN I_CentralPurchaseContractTP AS _CentralPurchaseContractTP ON _CentralPurchaseContractTP.CentralPurchaseContract = CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN I_CntrlPurContrHdrPartnerTP AS _CntrlPurContrHdrPartnerTP ON _CntrlPurContrHdrPartnerTP.CentralPurchaseContract = CentralPurchaseContract AND _CntrlPurContrHdrPartnerTP.DistributionKey = DistributionKey  -- association [0..*]
LEFT OUTER JOIN I_CntrlPurContrHdrDistrAddrTP AS _CntrlPurContrHdrDistrAddrTP ON _CntrlPurContrHdrDistrAddrTP.CentralPurchaseContract = CentralPurchaseContract AND _CntrlPurContrHdrDistrAddrTP.DistributionKey = DistributionKey  -- association [0..1]
LEFT OUTER JOIN E_CntrlPurContrDistribution AS _DistributionExtension ON _DistributionExtension.PurchasingDocument = CentralPurchaseContract AND _DistributionExtension.DistributionKey = DistributionKey  -- association [1..1]
;