I_PrepaymentDocFixedValDataPO

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_PrepaymentDocFixedValDataPO.
-- 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 I_PrepaymentDocFixedValDataPO AS
SELECT
  CPEPricingVal.PurchasingDocument AS PurchasingDocument,
  CPEPricingVal.PrepaymentRefDocCondition AS PrepaymentRefDocCondition,
  CPEPricingVal.PrepaymentRefDocConditionItem AS PrepaymentRefDocConditionItem,
  CPEPricingVal.DocItemCommodityPricingUUID AS DocItemCommodityPricingUUID,
  CPEPricingVal.ConditionType AS ConditionType,
  CPEPricingVal.CompanyCode AS CompanyCode,
  CPEPricingVal.Counterparty AS Counterparty,
  CPEPricingVal.PurchasingDocumentType AS PurchasingDocumentType,
  CPEPricingVal.CalculationPeriodEndDate AS CalculationPeriodEndDate,
  CPEPricingVal.MaturityKeyDate AS MaturityKeyDate,
  CPEPricingVal.DerivativeContrSpecification AS DerivativeContrSpecification,
  CPEPricingVal.MarketIdentifierCode AS MarketIdentifierCode,
  CPEPricingVal.BasisType AS BasisType,
  CPEPricingVal.BasisID AS BasisID,
  in Document Currency case when CPEPricingVal.ACMPrcgCndnTermInputPrice is not initial then CPEPricingVal.PrepaymentRefDocFixedPrice else cast( 0 as abap.curr(15,2) ) end as PrepaymentRefDocFixedPrice AS curr152endasPrepaymentRefDocFixedPrice,
  CPEPricingVal.PrepaymentRefDocFixedPriceCrcy AS PrepaymentRefDocFixedPriceCrcy,
  CPEPricingVal.PrcgCndnTermFixationOptnStatus AS PrcgCndnTermFixationOptnStatus,
  CPEPricingVal.PrcgCndnFmlaCmmdtyQuantityUnit AS PrepaymentDocCmmdtyMktQtyUnit,
  case when _FQuotationPrice.PrepaymentRefDocFuturePrcCrcy is not initial then _FQuotationPrice.PrepaymentRefDocFuturePrcCrcy when _BQuotationPrice.PrepaymentRefDocBasisPrcCrcy is not initial then _BQuotationPrice.PrepaymentRefDocBasisPrcCrcy when _SBQuotationPrice.PrepaymentRefDocSecBsPrcCrcy is not initial then _SBQuotationPrice.PrepaymentRefDocSecBsPrcCrcy else cast('' as abap.cuky(5) ) end as PrepaymentRefDocMarketPrcCrcy AS cuky5endasPrepaymentRefDocMarketPrcCrcy,
  CPEPricingVal.PrcgCndnTermCnvrsnSourceCrcy AS PrcgCndnTermCnvrsnSourceCrcy,
  CPEPricingVal.PrcgCndnTermCnvrsnTargetCrcy AS PrcgCndnTermCnvrsnTargetCrcy,
  uncoverted CPEPricingVal.ConditionTermRate AS ConditionTermRate,
  CPEPricingVal.ConditionTermRateCurrency AS ConditionTermRateCurrency,
  in document currency cast( case when CPEPricingVal.ConditionTermRateCurrency is not initial and prepaymentrefdocfixedpricecrcy = CPEPricingVal.ConditionTermRateCurrency then curr_to_decfloat_amount(CPEPricingVal.ConditionTermRate) when CPEPricingVal.ConditionTermRateCurrency is not initial and prepaymentrefdocfixedpricecrcy <> CPEPricingVal.ConditionTermRateCurrency then round( (curr_to_decfloat_amount(CPEPricingVal.ConditionTermRate) * prcgcndntermcnvrsnfxdexchrate), 3) else 0 end as abap.curr(15,2) ) as PrcgConditionTermPrice AS curr152asPrcgConditionTermPrice,
  F = Future CPEPricingVal.MTMCalculationGroup as MTMCalculationGroup AS MTMCalculationGroupasMTMCalculationGroup,
  CPEPricingVal.PrepaymentWrkCtrDocPricingOptn AS PrepaymentWrkCtrDocPricingOptn
FROM I_PpaytDocCmmdtyPrcValPO AS CPEPricingVal
LEFT OUTER JOIN I_PpaytDocFutureMktData AS _FQuotationPrice ON _FQuotationPrice.DerivativeContrSpecification = CPEPricingVal.DerivativeContrSpecification AND _FQuotationPrice.MarketIdentifierCode = CPEPricingVal.MarketIdentifierCode AND _FQuotationPrice.MaturityKeyDate = CPEPricingVal.MaturityKeyDate AND _FQuotationPrice.QuotationPriceType = CPEPricingVal.QuotationPriceType  -- association [0..1]
LEFT OUTER JOIN I_PpaytDocBasisMktData AS _BQuotationPrice ON _BQuotationPrice.DerivativeContrSpecification = CPEPricingVal.DerivativeContrSpecification AND _BQuotationPrice.MarketIdentifierCode = CPEPricingVal.MarketIdentifierCode AND _BQuotationPrice.BasisID = CPEPricingVal.BasisID AND _BQuotationPrice.BasisType = CPEPricingVal.BasisType AND _BQuotationPrice.BasisID is not initial AND _BQuotationPrice.QuotationPriceType = CPEPricingVal.QuotationPriceType  -- association [0..1]
LEFT OUTER JOIN I_PpaytDocSecBasisMktData AS _SBQuotationPrice ON _SBQuotationPrice.BasisID = CPEPricingVal.BasisID AND _SBQuotationPrice.BasisID is not initial AND _SBQuotationPrice.BasisType = CPEPricingVal.BasisType AND _SBQuotationPrice.QuotationPriceType = CPEPricingVal.QuotationPriceType  -- association [0..1]
;