SAP Table
T8JG Valid Investment Group
SAP table T8JG has 5 primary key fields being MANDT,BUKRS,VNAME,ETYPE,FDATE.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
T8JG columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| KeyBUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
| KeyVNAME | Joint venture | CHAR | 6 | 0 | T8JV | JV_NAME | |
| KeyETYPE | Equity type | CHAR | 3 | 0 | T8JE | JV_ETYPE | |
| KeyFDATE | 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 |
/ Relationships
T8JG foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| T8JG | BUKRS | T001 | Company Codes | BUKRS |
| T8JG | EGRUP | T8JF | Investment Group | MANDT |
| T8JG | EGRUP | T8JF | Investment Group | BUKRS |
| T8JG | EGRUP | T8JF | Investment Group | VNAME |
| T8JG | EGRUP | T8JF | Investment Group | EGRUP |
| T8JG | ETYPE | T8JE | Investment Type | MANDT |
| T8JG | ETYPE | T8JE | Investment Type | BUKRS |
| T8JG | ETYPE | T8JE | Investment Type | ETYPE |
| T8JG | FUNDGROUP | T8JM | Funding Group | MANDT |
| T8JG | FUNDGROUP | T8JM | Funding Group | BUKRS |
| T8JG | FUNDGROUP | T8JM | Funding Group | FUNDGROUP |
| T8JG | IC_GROUP | JVA_INTC_GRP | JV Interest calculation group | MANDT |
| T8JG | IC_GROUP | JVA_INTC_GRP | JV Interest calculation group | BUKRS |
| T8JG | IC_GROUP | JVA_INTC_GRP | JV Interest calculation group | GROUP_ID |
| T8JG | VNAME | T8JV | Joint Venture | MANDT |
| T8JG | VNAME | T8JV | Joint Venture | BUKRS |
| T8JG | VNAME | T8JV | Joint Venture | VNAME |