- Home
- Resources
- SAP Tables
- VZKNA1 - Collector for batch input KNA1 from RF-VV
SAP Table VZKNA1
Collector for batch input KNA1 from RF-VV
VZKNA1 (Collector for batch input KNA1 from RF-VV) 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 VZKNA1 to other SAP tables.
Source: VZKNA1 (Collector for batch input KNA1 from RF-VV)
VZKNA1 table fields
Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
MANDT |
Client |
MANDT |
T000
|
CLNT |
|
3 |
0 |
|
KUNNR |
Customer number RF-VV |
KUNNR_VV |
|
CHAR |
|
10 |
0 |
|
ANRED |
Title |
ANRED |
|
CHAR |
|
15 |
0 |
|
BBBNR |
German Standard Company Number (Batch Input Field) |
BBBNR_BI |
|
CHAR |
|
7 |
0 |
|
BBSNR |
German Standard Company Number (Additional) (Batch Input) |
BBSNR_BI |
|
CHAR |
|
5 |
0 |
|
BEGRU |
Authorization Group |
BRGRU |
|
CHAR |
|
4 |
0 |
|
BRSCH |
Industry key |
BRSCH |
|
CHAR |
|
4 |
0 |
|
BUBKZ |
German Standard Company Number Check Digit (Batch Input) |
BUBKZ_BI |
|
CHAR |
|
1 |
0 |
|
DATLT |
Data communication line no. |
DATLT |
|
CHAR |
|
14 |
0 |
|
FISKN |
Account number of the master record with the fiscal address |
FISKN_D |
|
CHAR |
|
10 |
0 |
|
KNRZA |
Account number of an alternative payer |
KNRZA |
|
CHAR |
|
10 |
0 |
|
KONZS |
Group key |
KONZS |
|
CHAR |
|
10 |
0 |
|
KTOKD |
Customer Account Group |
KTOKD |
|
CHAR |
|
4 |
0 |
|
LAND1 |
Country Key |
LAND1_GP |
|
CHAR |
|
3 |
0 |
|
LIFNR |
Account Number of Vendor or Creditor |
LIFNR |
|
CHAR |
|
10 |
0 |
|
NAME1 |
Name 1 |
NAME1_GP |
|
CHAR |
|
35 |
0 |
|
NAME2 |
Name 2 |
NAME2_GP |
|
CHAR |
|
35 |
0 |
|
NAME3 |
Name 3 |
NAME3_GP |
|
CHAR |
|
35 |
0 |
|
NAME4 |
Name 4 |
NAME4_GP |
|
CHAR |
|
35 |
0 |
|
ORT01 |
City |
ORT01_GP |
|
CHAR |
|
35 |
0 |
|
ORT02 |
District |
ORT02_GP |
|
CHAR |
|
35 |
0 |
|
PFACH |
PO Box |
PFACH |
|
CHAR |
|
10 |
0 |
|
PSTL2 |
P.O. Box Postal Code |
PSTL2 |
|
CHAR |
|
10 |
0 |
|
PSTLZ |
Postal Code |
PSTLZ |
|
CHAR |
|
10 |
0 |
|
REGIO |
Region (State, Province, County) |
REGIO |
|
CHAR |
|
3 |
0 |
|
COUNC |
County Code |
COUNC |
|
CHAR |
|
3 |
0 |
|
CITYC |
City Code |
CITYC |
|
CHAR |
|
4 |
0 |
|
SORTL |
Sort field |
SORTL |
|
CHAR |
|
10 |
0 |
|
SPRAS |
Language Key |
SPRAS |
|
LANG |
|
1 |
0 |
|
STCD1 |
Tax Number 1 |
STCD1 |
|
CHAR |
|
16 |
0 |
|
STCD2 |
Tax Number 2 |
STCD2 |
|
CHAR |
|
11 |
0 |
|
STKZA |
Indicator: Business Partner Subject to Equalization Tax? |
STKZA |
|
CHAR |
|
1 |
0 |
Possible values
NULL |
Not subject to equalization tax |
X |
Subject to equalization tax |
|
STKZU |
Liable for VAT |
STKZU |
|
CHAR |
|
1 |
0 |
Possible values
|
STRAS |
House number and street |
STRAS_GP |
|
CHAR |
|
35 |
0 |
|
TELBX |
Telebox number |
TELBX |
|
CHAR |
|
15 |
0 |
|
TELF1 |
First telephone number |
TELF1 |
|
CHAR |
|
16 |
0 |
|
TELF2 |
Second telephone number |
TELF2 |
|
CHAR |
|
16 |
0 |
|
TELFX |
Fax Number |
TELFX |
|
CHAR |
|
31 |
0 |
|
TELTX |
Teletex number |
TELTX |
|
CHAR |
|
30 |
0 |
|
TELX1 |
Telex number |
TELX1 |
|
CHAR |
|
30 |
0 |
|
XZEMP |
Indicator: Alternative payee in document allowed ? |
XZEMP |
|
CHAR |
|
1 |
0 |
Possible values
|
VBUND |
Company ID of trading partner |
RASSC |
|
CHAR |
|
6 |
0 |
|
STCEG |
VAT Registration Number |
STCEG |
|
CHAR |
|
20 |
0 |
|
STKZN |
Natural Person |
STKZN |
|
CHAR |
|
1 |
0 |
Possible values
X |
Natural person |
NULL |
Legal person |
|
LOEVM |
Central Deletion Flag for Master Record |
LOEVM_X |
|
CHAR |
|
1 |
0 |
Possible values
|
SPERR |
Central posting block |
SPERB_X |
|
CHAR |
|
1 |
0 |
Possible values
|
VZKNA1 foreign key relationships
Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
VZKNA1 |
MANDT |
VZKNA1 |
MANDT |
T000 |
Clients |
MANDT |