I_MATLCTRLRECDLDGRFISCALPERIOD

CDS View

MatlCtrlRecd Fiscal Periods per Ledger

I_MATLCTRLRECDLDGRFISCALPERIOD is a CDS View in S/4HANA. MatlCtrlRecd Fiscal Periods per Ledger. It contains 6 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_MaterialValuationsByPeriods view inner COMPOSITE Material Valuations by Currtp/Period
P_MlPrice_By_Periodtype view inner COMPOSITE

Fields (6)

KeyField CDS FieldsUsed in Views
KEY CurrentFiscalPeriod FiscalPeriod 1
KEY CurrentFiscalYear FiscalYear 1
KEY PrevFiscalYearLastFiscalPeriod FiscalPeriod 1
KEY PreviousFiscalPeriod FiscalPeriod 1
KEY PreviousFiscalPeriodFiscalYear FiscalYear 1
KEY PreviousFiscalYear FiscalYear 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.

-- MatlCtrlRecd Fiscal Periods per Ledger
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_MATLCTRLRECDLDGRFISCALPERIOD (
    CURRENTFISCALPERIOD,
    CURRENTFISCALYEAR,
    PREVFISCALYEARLASTFISCALPERIOD,
    PREVIOUSFISCALPERIOD,
    PREVIOUSFISCALPERIODFISCALYEAR,
    PREVIOUSFISCALYEAR,
    PRIMARY KEY (CURRENTFISCALPERIOD, CURRENTFISCALYEAR, PREVFISCALYEARLASTFISCALPERIOD, PREVIOUSFISCALPERIOD, PREVIOUSFISCALPERIODFISCALYEAR, PREVIOUSFISCALYEAR)
);