P_PrepaymentRefDocTotalAmtPO

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 P_PrepaymentRefDocTotalAmtPO.
-- 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.

CREATE VIEW P_PrepaymentRefDocTotalAmtPO AS
SELECT
  DocTypes.PrepaymentAgrmtWorkCenterType AS PrepaymentAgrmtWorkCenterType,
  DocTypes.PrepaymentAgrmtRefDocumentCat AS PrepaymentAgrmtRefDocumentCat,
  'BUS2012' AS PrepaymentAgrmtRefBusObject,
  Document.PurchasingDocument AS DocNumber,
  cast( DocumentItem.PurchasingDocumentItem as abap.char(6) ) AS DocumentItemNumber,
  DocumentItem.PurchasingDocumentItem AS PurchasingDocumentITem,
  lpad( Document.PurchasingDocument, 25, '0' ) AS PrepaymentAgrmtRefDocument,
  Document.CompanyCode AS CompanyCode,
  Document.PurchasingDocumentType AS DocumentType,
  Document.Supplier AS Counterparty,
  Document.ValidityStartDate AS PrepaymentRefDocItmValdFromDte,
  Document.ValidityEndDate AS PrepaymentRefDocItmValdToDte,
  DocumentItem.Material AS Material,
  Material.Commodity AS Commodity,
  DocumentItem.OrderQuantity AS OrderQuantity,
  DocumentItem.OrderQuantityUnit AS OrderQuantityUnit,
  Document.DocumentCurrency AS PrepaymentTotalAmtCrcy
FROM I_PrepayWrkCtrAllowedDocTypes AS DocTypes
INNER JOIN I_PurchasingDocument AS Document ON /* join condition not captured in parsed metadata */
INNER JOIN I_PurchasingDocumentItem AS DocumentItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_PrepaymentMaterial AS Material ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_PrepayDocVersLogPrcgValPO AS CMMPrice ON CMMPrice.PrepaymentWrkCtrDocPricingOptn = WCPrcConfig.PrepaymentWrkCtrDocPricingOptn AND Material.Commodity is not initial AND CMMPrice.PrepaymentAgrmtRefBusObject = 'BUS2012' AND CMMPrice.PrepaymentDocumentNumber = Document.PurchasingDocument AND CMMPrice.PurchasingDocumentItem = DocumentItem.PurchasingDocumentItem AND CMMPrice.CompanyCode = Document.CompanyCode AND CMMPrice.Counterparty = Document.Supplier  -- association [0..1]
LEFT OUTER JOIN I_PrepayDocumentMarketDataPO AS CPEPrice ON CPEPrice.PrepaymentWrkCtrDocPricingOptn = WCPrcConfig.PrepaymentWrkCtrDocPricingOptn AND CPEPrice.PurchasingDocument = Document.PurchasingDocument AND Material.Commodity is not initial AND CPEPrice.PrepaymentRefDocCondition = Document.PurchasingDocumentCondition AND CPEPrice.PurchasingDocumentItem = DocumentItem.PurchasingDocumentItem AND CPEPrice.CompanyCode = Document.CompanyCode AND CPEPrice.Counterparty = Document.Supplier  -- association [0..1]
;