C_MaterialInventoryPrice

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 C_MaterialInventoryPrice.
-- 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.
-- SQL view name: CMATINVPR

CREATE VIEW C_MaterialInventoryPrice AS
SELECT
  CostEstimate,
  FiscalYear,
  FiscalPeriod,
  LedgerValuationCurrencyRole,
  I_MaterialValuationsByPeriods.CurrencyRole AS CurrencyRole,
  I_MaterialValuationsByPeriods.CurrencyRoleName AS CurrencyRoleName,
  cast ('' as fml_umip_icon_path) AS OpnCtlgIconPath,
  Material,
  MaterialName,
  cast( InventoryValuationType as fml_umip_invtry_valuation_type ) AS InventoryValuationType,
  cast( InventoryValuationCategory as bwtty_d ) AS InventoryValuationCategory,
  Plant,
  PlantName,
  cast( concat( LegalCurrencyRole, concat( '/', concat ( Ledger, concat( '/', AcctgValnVwSubviewCombinedName ) ) ) ) as fins_ldgrvalncrcyrolesemkey ) AS LdgrValnCrcyRoleSemanticKey,
  LegalCurrencyRole,
  LegalCurrencyRoleName,
  Ledger,
  LedgerName,
  cast( AcctgValnVwSubviewCombinedName as fml_umip_valuviewname ) AS AcctgValnVwSubviewCombinedName,
  AccountingValuationView,
  AccountingValuationSubview,
  cast (1 as fml_umip_new_price) AS NewInventoryPrice,
  cast (0 as fml_umip_new_price_unit) AS NewMaterialPriceUnitQty,
  cast (MaterialPriceUnitQty as fml_umip_current_price_unit) AS MaterialPriceUnitQty,
  cast(TotalVltdStockQuantity as fml_umip_valuation_quantity) AS TotalVltdStockQuantity,
  cast (0 as fml_umip_new_total_value) AS NewStockAmount,
  cast (TotalValuatedStockAmount as fml_umip_current_total_value) AS TotalValuatedStockAmount,
  cast ('' as fml_umip_valuation_impact) AS ValuationImpactValue,
  cast ('' as fml_umip_mat_status_txt) AS MaterialStatusText,
  I_MaterialValuationsByPeriods.Currency AS Currency,
  ValuationQuantityUnit,
  cast( I_MaterialValuationsByPeriods.CompanyCode as fis_bukrs ) AS CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  cast ('' as kurst ) AS ExchangeRateType,
  I_MaterialValuationsByPeriods.ControllingArea AS ControllingArea,
  ControllingValuationType,
  ValuationArea,
  InvtryValnSpecialStockType
FROM I_MaterialValuationsByPeriods
;