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 | Possible values |
|---|---|---|---|---|---|---|
|
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 | MANDT |
FMMDFNSUB2
Value of Substring 2 of Functional Area
|
MANDT |
| 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 | 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 | 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 |
| TFKB | STR_ID | '4' |
FMMDSTRID
Define Subdivision ID of FM Master Data
|
MASDAT_ID |