SAP Table TFKB

Functional areas

TFKB (Functional areas) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TFKB to other SAP tables.

TFKB table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
FKBER Functional Area FKBER CHAR 16 0
AUTHGRP FM: Authorization Group of Functional Area FM_AUTHGR_FAREA CHAR 10 0
STR_ID Master Data Subdivision ID FM_STR_ID FMMDSTRID CHAR 10 0
FNSUB1 Substring 1 of Functional Area FM_FNSUB1 FMMDFNSUB1 CHAR 10 0
FNSUB2 Substring 2 of Functional Area FM_FNSUB2 FMMDFNSUB2 CHAR 10 0
FNSUB3 Substring 3 of Functional Area FM_FNSUB3 FMMDFNSUB3 CHAR 10 0
CREATED_BY FIFM: Created by FM_ERFNAME CHAR 12 0
CREATED_ON FIFM: Entry Date FM_ERFDAT DATS 8 0
CREATED_AT FIFM: Creation Time FM_ERFUHR TIMS 6 0
MODIFIED_BY FIFM: Name of Last Person to Make a Change FM_AENNAME CHAR 12 0
MODIFIED_ON FIFM: Changed on FM_AENDAT DATS 8 0
MODIFIED_AT FIFM: Changed time FM_AENUHR TIMS 6 0
DATAB FM: Valid from date FM_DATAB DATS 8 0
DATBIS FM: Valid to date FM_DATBIS DATS 8 0
DATE_EXP Expiration Date FM_DATE_EXP DATS 8 0

TFKB foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TFKB FNSUB1 TFKB MANDT FMMDFNSUB1 Value of Substring 1 of Functional Area MANDT
TFKB FNSUB1 TFKB STR_ID FMMDFNSUB1 Value of Substring 1 of Functional Area STR_ID
TFKB FNSUB1 TFKB FNSUB1 FMMDFNSUB1 Value of Substring 1 of Functional Area FNSUB1
TFKB FNSUB2 TFKB STR_ID FMMDFNSUB2 Value of Substring 2 of Functional Area STR_ID
TFKB FNSUB2 TFKB FNSUB2 FMMDFNSUB2 Value of Substring 2 of Functional Area FNSUB2
TFKB FNSUB2 TFKB MANDT FMMDFNSUB2 Value of Substring 2 of Functional Area MANDT
TFKB FNSUB3 TFKB MANDT FMMDFNSUB3 Value of Substring 3 of Functional Area MANDT
TFKB FNSUB3 TFKB STR_ID FMMDFNSUB3 Value of Substring 3 of Functional Area STR_ID
TFKB FNSUB3 TFKB FNSUB3 FMMDFNSUB3 Value of Substring 3 of Functional Area FNSUB3
TFKB MANDT TFKB MANDT T000 Clients MANDT
TFKB STR_ID '4' FMMDSTRID Define Subdivision ID of FM Master Data MASDAT_ID
TFKB STR_ID TFKB STR_ID FMMDSTRID Define Subdivision ID of FM Master Data STR_ID
TFKB STR_ID TFKB MANDT FMMDSTRID Define Subdivision ID of FM Master Data MANDT