SAP ABAP Table OIL_KNVV (IS-Oil fields in table KNVV)

Hierarchy

☛ IS-OIL (Software Component) IS-OIL
   ⤷ IS-OIL-DS (Application Component) Downstream
     ⤷ OI0_COMMON (Package) Common obj. in IS-Oil Downstream

Basic Data

Table Category	INTTAB	Structure
Structure	OIL_KNVV	Table Relationship Diagram
Short Description	IS-Oil fields in table KNVV

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	OILASTOR	☐	OID_LASTOR	VBELN	CHAR	10	0	Last order number	*
2	OIC_HOBIND	☐	OIC_HOBIND	OI0_XFELD	CHAR	1	0	Head office / branch indicator
3	OIABTNR	☐	ABTNR_PA	ABTNR	CHAR	4	0	Contact person department	TSAB
4	OIPAFKT	☐	PAFKT	PAFKT	CHAR	2	0	Contact person function	TPFK
5	OIC_MOT	☐	OIC_MOT	VKTRA	CHAR	2	0	IS-OIL MAP external details mode of transport	TVTR
6	OIGROUPNAM	☐	OIG_CCG	OIG_CCG	CHAR	8	0	TD:customer compatibility group	TOIGBC
7	OIHANTYP	☐	OIH_HANTYP	OIH_HANTYP	CHAR	2	0	Excise Duty Handling Type	OIH5
8	OIINEX	☐	OIH_INEX	OIH_INEX	CHAR	2	0	Code for internal or external excise duty rate determination	OIH16
9	OIPFLIC	☐	OIH_PFLIC	PARVW	CHAR	2	0	IS-OIL partner function for tax exemption license	TPAR
10	OIHCGROUP	☐	OIH_J1B_CTXGR	OIH_J1B_CTXGR	CHAR	4	0	Customer tax group	OIH2C_J1B
11	KVGR1	☐	KVGR1	KVGR1	CHAR	3	0	Customer group 1	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIL_KNVV	OIABTNR	TSAB	ABTNR
2	OIL_KNVV	OIC_MOT	TVTR	VKTRA
3	OIL_KNVV	OIGROUPNAM	TOIGBC	GROUPNAME
4	OIL_KNVV	OIHANTYP	OIH5	HANTYP	KEY	1
5	OIL_KNVV	OIHCGROUP	OIH2C_J1B	OIHCTXGR	KEY	1	CN
6	OIL_KNVV	OIINEX	OIH16	INEX
7	OIL_KNVV	OIPAFKT	TPFK	PAFKT
8	OIL_KNVV	OIPFLIC	TPAR	PARVW

History

Last changed by/on	SAP	20070914
SAP Release Created in	600