SAP Table
T8JF Investment Group
SAP table T8JF has 4 primary key fields being MANDT,BUKRS,VNAME,EGRUP.
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
T8JF 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 | |
| KeyEGRUP | Equity group | CHAR | 3 | 0 | JV_EGROUP | ||
| OPSHARE | Operated Share | DEC | 9 | 6 | JV_OPSHARE | ||
| NOPSHARE | Non-Operated Share | DEC | 9 | 6 | JV_NOSHARE | ||
| EGROUPACT | Equity Group Active Status | CHAR | 1 | 0 | JV_EGPACT | ||
| EGROUPSUS | Equity Group Suspended | CHAR | 1 | 0 | JV_EGPSUS | ||
| GRPSUSPER | Equity Group Suspended Period | NUMC | 3 | 0 | JV_GSUSPER | ||
| GRPSUSYEAR | JV Group Suspense Year | NUMC | 4 | 0 | JV_GSUSYR | ||
| EGROUPUSUS | JV Equity Group Unsuspensed | CHAR | 1 | 0 | JV_EGPUSUS | ||
| GRPUSUSPER | JV Group Unsuspensed Period | NUMC | 3 | 0 | JV_GUSUSP | ||
| GRPUSUSYER | JV Group Unsuspensed Year | NUMC | 4 | 0 | JV_GUSUSYR | ||
| NPIGROUP | JV Net Profit Interest Group | CHAR | 4 | 0 | T8J2A | JV_NPIGRP |
/ Relationships
T8JF foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| T8JF | BUKRS | T001 | Company Codes | BUKRS |
| T8JF | NPIGROUP | T8J2A | JV Net Profit Interest Group | MANDT |
| T8JF | NPIGROUP | T8J2A | JV Net Profit Interest Group | BUKRS |
| T8JF | VNAME | T8JV | Joint Venture | MANDT |
| T8JF | VNAME | T8JV | Joint Venture | BUKRS |
| T8JF | VNAME | T8JV | Joint Venture | VNAME |