SAP VZKNA1 Collector for batch input KNA1 from RF-VV Table
Overview
VZKNA1 is a standard SAP S/4HANA table that stores Collector for batch input KNA1 from RF-VV data. There are total 46 fields in the VZKNA1 table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VZKNA1 belongs to Treasury and Risk Management (FIN-FSCM-TRM) module and is located in the package R/3 application development for Financial Assets Management (FVV).
In addition, following links provide an overview of foreign key relationships, if any, that link VZKNA1 to other SAP tables and standard CDS views available based on VZKNA1 table in S/4HANA 2020.
Techincal Settings of VZKNA1
Below are technical details of the table VZKNA1
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VZKNA1 Fields
The following table gives you an overview of the fields available in VZKNA1
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| KUNNR | Customer number RF-VV | KUNNR_VV | CHAR | 10 | |
| ANRED | Title | ANRED | CHAR | 15 | |
| BBBNR | German Standard Company Number (Batch Input Field) | BBBNR_BI | CHAR | 7 | |
| BBSNR | German Standard Company Number (Additional) (Batch Input) | BBSNR_BI | CHAR | 5 | |
| BEGRU | Authorization Group | BRGRU | * | CHAR | 4 |
| BRSCH | Industry key | BRSCH | * | CHAR | 4 |
| BUBKZ | German Standard Company Number Check Digit (Batch Input) | BUBKZ_BI | CHAR | 1 | |
| DATLT | Data communication line no. | DATLT | CHAR | 14 | |
| FISKN | Account number of the master record with the fiscal address | FISKN_D | * | CHAR | 10 |
| KNRZA | Account number of an alternative payer | KNRZA | * | CHAR | 10 |
| KONZS | Group key | KONZS | CHAR | 10 | |
| KTOKD | Customer Account Group | KTOKD | * | CHAR | 4 |
| LAND1 | Country Key | LAND1_GP | * | CHAR | 3 |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | * | CHAR | 10 |
| NAME1 | Name 1 | NAME1_GP | CHAR | 35 | |
| NAME2 | Name 2 | NAME2_GP | CHAR | 35 | |
| NAME3 | Name 3 | NAME3_GP | CHAR | 35 | |
| NAME4 | Name 4 | NAME4_GP | CHAR | 35 | |
| ORT01 | City | ORT01_GP | CHAR | 35 | |
| ORT02 | District | ORT02_GP | CHAR | 35 | |
| PFACH | PO Box | PFACH | CHAR | 10 | |
| PSTL2 | P.O. Box Postal Code | PSTL2 | CHAR | 10 | |
| PSTLZ | Postal Code | PSTLZ | CHAR | 10 | |
| REGIO | Region (State Province County) | REGIO | * | CHAR | 3 |
| COUNC | County Code | COUNC | * | CHAR | 3 |
| CITYC | City Code | CITYC | * | CHAR | 4 |
| SORTL | Sort field | SORTL | CHAR | 10 | |
| SPRAS | Language Key | SPRAS | * | LANG | 1 |
| STCD1 | Tax Number 1 | STCD1 | CHAR | 16 | |
| STCD2 | Tax Number 2 | STCD2 | CHAR | 11 | |
| STKZA | Indicator: Business Partner Subject to Equalization Tax? | STKZA | CHAR | 1 | |
| STKZU | Liable for VAT | STKZU | CHAR | 1 | |
| STRAS | Street and House Number | STRAS_GP | CHAR | 35 | |
| TELBX | Telebox number | TELBX | CHAR | 15 | |
| TELF1 | First telephone number | TELF1 | CHAR | 16 | |
| TELF2 | Second telephone number | TELF2 | CHAR | 16 | |
| TELFX | Fax Number | TELFX | CHAR | 31 | |
| TELTX | Teletex number | TELTX | CHAR | 30 | |
| TELX1 | Telex number | TELX1 | CHAR | 30 | |
| XZEMP | Indicator: Alternative Payee in Document Allowed? | XZEMP | CHAR | 1 | |
| VBUND | Company ID of Trading Partner | RASSC | * | CHAR | 6 |
| STCEG | VAT Registration Number | STCEG | CHAR | 20 | |
| STKZN | Natural Person | STKZN | CHAR | 1 | |
| LOEVM | Central Deletion Flag for Master Record | LOEVM_X | CHAR | 1 | |
| SPERR | Central posting block | SPERB_X | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VZKNA1
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VZKNA1 | MANDT | 1: CN | T000 |