I_PrepaymentDocCmmdtyPrcgVal

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_PrepaymentDocCmmdtyPrcgVal.
-- 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.
-- SQL view name: IPPMGDOCCMDTYPRC

CREATE VIEW I_PrepaymentDocCmmdtyPrcgVal 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,
  coalesce( TermGrpOut.extension_usage, '' ) AS ConditionTermExtensionUsage,
  coalesce( TermOut.basis_id, TermGrpOut.basis_id ) AS BasisID,
  TermOut.keydate AS MaturityKeyDate,
  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,
  TermInput.fixtermrate AS ACMPrcgCndnTermInputPrice,
  TermInput.fixtermcurr AS PrcgCndnFmlaFixedRateCurrency,
  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 */
;