SAP ABAP Table VZKNA1 (Collector for batch input KNA1 from RF-VV)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FVV (Package) R/3 application development for Financial Assets Management

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VZKNA1	Table Relationship Diagram
Short Description	Collector for batch input KNA1 from RF-VV

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	KUNNR	☑	KUNNR_VV	KUNNR_VV	CHAR	10	0	Customer number RF-VV
3	ANRED	☐	ANRED	TEXT15	CHAR	15	0	Title
4	BBBNR	☐	BBBNR_BI	CHAR7	CHAR	7	0	German Standard Company Number (Batch Input Field)
5	BBSNR	☐	BBSNR_BI	CHAR5	CHAR	5	0	German Standard Company Number (Additional) (Batch Input)
6	BEGRU	☐	BRGRU	BRGRU	CHAR	4	0	Authorization Group	*
7	BRSCH	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	*
8	BUBKZ	☐	BUBKZ_BI	CHAR1	CHAR	1	0	German Standard Company Number Check Digit (Batch Input)
9	DATLT	☐	DATLT	TEXT14	CHAR	14	0	Data communication line no.
10	FISKN	☐	FISKN_D	KUNNR	CHAR	10	0	Account number of the master record with the fiscal address	*
11	KNRZA	☐	KNRZA	KUNNR	CHAR	10	0	Account number of an alternative payer	*
12	KONZS	☐	KONZS	KONZS	CHAR	10	0	Group key
13	KTOKD	☐	KTOKD	KTOKD	CHAR	4	0	Customer Account Group	*
14	LAND1	☐	LAND1_GP	LAND1	CHAR	3	0	Country Key	*
15	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
16	NAME1	☐	NAME1_GP	NAME	CHAR	35	0	Name 1
17	NAME2	☐	NAME2_GP	NAME	CHAR	35	0	Name 2
18	NAME3	☐	NAME3_GP	NAME	CHAR	35	0	Name 3
19	NAME4	☐	NAME4_GP	NAME	CHAR	35	0	Name 4
20	ORT01	☐	ORT01_GP	TEXT35	CHAR	35	0	City
21	ORT02	☐	ORT02_GP	TEXT35	CHAR	35	0	District
22	PFACH	☐	PFACH	PFACH	CHAR	10	0	PO Box
23	PSTL2	☐	PSTL2	PSTLZ	CHAR	10	0	P.O. Box Postal Code
24	PSTLZ	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
25	REGIO	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
26	COUNC	☐	COUNC	COUNC	CHAR	3	0	County Code	*
27	CITYC	☐	CITYC	CITYC	CHAR	4	0	City Code	*
28	SORTL	☐	SORTL	CHAR10	CHAR	10	0	Sort field
29	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
30	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
31	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
32	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
33	STKZU	☐	STKZU	XFELD	CHAR	1	0	Liable for VAT
34	STRAS	☐	STRAS_GP	TEXT35	CHAR	35	0	House number and street
35	TELBX	☐	TELBX	TEXT15	CHAR	15	0	Telebox number
36	TELF1	☐	TELF1	TEXT16	CHAR	16	0	First telephone number
37	TELF2	☐	TELF2	TEXT16	CHAR	16	0	Second telephone number
38	TELFX	☐	TELFX	TEXT31	CHAR	31	0	Fax Number
39	TELTX	☐	TELTX	TEXT30	CHAR	30	0	Teletex number
40	TELX1	☐	TELX1	TEXT30	CHAR	30	0	Telex number
41	XZEMP	☐	XZEMP	XFELD	CHAR	1	0	Indicator: Alternative payee in document allowed ?
42	VBUND	☐	RASSC	RCOMP	CHAR	6	0	Company ID of trading partner	*
43	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
44	STKZN	☐	STKZN	STKZN	CHAR	1	0	Natural Person
45	LOEVM	☐	LOEVM_X	XFELD	CHAR	1	0	Central Deletion Flag for Master Record
46	SPERR	☐	SPERB_X	XFELD	CHAR	1	0	Central posting block

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VZKNA1	MANDT	T000	MANDT	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in