I_PrepaymentDocCmmdtyPrcgData

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_PrepaymentDocCmmdtyPrcgData.
-- 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_PrepaymentDocCmmdtyPrcgData AS
SELECT
  ConditionToGUID.knumv AS PrepaymentRefDocCondition,
  ConditionToGUID.kposn AS PrepaymentRefDocConditionItem,
  FormDocument.cond_type AS ConditionType,
  ConditionToGUID.docitem_guid AS DocItemCommodityPricingUUID,
  CPExt.cond_type AS CommodityPricingConditionType,
  TermOut.cond_type AS MarketConditionType,
  TermOut.extension_group AS PricingCndnTermExtensionGroup,
  FormDocument.formid AS PricingConditionFormulaKey,
  TermGrpOut.termid AS PricingConditionTermKey,
  TermGrpOut.extension_usage AS ConditionTermExtensionUsage,
  coalesce( TermOut.basis_id, TermGrpOut.basis_id ) AS BasisID,
  case when TermOut.keydate is not initial then TermOut.keydate when TermGrpOut.keydate is not initial then TermGrpOut.keydate end as MaturityKeyDate AS keydateendasMaturityKeyDate,
  case when TermOut.keydate is initial then cast( left( PeriodOut.lasttimestamp, 8) as abap.dats ) else cast( '00000000' as abap.dats ) end as CalculationPeriodEndDate AS datsendasCalculationPeriodEndDate,
  FormDocument.formcommquan AS PrcgCndnFmlaCommodityQuantity,
  FormDocument.formcommuom AS PrcgCndnFmlaCmmdtyQuantityUnit,
  TermGrpOut.termval AS PrepaymentRefDocFixedPrice,
  FormDocument.doccurr AS PrepaymentRefDocFixedPriceCrcy,
  TermGrpOut.usedquan AS CalcdPrcgConditionTermQuantity,
  TermGrpOut.useduom AS PrepaymentDocCmmdtyMktQtyUnit,
  TermGrpOut.termstatus AS ConditionTermStatus,
  TermInput.fixtermrate AS ACMPrcgCndnTermInputPrice,
  TermInput.fixtermcurr AS PrcgCndnFmlaFixedRateCurrency,
  TermInput.dcsid AS DerivativeContrSpecification,
  TermInput.mic AS MarketIdentifierCode,
  TermInput.basis_type AS BasisType,
  TermInput.pricetype AS QuotationPriceType,
  TermOut.termrate AS ConditionTermRate,
  TermOut.termcurr AS ConditionTermRateCurrency,
  coalesce(TermConvOut.usedexchrate, 1) AS PrcgCndnTermCnvrsnFxdExchRate,
  TermConvOut.usedcurrfrom AS PrcgCndnTermCnvrsnSourceCrcy,
  TermConvOut.usedcurrto AS PrcgCndnTermCnvrsnTargetCrcy,
  TermGrpOut.terminput_guid AS PricingConditionTermInputUUID,
  PrcFixDef.prc_fixation_status AS PrcgCndnTermFixationOptnStatus,
  PrcFixDef.non_fixed_quantity AS CndnTrmFixationOptnNonFixedQty,
  PrcFixDef.non_fixed_qty_uom AS TrmFixationOptnNonFixedQtyUnit
FROM cped_knumvtoguid AS ConditionToGUID
INNER JOIN cped_formdoc AS FormDocument ON /* join condition not captured in parsed metadata */
INNER JOIN prcd_elements AS PricingElements ON /* join condition not captured in parsed metadata */
;