I_PpaytDocFixedValDataPO_1

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_PpaytDocFixedValDataPO_1.
-- 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_PpaytDocFixedValDataPO_1 AS
SELECT
  CPEPricingVal.PurchasingDocument AS PurchasingDocument,
  CPEPricingVal.PrepaymentRefDocCondition AS PrepaymentRefDocCondition,
  CPEPricingVal.PrepaymentRefDocConditionItem AS PrepaymentRefDocConditionItem,
  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,
  cast(case when _FQuotationPrice.CommodityUnit is not initial and _FQuotationPrice.CommodityUnit <> CPEPricingVal.PrcgCndnUsedTargetQuantityUnit and _FQuotationPrice.CommodityUnit = CPEPricingVal.PrcgCndnUsedSourceQuantityUnit then CPEPricingVal.PrcgConditionUsedTargetFactor / CPEPricingVal.PrcgConditionUsedSourceFactor when _BQuotationPrice.CommodityUnit is not initial and _BQuotationPrice.CommodityUnit <> CPEPricingVal.PrcgCndnUsedTargetQuantityUnit and _BQuotationPrice.CommodityUnit = CPEPricingVal.PrcgCndnUsedSourceQuantityUnit then CPEPricingVal.PrcgConditionUsedTargetFactor / CPEPricingVal.PrcgConditionUsedSourceFactor when _SBQuotationPrice.CommodityUnit is not initial and _SBQuotationPrice.CommodityUnit <> CPEPricingVal.PrcgCndnUsedTargetQuantityUnit and _SBQuotationPrice.CommodityUnit = CPEPricingVal.PrcgCndnUsedSourceQuantityUnit then CPEPricingVal.PrcgConditionUsedTargetFactor / CPEPricingVal.PrcgConditionUsedSourceFactor else 1 end as abap.dec(31,14)) as PpaytQuantityCnvrsnFactor AS dec3114asPpaytQuantityCnvrsnFactor,
  CPEPricingVal.PrepaymentDocCmmdtyMarketQty AS PrepaymentDocCmmdtyMarketQty,
  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_1 AS CPEPricingVal
LEFT OUTER JOIN I_PpaytDocFutureMktData_1 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_1 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_1 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]
;