SAP Table TJG37
IS-M/SD: Business Partner Account Groups
TJG37 (IS-M/SD: Business Partner Account Groups) 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 TJG37 to other SAP tables.
TJG37 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| JKTOKD | IS-M: Business Partner Account Group | JKTOKD | CHAR | 4 | 0 | |||||||
| NUMKRS | IS-M: Number range | NUMKRS | CHAR | 2 | 0 | |||||||
| XCPDS | Indicator: Account group for one-time accounts? | XCPDS | CHAR | 1 | 0 |
Possible values
|
||||||
| KTOKD | Customer Account Group | KTOKD | T077D | CHAR | 4 | 0 | ||||||
| KTOKDF | Customer account group in third party system | KTOKDF | CHAR | 4 | 0 | |||||||
| KTOKK | Vendor account group | KTOKK | T077K | CHAR | 4 | 0 | ||||||
| KTOKKF | Vendor account group in third party system | KTOKKF | CHAR | 4 | 0 | |||||||
| BU_GROUP | Business Partner Grouping | BU_GROUP | TB001 | CHAR | 4 | 0 | ||||||
TJG37 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| TJG37 | BU_GROUP | TJG37 | BU_GROUP | TB001 | BP groupings | BU_GROUP |
| TJG37 | BU_GROUP | TJG37 | MANDT | TB001 | BP groupings | MANDT |
| TJG37 | KTOKD | TJG37 | MANDT | T077D | Customer account groups | MANDT |
| TJG37 | KTOKD | TJG37 | KTOKD | T077D | Customer account groups | KTOKD |
| TJG37 | KTOKK | TJG37 | MANDT | T077K | Vendor account groups | MANDT |
| TJG37 | KTOKK | TJG37 | KTOKK | T077K | Vendor account groups | KTOKK |
| TJG37 | MANDT | TJG37 | MANDT | T000 | Clients | MANDT |
