SAP Table KNVA
Customer Master Unloading Points
KNVA (Customer Master Unloading Points) 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 KNVA to other SAP tables.
KNVA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
KUNNR
Customer Number
|
KUNNR | KNA1 |
CHAR
|
10 | 0 | |||||||
|
ABLAD
Unloading Point
|
ABLAD |
CHAR
|
25 | 0 | ||||||||
|
LFDNR
Sequential number for unloading points
|
LNRAB |
NUMC
|
2 | 0 | ||||||||
|
KNFAK
Customer's factory calendar
|
KNKAL | TFACD |
CHAR
|
2 | 0 | |||||||
|
WANID
Goods receiving hours ID (default value)
|
WANID | TVWA |
CHAR
|
3 | 0 | |||||||
|
TPQUA
not currently in use
|
TPQUA |
CHAR
|
1 | 0 | ||||||||
|
TPGRP
not currently in use
|
TPGRP |
CHAR
|
2 | 0 | ||||||||
|
STZKL
Not Currently in Use
|
STZKL |
DEC
|
3 | 2 | ||||||||
|
STZZU
not currently in use
|
STZZU |
DEC
|
3 | 0 | ||||||||
|
MOAB1
Goods receipt times: Monday morning from ...
|
WAMOAB1 |
TIMS
|
6 | 0 | ||||||||
|
MOBI1
Goods receiving hours: Monday morning until ...
|
WAMOBI1 |
TIMS
|
6 | 0 | ||||||||
|
MOAB2
Goods receiving hours: Monday afternoon from ...
|
WAMOAB2 |
TIMS
|
6 | 0 | ||||||||
|
MOBI2
Goods receiving hours: Monday afternoon until ...
|
WAMOBI2 |
TIMS
|
6 | 0 | ||||||||
|
DIAB1
Goods receiving hours: Tuesday morning from...
|
WADIAB1 |
TIMS
|
6 | 0 | ||||||||
|
DIBI1
Goods receipt times: Tuesday morning until ...
|
WADIBI1 |
TIMS
|
6 | 0 | ||||||||
|
DIAB2
Goods receiving hours: Tuesday afternoon from ...
|
WADIAB2 |
TIMS
|
6 | 0 | ||||||||
|
DIBI2
Goods receiving hours: Tuesday afternoon until ...
|
WADIBI2 |
TIMS
|
6 | 0 | ||||||||
|
MIAB1
Goods receiving hours: Wednesday morning from ...
|
WAMIAB1 |
TIMS
|
6 | 0 | ||||||||
|
MIBI1
Goods receiving hours: Wednesday morning until ...
|
WAMIBI1 |
TIMS
|
6 | 0 | ||||||||
|
MIAB2
Goods receiving hours: Wednesday afternoon from ...
|
WAMIAB2 |
TIMS
|
6 | 0 | ||||||||
|
MIBI2
Goods receiving hours: Wednesday afternoon until ...
|
WAMIBI2 |
TIMS
|
6 | 0 | ||||||||
|
DOAB1
Goods receiving hours: Thursday morning from ...
|
WADOAB1 |
TIMS
|
6 | 0 | ||||||||
|
DOBI1
Goods receiving hours: Thursday morning until ...
|
WADOBI1 |
TIMS
|
6 | 0 | ||||||||
|
DOAB2
Goods receiving hours: Thursday afternoon from ...
|
WADOAB2 |
TIMS
|
6 | 0 | ||||||||
|
DOBI2
Goods receiving hours: Thursday afternoon until...
|
WADOBI2 |
TIMS
|
6 | 0 | ||||||||
|
FRAB1
Goods receiving hours: Friday morning from ...
|
WAFRAB1 |
TIMS
|
6 | 0 | ||||||||
|
FRBI1
Goods receiving hours: Friday morning until ...
|
WAFRBI1 |
TIMS
|
6 | 0 | ||||||||
|
FRAB2
Goods receiving hours: Friday afternoon from ...
|
WAFRAB2 |
TIMS
|
6 | 0 | ||||||||
|
FRBI2
Goods receiving hours: Friday afternoon until ...
|
WAFRBI2 |
TIMS
|
6 | 0 | ||||||||
|
SAAB1
Goods receiving hours: Saturday morning from ...
|
WASAAB1 |
TIMS
|
6 | 0 | ||||||||
|
SABI1
Goods receiving hours: Saturday morning from ...
|
WASABI1 |
TIMS
|
6 | 0 | ||||||||
|
SAAB2
Goods receiving hours: Saturday afternoon from ...
|
WASAAB2 |
TIMS
|
6 | 0 | ||||||||
|
SABI2
Goods receiving hours: Saturday afternoon until ...
|
WASABI2 |
TIMS
|
6 | 0 | ||||||||
|
SOAB1
Goods receiving hours: Sunday morning from ...
|
WASOAB1 |
TIMS
|
6 | 0 | ||||||||
|
SOBI1
Goods receiving hours: Sunday morning until ...
|
WASOBI1 |
TIMS
|
6 | 0 | ||||||||
|
SOAB2
Goods receiving hours: Sunday afternoon from ...
|
WASOAB2 |
TIMS
|
6 | 0 | ||||||||
|
SOBI2
Goods receiving hours: Sunday afternoon until ...
|
WASOBI2 |
TIMS
|
6 | 0 | ||||||||
|
DEFAB
Default unloading point
|
DEFAB |
CHAR
|
1 | 0 | ||||||||
|
||||||||||||
KNVA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| KNVA | KNFAK | KNVA | KNFAK |
TFACD
Factory calendar definition
|
IDENT |
| KNVA | KUNNR | KNVA | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| KNVA | KUNNR | KNVA | KUNNR |
KNA1
General Data in Customer Master
|
KUNNR |
| KNVA | MANDT | KNVA | MANDT |
T000
Clients
|
MANDT |
| KNVA | WANID | KNVA | MANDT |
TVWA
Customers: Goods receiving hours (default values)
|
MANDT |
| KNVA | WANID | KNVA | WANID |
TVWA
Customers: Goods receiving hours (default values)
|
WANID |