E1KNA1M (Master customer master basic data (KNA1)) 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 E1KNA1M to other SAP tables.
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values |
|---|---|---|---|---|---|---|
|
MSGFN
|
CHAR
|
3 | 0 | |||
|
KUNNR
|
CHAR
|
10 | 0 | |||
|
ANRED
|
CHAR
|
15 | 0 | |||
|
AUFSD
|
CHAR
|
2 | 0 | |||
|
BAHNE
|
CHAR
|
25 | 0 | |||
|
BAHNS
|
CHAR
|
25 | 0 | |||
|
BBBNR
|
CHAR
|
7 | 0 | |||
|
BBSNR
|
CHAR
|
5 | 0 | |||
|
BEGRU
|
CHAR
|
4 | 0 | |||
|
BRSCH
|
CHAR
|
4 | 0 | |||
|
BUBKZ
|
CHAR
|
1 | 0 | |||
|
DATLT
|
CHAR
|
14 | 0 | |||
|
FAKSD
|
CHAR
|
2 | 0 | |||
|
FISKN
|
CHAR
|
10 | 0 | |||
|
KNRZA
|
CHAR
|
10 | 0 | |||
|
KONZS
|
CHAR
|
10 | 0 | |||
|
KTOKD
|
CHAR
|
4 | 0 | |||
|
KUKLA
|
CHAR
|
2 | 0 | |||
|
LAND1
|
CHAR
|
3 | 0 | |||
|
LIFNR
|
CHAR
|
10 | 0 | |||
|
LIFSD
|
CHAR
|
2 | 0 | |||
|
LOCCO
|
CHAR
|
10 | 0 | |||
|
LOEVM
|
CHAR
|
1 | 0 | |||
|
NAME1
|
CHAR
|
35 | 0 | |||
|
NAME2
|
CHAR
|
35 | 0 | |||
|
NAME3
|
CHAR
|
35 | 0 | |||
|
NAME4
|
CHAR
|
35 | 0 | |||
|
NIELS
|
CHAR
|
2 | 0 | |||
|
ORT01
|
CHAR
|
35 | 0 | |||
|
ORT02
|
CHAR
|
35 | 0 | |||
|
PFACH
|
CHAR
|
10 | 0 | |||
|
PSTL2
|
CHAR
|
10 | 0 | |||
|
PSTLZ
|
CHAR
|
10 | 0 | |||
|
REGIO
|
CHAR
|
3 | 0 | |||
|
COUNC
|
CHAR
|
3 | 0 | |||
|
CITYC
|
CHAR
|
4 | 0 | |||
|
RPMKR
|
CHAR
|
5 | 0 | |||
|
SORTL
|
CHAR
|
10 | 0 | |||
|
SPERR
|
CHAR
|
1 | 0 | |||
|
SPRAS
|
CHAR
|
1 | 0 | |||
|
STCD1
|
CHAR
|
16 | 0 | |||
|
STCD2
|
CHAR
|
11 | 0 | |||
|
STKZA
|
CHAR
|
1 | 0 | |||
|
STKZU
|
CHAR
|
1 | 0 | |||
|
STRAS
|
CHAR
|
35 | 0 | |||
|
TELBX
|
CHAR
|
15 | 0 | |||
|
TELF1
|
CHAR
|
16 | 0 | |||
|
TELF2
|
CHAR
|
16 | 0 | |||
|
TELFX
|
CHAR
|
31 | 0 | |||
|
TELTX
|
CHAR
|
30 | 0 | |||
|
TELX1
|
CHAR
|
30 | 0 | |||
|
LZONE
|
CHAR
|
10 | 0 | |||
|
XZEMP
|
CHAR
|
1 | 0 | |||
|
VBUND
|
CHAR
|
6 | 0 | |||
|
STCEG
|
CHAR
|
20 | 0 | |||
|
GFORM
|
CHAR
|
2 | 0 | |||
|
BRAN1
|
CHAR
|
10 | 0 | |||
|
BRAN2
|
CHAR
|
10 | 0 | |||
|
BRAN3
|
CHAR
|
10 | 0 | |||
|
BRAN4
|
CHAR
|
10 | 0 | |||
|
BRAN5
|
CHAR
|
10 | 0 | |||
|
UMJAH
|
CHAR
|
4 | 0 | |||
|
UWAER
|
CHAR
|
5 | 0 | |||
|
JMZAH
|
CHAR
|
6 | 0 | |||
|
JMJAH
|
CHAR
|
4 | 0 | |||
|
KATR1
|
CHAR
|
2 | 0 | |||
|
KATR2
|
CHAR
|
2 | 0 | |||
|
KATR3
|
CHAR
|
2 | 0 | |||
|
KATR4
|
CHAR
|
2 | 0 | |||
|
KATR5
|
CHAR
|
2 | 0 | |||
|
KATR6
|
CHAR
|
3 | 0 | |||
|
KATR7
|
CHAR
|
3 | 0 | |||
|
KATR8
|
CHAR
|
3 | 0 | |||
|
KATR9
|
CHAR
|
3 | 0 | |||
|
KATR10
|
CHAR
|
3 | 0 | |||
|
STKZN
|
CHAR
|
1 | 0 | |||
|
UMSA1
|
CHAR
|
16 | 0 | |||
|
TXJCD
|
CHAR
|
15 | 0 | |||
|
PERIV
|
CHAR
|
2 | 0 | |||
|
KTOCD
|
CHAR
|
4 | 0 | |||
|
PFORT
|
CHAR
|
35 | 0 | |||
|
DTAMS
|
CHAR
|
1 | 0 | |||
|
DTAWS
|
CHAR
|
2 | 0 | |||
|
HZUOR
|
CHAR
|
2 | 0 | |||
|
CIVVE
|
CHAR
|
1 | 0 | |||
|
MILVE
|
CHAR
|
1 | 0 | |||
|
SPRAS_ISO
|
CHAR
|
2 | 0 | |||
|
FITYP
|
CHAR
|
2 | 0 | |||
|
STCDT
|
CHAR
|
2 | 0 | |||
|
STCD3
|
CHAR
|
18 | 0 | |||
|
STCD4
|
CHAR
|
18 | 0 | |||
|
XICMS
|
CHAR
|
1 | 0 | |||
|
XXIPI
|
CHAR
|
1 | 0 | |||
|
XSUBT
|
CHAR
|
1 | 0 | |||
|
CFOPC
|
CHAR
|
2 | 0 | |||
|
TXLW1
|
CHAR
|
3 | 0 | |||
|
TXLW2
|
CHAR
|
3 | 0 | |||
|
CCC01
|
CHAR
|
1 | 0 | |||
|
CCC02
|
CHAR
|
1 | 0 | |||
|
CCC03
|
CHAR
|
1 | 0 | |||
|
CCC04
|
CHAR
|
1 | 0 | |||
|
CASSD
|
CHAR
|
2 | 0 | |||
|
KDKG1
|
CHAR
|
2 | 0 | |||
|
KDKG2
|
CHAR
|
2 | 0 | |||
|
KDKG3
|
CHAR
|
2 | 0 | |||
|
KDKG4
|
CHAR
|
2 | 0 | |||
|
KDKG5
|
CHAR
|
2 | 0 | |||
|
NODEL
|
CHAR
|
1 | 0 | |||
|
XSUB2
|
CHAR
|
3 | 0 | |||
|
WERKS
|
CHAR
|
4 | 0 |