back to top

SAP T009 Table – Fiscal Year Variants

T009 table in SAP ERP or S/4HANA stores Fiscal Year Variants data. There are total 10 fields in T009 table. The Fiscal Year Variants table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of T009 table. It is in Financial year variants in the Basis (SFBX) ABAP package and is part of the Service functions for fiscal year versions (BC-SRV-ASF-FYV) module.

SAP T009 Table Fields

Following is the list of fields that are available in SAP T009 table. The primary key fields of Fiscal Year Variants table in SAP are MANDT (Client), PERIV (Fiscal Year Variant).

Field Description Data Element Check Table Data Type
MANDT Client MANDT T000 CLNT(3)
PERIV Fiscal Year Variant PERIV CHAR(2)
XKALE Indicator: Determine periods like calendar year ? XKALE CHAR(1)
XJABH Indicator: Fiscal year variants year-dependent ? XJABH CHAR(1)
ANZBP Number of posting periods ANZBP NUMC(3)
ANZSP Number of special periods ANZSP NUMC(2)
XWEEK Flag: Fiscal Weeks Calculated from Start of Fiscal Year XWEEK CHAR(1)
FYOFB Number of Fiscal Years Before Current Fiscal Year FYOFB NUMC(2)
FYOFE Number of Fiscal Years After Current Fiscal Year FYOFE NUMC(2)
XWEEKQUART Flag: Fiscal Year Variant as Week Calendar XWEEKQUARTER CHAR(1)