I_MATERIALVALUATIONHIST

CDS View
5 Fields 3 CDS Views

Material Valuation History

I_MATERIALVALUATIONHIST is a CDS View in S/4HANA. Material Valuation History. It contains 5 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_CN_MaterialStockValuation view union COMPOSITE Material stock valuation for china turnover report
I_RO_SAFTMatlValuationHistory view from COMPOSITE Material Value History for Romania SAFT
P_MatlMovingAvgPrice view from CONSUMPTION Moving Average Price for Material

Fields (5)

KeyField CDS FieldsUsed in Views
KEY Material Material 2
KEY ValuationArea Plant 1
KEY ValuationType ValuationType 1
StockValueInCCCrcy StockValueInCCCrcy 1
TotalValStockQuantity TotalValStockQuantity 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Material Valuation History
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MATERIALVALUATIONHIST (
    MATERIAL,
    VALUATIONAREA,
    VALUATIONTYPE,
    STOCKVALUEINCCCRCY,
    TOTALVALSTOCKQUANTITY,
    PRIMARY KEY (MATERIAL, VALUATIONAREA, VALUATIONTYPE)
);

Learn More