SAP ABAP Table VZPARZU (Addit. partner data)

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	VZPARZU	Table Relationship Diagram
Short Description	Addit. partner data

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	☐	BP_PARTNR	BP_PARTNR	CHAR	10	0	Business Partner Number	BP000
3	SRECHTSF	☐	BP_LEG_ETY	BP_LEG_ETY	NUMC	2	0	Legal Form of Organization	TP08
4	SRECHTST	☐	BP_LEG_ORG	BP_LEG_ORG	NUMC	2	0	Legal Entity of Organization	TP09
5	SKONSOL	☐	SKONSOL	JANEI	CHAR	1	0	Consolidation indicator (yes/no)
6	SUNTBEZ	☐	SUNTBEZ	SUBEZ	CHAR	1	0	Company relationship
7	BGRDKAP	☐	BGRDKAP	WERT8	CURR	15	2	Authorized company capital stock
8	SGRDWHR	☐	BIWHR	WAERS	CUKY	5	0	Balance sheet currency	TCURC
9	BAKTKAP	☐	BAKTKAP	WERT8	CURR	15	2	Company stock capital issued
10	BGENKAP	☐	BGENKAP	WERT8	CURR	15	2	Participation certificates outstanding
11	BEIGKAP	☐	BEIGKAP	WERT8	CURR	15	2	Equity capital
12	BBRUTBEI	☐	BBRUTBEI	WERT8	CURR	15	2	Gross contributions
13	BNETBEI	☐	BNETBEI	WERT8	CURR	15	2	Net contribution
14	BJUENST	☐	BJUENST	WERT8	CURR	15	2	Annual net income after tax
15	DHPTVERS	☐	DHPTVERS	DATUM	DATS	8	0	Date of annual stockholders meeting
16	YLKAPERH	☐	VVYLKAPERH	GJAHR	NUMC	4	0	Year of last capital increase
17	BKAPERH	☐	BKAPERH	WERT8	CURR	15	2	Amount of last capital increase
18	SRATING	☐	BP_RATING	BP_RATING	CHAR	3	0	Rating	TP06
19	SRATAGEN	☐	SRATAGEN	SPARTNR	CHAR	10	0	Rating agency	*
20	JAWVEROR	☐	JAWVEROR	JANEI	CHAR	1	0	German foreign trade and payments ordinance indicator
21	SWIRTBR	☐	BRSCH	BRSCH	CHAR	4	0	Industry key	T016
22	RKWG14	☐	RKWG14	RKWG14	CHAR	8	0	SCB borrower no. in acc. with par. 14 GBA
23	BLZ	☐	BLZ	BLZ	CHAR	8	0	Bank number
24	RINTPERS	☐	RINTPERS	CHAR10	CHAR	10	0	Personnel number/internal number
25	SINTPOS	☐	SINTPOS	VVSINTPOS	CHAR	3	0	Internal position/employee group indicator	*
26	DGEBURT	☐	DGEBURT	DATUM	DATS	8	0	Partner date of birth
27	XGEBORT	☐	XGEBORT	TEXT20	CHAR	20	0	Place of birth of partner
28	SFAMILIE	☐	SFAMILIE	SFAMILIE	NUMC	1	0	Marital status indicator
29	SGUETER	☐	SGUETER	SGUETER	CHAR	1	0	Matrimonial property regime indicator
30	SZIEL	☐	SZIEL	SZIEL	NUMC	2	0	Target group	TD05
31	AKINDER	☐	AKINDER	DEC2	DEC	2	0	Number of children
32	SORGAN	☐	SORGAN	SORGAN	NUMC	2	0	Loan to manager indicator	*
33	DBSSEIT	☐	DBSSEIT	DATUM	DATS	8	0	Operative since
34	JEIDVER	☐	JEIDVER	JANEI	CHAR	1	0	Submission of solemn declaration about wealth
35	JKONKURS	☐	JKONKURS	JANEI	CHAR	1	0	Bankruptcy proceedings indicator
36	JZWANG	☐	JZWANG	JANEI	CHAR	1	0	Foreclosure indicator
37	JSELBST	☐	JSELBST	JANEI	CHAR	1	0	Indicator self-employed (yes/no)
38	JSCHUFA	☐	JSCHUFA	JANEI	CHAR	1	0	Indicator: SCHUFA information correct
39	SBONITA	☐	SBONITA	SBONITA	CHAR	1	0	Credit standing
40	XBERUF	☐	XBERUF	XMBEZ	CHAR	30	0	Profession
41	XBSALS	☐	XBSALS	XMBEZ	CHAR	30	0	Employed as
42	XARBGEB	☐	XARBGEB	TEXT50	CHAR	50	0	Employer
43	BEINKO	☐	BEINKO	BWHR	CURR	13	2	Net income/year
44	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
45	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
46	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
47	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
48	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
49	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
50	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
51	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
52	BUMSATZ	☐	BUMSATZ	WERT8	CURR	15	2	Annual sales
53	YGRND	☐	VVYGRND	GJAHR	NUMC	4	0	Year of formation of a company
54	VBJAHR	☐	VBJAHR	GJAHR	NUMC	4	0	Fiscal year
55	XHRGN	☐	XHRGN	XCH50	CHAR	50	0	Entry in commercial register
56	SKRED	☐	SKRED	SKRED	NUMC	2	0	Source of credit information (informant in form of company)	TIV61
57	XKRED	☐	VVXKRED	XTEXT50	CHAR	50	0	Summary of credit information
58	JKWG14	☐	JKWG14	JANEI	CHAR	1	0	Indicator borrowers subject to reporting GBA §14 (KWG)
59	RKWG14KE	☐	RKWG14KE	RKWG14	CHAR	8	0	SCB borrower unit no. according to para. 14 KWG

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VZPARZU	MANDT	T000	MANDT
2	VZPARZU	PARTNR	BP000	PARTNR
3	VZPARZU	SGRDWHR	TCURC	WAERS
4	VZPARZU	SKRED	TIV61	SKRED
5	VZPARZU	SRATING	TP06	RATING
6	VZPARZU	SRECHTSF	TP08	LEGAL_ENTY
7	VZPARZU	SRECHTST	TP09	LEGAL_ORG
8	VZPARZU	SWIRTBR	T016	BRSCH
9	VZPARZU	SZIEL	TD05	SZIEL

History

Last changed by/on	SAP	20130529
SAP Release Created in