TKEB Management for Operating Concerns (Client-Specific)
SAP Table TKEB is used for managing client-specific settings and configurations related to operating concerns in Profitability Analysis (CO-PA). It stores critical information for controlling structures, such as assignment rules and attributes that define how data is processed and analyzed for profitability reporting. This table supports client-specific customization to meet the unique operational and reporting requirements of the organization.
SAP table TKEB has 2 primary key fields being MANDT,ERKRS.
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.
TKEB columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||
| KeyERKRS | Operating concern | CHAR | 4 | 0 | ERKRS | ||||||||||
| SAPRL | SAP release when last generated | CHAR | 4 | 0 | RKE_SAPRL | ||||||||||
| PVERS | Program Version | NUMC | 3 | 0 | RKE_PVERS | ||||||||||
| HITYP | Customer hierarchy type | CHAR | 1 | 0 | THIT | HITYP_KH | |||||||||
| WAERS | Operating concern currency | CUKY | 5 | 0 | TCURC | RKE_WAERS | |||||||||
| PERIV | Fiscal Year Variant | CHAR | 2 | 0 | T009 | PERIV | |||||||||
| PERFLAG | Period-type indicator | CHAR | 1 | 0 | PERFLAG | ||||||||||
|
|||||||||||||||
| PERIV2 | Fiscal year variant for alternative period type | CHAR | 2 | 0 | T009 | PERIV2 | |||||||||
| PERFLAG2 | Alternative period type indicator | CHAR | 1 | 0 | PERFLAG2 | ||||||||||
|
|||||||||||||||
| USEPER2I | Indicator: Update actual data in the second period type | CHAR | 1 | 0 | USEPER2I | ||||||||||
| USEPER2P | Indicator: Update plan data in the 2nd period type | CHAR | 1 | 0 | USEPER2P | ||||||||||
| TIMESTMP | Start time for reading data | DEC | 16 | 0 | RKE_DBSTMP | ||||||||||
| ALEACT | CO-PA Distribution: Active indicator | CHAR | 1 | 0 | RKE_ALEACT | ||||||||||
|
|||||||||||||||
| CHAR_CHECK | Consistency Check for Characteristic Values | CHAR | 1 | 0 | RKE_CHAR_CHECK | ||||||||||
| CRERL | SAP Release in which the operating concern was created | CHAR | 4 | 0 | RKE_CRERL | ||||||||||
| CREDA | Date operating concern was created | DATS | 8 | 0 | RKE_CREDA | ||||||||||
| UPDATE_MODE | Update Mode | CHAR | 1 | 0 | KEPSL_UPD_MODE | ||||||||||
|
|||||||||||||||
| NO_CE3 | General Flag | CHAR | 1 | 0 | FLAG | ||||||||||
|
|||||||||||||||
| ALEACT_CPA | Activity Indicator Distribution of Combined CO-PA | CHAR | 1 | 0 | RKE_ALEACT_CPA | ||||||||||
|
|||||||||||||||
TKEB foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| TKEB | HITYP | THIT | Customer Hierarchy Types | MANDT |
| TKEB | HITYP | THIT | Customer Hierarchy Types | HITYP |
| TKEB | PERIV | T009 | Fiscal Year Variants | MANDT |
| TKEB | PERIV | T009 | Fiscal Year Variants | PERIV |
| TKEB | PERIV2 | T009 | Fiscal Year Variants | MANDT |
| TKEB | PERIV2 | T009 | Fiscal Year Variants | PERIV |
| TKEB | WAERS | TCURC | Currency Codes | MANDT |
| TKEB | WAERS | TCURC | Currency Codes | WAERS |