SAP Table KNVL
Customer Master Licenses
KNVL (Customer Master Licenses) 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 KNVL to other SAP tables.
KNVL table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| KUNNR | Customer Number | KUNNR | KNA1 | CHAR | 10 | 0 | ||||||
| ALAND | Departure country (country from which the goods are sent) | ALAND | T005 | CHAR | 3 | 0 | ||||||
| TATYP | Tax category (sales tax, federal sales tax,...) | TATYP | T685A | CHAR | 4 | 0 | ||||||
| LICNR | License number | LICNR | CHAR | 15 | 0 | |||||||
| DATAB | Valid-From Date | DATAB | DATS | 8 | 0 | |||||||
| DATBI | Valid To Date | DATBI | DATS | 8 | 0 | |||||||
| BELIC | Confirmation for licenses | BELIC | CHAR | 1 | 0 |
Possible values
|
||||||
KNVL foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| KNVL | ALAND | KNVL | ALAND | T005 | Countries | LAND1 |
| KNVL | ALAND | KNVL | MANDT | T005 | Countries | MANDT |
| KNVL | KUNNR | KNVL | MANDT | KNA1 | General Data in Customer Master | MANDT |
| KNVL | KUNNR | KNVL | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| KNVL | MANDT | KNVL | MANDT | T000 | Clients | MANDT |
| KNVL | TATYP | KNVL | MANDT | T685A | Conditions: Types: Additional Price Element Data | MANDT |
| KNVL | TATYP | 'V ' | T685A | Conditions: Types: Additional Price Element Data | KAPPL | |
| KNVL | TATYP | KNVL | TATYP | T685A | Conditions: Types: Additional Price Element Data | KSCHL |
