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 Global Parameters with Dates
P_Consfiscalmap view from BASIC Fiscal Calendar Mapping for FI Consolidation
P_FiscalCalendarDate view_entity from BASIC Fiscal Calendar Date

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