P_MATLCTRLRECDLDGRFISCALPERIOD

CDS View
17 Fields 6 CDS Views

P_MATLCTRLRECDLDGRFISCALPERIOD is a CDS View in S/4HANA. It contains 17 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
I_MatlCtrlRecdLdgrFiscalPeriod view from BASIC MatlCtrlRecd Fiscal Periods per Ledger
P_MatVal_By_Period_Types view inner BASIC
P_Matval_Manage_Bal view inner BASIC
P_Matval_Manage_Bal_Split view inner BASIC
P_Matval_Manage_Pnv_Pre view inner BASIC
P_Matval_Manage_Val_Chart view inner BASIC

Fields (17)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 1
KEY CurrentFiscalPeriod CurrentFiscalPeriod,FiscalPeriod 2
KEY CurrentFiscalYear CurrentFiscalYear,FiscalYear 2
KEY Ledger Ledger 1
KEY PrevFiscalYearLastFiscalPeriod FiscalPeriod,PrevFiscalYearLastFiscalPeriod 2
KEY PreviousFiscalPeriod FiscalPeriod,PreviousFiscalPeriod 2
KEY PreviousFiscalPeriodFiscalYear FiscalYear,PreviousFiscalPeriodFiscalYear 2
KEY PreviousFiscalYear FiscalYear,PreviousFiscalYear 2
CurrentFiscalPeriodEndDate CurrentFiscalPeriodEndDate 1
CurrentFiscalPeriodStartDate CurrentFiscalPeriodStartDate 1
CurrentFiscalYearPeriod CurrentFiscalYearPeriod 1
PrevFsclYearLastFsclYearPeriod PrevFsclYearLastFsclYearPeriod 1
PrevFsclYrLastFsclPerdEndDate PrevFsclYrLastFsclPerdEndDate 1
PrevFsclYrLastFsclPerdStrtDate PrevFsclYrLastFsclPerdStrtDate 1
PreviousFiscalPeriodEndDate PreviousFiscalPeriodEndDate 1
PreviousFiscalPeriodStartDate PreviousFiscalPeriodStartDate 1
PreviousFiscalYearPeriod PreviousFiscalYearPeriod 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_MATLCTRLRECDLDGRFISCALPERIOD (
    COMPANYCODE,
    CURRENTFISCALPERIOD,
    CURRENTFISCALYEAR,
    LEDGER,
    PREVFISCALYEARLASTFISCALPERIOD,
    PREVIOUSFISCALPERIOD,
    PREVIOUSFISCALPERIODFISCALYEAR,
    PREVIOUSFISCALYEAR,
    CURRENTFISCALPERIODENDDATE,
    CURRENTFISCALPERIODSTARTDATE,
    CURRENTFISCALYEARPERIOD,
    PREVFSCLYEARLASTFSCLYEARPERIOD,
    PREVFSCLYRLASTFSCLPERDENDDATE,
    PREVFSCLYRLASTFSCLPERDSTRTDATE,
    PREVIOUSFISCALPERIODENDDATE,
    PREVIOUSFISCALPERIODSTARTDATE,
    PREVIOUSFISCALYEARPERIOD,
    PRIMARY KEY (COMPANYCODE, CURRENTFISCALPERIOD, CURRENTFISCALYEAR, LEDGER, PREVFISCALYEARLASTFISCALPERIOD, PREVIOUSFISCALPERIOD, PREVIOUSFISCALPERIODFISCALYEAR, PREVIOUSFISCALYEAR)
);

Learn More