P_PrepayDocVersLogPrcgValPO

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_PrepayDocVersLogPrcgValPO.
-- 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_PrepayDocVersLogPrcgValPO AS
SELECT
  FixedVal.OriginReferenceDocBusObjType AS PrepaymentAgrmtRefBusObject,
  Document.PurchasingDocument AS PrepaymentDocumentNumber,
  FixedVal.OriginReferenceDocumentItem AS PrepaymentDocumentItemNumber,
  right( FixedVal.OriginReferenceDocumentItem, 5 ) AS PurchasingDocumentItem,
  sum( case when FixedVal.ConditionTermRateIsFixed = ' ' and ( FixedVal.MTMCalculationGroup = 'B' or FixedVal.MTMCalculationGroup = 'F' ) then MarketVal.CommodityQuantity else cast( 0 as abap.quan(13,3)) end ) as PrepaymentDocCmmdtyMarketQty AS quan133endasPrepaymentDocCmmdtyMarketQty,
  FixedVal.CommodityUnit AS PrepaymentDocCmmdtyMktQtyUnit,
  cast(cast( sum( case when FixedVal.ConditionTermRateIsFixed = 'X' and FixedVal.ConditionTermRateCurrency = FixedVal.DocumentCurrency then curr_to_decfloat_amount(FixedVal.ConditionTermValue) when FixedVal.ConditionTermRateIsFixed = 'X' and FixedVal.ConditionTermRateCurrency <> FixedVal.DocumentCurrency then curr_to_decfloat_amount(FixedVal.ConditionTermValue) * FixedValRate.TargetConversionFactor when FixedVal.ConditionTermRateIsFixed = ' ' and MarketVal.ConditionTermRateCurrency = MarketVal.DocumentCurrency then curr_to_decfloat_amount(MarketVal.ConditionTermValue) when FixedVal.ConditionTermRateIsFixed = ' ' and MarketVal.ConditionTermRateCurrency <> MarketVal.DocumentCurrency and FixedVal.ConditionTermExchRateIsFixed = ' ' then curr_to_decfloat_amount(MarketVal.ConditionTermValue) * MarketValRate.TargetConversionFactor when FixedVal.ConditionTermRateIsFixed = ' ' and MarketVal.ConditionTermRateCurrency <> MarketVal.DocumentCurrency and FixedVal.ConditionTermExchRateIsFixed = 'X' then curr_to_decfloat_amount(MarketVal.ConditionTermValue) * FixedValRate.TargetConversionFactor else 0 end ) as abap.dec(25,3) ) as abap.curr(25,3) ) as PrepaymentTotalAmt AS curr253asPrepaymentTotalAmt,
  FixedVal.DocumentCurrency AS PrepaymentTotalAmountCrcy,
  Document.CompanyCode AS CompanyCode,
  Document.Supplier AS Counterparty,
  WCPrcConfig.PrepaymentWrkCtrDocPricingOptn AS PrepaymentWrkCtrDocPricingOptn
FROM I_PrepayWrkCtrAllowedDocTypes AS DocTypes
INNER JOIN I_PurchasingDocument AS Document ON /* join condition not captured in parsed metadata */
INNER JOIN I_PrepaymentWrkCtrLinkConfign AS WCPrcConfig ON /* join condition not captured in parsed metadata */
INNER JOIN I_VersionedLogisticDocument AS FixedVal ON /* join condition not captured in parsed metadata */
INNER JOIN I_VersionedLogisticDocument AS MarketVal ON /* join condition not captured in parsed metadata */
;