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.
Source: KNVA (Customer Master Unloading Points)
KNVA table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
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 |
Possible values
|
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 |