SAP ABAP Table VZPARZN (Partner addit. data (natural person))

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	INTTAB	Structure
Structure	VZPARZN	Table Relationship Diagram
Short Description	Partner addit. data (natural person)

Delivery and Maintenance

Pool/cluster
Delivery Class
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	PARTNR	☑	SPARTNR	SPARTNR	CHAR	10	0	Partner number	SPRT1
3	RINTPERS	☐	RINTPERS	CHAR10	CHAR	10	0	Personnel number/internal number
4	SINTPOS	☐	SINTPOS	VVSINTPOS	CHAR	3	0	Internal position/employee group indicator	TZV06
5	JSELBST	☐	JSELBST	JANEI	CHAR	1	0	Indicator self-employed (yes/no)
6	DGEBURT	☐	DGEBURT	DATUM	DATS	8	0	Partner date of birth
7	XGEBORT	☐	XGEBORT	TEXT20	CHAR	20	0	Place of birth of partner
8	SFAMILIE	☐	SFAMILIE	SFAMILIE	NUMC	1	0	Marital status indicator
9	SGUETER	☐	SGUETER	SGUETER	CHAR	1	0	Matrimonial property regime indicator
10	AKINDER	☐	AKINDER	DEC2	DEC	2	0	Number of children
11	APERSON	☐	APERSO	DEC2	DEC	2	0	Number of People Living in the Household
12	DBSSEIT	☐	DBSSEIT	DATUM	DATS	8	0	Operative since
13	XBERUF	☐	XBERUF	XMBEZ	CHAR	30	0	Profession
14	XBSALS	☐	XBSALS	XMBEZ	CHAR	30	0	Employed as
15	XARBGEB	☐	XARBGEB	TEXT50	CHAR	50	0	Employer
16	BEINKO	☐	BEINKO	BWHR	CURR	13	2	Net income/year
17	SGRP8	☐	VVGRP_8	VVGRP_8	NUMC	3	0	Group Key 8 (Freely-Definable - 3 Figure Number)	TZDG8
18	SGRP9	☐	VVGRP_9	VVGRP_9	NUMC	3	0	Group Key 9 (Freely-Definable - 3 Figure Number)	TZDG9
19	SGRP10	☐	VVGRP10	VVGRP10	NUMC	3	0	Group Key 10 (Freely-Definable - 3 Figure Number)	TZEG1
20	SGRP11	☐	VVGRP11	VVGRP11	NUMC	3	0	Group Key 11 (Freely-Definable - 3 Figure Number)	TZEG2
21	SFRT1	☐	VVFREI_6	TEXT35	CHAR	35	0	User-defined text (freely definable - 35 character text)
22	SFRT2	☐	VVFREI_7	TEXT35	CHAR	35	0	User-defined text (freely definable - 35 character text)
23	SFRT3	☐	VVFREI_8	TEXT35	CHAR	35	0	User-defined text (freely definable - 35 character text)
24	DBSBIS	☐	VVDBSBIS	DATUM	DATS	8	0	Employed until
25	DTOD	☐	VVDTOD	DATUM	DATS	8	0	Date of death
26	SWIRTBR	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
27	SRSZKE	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
28	XGEBNAME	☐	VVXGEBNAME	TEXT35	CHAR	35	0	Name at Birth
29	XGEBNAMZ	☐	VVXGEBNAMZ	TEXT35	CHAR	35	0	Birth name-additional information
30	SZUGHK	☐	VVZUGHK	VVZUGHK	NUMC	2	0	Employee	TIV30
31	SGRDWHR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
32	YEINKO	☐	VVYEINKO	GJAHR	NUMC	4	0	Annual net income
33	MYEINKO	☐	VVMYEINKO	NUMC06	NUMC	6	0	Month/year monthly income
34	BMEINKO	☐	VVBMEINKO	BWHR	CURR	13	2	Monthly income
35	JAWVEROR	☐	JAWVEROR	JANEI	CHAR	1	0	German foreign trade and payments ordinance indicator
36	DAWVO	☐	VVDAWVO	DATUM	DATS	8	0	Validity date German for.trade law/for.trade + pmnts ordin.
37	BNAME	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VZPARZN	MANDT	T000	MANDT	KEY	1	1
2	VZPARZN	PARTNR	SPRT1	PARTNR	KEY	1	CN
3	VZPARZN	SGRDWHR	TCURC	WAERS	KEY	1	1
4	VZPARZN	SGRP10	TZEG1	SGRP10	KEY	1	CN
5	VZPARZN	SGRP11	TZEG2	SGRP11	KEY	1	CN
6	VZPARZN	SGRP8	TZDG8	SGRP8	KEY	1	CN
7	VZPARZN	SGRP9	TZDG9	SGRP9	KEY	1	CN
8	VZPARZN	SINTPOS	TZV06	SINTPOS	KEY	1	CN
9	VZPARZN	SWIRTBR	T016	BRSCH	KEY	1	CN
10	VZPARZN	SZUGHK	TIV30	ZUGHK	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in