KNVA SAP (Customer Master Unloading Points) Table details

Dictionary Type: Table
Description: Customer Master Unloading Points




ABAP Code to SELECT data from KNVA
Related tables to KNVA
Access table KNVA




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
MANDTClient MANDTCLNT3T000MANDT
KUNNRCustomer Numbers KUNNRCHAR10KNA1ALPHAKUNNRKUNC_KUNNR
ABLADUnloading Point ABLADCHAR25TEXT25
LFDNRSequential number for unloading points LNRABNUMC2NUM2
KNFAKCustomer's factory calendar KNKALCHAR2TFACDWFCID
WANIDGoods receiving hours ID (default value) WANIDCHAR3TVWAWANID
TPQUAnot currently in use TPQUACHAR1TPQUA
TPGRPnot currently in use TPGRPCHAR2TPGRP
STZKLNot Currently in Use STZKLDEC3(2) STZKL
STZZUnot currently in use STZZUDEC3STZZU
MOAB1Goods receipt times: Monday morning from ... WAMOAB1TIMS6UHRZT
MOBI1Goods receiving hours: Monday morning until ... WAMOBI1TIMS6UHRZT
MOAB2Goods receiving hours: Monday afternoon from ... WAMOAB2TIMS6UHRZT
MOBI2Goods receiving hours: Monday afternoon until ... WAMOBI2TIMS6UHRZT
DIAB1Goods receiving hours: Tuesday morning from... WADIAB1TIMS6UHRZT
DIBI1Goods receipt times: Tuesday morning until ... WADIBI1TIMS6UHRZT
DIAB2Goods receiving hours: Tuesday afternoon from ... WADIAB2TIMS6UHRZT
DIBI2Goods receiving hours: Tuesday afternoon until ... WADIBI2TIMS6UHRZT
MIAB1Goods receiving hours: Wednesday morning from ... WAMIAB1TIMS6UHRZT
MIBI1Goods receiving hours: Wednesday morning until ... WAMIBI1TIMS6UHRZT
MIAB2Goods receiving hours: Wednesday afternoon from ... WAMIAB2TIMS6UHRZT
MIBI2Goods receiving hours: Wednesday afternoon until ... WAMIBI2TIMS6UHRZT
DOAB1Goods receiving hours: Thursday morning from ... WADOAB1TIMS6UHRZT
DOBI1Goods receiving hours: Thursday morning until ... WADOBI1TIMS6UHRZT
DOAB2Goods receiving hours: Thursday afternoon from ... WADOAB2TIMS6UHRZT
DOBI2Goods receiving hours: Thursday afternoon until... WADOBI2TIMS6UHRZT
FRAB1Goods receiving hours: Friday morning from ... WAFRAB1TIMS6UHRZT
FRBI1Goods receiving hours: Friday morning until ... WAFRBI1TIMS6UHRZT
FRAB2Goods receiving hours: Friday afternoon from ... WAFRAB2TIMS6UHRZT
FRBI2Goods receiving hours: Friday afternoon until ... WAFRBI2TIMS6UHRZT
SAAB1Goods receiving hours: Saturday morning from ... WASAAB1TIMS6UHRZT
SABI1Goods receiving hours: Saturday morning from ... WASABI1TIMS6UHRZT
SAAB2Goods receiving hours: Saturday afternoon from ... WASAAB2TIMS6UHRZT
SABI2Goods receiving hours: Saturday afternoon until ... WASABI2TIMS6UHRZT
SOAB1Goods receiving hours: Sunday morning from ... WASOAB1TIMS6UHRZT
SOBI1Goods receiving hours: Sunday morning until ... WASOBI1TIMS6UHRZT
SOAB2Goods receiving hours: Sunday afternoon from ... WASOAB2TIMS6UHRZT
SOBI2Goods receiving hours: Sunday afternoon until ... WASOBI2TIMS6UHRZT
DEFABDefault unloading point DEFABCHAR1XFELD

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!