P_MatlLdgrPrByPrTypeNoTblFunc

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_MatlLdgrPrByPrTypeNoTblFunc.
-- 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_ValidOnDate : fml_date_valid_on

CREATE VIEW P_MatlLdgrPrByPrTypeNoTblFunc AS
SELECT
  cast(CostEstimate as fml_chmp_cost_estimate_number preserving type ) AS CostEstimate,
  MaterialPriceType,
  MaterialPriceSubtype,
  cast(MaterialPriceValidityEndDate as fml_date_to preserving type ) AS MaterialPriceValidityEndDate,
  cast( MatlPrcValdtyStrtFsclYearPerd as fml_from_period_year preserving type ) AS MatlPrcValdtyStrtFsclYearPerd,
  cast( MatlPrcValdtyEndFsclYearPeriod as fml_to_period_year preserving type ) AS MatlPrcValdtyEndFsclYearPeriod,
  MatlPrcValidityStartFiscalYear,
  MatlPrcValdtyStartFiscalPeriod,
  MatlPrcValidityEndFiscalYear,
  MatlPrcValdtyEndFiscalPeriod,
  cast(MaterialPriceControl as fml_mpchd_price_control preserving type ) AS MaterialPriceControl,
  cast(CurPlanProjSlsOrdValnStrategy as fml_chmp_lbwst preserving type ) AS CurPlanProjSlsOrdValnStrategy,
  _SlsOrdProjValnStrategy.SlsOrdProjValnStrgyName AS SlsOrdProjValnStrgyName,
  MaterialPriceCostEstimateStage,
  Material,
  ValuationArea,
  cast(InventoryValuationType as fml_mpchd_valuation_type preserving type ) AS InventoryValuationType,
  CompanyCode,
  InvtryValnSpecialStockType,
  cast(SalesOrder as vbeln preserving type ) AS SalesOrder,
  cast(SalesOrderItem as posnr preserving type ) AS SalesOrderItem,
  cast(WBSElementInternalID as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  cast(Supplier as lifnr preserving type ) AS Supplier,
  StkMaterialPriceValuationType,
  MaterialPriceExtRefCategory,
  MaterialPriceExtReference,
  cast(0 as fis_osl) AS AmountInFreeDefinedCurrency1,
  cast(0 as fis_vsl) AS AmountInFreeDefinedCurrency2,
  cast('' as fis_rocur) AS FreeDefinedCurrency1,
  cast('' as fis_rvcur) AS FreeDefinedCurrency2,
  cast(0 as fml_difference_price) AS MatlLdgrPriceDifferenceAmount,
  cast('' as waers) AS Currency,
  cast(0 as fml_threshold_in_percent) AS MatlLdgrPrThresholdInPercent,
  $parameters.P_ValidOnDate AS ValidOnDate
FROM P_MntrMatlPrWthoutTblFunc
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]
;