SAP Table E1KNVKM
Master customer master contact person (KNVK)
E1KNVKM (Master customer master contact person (KNVK)) 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 E1KNVKM to other SAP tables.
E1KNVKM table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MSGFN
Function
|
MSGFN |
CHAR
|
3 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
PARNR
Character Field Length = 10
|
CHAR10 |
CHAR
|
10 | 0 | ||||||||||||||||
|
NAMEV
First name
|
NAMEV_VP |
CHAR
|
35 | 0 | ||||||||||||||||
|
NAME1
Name 1
|
NAME1_GP |
CHAR
|
35 | 0 | ||||||||||||||||
|
ABTPA
Contact person's department at customer
|
ABTEI_PA |
CHAR
|
12 | 0 | ||||||||||||||||
|
ABTNR
Contact person department
|
ABTNR_PA |
CHAR
|
4 | 0 | ||||||||||||||||
|
UEPAR
Character Field Length = 10
|
CHAR10 |
CHAR
|
10 | 0 | ||||||||||||||||
|
TELF1
First telephone number
|
TELF1 |
CHAR
|
16 | 0 | ||||||||||||||||
|
ANRED
Form of address for contact person (Mr, Mrs...etc)
|
ANRED_AP |
CHAR
|
30 | 0 | ||||||||||||||||
|
PAFKT
Contact person function
|
PAFKT |
CHAR
|
2 | 0 | ||||||||||||||||
|
PARVO
Partner's Authority
|
PARVO |
CHAR
|
1 | 0 | ||||||||||||||||
|
PAVIP
VIP Partner
|
PAVIP |
CHAR
|
1 | 0 | ||||||||||||||||
|
PARGE
Partner's gender
|
PARGE |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
PARLA
Character field of length 1
|
CHAR_LG_01 |
CHAR
|
1 | 0 | ||||||||||||||||
|
GBDAT
Character field, 8 characters long
|
CHAR8 |
CHAR
|
8 | 0 | ||||||||||||||||
|
VRTNR
Character Field Length = 10
|
CHAR10 |
CHAR
|
10 | 0 | ||||||||||||||||
|
BRYTH
Call frequency
|
BRYTH |
CHAR
|
4 | 0 | ||||||||||||||||
|
AKVER
Buying habits
|
AKVER |
CHAR
|
2 | 0 | ||||||||||||||||
|
NMAIL
Advertising material indicator
|
NMAIL |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
PARAU
Notes about contact person
|
PARAU |
CHAR
|
40 | 0 | ||||||||||||||||
|
PARH1
Contact person: Attribute 1
|
PAAT1 |
CHAR
|
2 | 0 | ||||||||||||||||
|
PARH2
Contact person: Attribute 2
|
PAAT2 |
CHAR
|
2 | 0 | ||||||||||||||||
|
PARH3
Contact person: Attribute 3
|
PAAT3 |
CHAR
|
2 | 0 | ||||||||||||||||
|
PARH4
Contact person: Attribute 4
|
PAAT4 |
CHAR
|
2 | 0 | ||||||||||||||||
|
PARH5
Contact person: Attribute 5
|
PAAT5 |
CHAR
|
2 | 0 | ||||||||||||||||
|
MOAB1
Character field of length 6
|
CHAR6 |
CHAR
|
6 | 0 | ||||||||||||||||
|
MOBI1
Character field of length 6
|
CHAR6 |
CHAR
|
6 | 0 | ||||||||||||||||
|
MOAB2
Character field of length 6
|
CHAR6 |
CHAR
|
6 | 0 | ||||||||||||||||
|
MOBI2
Character field of length 6
|
CHAR6 |
CHAR
|
6 | 0 | ||||||||||||||||
|
DIAB1
Character field of length 6
|
CHAR6 |
CHAR
|
6 | 0 | ||||||||||||||||
|
DIBI1
Character field of length 6
|
CHAR6 |
CHAR
|
6 | 0 | ||||||||||||||||
|
DIAB2
Character field of length 6
|
CHAR6 |
CHAR
|
6 | 0 | ||||||||||||||||
|
DIBI2
Character field of length 6
|
CHAR6 |
CHAR
|
6 | 0 | ||||||||||||||||
|
MIAB1
Character field of length 6
|
CHAR6 |
CHAR
|
6 | 0 | ||||||||||||||||
|
MIBI1
Character field of length 6
|
CHAR6 |
CHAR
|
6 | 0 | ||||||||||||||||
|
MIAB2
Character field of length 6
|
CHAR6 |
CHAR
|
6 | 0 | ||||||||||||||||
|
MIBI2
Character field of length 6
|
CHAR6 |
CHAR
|
6 | 0 | ||||||||||||||||
|
DOAB1
Character field of length 6
|
CHAR6 |
CHAR
|
6 | 0 | ||||||||||||||||
|
DOBI1
Character field of length 6
|
CHAR6 |
CHAR
|
6 | 0 | ||||||||||||||||
|
DOAB2
Character field of length 6
|
CHAR6 |
CHAR
|
6 | 0 | ||||||||||||||||
|
DOBI2
Character field of length 6
|
CHAR6 |
CHAR
|
6 | 0 | ||||||||||||||||
|
FRAB1
Character field of length 6
|
CHAR6 |
CHAR
|
6 | 0 | ||||||||||||||||
|
FRBI1
Character field of length 6
|
CHAR6 |
CHAR
|
6 | 0 | ||||||||||||||||
|
FRAB2
Character field of length 6
|
CHAR6 |
CHAR
|
6 | 0 | ||||||||||||||||
|
FRBI2
Character field of length 6
|
CHAR6 |
CHAR
|
6 | 0 | ||||||||||||||||
|
SAAB1
Character field of length 6
|
CHAR6 |
CHAR
|
6 | 0 | ||||||||||||||||
|
SABI1
Character field of length 6
|
CHAR6 |
CHAR
|
6 | 0 | ||||||||||||||||
|
SAAB2
Character field of length 6
|
CHAR6 |
CHAR
|
6 | 0 | ||||||||||||||||
|
SABI2
Character field of length 6
|
CHAR6 |
CHAR
|
6 | 0 | ||||||||||||||||
|
SOAB1
Character field of length 6
|
CHAR6 |
CHAR
|
6 | 0 | ||||||||||||||||
|
SOBI1
Character field of length 6
|
CHAR6 |
CHAR
|
6 | 0 | ||||||||||||||||
|
SOAB2
Character field of length 6
|
CHAR6 |
CHAR
|
6 | 0 | ||||||||||||||||
|
SOBI2
Character field of length 6
|
CHAR6 |
CHAR
|
6 | 0 | ||||||||||||||||
|
PAKN1
Contact person: Attribute 6
|
PAAT6 |
CHAR
|
3 | 0 | ||||||||||||||||
|
PAKN2
Contact person: Attribute 7
|
PAAT7 |
CHAR
|
3 | 0 | ||||||||||||||||
|
PAKN3
Contact person: Attribute 8
|
PAAT8 |
CHAR
|
3 | 0 | ||||||||||||||||
|
PAKN4
Contact person: Attribute 9
|
PAAT9 |
CHAR
|
3 | 0 | ||||||||||||||||
|
PAKN5
Contact person: Attribute 10
|
PAAT0 |
CHAR
|
3 | 0 | ||||||||||||||||
|
SORTL
Sort field
|
SORTL |
CHAR
|
10 | 0 | ||||||||||||||||
|
FAMST
Marital Status Key
|
FAMST |
CHAR
|
1 | 0 | ||||||||||||||||
|
SPNAM
Nickname
|
SPNAM |
CHAR
|
10 | 0 | ||||||||||||||||
|
TITEL_AP
Title of contact person (description of function)
|
TITEL_AP |
CHAR
|
35 | 0 | ||||||||||||||||
|
PARLA_ISO
|
CHAR
|
2 | 0 | |||||||||||||||||