SAP Table OIL_KNVV
IS-Oil fields in table KNVV
OIL_KNVV (IS-Oil fields in table KNVV) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link OIL_KNVV to other SAP tables.
OIL_KNVV table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| OILASTOR | Last order number | OID_LASTOR | CHAR | 10 | 0 | |||||||
| OIC_HOBIND | Head office / branch indicator | OIC_HOBIND | CHAR | 1 | 0 |
Possible values
|
||||||
| OIABTNR | Contact person department | ABTNR_PA | TSAB | CHAR | 4 | 0 | ||||||
| OIPAFKT | Contact person function | PAFKT | TPFK | CHAR | 2 | 0 | ||||||
| OIC_MOT | IS-OIL MAP external details mode of transport | OIC_MOT | TVTR | CHAR | 2 | 0 | ||||||
| OIGROUPNAM | TD:customer compatibility group | OIG_CCG | TOIGBC | CHAR | 8 | 0 | ||||||
| OIHANTYP | Excise Duty Handling Type | OIH_HANTYP | OIH5 | CHAR | 2 | 0 | ||||||
| OIINEX | Code for internal or external excise duty rate determination | OIH_INEX | OIH16 | CHAR | 2 | 0 | ||||||
| OIPFLIC | IS-OIL partner function for tax exemption license | OIH_PFLIC | TPAR | CHAR | 2 | 0 | ||||||
| OIHCGROUP | Customer tax group | OIH_J1B_CTXGR | OIH2C_J1B | CHAR | 4 | 0 | ||||||
| KVGR1 | Customer group 1 | KVGR1 | CHAR | 3 | 0 | |||||||
OIL_KNVV foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| OIL_KNVV | OIABTNR | T000 | MANDT | TSAB | Contact persons: standard departments | MANDT |
| OIL_KNVV | OIABTNR | OIL_KNVV | OIABTNR | TSAB | Contact persons: standard departments | ABTNR |
| OIL_KNVV | OIC_MOT | T000 | MANDT | TVTR | Routes: Modes of Transport | MANDT |
| OIL_KNVV | OIC_MOT | OIL_KNVV | OIC_MOT | TVTR | Routes: Modes of Transport | VKTRA |
| OIL_KNVV | OIGROUPNAM | KNVV | MANDT | TOIGBC | TD Customer Group | CLIENT |
| OIL_KNVV | OIGROUPNAM | OIL_KNVV | OIGROUPNAM | TOIGBC | TD Customer Group | GROUPNAME |
| OIL_KNVV | OIHANTYP | KNVV | MANDT | OIH5 | Definition of Excise Duty Handling Type (IS-OIL-TDP) | MANDT |
| OIL_KNVV | OIHANTYP | OIL_KNVV | OIHANTYP | OIH5 | Definition of Excise Duty Handling Type (IS-OIL-TDP) | HANTYP |
| OIL_KNVV | OIHCGROUP | OIL_KNVV | OIHCGROUP | OIH2C_J1B | Check table for customer tax group | OIHCTXGR |
| OIL_KNVV | OIHCGROUP | SYST | MANDT | OIH2C_J1B | Check table for customer tax group | MANDT |
| OIL_KNVV | OIINEX | T001 | MANDT | OIH16 | Internal/external price conditions | MANDT |
| OIL_KNVV | OIINEX | OIL_KNVV | OIINEX | OIH16 | Internal/external price conditions | INEX |
| OIL_KNVV | OIPAFKT | T000 | KNVV | TPFK | Contact Persons: Functions | MANDT |
| OIL_KNVV | OIPAFKT | OIL_KNVV | OIPAFKT | TPFK | Contact Persons: Functions | PAFKT |
| OIL_KNVV | OIPFLIC | SYST | MANDT | TPAR | Business Partner: Functions | MANDT |
| OIL_KNVV | OIPFLIC | OIL_KNVV | OIPFLIC | TPAR | Business Partner: Functions | PARVW |
