T009

Transparent Table Customizing Table
11 Fields 12 CDS Views

Fiscal Year Variants

T009 is an SAP database table in S/4HANA. Fiscal Year Variants. It contains 11 fields. 12 CDS views read from this table.

CDS Views using this table (12)

ViewTypeJoinVDMDescription
CNV_20011_UI_DD_I_T009 view_entity from CNV-FYV: Data definition for Variant IDs
fac_audit_z3_fiscalyearvariant view from Fiscal Year Variant
fac_opp_cds_co_ctrl_area view inner CDS View For CO Controlling Area
fac_opp_cds_co_fiscal_variants view inner CDS View For variant from CO Areas
Fac_Opp_Cds_T001b view left_outer CDS View For T001B
Fac_Opp_Cds_T001b_In_Cocd view left_outer CDS View For T001B
I_FiscalYearVariant view_entity from BASIC Fiscal Year Variant
ICA_FiscalYearVariant view from Fiscal Year Variant
ICA_GENJOURNALENTRIES_2 view left_outer Match Universal Journal Entry Line Items
ICA_GENJOURNALENTRIES_C2 view left_outer Match Universal Journal Entry Line Items
P_NZ_HEADERDATA view inner BASIC
P_Rtc_Diff_Item_Periv view from BASIC

Fields (11)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY periv PERIV FY Variant
xkale XKALE Calendar year
xjabh XJABH Year-dependent
anzbp ANZBP Posting Period
anzsp ANZSP Special Periods
xweek XWEEK Fiscal Week Start
fyofb FYOFB No. FYs Before FY
fyofe FYOFE No. FYs After FY
xweekquart XWEEKQUARTER Weekly Calendar
xperiodquart XPERIODQUARTER Quarter by 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 Year Variants
-- Category TRANSPARENT · Delivery class C
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T009 (
    MANDT,         -- Client [MANDT]
    PERIV,         -- FY Variant [PERIV]
    XKALE,         -- Calendar year [XKALE]
    XJABH,         -- Year-dependent [XJABH]
    ANZBP,         -- Posting Period [ANZBP]
    ANZSP,         -- Special Periods [ANZSP]
    XWEEK,         -- Fiscal Week Start [XWEEK]
    FYOFB,         -- No. FYs Before FY [FYOFB]
    FYOFE,         -- No. FYs After FY [FYOFE]
    XWEEKQUART,    -- Weekly Calendar [XWEEKQUARTER]
    XPERIODQUART,  -- Quarter by Period [XPERIODQUARTER]
    PRIMARY KEY (MANDT, PERIV)
);

Learn More