C_DistrdContrForCntrlPurContr

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_DistrdContrForCntrlPurContr.
-- 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: CDISTRCONTR

CREATE VIEW C_DistrdContrForCntrlPurContr AS
SELECT
  CentralPurchaseContract,
  CompanyCode,
  ExtContractForPurg,
  ProcurementHubSourceSystem,
  PurchasingOrganization,
  PurchasingGroup,
  DistrResponseMessageUUID,
  PurchasingDocumentCategory,
  DistributionKey,
  CentralPurchaseContractItem,
  CntrlPurContrDistrTrggrDteTime,
  PurchasingDocumentCategoryName,
  CompanyCodeName,
  PurchasingOrganizationName,
  PurchasingGroupName,
  PurgDocItemDistributionStatus AS ItemDistributionStatus,
  SourceListIsUpdated,
  SrceListResponseMsgUUID,
  _CntrlDistrdPurContrStatusTxt.ItemDistributionStatusName AS ItemDistributionStatusName,
  SourceListChangeConfStatus,
  _SourceListChgConfStsDesc.SourceListChgConfStsDesc AS SourceListChgConfStsDesc,
  LogicalSystem
FROM I_CePuCoDistributedContrTP
LEFT OUTER JOIN C_CentralPurchaseContractTP AS _CentralPurchaseContractTP ON CentralPurchaseContract = _CentralPurchaseContractTP.CentralPurchaseContract  -- association [1..1]
LEFT OUTER JOIN C_CntrlPurContrDistrMessages AS _CntrlPurContrDistrMessages ON DistrResponseMessageUUID = _CntrlPurContrDistrMessages.DistrResponseMessageUUID  -- association [1..*]
LEFT OUTER JOIN C_CntrlDistrdPurContrStatusTxt AS _CntrlDistrdPurContrStatusTxt ON _CntrlDistrdPurContrStatusTxt.ItemDistributionStatus = ItemDistributionStatus  -- association [0..1]
LEFT OUTER JOIN C_SourceListChgConfStsDesc AS _SourceListChgConfStsDesc ON _SourceListChgConfStsDesc.SourceListChangeConfStatus = SourceListChangeConfStatus  -- association [0..1]
LEFT OUTER JOIN C_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]
;