FINSC_PERIOD

Transparent Table Customizing Table
12 Fields 14 CDS Views

Fiscal Periods

FINSC_PERIOD is an SAP database table in S/4HANA. Fiscal Periods. It contains 12 fields. 14 CDS views read from this table.

CDS Views using this table (14)

ViewTypeJoinVDMDescription
FCML_FIND_MLDOC_WRONG_BUDAT_V view inner CDS View to detect wrong BUDAT in MLDOC
FCML_MLDOC_EMPTY_BUDAT_DDL view inner CDS View to detect empty BUDAT in MLDOC
FINS_IC_CONV_DATE view left_outer IC: Conversion dates for ACDOCA entries
FINS_IC_DATE_ZERO_POPER view inner IC: Conversion dates for zero poper
gle_adb_kfc_accdoc_item view left_outer Average Daily Balances - Line Item
I_FiscalPeriodForCoCodeText view_entity inner BASIC Fiscal Period for Company Code - Text
I_FiscalPeriodText view_entity inner BASIC Fiscal Period Text
I_FiscalYearPeriodText view_entity inner BASIC Fiscal Year Period Text
P_FiscalYearPeriod view_entity from BASIC Fiscal Year Period
P_GR_FiscalYearPeriod view_entity from BASIC Greece Fiscal year period
P_PlanCostRateByPeriod view left_outer BASIC Private view for Cost Rate by Period
v_ml_l3_total_view view inner LOCAL: Material Ledger Totals
v_ml_p_gap_l2_view view left_outer LOCAL: Material Ledger Gap in Periods
v_ml_perio_l3_view view left_outer LOCAL: Material Ledger Periods

Fields (12)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY fiscal_year_variant fins_periv Fiscal Year Variant
KEY fiscal_year fins_gjahr Fiscal Year
KEY fiscal_period fins_fiscalperiod Fiscal Period
fiscal_period_start_date fins_fperiod_startdate Start Date
fiscal_period_end_date fins_fperiod_enddate End Date
is_special_period fins_xspecper Is Spec. Period
fiscal_year_start_date fins_fyear_startdate Start Date
fiscal_year_end_date fins_fyear_enddate End Date
next_fiscal_period fins_next_fiscalperiod Next Period
next_fiscal_period_fiscal_year fins_next_fiscperiodfiscyear Next FiscPerFiscYear
fiscal_year_period fins_jahrper Fiscal Year Period

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 Periods
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE FINSC_PERIOD (
    CLIENT,                          -- Client [mandt]
    FISCAL_YEAR_VARIANT,             -- Fiscal Year Variant [fins_periv]
    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]
    IS_SPECIAL_PERIOD,               -- Is Spec. Period [fins_xspecper]
    FISCAL_YEAR_START_DATE,          -- Start Date [fins_fyear_startdate]
    FISCAL_YEAR_END_DATE,            -- End Date [fins_fyear_enddate]
    NEXT_FISCAL_PERIOD,              -- Next Period [fins_next_fiscalperiod]
    NEXT_FISCAL_PERIOD_FISCAL_YEAR,  -- Next FiscPerFiscYear [fins_next_fiscperiodfiscyear]
    FISCAL_YEAR_PERIOD,              -- Fiscal Year Period [fins_jahrper]
    PRIMARY KEY (CLIENT, FISCAL_YEAR_VARIANT, FISCAL_YEAR, FISCAL_PERIOD)
);

Learn More