Saturday, September 7, 2024

TFKB: Functional areas

TFKB is a standard SAP HANA table in SAP ERP (or) S/4HANA system which stores Functional areas data. There are total 16 fields in the table. The TFKB table can be found in the Overhead Cost Controlling (KBAS) package and is part of the Overhead Cost Controlling (CO-OM) module.

SAP HANA Table Type Column Store
Buffering Permission Buffering switched on
Buffering Type Full table is passed to buffer

TFKB Table Fields

The following is the list of fields that are available in SAP TFKB table. The key fields of the table are highlighted in color.

Field Description Data Element Domain Check Table Data Type Length
MANDT Client MANDT MANDT T000 CLNT 3
FKBER Functional Area FKBER FKBER CHAR 16
AUTHGRP FM: Authorization Group of Functional Area FM_AUTHGR_FAREA CHAR10 CHAR 10
STR_ID Master Data Subdivision ID FM_STR_ID CHAR10 FMMDSTRID CHAR 10
FNSUB1 Substring 1 of Functional Area FM_FNSUB1 CHAR10 FMMDFNSUB1 CHAR 10
FNSUB2 Substring 2 of Functional Area FM_FNSUB2 CHAR10 FMMDFNSUB2 CHAR 10
FNSUB3 Substring 3 of Functional Area FM_FNSUB3 CHAR10 FMMDFNSUB3 CHAR 10
CREATED_BY FIFM: Created By FM_ERFNAME USNAM CHAR 12
CREATED_ON FIFM: Entry Date FM_ERFDAT DATUM DATS 8
CREATED_AT FIFM: Creation Time FM_ERFUHR TIME TIMS 6
MODIFIED_BY FIFM: Name of Last Person to Make a Change FM_AENNAME USNAM CHAR 12
MODIFIED_ON FIFM: Changed On FM_AENDAT DATUM DATS 8
MODIFIED_AT FIFM: Changed time FM_AENUHR TIME TIMS 6
DATAB FM: Valid-From Date FM_DATAB DATUM DATS 8
DATBIS FM: Valid-To Date FM_DATBIS DATUM DATS 8
DATE_EXP Expiration Date FM_DATE_EXP DATUM DATS 8

Availability

The SAP HANA table TFKB is available within SAP S/4HANA On-premise and SAP S/4HANA Cloud systems depending on the version and release level.

SAP S/4HANA Version Released
1909 Yes
2020 Yes
2021 Yes
2022 Yes
2023 Yes

CDS Views for TFKB table

We’re updating the content all the time, so check back regularly.