SAP table reference
T8JG
Valid Investment GroupExplore another table
Enter a table code or keyword to continue exploring.
Explore the structure, fields and relationships of SAP table T8JG.
SAP table T8JG has 5 primary key fields: MANDT,BUKRS,VNAME,ETYPE,FDATE.
When analysing data from one SAP instance, MANDT is normally identical across the dataset and may be omitted from relationships. When combining multiple instances, include MANDT.
/ Fields
T8JG fields.
| Field | Description | Data type | Length | Decimals | Check table | Data element | |
|---|---|---|---|---|---|---|---|
| Key MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| Key BUKRS | Company Code | CHAR | 4 | 0 | T001 | BUKRS | |
| Key VNAME | Joint venture | CHAR | 6 | 0 | T8JV | JV_NAME | |
| Key ETYPE | Equity type | CHAR | 3 | 0 | T8JE | JV_ETYPE | |
| Key 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 |
/ Relationships
T8JG relationships.
| 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 |