SAP Table TPIK3
Assignment Table: Cost Elements -> Value Categories
TPIK3 (Assignment Table: Cost Elements -> Value Categories) 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 TPIK3 to other SAP tables.
TPIK3 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| APPL | User component | PS_APPL | CHAR | 2 | 0 |
Possible values
|
||||||
| KOKRS | Controlling Area | KOKRS | TKA01 | CHAR | 4 | 0 | ||||||
| ACPOS | Value category | ACPOS | TPIR2 | CHAR | 14 | 0 | ||||||
| LFDNR | Sequence Number | LFDNR | CHAR | 3 | 0 | |||||||
| KSTRF | From Cost Element | KSTRF | CSKA | CHAR | 10 | 0 | ||||||
| KSTRT | To Cost Element | KSTRT | CSKA | CHAR | 10 | 0 | ||||||
| LINEX | Suppress line | KATEX | CHAR | 1 | 0 |
Possible values
|
||||||
| KAGRU | Cost Element Group | KAGRU | CHAR | 15 | 0 | |||||||
TPIK3 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TPIK3 | ACPOS | TPIK3 | ACPOS | TPIR2 | Value Categories | ACPOS |
| TPIK3 | ACPOS | TPIK3 | MANDT | TPIR2 | Value Categories | MANDT |
| TPIK3 | ACPOS | TPIK3 | APPL | TPIR2 | Value Categories | APPL |
| TPIK3 | ACPOS | TPIK3 | KOKRS | TPIR2 | Value Categories | KOKRS |
| TPIK3 | KOKRS | TPIK3 | MANDT | TKA01 | Controlling Areas | MANDT |
| TPIK3 | KOKRS | TPIK3 | KOKRS | TKA01 | Controlling Areas | KOKRS |
| TPIK3 | KSTRF | TPIK3 | KSTRF | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | KSTAR |
| TPIK3 | KSTRF | TPIK3 | MANDT | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | MANDT |
| TPIK3 | KSTRF | TKA01 | KTOPL | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | KTOPL |
| TPIK3 | KSTRT | TPIK3 | MANDT | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | MANDT |
| TPIK3 | KSTRT | TKA01 | KTOPL | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | KTOPL |
| TPIK3 | KSTRT | TPIK3 | KSTRT | CSKA | Cost Elements (Data Dependent on Chart of Accounts) | KSTAR |
| TPIK3 | MANDT | TPIK3 | MANDT | T000 | Clients | MANDT |
