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
NULL Not subject to equalization tax
X Subject to equalization tax
STKZU Liable for VAT STKZU CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
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
X Natural person
NULL Legal person
LOEVM Central Deletion Flag for Master Record LOEVM_X CHAR 1 0
X Yes
NULL No
SPERR Central posting block SPERB_X CHAR 1 0
X Yes
NULL No

VZKNA1 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VZKNA1 MANDT VZKNA1 MANDT T000 Clients MANDT