KNVA SAP (Customer Master Unloading Points) Table details
Dictionary Type: Table
Description: Customer Master Unloading Points
Description: Customer Master Unloading Points
Table field list including key, data, relationships and ABAP select examples
KNVA is a standard SAP Table which is used to store Customer Master Unloading Points data and is available within R/3 SAP systems depending on the version and release level.
The KNVA table consists of various fields, each holding specific information or linking keys about Customer Master Unloading Points data available in SAP. These include KUNNR (Customer Numbers), ABLAD (Unloading Point), LFDNR (Sequential number for unloading points), KNFAK (Customer's factory calendar).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP KNVA table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
KUNNR | Customer Numbers | KUNNR | CHAR | 10 | KNA1 | ALPHA | KUNNR | KUN | C_KUNNR |
ABLAD | Unloading Point | ABLAD | CHAR | 25 | TEXT25 | ||||
LFDNR | Sequential number for unloading points | LNRAB | NUMC | 2 | NUM2 | ||||
KNFAK | Customer's factory calendar | KNKAL | CHAR | 2 | TFACD | WFCID | |||
WANID | Goods receiving hours ID (default value) | WANID | CHAR | 3 | TVWA | WANID | |||
TPQUA | not currently in use | TPQUA | CHAR | 1 | TPQUA | ||||
TPGRP | not currently in use | TPGRP | CHAR | 2 | TPGRP | ||||
STZKL | Not Currently in Use | STZKL | DEC | 3(2) | STZKL | ||||
STZZU | not currently in use | STZZU | DEC | 3 | STZZU | ||||
MOAB1 | Goods receipt times: Monday morning from ... | WAMOAB1 | TIMS | 6 | UHRZT | ||||
MOBI1 | Goods receiving hours: Monday morning until ... | WAMOBI1 | TIMS | 6 | UHRZT | ||||
MOAB2 | Goods receiving hours: Monday afternoon from ... | WAMOAB2 | TIMS | 6 | UHRZT | ||||
MOBI2 | Goods receiving hours: Monday afternoon until ... | WAMOBI2 | TIMS | 6 | UHRZT | ||||
DIAB1 | Goods receiving hours: Tuesday morning from... | WADIAB1 | TIMS | 6 | UHRZT | ||||
DIBI1 | Goods receipt times: Tuesday morning until ... | WADIBI1 | TIMS | 6 | UHRZT | ||||
DIAB2 | Goods receiving hours: Tuesday afternoon from ... | WADIAB2 | TIMS | 6 | UHRZT | ||||
DIBI2 | Goods receiving hours: Tuesday afternoon until ... | WADIBI2 | TIMS | 6 | UHRZT | ||||
MIAB1 | Goods receiving hours: Wednesday morning from ... | WAMIAB1 | TIMS | 6 | UHRZT | ||||
MIBI1 | Goods receiving hours: Wednesday morning until ... | WAMIBI1 | TIMS | 6 | UHRZT | ||||
MIAB2 | Goods receiving hours: Wednesday afternoon from ... | WAMIAB2 | TIMS | 6 | UHRZT | ||||
MIBI2 | Goods receiving hours: Wednesday afternoon until ... | WAMIBI2 | TIMS | 6 | UHRZT | ||||
DOAB1 | Goods receiving hours: Thursday morning from ... | WADOAB1 | TIMS | 6 | UHRZT | ||||
DOBI1 | Goods receiving hours: Thursday morning until ... | WADOBI1 | TIMS | 6 | UHRZT | ||||
DOAB2 | Goods receiving hours: Thursday afternoon from ... | WADOAB2 | TIMS | 6 | UHRZT | ||||
DOBI2 | Goods receiving hours: Thursday afternoon until... | WADOBI2 | TIMS | 6 | UHRZT | ||||
FRAB1 | Goods receiving hours: Friday morning from ... | WAFRAB1 | TIMS | 6 | UHRZT | ||||
FRBI1 | Goods receiving hours: Friday morning until ... | WAFRBI1 | TIMS | 6 | UHRZT | ||||
FRAB2 | Goods receiving hours: Friday afternoon from ... | WAFRAB2 | TIMS | 6 | UHRZT | ||||
FRBI2 | Goods receiving hours: Friday afternoon until ... | WAFRBI2 | TIMS | 6 | UHRZT | ||||
SAAB1 | Goods receiving hours: Saturday morning from ... | WASAAB1 | TIMS | 6 | UHRZT | ||||
SABI1 | Goods receiving hours: Saturday morning from ... | WASABI1 | TIMS | 6 | UHRZT | ||||
SAAB2 | Goods receiving hours: Saturday afternoon from ... | WASAAB2 | TIMS | 6 | UHRZT | ||||
SABI2 | Goods receiving hours: Saturday afternoon until ... | WASABI2 | TIMS | 6 | UHRZT | ||||
SOAB1 | Goods receiving hours: Sunday morning from ... | WASOAB1 | TIMS | 6 | UHRZT | ||||
SOBI1 | Goods receiving hours: Sunday morning until ... | WASOBI1 | TIMS | 6 | UHRZT | ||||
SOAB2 | Goods receiving hours: Sunday afternoon from ... | WASOAB2 | TIMS | 6 | UHRZT | ||||
SOBI2 | Goods receiving hours: Sunday afternoon until ... | WASOBI2 | TIMS | 6 | UHRZT | ||||
DEFAB | Default unloading point | DEFAB | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP table KNVA using ABAP code
The following ABAP code Example will allow you to do a basic selection on KNVA to SELECT all data from the tableDATA: WA_KNVA TYPE KNVA.
SELECT SINGLE *
FROM KNVA
INTO CORRESPONDING FIELDS OF WA_KNVA
WHERE...
How to access SAP table KNVA
Within an ECC or HANA version of SAP you can also view further information about KNVA and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects