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 | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||
|
||||||||||||
|
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 |