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 |
