R_MatlLdgrPriceByTwoValuations

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 R_MatlLdgrPriceByTwoValuations.
-- 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.
-- Parameters: P_MaterialLedgerLedger1 : fins_ledger, P_MaterialLedgerCurrencyRole1 : fins_ext_curtype, P_MaterialLedgerLedger2 : fins_ledger, P_MaterialLedgerCurrencyRole2 : fins_ext_curtype, P_ValidOnDate : fml_date_valid_on

CREATE VIEW R_MatlLdgrPriceByTwoValuations AS
SELECT
  _Valuation1.CostEstimate AS CostEstimate,
  _Valuation1.MaterialPriceType AS MaterialPriceType,
  _Valuation1.MaterialPriceSubtype AS MaterialPriceSubtype,
  _Valuation1.MaterialPriceValidityStartDate AS MaterialPriceValuation1StrtDt,
  _Valuation1.MaterialPriceValidityEndDate AS MaterialPriceValuation1EndDate,
  _Valuation2.MaterialPriceValidityStartDate AS MaterialPriceValuation2StrtDt,
  _Valuation2.MaterialPriceValidityEndDate AS MaterialPriceValuation2EndDate,
  _Valuation1.MaterialPriceControl AS MaterialPriceControl,
  _Valuation1.CurPlanProjSlsOrdValnStrategy AS CurPlanProjSlsOrdValnStrategy,
  _Valuation1.MaterialPriceCostEstimateStage AS MaterialPriceCostEstimateStage,
  _Valuation1.Material AS Material,
  _Valuation1.ValuationArea AS ValuationArea,
  _Valuation1.InventoryValuationType AS InventoryValuationType,
  _Valuation1.CompanyCode AS CompanyCode,
  _Valuation1.InvtryValnSpecialStockType AS InvtryValnSpecialStockType,
  _Valuation1.SalesOrder AS SalesOrder,
  _Valuation1.SalesOrderItem AS SalesOrderItem,
  cast(_Valuation1.WBSElementInternalID as ps_s4_pspnr) AS WBSElementInternalID,
  _Valuation1.Supplier AS Supplier,
  _Valuation1.StkMaterialPriceValuationType AS StkMaterialPriceValuationType,
  _Valuation1.MaterialPriceExtRefCategory AS MaterialPriceExtRefCategory,
  _Valuation1.MaterialPriceExtReference AS MaterialPriceExtReference,
  _SlsOrdProjValnStrategy.SlsOrdProjValnStrgyName AS SlsOrdProjValnStrgyName,
  cast(_Valuation1.MaterialPriceUnitQty as peinh) AS MatPriceUnitInFreeDefinedCrcy1,
  _Valuation1.ValuationQuantityUnit AS AdditionalQuantity1Unit,
  cast(_Valuation2.MaterialPriceUnitQty as peinh) AS MatPriceUnitInFreeDefinedCrcy2,
  _Valuation2.ValuationQuantityUnit AS AdditionalQuantity2Unit,
  cast(_Valuation1.MaterialPrice as fis_osl) AS AmountInFreeDefinedCurrency1,
  cast(_Valuation2.MaterialPrice as fis_vsl) AS AmountInFreeDefinedCurrency2,
  _Valuation1.Currency AS FreeDefinedCurrency1,
  _Valuation2.Currency AS FreeDefinedCurrency2,
  case _Valuation1.MaterialPrice when 0 then 0 else cast((division(cast((_Valuation2.MaterialPrice - _Valuation1.MaterialPrice) as abap.dec(23,2)), cast(_Valuation1.MaterialPrice as abap.dec(23,2)), 4) * 100) as abap.dec(23,2)) end as MatlLdgrPrThresholdInPercent AS dec232endasMatlLdgrPrThresholdInPercent,
  cast(_Valuation2.MaterialPrice - _Valuation1.MaterialPrice as fml_difference_price) AS MatlLdgrPriceDifferenceAmount,
  $parameters.P_ValidOnDate AS ValidOnDate,
  $parameters.P_MaterialLedgerLedger1 AS MaterialLedgerLedger1,
  $parameters.P_MaterialLedgerCurrencyRole1 AS MaterialLedgerCurrencyRole1,
  $parameters.P_MaterialLedgerLedger2 AS MaterialLedgerLedger2,
  $parameters.P_MaterialLedgerCurrencyRole2 AS MaterialLedgerCurrencyRole2
FROM I_MaterialLedgerPrice AS _Valuation1
LEFT OUTER JOIN R_MatlValnEndgInvtryByKeyDate AS _TotalValuatedStockAmount1 ON CostEstimate = _TotalValuatedStockAmount1.CostEstimate AND Material = _TotalValuatedStockAmount1.Material AND ValuationArea = _TotalValuatedStockAmount1.ValuationArea AND CompanyCode = _TotalValuatedStockAmount1.CompanyCode AND _TotalValuatedStockAmount1.Ledger = $parameters.P_MaterialLedgerLedger1 AND _TotalValuatedStockAmount1.CurrencyRole = $parameters.P_MaterialLedgerCurrencyRole1 AND P_ValidOnDate = _TotalValuatedStockAmount1.ValidOnDate  -- association [0..1]
LEFT OUTER JOIN R_MatlValnEndgInvtryByKeyDate AS _TotalValuatedStockAmount2 ON CostEstimate = _TotalValuatedStockAmount2.CostEstimate AND Material = _TotalValuatedStockAmount2.Material AND ValuationArea = _TotalValuatedStockAmount2.ValuationArea AND CompanyCode = _TotalValuatedStockAmount2.CompanyCode AND _TotalValuatedStockAmount2.Ledger = $parameters.P_MaterialLedgerLedger2 AND _TotalValuatedStockAmount2.CurrencyRole = $parameters.P_MaterialLedgerCurrencyRole2 AND P_ValidOnDate = _TotalValuatedStockAmount2.ValidOnDate  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON ValuationArea = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_MaterialPriceControl AS _MaterialPriceControl ON MaterialPriceControl = _MaterialPriceControl.MaterialPriceControl  -- association [0..1]
LEFT OUTER JOIN I_MaterialLedgerPriceType AS _PriceType ON MaterialPriceType = _PriceType.MaterialPriceType  -- association [1..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_InvtryValnSpecialStockType AS _InvtryValnSpecialStockType ON InvtryValnSpecialStockType = _InvtryValnSpecialStockType.InvtryValnSpecialStockType  -- association [0..1]
LEFT OUTER JOIN I_MatlPriceCostEstimateStage AS _MatlPriceCostEstimateStage ON MaterialPriceCostEstimateStage = _MatlPriceCostEstimateStage.MaterialPriceCostEstimateStage  -- association [0..1]
LEFT OUTER JOIN I_StkMatlPriceValuationType AS _StkMatlPriceValuationType ON StkMaterialPriceValuationType = _StkMatlPriceValuationType.StkMaterialPriceValuationType  -- association [0..1]
LEFT OUTER JOIN I_SlsOrdProjValnStrategyStdVH AS _SlsOrdProjValnStrategy ON CurPlanProjSlsOrdValnStrategy = _SlsOrdProjValnStrategy.SlsOrdProjValnStrategy  -- association [0..1]
;