T8JG (Valid Investment Group) 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 T8JG to other SAP tables.
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
BUKRS
Company Code
|
BUKRS | T001 |
CHAR
|
4 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
VNAME
Joint Venture
|
JV_NAME | T8JV |
CHAR
|
6 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
ETYPE
Equity type
|
JV_ETYPE | T8JE |
CHAR
|
3 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
FDATE
Valid from date (inverted: 99999999 - YYYYMMDD)
|
FDATE |
NUMC
|
8 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
EGRUP
Equity group
|
JV_EGROUP | T8JF |
CHAR
|
3 | 0 | |||||||||||||||||||||||||||||||||||||||||||||||||||||
|
EGROUPACT
Equity Group Active Status
|
JV_EGPACT |
CHAR
|
1 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
BCURR
JV Default Billing Currency
|
JV_BCURR |
CHAR
|
2 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| T8JG | BUKRS | T8JG | MANDT |
T001
Company Codes
|
MANDT |
| T8JG | BUKRS | T8JG | BUKRS |
T001
Company Codes
|
BUKRS |
| T8JG | EGRUP | T8JG | MANDT |
T8JF
Investment Group
|
MANDT |
| T8JG | EGRUP | T8JG | BUKRS |
T8JF
Investment Group
|
BUKRS |
| T8JG | EGRUP | T8JG | VNAME |
T8JF
Investment Group
|
VNAME |
| T8JG | EGRUP | T8JG | EGRUP |
T8JF
Investment Group
|
EGRUP |
| T8JG | ETYPE | T8JG | MANDT |
T8JE
Investment Type
|
MANDT |
| T8JG | ETYPE | T8JG | BUKRS |
T8JE
Investment Type
|
BUKRS |
| T8JG | ETYPE | T8JG | ETYPE |
T8JE
Investment Type
|
ETYPE |
| T8JG | MANDT | T8JG | MANDT |
T000
Clients
|
MANDT |
| T8JG | VNAME | T8JG | BUKRS |
T8JV
Joint Venture
|
BUKRS |
| T8JG | VNAME | T8JG | VNAME |
T8JV
Joint Venture
|
VNAME |
| T8JG | VNAME | T8JG | MANDT |
T8JV
Joint Venture
|
MANDT |