SAP ABAP Table OIHLVB (IS-OIL TDP: reference structure for XOIHL)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ OIH (Package) TDP Tariffs, Duties and Permits

Basic Data

Table Category	INTTAB	Structure
Structure	OIHLVB	Table Relationship Diagram
Short Description	IS-OIL TDP: reference structure for XOIHL

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	.INCLUDE	☐				0	0	License Master Data
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	LICIN	☐	OIH_LICIN	OIH_LICIN	CHAR	10	0	Excise tax internal license number	*
4	LICTP	☐	OIH_LICTP	OIH_LICTP	CHAR	4	0	License type	OIH20
5	CERTF1	☐	OIH_CERTF1	OIH_CERTF1	CHAR	15	0	Excise tax external license number
6	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	T001
7	LCTXT	☐	OIH_LCTXT	OIH_LCTXT	CHAR	40	0	License text
8	KUNNR	☐	KUNNR	KUNNR	CHAR	10	0	Customer Number	KNA1
9	KVGR1	☐	KVGR1	KVGR1	CHAR	3	0	Customer group 1	TVV1
10	MVGR2	☐	MVGR2	MVGR2	CHAR	3	0	Material group 2	TVM2
11	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
12	AUART	☐	AUART	AUART	CHAR	4	0	Sales Document Type	TVAK
13	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
14	LCOMP	☐	OIH_LCOMP	X	CHAR	1	0	Company-owned license
15	LCUST	☐	OIH_LCUST	X	CHAR	1	0	Customer license
16	LCJUR	☐	OIH_LCJUR	LIFNR	CHAR	10	0	Jurisdiction vendor number	LFA1
17	LICIA	☐	OIH_LICIA	X	CHAR	1	0	License inactive
18	DATAB	☐	DATAB	DATUM	DATS	8	0	Valid-From Date
19	DATBI	☐	DATBI	DATUM	DATS	8	0	Valid To Date
20	LICMQ	☐	OIH_LICMQ	MENG13	QUAN	13	3	Maximum quantity for license
21	LQUSE	☐	OIH_LQUSE	MENG13	QUAN	13	3	License: Quantity used
22	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	T006
23	LCMOT	☐	OIH_LCMOT	VKTRA	CHAR	2	0	Mode of transport	TVTR
24	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
25	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
26	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	T005E
27	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	T005G
28	ALTLC	☐	OIC_PORGIN	OIC_PORGIN	CHAR	15	0	Tax origin
29	HANTP	☐	OIH_HANTYP	OIH_HANTYP	CHAR	2	0	Excise Duty Handling Type	OIH5
30	LCFOL	☐	OIH_LCFOL	OIH_LICIN	CHAR	10	0	Follow-on license for quantity license	OIHL
31	LTOPQ	☐	OIH_LTOPQ	MENG13	QUAN	13	3	Top-up quantity
32	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
33	ERDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
34	ERTIM	☐	OI0_ERTIM	UZEIT	TIMS	6	0	Time of creation
35	UPNAM	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
36	UPDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
37	UPTIM	☐	OI0_AETIM	UZEIT	TIMS	6	0	Time of day the record was changed
38	EXEMP	☐	OIH_EXEMP	X	CHAR	1	0	Exemption license
39	DEFER	☐	OIH_DEFER	X	CHAR	1	0	Deferred payment (radio button)
40	REFLT	☐	OIH_REFLT	OIH_REFLT	CHAR	4	0	Reference license type
41	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
42	UMWRK	☐	UMWRK	WERKS	CHAR	4	0	Receiving plant/issuing plant	T001W
43	UPDKZ	☐	UPDKZ_D	UPDKZ	CHAR	1	0	Update indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	OIHLVB	AUART	TVAK	AUART
2	OIHLVB	BUKRS	T001	BUKRS
3	OIHLVB	CITYC	T005G	CITYC
4	OIHLVB	COUNC	T005E	COUNC
5	OIHLVB	HANTP	OIH5	HANTYP
6	OIHLVB	KUNNR	KNA1	KUNNR
7	OIHLVB	KVGR1	TVV1	KVGR1
8	OIHLVB	LAND1	T005	LAND1
9	OIHLVB	LCFOL	OIHL	LICIN
10	OIHLVB	LCJUR	LFA1	LIFNR
11	OIHLVB	LCMOT	TVTR	VKTRA
12	OIHLVB	LICTP	OIH20	LICTP
13	OIHLVB	LIFNR	LFA1	LIFNR
14	OIHLVB	MANDT	T000	MANDT
15	OIHLVB	MATNR	MARA	MATNR
16	OIHLVB	MEINS	T006	MSEHI
17	OIHLVB	MVGR2	TVM2	MVGR2
18	OIHLVB	REGIO	T005S	BLAND
19	OIHLVB	UMWRK	T001W	WERKS
20	OIHLVB	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20130529
SAP Release Created in