SAP table KNVL (Customer Master Licenses)

SAP table KNVL has 5 primary key fields being MANDT,KUNNR,ALAND,TATYP,LICNR.

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
KUNNR Customer Number CHAR 10 0 KNA1 KUNNR
ALAND Departure Country/Region (from which the goods are sent) CHAR 3 0 T005 ALAND
TATYP Tax category (sales tax, federal sales tax,...) CHAR 4 0 T685A TATYP
LICNR License number CHAR 15 0 LICNR
DATAB Valid-From Date DATS 8 0 DATAB
DATBI Valid To Date DATS 8 0 DATBI
BELIC Confirmation for licenses CHAR 1 0 BELIC

KNVL foreign key relationships

Table Field Check Table Check Field
0 KNVL ALAND T005 Countries MANDT
0 KNVL ALAND T005 Countries LAND1
1 KNVL KUNNR KNA1 General Data in Customer Master MANDT
1 KNVL KUNNR KNA1 General Data in Customer Master KUNNR
0 KNVL MANDT T000 Clients MANDT
1 KNVL TATYP T685A Conditions: Types: Additional Price Element Data KAPPL
1 KNVL TATYP T685A Conditions: Types: Additional Price Element Data KSCHL