P_MatlLdgrPrByMltplValuations

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_MatlLdgrPrByMltplValuations.
-- 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 P_MatlLdgrPrByMltplValuations AS
SELECT
  cast(CostEstimate as fml_chmp_cost_estimate_number preserving type) AS CostEstimate,
  Ledger,
  CurrencyRole,
  MaterialPriceType,
  MaterialPriceSubtype,
  MaterialPriceValidityStartDate,
  cast(MaterialPriceValidityEndDate as fml_date_to preserving type) AS MaterialPriceValidityEndDate,
  CompanyCode,
  cast(MaterialPriceControl as fml_mpchd_price_control preserving type) AS MaterialPriceControl,
  cast(CurPlanProjSlsOrdValnStrategy as fml_chmp_lbwst preserving type) AS CurPlanProjSlsOrdValnStrategy,
  MaterialPriceCostEstimateStage,
  cast(InventoryValuationType as fml_mpchd_valuation_type preserving type) AS InventoryValuationType,
  InvtryValnSpecialStockType,
  StkMaterialPriceValuationType,
  MaterialPriceExtReference,
  MaterialPriceExtRefCategory,
  cast(SalesOrder as vbeln preserving type) AS SalesOrder,
  cast(SalesOrderItem as posnr preserving type) AS SalesOrderItem,
  Material,
  ValuationArea,
  cast(WBSElementInternalID as ps_s4_pspnr preserving type) AS WBSElementInternalID,
  cast(Supplier as lifnr preserving type) AS Supplier,
  _SlsOrdProjValnStrategy.SlsOrdProjValnStrgyName AS SlsOrdProjValnStrgyName,
  concat(concat(Ledger, CurrencyRole), ',') AS MaterialValuationListText,
  cast('' as fml_valncrcyrolesemkey) AS MatlLdgrPrValnCrcyRoleSemKey,
  cast('00010101' as fml_date_valid_on) AS ValidOnDate,
  cast(0 as fis_osl) AS AmountInFreeDefinedCurrency1,
  cast(0 as fis_vsl) AS AmountInFreeDefinedCurrency2,
  cast(0 as fis_bsl) AS AmountInFreeDefinedCurrency3,
  cast(0 as fis_csl) AS AmountInFreeDefinedCurrency4,
  cast(0 as fis_dsl) AS AmountInFreeDefinedCurrency5,
  cast(0 as fis_esl) AS AmountInFreeDefinedCurrency6,
  cast(0 as fis_fsl) AS AmountInFreeDefinedCurrency7,
  cast(0 as fis_gsl) AS AmountInFreeDefinedCurrency8,
  cast(0 as fis_freely_defined_currency_9) AS AmountInFreeDefinedCurrency9,
  cast('' as fis_rocur) AS FreeDefinedCurrency1,
  cast('' as fis_rvcur) AS FreeDefinedCurrency2,
  cast('' as fins_curr3) AS FreeDefinedCurrency3,
  cast('' as fins_curr4) AS FreeDefinedCurrency4,
  cast('' as fins_curr5) AS FreeDefinedCurrency5,
  cast('' as fins_curr6) AS FreeDefinedCurrency6,
  cast('' as fins_curr7) AS FreeDefinedCurrency7,
  cast('' as fins_curr8) AS FreeDefinedCurrency8,
  cast('' as fins_curr9) AS FreeDefinedCurrency9
FROM I_MaterialLedgerPrice
LEFT OUTER JOIN I_Plant AS _Plant ON ValuationArea = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- 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]
;