FINSC_FISC_DATE

Transparent Table Customizing Table
21 Fields 11 CDS Views

Fiscal Date

FINSC_FISC_DATE is an SAP database table in S/4HANA. Fiscal Date. It contains 21 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
FINCS_FISCAL_YEAR_PEROID view from FINCS Fiscal year peroid
ICA_BSEG_ENTRY_VIEW view inner ICA: Entry View Based on BSEG
ICA_CONSJOURNALENTRIES_4 view inner Match Consolidation Journal Entry Lines
ICA_CONSJOURNALENTRIES_5 view inner Match Consolidation Journal Entry Lines
ICA_FiscalCalendarDate view from Map Calendar to Fiscal year and period
ICA_GENJOURNALENTRIES_2 view inner Match Universal Journal Entry Line Items
ICA_GENJOURNALENTRIES_C2 view inner Match Universal Journal Entry Line Items
ICA_P_CONSJOURNALENTRIES_01 view inner ICA: Consolidation Journal Entry Line Items from ACDOCA
P_CnsldtnGlobalParameter view inner BASIC
P_Consfiscalmap view from BASIC
P_FiscalCalendarDate view_entity from BASIC

Fields (21)

KeyField Data ElementDescription DomainTypeLength
KEY client MANDT Client
KEY fiscal_year_variant FINS_PERIV Fiscal Year Variant
KEY calendar_date FINS_CALDATE Calendar Date
fiscal_year FINS_GJAHR Fiscal Year
fiscal_period FINS_FISCALPERIOD Fiscal Period
fiscal_period_start_date FINS_FPERIOD_STARTDATE Start Date
fiscal_period_end_date FINS_FPERIOD_ENDDATE End Date
fiscal_year_quarter FINS_FYEARQUARTER Fiscal YQuarter
fiscal_year_start_date FINS_FYEAR_STARTDATE Start Date
fiscal_year_end_date FINS_FYEAR_ENDDATE End Date
fiscal_quarter_start_date FINS_FQUARTER_STARTDATE Start Date
fiscal_quarter_end_date FINS_FQUARTER_ENDDATE End Date
fiscal_year_period FINS_JAHRPER Fiscal Year Period
fiscal_quarter FINS_FSCALQUARTER Fiscal Quarter
fiscal_week FINS_FISCALWEEK Fiscal Week
fiscal_week_start_date FINS_FWEEK_STARTDATE Strt Fscl Week
fiscal_week_end_date FINS_FWEEK_ENDDATE End Fscl Week
fiscal_year_week FINS_FYEARWEEK Fiscal YWeek
fiscal_year_period_int FINS_FYEARPERIOD_I Fiscal Period Number
fiscal_year_quarter_int FINS_FYEARQUARTER_I Fiscal Quarter Nmber
fiscal_year_week_int FINS_FYEARWEEK_I Fiscal Week Number

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.

-- Fiscal Date
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINSC_FISC_DATE (
    CLIENT,                     -- Client [MANDT]
    FISCAL_YEAR_VARIANT,        -- Fiscal Year Variant [FINS_PERIV]
    CALENDAR_DATE,              -- Calendar Date [FINS_CALDATE]
    FISCAL_YEAR,                -- Fiscal Year [FINS_GJAHR]
    FISCAL_PERIOD,              -- Fiscal Period [FINS_FISCALPERIOD]
    FISCAL_PERIOD_START_DATE,   -- Start Date [FINS_FPERIOD_STARTDATE]
    FISCAL_PERIOD_END_DATE,     -- End Date [FINS_FPERIOD_ENDDATE]
    FISCAL_YEAR_QUARTER,        -- Fiscal YQuarter [FINS_FYEARQUARTER]
    FISCAL_YEAR_START_DATE,     -- Start Date [FINS_FYEAR_STARTDATE]
    FISCAL_YEAR_END_DATE,       -- End Date [FINS_FYEAR_ENDDATE]
    FISCAL_QUARTER_START_DATE,  -- Start Date [FINS_FQUARTER_STARTDATE]
    FISCAL_QUARTER_END_DATE,    -- End Date [FINS_FQUARTER_ENDDATE]
    FISCAL_YEAR_PERIOD,         -- Fiscal Year Period [FINS_JAHRPER]
    FISCAL_QUARTER,             -- Fiscal Quarter [FINS_FSCALQUARTER]
    FISCAL_WEEK,                -- Fiscal Week [FINS_FISCALWEEK]
    FISCAL_WEEK_START_DATE,     -- Strt Fscl Week [FINS_FWEEK_STARTDATE]
    FISCAL_WEEK_END_DATE,       -- End Fscl Week [FINS_FWEEK_ENDDATE]
    FISCAL_YEAR_WEEK,           -- Fiscal YWeek [FINS_FYEARWEEK]
    FISCAL_YEAR_PERIOD_INT,     -- Fiscal Period Number [FINS_FYEARPERIOD_I]
    FISCAL_YEAR_QUARTER_INT,    -- Fiscal Quarter Nmber [FINS_FYEARQUARTER_I]
    FISCAL_YEAR_WEEK_INT,       -- Fiscal Week Number [FINS_FYEARWEEK_I]
    PRIMARY KEY (CLIENT, FISCAL_YEAR_VARIANT, CALENDAR_DATE)
);

Learn More