SAP table OIH20 (License types)

SAP table OIH20 has 2 primary key fields being MANDT,LICTP.

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
LICTP License type CHAR 4 0 OIH_LICTP
REFLT Reference license type CHAR 4 0 OIH_REFLT
0001 Excise duty
0002 Federal excise tax
0003 State excise tax
0004 County excise tax
0005 City excise tax
0006 Other North American tax
0007 Vendor licence
0008 Pre-paid permit
0009 Duty-free permit
0010 Excise duty license enhanced
0011 Excise duty region based
DYNNR License master data screen number CHAR 4 0 OIH_DYNNR
LPURO Print license number on purchase order CHAR 1 0 OIH_LPURO
LPUCO Print license number on purchase contract CHAR 1 0 OIH_LPUCO
LORCO Print license number on order confirmation CHAR 1 0 OIH_LORCO
LSACO Print license number on sales contract CHAR 1 0 OIH_LSACO
LDELN Print license number on delivery note CHAR 1 0 OIH_LDELN
LINVO Print license number on invoice CHAR 1 0 OIH_LINVO

OIH20 foreign key relationships

Table Field Check Table Check Field
0 OIH20 MANDT T000 Clients MANDT