SAP Table
TKA09 Basic Settings for Versions
SAP table TKA09 has 3 primary key fields being MANDT,KOKRS,VERSN.
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
TKA09 columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||||||
| KeyKOKRS | Controlling Area | CHAR | 4 | 0 | TKA01 | KOKRS | |||||||||||||||
| KeyVERSN | Version | CHAR | 3 | 0 | TKVS | VERSN | |||||||||||||||
| ACTUAL | Record actual data for the relevant version? | CHAR | 1 | 0 | VER_ACTUAL | ||||||||||||||||
| PLANNING | Record planning data for the relevant version? | CHAR | 1 | 0 | VER_PLAN | ||||||||||||||||
| BRGRU | Authorization Group | CHAR | 4 | 0 | TBRG | KPP_BRGRU | |||||||||||||||
| REFVS | CO Reference Version | CHAR | 3 | 0 | TKA09 | REFVS | |||||||||||||||
| EXUVS | Exclusive Use of Version | NUMC | 2 | 0 | CO_EXUVS | ||||||||||||||||
|
|||||||||||||||||||||
| VALUTYP | Valuation View | NUMC | 1 | 0 | VALUTYP | ||||||||||||||||
|
|||||||||||||||||||||
| WIPDF | Carry data from res. analysis and WIP calc. in the version? | CHAR | 1 | 0 | VER_WIP | ||||||||||||||||
| ABWDF | Carry data from variance calculation in the version? | CHAR | 1 | 0 | VER_ABW | ||||||||||||||||
/ Relationships
TKA09 foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| TKA09 | BRGRU | TBRG | Authorization groups | MANDT |
| TKA09 | BRGRU | TBRG | Authorization groups | BRGRU |
| TKA09 | KOKRS | TKA01 | Controlling Areas | MANDT |
| TKA09 | REFVS | TKA09 | Basic Settings for Versions | MANDT |
| TKA09 | REFVS | TKA09 | Basic Settings for Versions | KOKRS |
| TKA09 | REFVS | TKA09 | Basic Settings for Versions | VERSN |
| TKA09 | VERSN | TKVS | CO Versions | VERSI |