SAP Table
TFKB Functional areas
SAP table TFKB has 2 primary key fields being MANDT,FKBER.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
TFKB columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| KeyFKBER | Functional Area | CHAR | 16 | 0 | FKBER | ||
| AUTHGRP | FM: Authorization Group of Functional Area | CHAR | 10 | 0 | FM_AUTHGR_FAREA | ||
| STR_ID | Master Data Subdivision ID | CHAR | 10 | 0 | FMMDSTRID | FM_STR_ID | |
| FNSUB1 | Substring 1 of Functional Area | CHAR | 10 | 0 | FMMDFNSUB1 | FM_FNSUB1 | |
| FNSUB2 | Substring 2 of Functional Area | CHAR | 10 | 0 | FMMDFNSUB2 | FM_FNSUB2 | |
| FNSUB3 | Substring 3 of Functional Area | CHAR | 10 | 0 | FMMDFNSUB3 | FM_FNSUB3 | |
| CREATED_BY | FIFM: Created By | CHAR | 12 | 0 | FM_ERFNAME | ||
| CREATED_ON | FIFM: Entry Date | DATS | 8 | 0 | FM_ERFDAT | ||
| CREATED_AT | FIFM: Creation Time | TIMS | 6 | 0 | FM_ERFUHR | ||
| MODIFIED_BY | FIFM: Name of Last Person to Make a Change | CHAR | 12 | 0 | FM_AENNAME | ||
| MODIFIED_ON | FIFM: Changed On | DATS | 8 | 0 | FM_AENDAT | ||
| MODIFIED_AT | FIFM: Changed time | TIMS | 6 | 0 | FM_AENUHR | ||
| DATAB | FM: Valid-From Date | DATS | 8 | 0 | FM_DATAB | ||
| DATBIS | FM: Valid-To Date | DATS | 8 | 0 | FM_DATBIS | ||
| DATE_EXP | Expiration Date | DATS | 8 | 0 | FM_DATE_EXP |
/ Relationships
TFKB foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| TFKB | FNSUB1 | FMMDFNSUB1 | Value of Substring 1 of Functional Area | STR_ID |
| TFKB | FNSUB1 | FMMDFNSUB1 | Value of Substring 1 of Functional Area | FNSUB1 |
| TFKB | FNSUB2 | FMMDFNSUB2 | Value of Substring 2 of Functional Area | STR_ID |
| TFKB | FNSUB2 | FMMDFNSUB2 | Value of Substring 2 of Functional Area | FNSUB2 |
| TFKB | FNSUB3 | FMMDFNSUB3 | Value of Substring 3 of Functional Area | STR_ID |
| TFKB | FNSUB3 | FMMDFNSUB3 | Value of Substring 3 of Functional Area | FNSUB3 |
| TFKB | STR_ID | FMMDSTRID | Define Subdivision ID of FM Master Data | MASDAT_ID |
| TFKB | STR_ID | FMMDSTRID | Define Subdivision ID of FM Master Data | STR_ID |