I_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 I_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: ICNTRLPCONDSTRTP

CREATE VIEW I_CntrlPurContrDistributionTP AS
SELECT
  CentralPurchaseContract,
  CentralPurchaseContractItem,
  DistributionKey,
  PurchasingDocumentCategory,
  PurchasingDocumentType,
  PurchasingOrganization,
  CompanyCode,
  Plant,
  LogicalSystem,
  _CntrlPurchaseContractItem.DocumentCurrency AS DocumentCurrency,
  Currency,
  PurchasingGroup,
  StorageLocation,
  PaymentTerms,
  CashDiscount1Days,
  CashDiscount2Days,
  NetPaymentDays,
  CashDiscount1Percent,
  CashDiscount2Percent,
  Material,
  MaterialGroup,
  CntrlPurContrDistributionPct,
  TargetQuantity,
  TargetAmount,
  ExtContractForPurg,
  ExtContractItemForPurg,
  ExtContractItemDistrForPurg,
  ItemDistributionStatus,
  IsDeleted,
  OrderQuantityUnit,
  DistributionType,
  _CntrlPurchaseContractItem.ContractNetPriceAmount AS ContractNetPriceAmount,
  DistrResponseMessageUUID,
  ItemDistributionIsRelevant,
  CntrlPurContrItmDistrIsBlocked,
  ReferenceHeaderDistributionKey,
  ManualDeliveryAddressID,
  AddressType,
  ProcmtHubDelivAddressTypeCode,
  ProcurementHubSourceSystem,
  ExternalReferenceDocument,
  ExternalReferenceDocumentItem,
  ExternalRefDocCategory,
  OutlineAgrmtItmIsBlocked,
  PurchasingInfoRecordUpdateCode,
  ProcmtHubPredecessorDocument,
  ProcmtHubPredecessorDocItem,
  ProcmtHubPredecessorDocCat,
  ProcmtHubPurchaseRequisition,
  ProcmtHubPurRequisitionItem,
  cast(SourceListIsUpdated as xfeld) AS SourceListIsUpdated,
  SourceListRestriction,
  IncotermsClassification,
  IncotermsLocation1,
  ShippingInstruction,
  ProcmtHubCompanyCodeGroupingID,
  ProcmtHubSubcontractor,
  ProcmtHubSuplrIsSubcontractor,
  ReferenceDeliveryAddressID,
  FormOfAddress,
  ProcmtHubBusinessPartnerName1,
  ProcmtHubBusinessPartnerName2,
  ProcmtHubBusinessPartnerName3,
  ProcmtHubBusinessPartnerName4,
  ProcmtHubStreetName,
  ProcmtHubHouseNumber,
  ProcmtHubPostalCode,
  ProcmtHubCityName,
  ProcmtHubCountry,
  ProcmtHubRegion,
  ProcmtHubPrdcssrDocUUID,
  ProcmtHubPrdcssrDocItemUUID,
  ProcmtHubPrdcssrDocObjType,
  ProcmtHubPrdcssrDocObjNodeType,
  _CntrlPurchaseContractItem.PurchasingDocumentItemCategory AS PurchasingDocumentItemCategory,
  _ContrItmDistrEnhancedFields.CntrlPurContractGRQuantity AS CntrlPurContractGRQuantity,
  _ContrItmDistrEnhancedFields.ReleaseOrderItemQuantityUnit AS ReleaseOrderItemQuantityUnit,
  _ContrItmDistrEnhancedFields.CntrlPurContractGRAmount AS CntrlPurContractGRAmount,
  _ContrItmDistrEnhancedFields.ReleaseOrderCurrency AS ReleaseOrderCurrency,
  _ContrItmDistrEnhancedFields.CntrlPurContrInvcRcptQuantity AS CntrlPurContrInvcRcptQuantity,
  _ContrItmDistrEnhancedFields.CntrlPurContrInvcRcptAmount AS CntrlPurContrInvcRcptAmount
FROM I_CntrlPurContrDistribution
LEFT OUTER JOIN I_CentralPurchaseContractTP AS _CentralPurchaseContractTP ON _CentralPurchaseContractTP.CentralPurchaseContract = CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN I_CntrlPurchaseContractItemTP AS _CntrlPurchaseContractItemTP ON _CntrlPurchaseContractItemTP.CentralPurchaseContract = CentralPurchaseContract AND _CntrlPurchaseContractItemTP.CentralPurchaseContractItem = CentralPurchaseContractItem  -- association [1..1]
LEFT OUTER JOIN I_CntrlPurContrItemPartnerTP AS _CntrlPurContrItemPartnerTP ON _CntrlPurContrItemPartnerTP.CentralPurchaseContract = CentralPurchaseContract AND _CntrlPurContrItemPartnerTP.CentralPurchaseContractItem = CentralPurchaseContractItem AND _CntrlPurContrItemPartnerTP.DistributionKey = DistributionKey  -- association [0..*]
LEFT OUTER JOIN I_CntrlPurContrItmDistrAddrTP AS _CntrlPurContrItmDistrAddrTP ON _CntrlPurContrItmDistrAddrTP.CentralPurchaseContract = CentralPurchaseContract AND _CntrlPurContrItmDistrAddrTP.CentralPurchaseContractItem = CentralPurchaseContractItem AND _CntrlPurContrItmDistrAddrTP.DistributionKey = DistributionKey  -- association [0..1]
LEFT OUTER JOIN I_PurgDocumentCategoryText AS _PurgDocumentCategoryText ON _PurgDocumentCategoryText.PurchasingDocumentCategory = PurchasingDocumentCategory AND _PurgDocumentCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CntrlPurContrDistrTypeText AS _CntrlPurContrDistrTypeText ON _CntrlPurContrDistrTypeText.DistributionType = DistributionType AND _CntrlPurContrDistrTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_PaymentTerms AS _PaymentTerms ON PaymentTerms = _PaymentTerms.PaymentTerms  -- association [0..1]
LEFT OUTER JOIN I_PaymentTermsText AS _PaymentTermsText ON PaymentTerms = _PaymentTermsText.PaymentTerms  -- association [0..*]
LEFT OUTER JOIN I_Currency AS _DocumentCurrency ON _DocumentCurrency.Currency = Currency  -- association [0..1]
LEFT OUTER JOIN I_ContrItmDistrEnhancedFields AS _ContrItmDistrEnhancedFields ON CentralPurchaseContract = _ContrItmDistrEnhancedFields.CentralPurchaseContract AND CentralPurchaseContractItem = _ContrItmDistrEnhancedFields.CentralPurchaseContractItem AND DistributionKey = _ContrItmDistrEnhancedFields.DistributionKey  -- association [0..1]
LEFT OUTER JOIN E_CntrlPurContrDistribution AS _CntrlPurContrItmDistExtension ON _CntrlPurContrItmDistExtension.PurchasingDocument = CentralPurchaseContract AND _CntrlPurContrItmDistExtension.PurchasingDocumentItem = CentralPurchaseContractItem AND _CntrlPurContrItmDistExtension.DistributionKey = DistributionKey  -- association [1..1]
;