P_MatlLedgerPriceByPriceType

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 P_MatlLedgerPriceByPriceType.
-- 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_MaterialLedgerValuation1 : fml_valuationtocompare1, P_MaterialLedgerValuation2 : fml_valuationtocompare2, P_ValidOnDate : fml_date_valid_on

CREATE VIEW P_MatlLedgerPriceByPriceType AS
SELECT
  CostEstimate,
  MaterialPriceType,
  MaterialPriceSubtype,
  MaterialPriceValidityStartDate,
  MaterialPriceValidityEndDate,
  MaterialPriceControl,
  CurPlanProjSlsOrdValnStrategy,
  MaterialPriceCostEstimateStage,
  Material,
  ValuationArea,
  InventoryValuationType,
  CompanyCode,
  InvtryValnSpecialStockType,
  SalesOrder,
  SalesOrderItem,
  WBSElementInternalID,
  Supplier,
  StkMaterialPriceValuationType,
  MaterialPriceExtRefCategory,
  MaterialPriceExtReference,
  SlsOrdProjValnStrgyName,
  cast(_Valuation1.MaterialPrice as fis_osl) AS AmountInFreeDefinedCurrency1,
  cast(_Valuation2.MaterialPrice as fis_vsl) AS AmountInFreeDefinedCurrency2,
  _Valuation1.Currency AS FreeDefinedCurrency1,
  _Valuation2.Currency AS FreeDefinedCurrency2,
  cast(_Valuation1.MaterialPriceUnitQty as peinh) AS MatPriceUnitInFreeDefinedCrcy1,
  _Valuation1.ValuationQuantityUnit AS AdditionalQuantity1Unit,
  cast(_Valuation2.MaterialPriceUnitQty as peinh) AS MatPriceUnitInFreeDefinedCrcy2,
  _Valuation2.ValuationQuantityUnit AS AdditionalQuantity2Unit,
  _TotalValuatedStockAmount1( P_ValidOnDate: $parameters.P_ValidOnDate ).TotalValuatedStockAmount AS TotalValuatedStockAmount,
  _TotalValuatedStockAmount2( P_ValidOnDate: $parameters.P_ValidOnDate ).TotalValuatedStockAmount AS TotalValuatedStockAmount2,
  _TotalValuatedStockAmount1( P_ValidOnDate: $parameters.P_ValidOnDate ).Currency AS FreeDefinedCurrency3,
  _TotalValuatedStockAmount2( P_ValidOnDate: $parameters.P_ValidOnDate ).Currency AS FreeDefinedCurrency4,
  cast(_TotalValuatedStockAmount1( P_ValidOnDate: $parameters.P_ValidOnDate ).ValuationQuantity as fin_qtyval) AS FreeDefinedQuantity1,
  _TotalValuatedStockAmount1( P_ValidOnDate: $parameters.P_ValidOnDate ).UnitOfMeasure AS FreeDefinedQuantity1Unit,
  cast(_TotalValuatedStockAmount2( P_ValidOnDate: $parameters.P_ValidOnDate ).ValuationQuantity as fin_qtyval) AS FreeDefinedQuantity2,
  _TotalValuatedStockAmount2( P_ValidOnDate: $parameters.P_ValidOnDate ).UnitOfMeasure AS FreeDefinedQuantity2Unit,
  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_MaterialLedgerValuation1 AS MaterialLedgerValuation1,
  $parameters.P_MaterialLedgerValuation2 AS MaterialLedgerValuation2,
  $parameters.P_ValidOnDate AS ValidOnDate
FROM P_MatlLdgrPriceByTwoValuations
;