SAP table TCOKT (Account assignment categories for order)
SAP table TCOKT has 2 primary key fields being MANDT,AUTYP.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||||||||||||||||||||
AUTYP | Order category | NUMC | 2 | 0 | AUFTYP |
|
|||||||||||||||||||||||||||||
BART_001 | Document type for requisitions for order / network | CHAR | 4 | 0 | T161 | BART_ORDER | |||||||||||||||||||||||||||||
KTYP_001 | Acct. assgmt. cat. for reqn/res. in order/network: consumpt. | CHAR | 1 | 0 | T163K | KTYP_ALLG | |||||||||||||||||||||||||||||
KTYP_002 | Account assignment category for project stock | CHAR | 1 | 0 | T163K | KTYP_PROJ | |||||||||||||||||||||||||||||
KTYP_003 | Account assignment category for sales order stock | CHAR | 1 | 0 | T163K | KTYP_KAUF | |||||||||||||||||||||||||||||
KTYP_004 | Account assignment type for leg | CHAR | 1 | 0 | T163K | KTYP_STRE | |||||||||||||||||||||||||||||
KTYP_005 | Acct. assignment cat.: Sales document w/project settlement | CHAR | 1 | 0 | T163K | KTYP_KAUFP | |||||||||||||||||||||||||||||
KTYP_006 | Third-Party Req. for WBS Element Account Assignment Category | CHAR | 1 | 0 | T163K | NET_PROJ | |||||||||||||||||||||||||||||
KTYP_007 | Third-Party Req. for Sales Order Account Assignment Category | CHAR | 1 | 0 | T163K | NET_KAUF |
TCOKT foreign key relationships
Table | Field | Check Table | Check Field | |
---|---|---|---|---|
0 TCOKT | BART_001 | T161 | Purchasing Document Types | MANDT |
1 TCOKT | KTYP_001 | T163K | Account Assignment Categories in Purchasing Document | MANDT |
1 TCOKT | KTYP_001 | T163K | Account Assignment Categories in Purchasing Document | KNTTP |
0 TCOKT | KTYP_002 | T163K | Account Assignment Categories in Purchasing Document | MANDT |
0 TCOKT | KTYP_002 | T163K | Account Assignment Categories in Purchasing Document | KNTTP |
1 TCOKT | KTYP_003 | T163K | Account Assignment Categories in Purchasing Document | MANDT |
1 TCOKT | KTYP_003 | T163K | Account Assignment Categories in Purchasing Document | KNTTP |
0 TCOKT | KTYP_004 | T163K | Account Assignment Categories in Purchasing Document | MANDT |
0 TCOKT | KTYP_004 | T163K | Account Assignment Categories in Purchasing Document | KNTTP |
1 TCOKT | KTYP_005 | T163K | Account Assignment Categories in Purchasing Document | MANDT |
1 TCOKT | KTYP_005 | T163K | Account Assignment Categories in Purchasing Document | KNTTP |
0 TCOKT | KTYP_006 | T163K | Account Assignment Categories in Purchasing Document | MANDT |
0 TCOKT | KTYP_006 | T163K | Account Assignment Categories in Purchasing Document | KNTTP |
1 TCOKT | KTYP_007 | T163K | Account Assignment Categories in Purchasing Document | MANDT |
1 TCOKT | KTYP_007 | T163K | Account Assignment Categories in Purchasing Document | KNTTP |