SAP table OIFBRT1 (Business partner roles - technical category (IS-Oil MRN))
SAP table OIFBRT1 has 2 primary key fields being MANDT,PARTC.
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 | |
| PARTC | Technical characteristic for partner role | CHAR | 2 | 0 | OIF_PARTC | ||
| TABNAM | Name of DDIC table supporting technical category | CHAR | 30 | 0 | OIFXBPTAB | OIF_TABNAM | |
| GENIND | Generate location entry in bus.partner master (IS-Oil MRN) | CHAR | 1 | 0 | OIF_GENIND | ||
| KTOKD | Customer Account Group | CHAR | 4 | 0 | T077D | KTOKD | |
| KTOKK | Vendor account group | CHAR | 4 | 0 | T077K | KTOKK | |
| PARVW | Partner Function | CHAR | 2 | 0 | TPAR | PARVW |
OIFBRT1 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 OIFBRT1 | KTOKD | T077D | Customer account groups | MANDT |
| 1 OIFBRT1 | KTOKK | T077K | Supplier Account Groups | MANDT |
| 0 OIFBRT1 | MANDT | T000 | Clients | MANDT |
| 1 OIFBRT1 | PARVW | TPAR | Business Partner: Functions | PARVW |