VZKNA1 SAP (Collector for batch input KNA1 from RF-VV) Table details
Dictionary Type: Table
Description: Collector for batch input KNA1 from RF-VV
Description: Collector for batch input KNA1 from RF-VV
Table field list including key, data, relationships and ABAP select examples
VZKNA1 is a standard SAP Table which is used to store Collector for batch input KNA1 from RF-VV data and is available within R/3 SAP systems depending on the version and release level.
The VZKNA1 table consists of various fields, each holding specific information or linking keys about Collector for batch input KNA1 from RF-VV data available in SAP. These include KUNNR (Customer number RF-VV), ANRED (Title), BBBNR (German Standard Company Number (Batch Input Field)), BBSNR (German Standard Company Number (Additional) (Batch Input)).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)
SAP VZKNA1 table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
KUNNR | Customer number RF-VV | KUNNR_VV | CHAR | 10 | ALPHA | KUNNR_VV | |||
ANRED | Title | ANRED | CHAR | 15 | TEXT15 | ||||
BBBNR | German Standard Company Number (Batch Input Field) | BBBNR_BI | CHAR | 7 | CHAR7 | ||||
BBSNR | German Standard Company Number (Additional) (Batch Input) | BBSNR_BI | CHAR | 5 | CHAR5 | ||||
BEGRU | Authorization Group | BRGRU | CHAR | 4 | Assigned to domain | BRGRU | |||
BRSCH | Industry key | BRSCH | CHAR | 4 | Assigned to domain | BRSCH | |||
BUBKZ | German Standard Company Number Check Digit (Batch Input) | BUBKZ_BI | CHAR | 1 | CHAR1 | ||||
DATLT | Data communication line no. | DATLT | CHAR | 14 | TEXT14 | ||||
FISKN | Account number of the master record with the fiscal address | FISKN_D | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
KNRZA | Account number of an alternative payer | KNRZA | CHAR | 10 | Assigned to domain | ALPHA | KUNNR | ||
KONZS | Group key | KONZS | CHAR | 10 | KONZS | ||||
KTOKD | Customer Account Group | KTOKD | CHAR | 4 | Assigned to domain | KTOKD | KGD | ||
LAND1 | Country Key | LAND1_GP | CHAR | 3 | Assigned to domain | LAND1 | C_LAND1 | ||
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10 | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C |
NAME1 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
NAME2 | Name 2 | NAME2_GP | CHAR | 35 | NAME | ||||
NAME3 | Name 3 | NAME3_GP | CHAR | 35 | NAME | ||||
NAME4 | Name 4 | NAME4_GP | CHAR | 35 | NAME | ||||
ORT01 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
ORT02 | District | ORT02_GP | CHAR | 35 | TEXT35 | ||||
PFACH | PO Box | PFACH | CHAR | 10 | PFACH | ||||
PSTL2 | P.O. Box Postal Code | PSTL2 | CHAR | 10 | PSTLZ | ||||
PSTLZ | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | Assigned to domain | REGIO | |||
COUNC | County Code | COUNC | CHAR | 3 | Assigned to domain | COUNC | |||
CITYC | City Code | CITYC | CHAR | 4 | Assigned to domain | CITYC | |||
SORTL | Sort field | SORTL | CHAR | 10 | CHAR10 | ||||
SPRAS | Language Key | SPRAS | LANG | 1 | Assigned to domain | ISOLA | SPRAS | SPR | H_T002 |
STCD1 | Tax Number 1 | STCD1 | CHAR | 16 | STCD1 | ||||
STCD2 | Tax Number 2 | STCD2 | CHAR | 11 | STCD2 | ||||
STKZA | Indicator: Business Partner Subject to Equalization Tax? | STKZA | CHAR | 1 | STKZA | ||||
STKZU | Liable for VAT | STKZU | CHAR | 1 | XFELD | ||||
STRAS | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
TELBX | Telebox number | TELBX | CHAR | 15 | TEXT15 | ||||
TELF1 | First telephone number | TELF1 | CHAR | 16 | TEXT16 | ||||
TELF2 | Second telephone number | TELF2 | CHAR | 16 | TEXT16 | ||||
TELFX | Fax Number | TELFX | CHAR | 31 | TEXT31 | ||||
TELTX | Teletex number | TELTX | CHAR | 30 | TEXT30 | ||||
TELX1 | Telex number | TELX1 | CHAR | 30 | TEXT30 | ||||
XZEMP | Indicator: Alternative payee in document allowed ? | XZEMP | CHAR | 1 | XFELD | ||||
VBUND | Company ID of trading partner | RASSC | CHAR | 6 | Assigned to domain | ALPHA | RCOMP | PGS | |
STCEG | VAT Registration Number | STCEG | CHAR | 20 | STCEG | ||||
STKZN | Natural Person | STKZN | CHAR | 1 | STKZN | ||||
LOEVM | Central Deletion Flag for Master Record | LOEVM_X | CHAR | 1 | XFELD | ||||
SPERR | Central posting block | SPERB_X | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP table VZKNA1 using ABAP code
The following ABAP code Example will allow you to do a basic selection on VZKNA1 to SELECT all data from the tableDATA: WA_VZKNA1 TYPE VZKNA1.
SELECT SINGLE *
FROM VZKNA1
INTO CORRESPONDING FIELDS OF WA_VZKNA1
WHERE...
How to access SAP table VZKNA1
Within an ECC or HANA version of SAP you can also view further information about VZKNA1 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects