I_CePuCoDistributedContrTP

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_CePuCoDistributedContrTP.
-- 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: ICEPUCODISTROA

CREATE VIEW I_CePuCoDistributedContrTP AS
SELECT
  CentralPurchaseContract,
  ExtContractForPurg,
  ProcurementHubSourceSystem,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  DistrResponseMessageUUID,
  PurchasingDocumentCategory,
  DistributionKey,
  CentralPurchaseContractItem,
  CntrlPurContrDistrTrggrDteTime,
  _Text.PurchasingDocumentCategoryName AS PurchasingDocumentCategoryName,
  PurgDocItemDistributionStatus,
  SourceListIsUpdated,
  SrceListResponseMsgUUID,
  SourceListChangeConfStatus,
  LogicalSystem
FROM I_CntrlPurContrDistribution
LEFT OUTER JOIN I_CentralPurchaseContractTP AS _CentralPurchaseContractTP ON _CentralPurchaseContractTP.CentralPurchaseContract = CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN I_PurgDocumentCategoryText AS _Text ON PurchasingDocumentCategory = _Text.PurchasingDocumentCategory AND _Text.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CePuCoDistrdContrPaytTrmsTP AS _CCTRDistributedContrPayTerms ON _CCTRDistributedContrPayTerms.CentralPurchaseContract = CentralPurchaseContract AND _CCTRDistributedContrPayTerms.ExtContractForPurg = ExtContractForPurg AND _CCTRDistributedContrPayTerms.ProcurementHubSourceSystem = ProcurementHubSourceSystem AND _CCTRDistributedContrPayTerms.CompanyCode = CompanyCode AND _CCTRDistributedContrPayTerms.PurchasingOrganization = PurchasingOrganization AND _CCTRDistributedContrPayTerms.PurchasingGroup = PurchasingGroup AND _CCTRDistributedContrPayTerms.DistrResponseMessageUUID = DistrResponseMessageUUID AND _CCTRDistributedContrPayTerms.PurchasingDocumentCategory = PurchasingDocumentCategory AND _CCTRDistributedContrPayTerms.DistributionKey = DistributionKey AND _CCTRDistributedContrPayTerms.CentralPurchaseContractItem = CentralPurchaseContractItem  -- association [1..1]
;