SAP table T038 (Cash Management: Grouping Structure)
SAP table T038 has 6 primary key fields being MANDT,GLIED,ZEILT,SELEK,BUKRS,KTOPL.
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 | |
| GLIED | Grouping | CHAR | 10 | 0 | T038P | GLIED | |
| ZEILT | Line Type | CHAR | 1 | 0 | DZEILT | ||
| SELEK | Selection for Cash Management (Example: for Cash Position) | CHAR | 10 | 0 | SELEK | ||
| BUKRS | Company Code | CHAR | 4 | 0 | * | BUKRS_CM | |
| KTOPL | Chart of Accounts | CHAR | 4 | 0 | * | KTOPL_CM | |
| EXCLUDE | Exclude | CHAR | 1 | 0 | EXCLUDE | ||
| TEXTV | Summarization Term | CHAR | 10 | 0 | TEXTV | ||
| CKONT | Summarization Account for Cash Concentration | CHAR | 10 | 0 | * | CKONT | |
| CBUKR | Summarization Company Code for Cash Concentration | CHAR | 4 | 0 | T001 | CBUKR |
T038 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T038 | CBUKR | T001 | Company Codes | BUKRS |
| 1 T038 | GLIED | T038P | Cash Management: Groupings (Checking Table) | GLIED |
| 0 T038 | MANDT | T000 | Clients | MANDT |