I_MLPrcWthUnivCompBreakdown

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_MLPrcWthUnivCompBreakdown.
-- 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_MLPrcWthUnivCompBreakdown AS
SELECT
  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,
  cast(MatlPrcValdtyEndFsclYearPeriod as fml_to_period_year preserving type) AS MatlPrcValdtyEndFsclYearPeriod,
  MatlPrcValidityStartFiscalYear,
  MatlPrcValdtyStartFiscalPeriod,
  MatlPrcValidityEndFiscalYear,
  MatlPrcValdtyEndFiscalPeriod,
  ComponentBreakdown,
  MaterialPrice,
  FixedPortionOfMaterialPrice,
  Currency,
  MaterialPriceUnitQty,
  cast( ValuationQuantityUnit as fml_valuation_unit_of_measure preserving type ) AS ValuationQuantityUnit,
  MaterialPriceControl,
  CurPlanProjSlsOrdValnStrategy,
  MaterialPriceCostEstimateStage,
  Material,
  ValuationArea,
  InventoryValuationType,
  CompanyCode,
  InvtryValnSpecialStockType,
  SalesOrder,
  SalesOrderItem,
  cast(WBSElementInternalID as ps_s4_pspnr) AS WBSElementInternalID,
  cast('00010101' as fml_date_valid_on) AS ValidOnDate,
  Supplier,
  StkMaterialPriceValuationType,
  MaterialPriceExtRefCategory,
  MaterialPriceExtReference,
  MaterialPriceCreatedByUser,
  MaterialPriceChangedByUser,
  MaterialPriceCreationDateTime,
  MatlPriceLastChangeDateTime,
  _SlsOrdProjValnStrategy.SlsOrdProjValnStrgyName AS SlsOrdProjValnStrgyName,
  _CurrencyRoleMapping.LegalCurrencyRoleName AS LegalCurrencyRoleName,
  _CurrencyRoleMapping.LegalCurrencyRole AS LegalCurrencyRole,
  _CurrencyRoleMapping.AccountingValuationViewName AS AccountingValuationViewName,
  _CurrencyRoleMapping.AccountingValuationView AS AccountingValuationView
FROM I_MaterialLedgerPrice
LEFT OUTER JOIN I_Plant AS _Plant ON ValuationArea = _Plant.ValuationArea  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [1..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElementBasicData ON WBSElementInternalID = _WBSElementBasicData.WBSElementInternalID  -- association [0..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_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [1..1]
LEFT OUTER JOIN I_MaterialLedgerPriceType AS _PriceType ON MaterialPriceType = _PriceType.MaterialPriceType  -- association [1..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]
LEFT OUTER JOIN R_MatlLedgerValnCrcyRole AS _CurrencyRoleMapping ON CurrencyRole = _CurrencyRoleMapping.CurrencyRole AND CompanyCode = _CurrencyRoleMapping.CompanyCode AND Ledger = _CurrencyRoleMapping.Ledger  -- association [0..1]
LEFT OUTER JOIN I_MatlLedgerValnCrcyRoleName AS _Curtp ON CompanyCode = _Curtp.CompanyCode AND Ledger = _Curtp.Ledger AND CurrencyRole = _Curtp.CurrencyRole  -- association [1..1]
;