I_MaterialLedgerPriceOverview

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_MaterialLedgerPriceOverview.
-- 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 I_MaterialLedgerPriceOverview AS
SELECT
  cast(CostEstimate as fml_chmp_cost_estimate_number preserving type ) AS CostEstimate,
  Ledger,
  CurrencyRole,
  MaterialPriceType,
  MaterialPriceSubtype,
  cast(MaterialPriceValidityEndDate as fml_date_to preserving type ) AS MaterialPriceValidityEndDate,
  cast( MatlPrcValdtyStrtFsclYearPerd as fml_from_period_year preserving type ) AS MatlPrcValdtyStrtFsclYearPerd,
  MatlPrcValidityStartFiscalYear,
  MatlPrcValdtyStartFiscalPeriod,
  cast( MatlPrcValdtyEndFsclYearPeriod as fml_to_period_year preserving type ) AS MatlPrcValdtyEndFsclYearPeriod,
  MatlPrcValidityEndFiscalYear,
  MatlPrcValdtyEndFiscalPeriod,
  MaterialPrice,
  Currency,
  cast(MaterialPriceUnitQty as fml_mpchd_price_unit preserving type ) AS MaterialPriceUnitQty,
  cast( ValuationQuantityUnit as fml_valuation_unit_of_measure preserving type ) AS ValuationQuantityUnit,
  cast(MaterialPriceControl as fml_mpchd_price_control preserving type ) AS MaterialPriceControl,
  FixedPortionOfMaterialPrice,
  cast(CurPlanProjSlsOrdValnStrategy as fml_chmp_lbwst preserving type ) AS CurPlanProjSlsOrdValnStrategy,
  MaterialPriceCostEstimateStage,
  Material,
  ValuationArea,
  cast(ValuationArea as werks_d preserving type ) AS Plant,
  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,
  MaterialPriceCreatedByUser,
  MaterialPriceChangedByUser,
  cast(MaterialPriceCreationDateTime as fml_chmp_created_on preserving type ) AS MaterialPriceCreationDateTime,
  cast(MatlPriceLastChangeDateTime as fml_chmp_changed_on preserving type ) AS MatlPriceLastChangeDateTime,
  cast(_LedgerValuationCrcyRole.AcctgValnVwSubviewCombinedName as fml_umip_valuviewname preserving type ) AS AcctgValnVwSubviewCombinedName,
  cast('' as fac_network_graph_group_id) AS UI5NetworkGraphGroup
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_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [1..1]
LEFT OUTER JOIN I_CurrencyRole AS _CurrencyRole ON CurrencyRole = _CurrencyRole.CurrencyRole  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedBy ON MaterialPriceCreatedByUser = _CreatedBy.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ChangedBy ON MaterialPriceChangedByUser = _ChangedBy.ContactCardID  -- association [0..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_MaterialPriceControl AS _MaterialPriceControl ON MaterialPriceControl = _MaterialPriceControl.MaterialPriceControl  -- association [0..1]
LEFT OUTER JOIN I_StkMatlPriceValuationType AS _StkMatlPriceValuationType ON StkMaterialPriceValuationType = _StkMatlPriceValuationType.StkMaterialPriceValuationType  -- association [0..1]
LEFT OUTER JOIN I_SlsOrdProjValuationStrategy AS _SlsOrdProjValuationStrategy ON CurPlanProjSlsOrdValnStrategy = _SlsOrdProjValuationStrategy.SlsOrdProjValnStrategy  -- association [0..1]
LEFT OUTER JOIN R_MatlLedgerValnCrcyRole AS _LedgerValuationCrcyRole ON CurrencyRole = _LedgerValuationCrcyRole.CurrencyRole AND Ledger = _LedgerValuationCrcyRole.Ledger AND CompanyCode = _LedgerValuationCrcyRole.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_MaterialLedgerPriceType AS _PriceType ON MaterialPriceType = _PriceType.MaterialPriceType  -- association [1..1]
LEFT OUTER JOIN I_SalesDocumentItem AS _SalesDocumentItem ON SalesOrder = _SalesDocumentItem.SalesDocument AND SalesOrderItem = _SalesDocumentItem.SalesDocumentItem  -- association [0..1]
;