SAP table VZKNA1 (Collector for batch input KNA1 from RF-VV)
SAP table VZKNA1 has 2 primary key fields being MANDT,KUNNR.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
Field
Description
Data Type
Length
Decimals
Checktable
Data Element
Client
CLNT
3
0
T000
MANDT
Customer number RF-VV
CHAR
10
0
KUNNR_VV
ANRED
Title
CHAR
15
0
ANRED
BBBNR
German Standard Company Number (Batch Input Field)
CHAR
7
0
BBBNR_BI
BBSNR
German Standard Company Number (Additional) (Batch Input)
CHAR
5
0
BBSNR_BI
BEGRU
Authorization Group
CHAR
4
0
*
BRGRU
BRSCH
Industry key
CHAR
4
0
*
BRSCH
BUBKZ
German Standard Company Number Check Digit (Batch Input)
CHAR
1
0
BUBKZ_BI
DATLT
Data communication line no.
CHAR
14
0
DATLT
FISKN
Account number of the master record with the fiscal address
CHAR
10
0
*
FISKN_D
KNRZA
Account Number of an Alternative Payer
CHAR
10
0
*
KNRZA
KONZS
Group key
CHAR
10
0
KONZS
KTOKD
Customer Account Group
CHAR
4
0
*
KTOKD
LAND1
Country/Region Key
CHAR
3
0
*
LAND1_GP
LIFNR
Account Number of Supplier
CHAR
10
0
*
LIFNR
NAME1
Name 1
CHAR
35
0
NAME1_GP
NAME2
Name 2
CHAR
35
0
NAME2_GP
NAME3
Name 3
CHAR
35
0
NAME3_GP
NAME4
Name 4
CHAR
35
0
NAME4_GP
ORT01
City
CHAR
35
0
ORT01_GP
ORT02
District
CHAR
35
0
ORT02_GP
PFACH
PO Box
CHAR
10
0
PFACH
PSTL2
P.O. Box Postal Code
CHAR
10
0
PSTL2
PSTLZ
Postal Code
CHAR
10
0
PSTLZ
REGIO
Region (State, Province, County)
CHAR
3
0
*
REGIO
COUNC
County Code
CHAR
3
0
*
COUNC
CITYC
City Code
CHAR
4
0
*
CITYC
SORTL
Sort field
CHAR
10
0
SORTL
SPRAS
Language Key
LANG
1
0
*
SPRAS
STCD1
Tax Number 1
CHAR
16
0
STCD1
STCD2
Tax Number 2
CHAR
11
0
STCD2
STKZA
Indicator: Business Partner Subject to Equalization Tax?
CHAR
1
0
STKZA
Possible values
Not subject to equalization tax
X
Subject to equalization tax
STKZU
Liable for VAT
CHAR
1
0
STKZU
STRAS
Street and House Number
CHAR
35
0
STRAS_GP
TELBX
Telebox number
CHAR
15
0
TELBX
TELF1
First telephone number
CHAR
16
0
TELF1
TELF2
Second telephone number
CHAR
16
0
TELF2
TELFX
Fax Number
CHAR
31
0
TELFX
TELTX
Teletex number
CHAR
30
0
TELTX
TELX1
Telex number
CHAR
30
0
TELX1
XZEMP
Indicator: Alternative Payee in Document Allowed?
CHAR
1
0
XZEMP
VBUND
Company ID of Trading Partner
CHAR
6
0
*
RASSC
STCEG
VAT Registration Number
CHAR
20
0
STCEG
STKZN
Natural Person
CHAR
1
0
STKZN
Possible values
Legal person
X
Natural person
LOEVM
Central Deletion Flag for Master Record
CHAR
1
0
LOEVM_X
SPERR
Central posting block
CHAR
1
0
SPERB_X
VZKNA1 foreign key relationships
Table
Field
Check Table
Check Field
0 VZKNA1
MANDT
T000 Clients
MANDT