I_MATERIALVALUATIONSBYPERIODS

CDS View

Material Valuations by Currtp/Period

I_MATERIALVALUATIONSBYPERIODS is a CDS View in S/4HANA. Material Valuations by Currtp/Period. It contains 5 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_MaterialInventoryPrice view from CONSUMPTION Material Inventory Price
C_MatlValnManageInvtryValn view from CONSUMPTION Prices and values over Per. and Curr.
P_TotalVltdStkAmtByValuation view_entity from COMPOSITE Material Ledger Price by Price Type

Fields (5)

KeyField CDS FieldsUsed in Views
ControllingArea ControllingArea 2
Currency Currency 1
CurrencyRole CurrencyRole 1
CurrencyRoleName CurrencyRoleName 1
FuturePriceValidityStartDate FuturePriceValidityStartDate 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 Valuations by Currtp/Period
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MATERIALVALUATIONSBYPERIODS (
    CONTROLLINGAREA,
    CURRENCY,
    CURRENCYROLE,
    CURRENCYROLENAME,
    FUTUREPRICEVALIDITYSTARTDATE
);