SAP table T8JG (Valid Investment Group)
SAP table T8JG has 5 primary key fields being MANDT,BUKRS,VNAME,ETYPE,FDATE.
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 | |
| BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
| VNAME | Joint venture | CHAR | 6 | 0 | T8JV | JV_NAME | |
| ETYPE | Equity type | CHAR | 3 | 0 | T8JE | JV_ETYPE | |
| FDATE | Valid from date (inverted: 99999999 - YYYYMMDD) | NUMC | 8 | 0 | FDATE | ||
| EGRUP | Equity group | CHAR | 3 | 0 | T8JF | JV_EGROUP | |
| EGROUPACT | Equity Group Active Status | CHAR | 1 | 0 | JV_EGPACT | ||
| BCURR | JV Default Billing Currency | CHAR | 2 | 0 | JV_BCURR | ||
| FUNDGROUP | JV Funding group | CHAR | 6 | 0 | T8JM | JV_FUNDGP | |
| IC_GROUP | JV Interest Calculation Group ID | CHAR | 10 | 0 | JVA_INTC_GRP | JV_INTCALC_GROUP_ID |
T8JG foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 T8JG | BUKRS | T001 | Company Codes | BUKRS |
| 1 T8JG | EGRUP | T8JF | Investment Group | MANDT |
| 1 T8JG | EGRUP | T8JF | Investment Group | BUKRS |
| 1 T8JG | EGRUP | T8JF | Investment Group | VNAME |
| 1 T8JG | EGRUP | T8JF | Investment Group | EGRUP |
| 0 T8JG | ETYPE | T8JE | Investment Type | MANDT |
| 0 T8JG | ETYPE | T8JE | Investment Type | BUKRS |
| 0 T8JG | ETYPE | T8JE | Investment Type | ETYPE |
| 1 T8JG | FUNDGROUP | T8JM | Funding Group | MANDT |
| 1 T8JG | FUNDGROUP | T8JM | Funding Group | BUKRS |
| 1 T8JG | FUNDGROUP | T8JM | Funding Group | FUNDGROUP |
| 0 T8JG | IC_GROUP | JVA_INTC_GRP | JV Interest calculation group | MANDT |
| 0 T8JG | IC_GROUP | JVA_INTC_GRP | JV Interest calculation group | BUKRS |
| 0 T8JG | IC_GROUP | JVA_INTC_GRP | JV Interest calculation group | GROUP_ID |
| 1 T8JG | VNAME | T8JV | Joint Venture | MANDT |
| 1 T8JG | VNAME | T8JV | Joint Venture | BUKRS |
| 1 T8JG | VNAME | T8JV | Joint Venture | VNAME |