SAP ABAP Table VZPARZA (Partner addit. data (general part))

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	VZPARZA	Table Relationship Diagram
Short Description	Partner addit. data (general part)

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	PARTNR	☑	SPARTNR	SPARTNR	CHAR	10	0	Partner number	SPRT1
3	SPERRE	☐	JGESPERRT	JFLAGG	CHAR	1	0	Internal flag: Record is blocked for changes
4	RERF	☐	RERF	SYCHAR12	CHAR	12	0	Entered by
5	DERF	☐	DERF	DATUM	DATS	8	0	First Entered on
6	TERF	☐	TERF	TIMES	TIMS	6	0	Time of Initial Entry
7	REHER	☐	REHER	CHAR10	CHAR	10	0	Source of initial entry
8	ROLLERF	☐	SROLEXT	SROLEXT	CHAR	3	0	External role of partner	TZRE
9	RBEAR	☐	RBEAR	SYCHAR12	CHAR	12	0	Employee ID
10	DBEAR	☐	DBEAR	DATUM	DATS	8	0	Last Edited on
11	TBEAR	☐	TBEAR	TIMES	TIMS	6	0	Last Edited at
12	RBHER	☐	RBHER	CHAR10	CHAR	10	0	Editing Source
13	ROLLBEA	☐	SROLEXT	SROLEXT	CHAR	3	0	External role of partner	TZRE
14	SGRDWHR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
15	SZIEL	☐	SZIEL	SZIEL	NUMC	2	0	Target group	TD05
16	JEIDVER	☐	JEIDVER	JANEI	CHAR	1	0	Submission of solemn declaration about wealth
17	JKONKURS	☐	JKONKURS	JANEI	CHAR	1	0	Bankruptcy proceedings indicator
18	JZWANG	☐	JZWANG	JANEI	CHAR	1	0	Foreclosure indicator
19	JSCHUFA	☐	SSCHUFA	SSCHUFA	CHAR	1	0	Acct solicitation service status
20	SBONITA	☐	SBONITA	SBONITA	CHAR	1	0	Credit standing
21	SKRED	☐	SKRED	SKRED	NUMC	2	0	Source of credit information (informant in form of company)	TIV61
22	XKRED	☐	VVXKRED	XTEXT50	CHAR	50	0	Summary of credit information
23	JKWG14	☐	JKWG14	JANEI	CHAR	1	0	Indicator borrowers subject to reporting GBA §14 (KWG)
24	RKWG14	☐	RKWG14	RKWG14	CHAR	8	0	SCB borrower no. in acc. with par. 14 GBA
25	RKWG14KE	☐	RKWG14KE	RKWG14	CHAR	8	0	SCB borrower unit no. according to para. 14 KWG
26	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
27	STCD2	☐	STCD2	STCD2	CHAR	11	0	Tax Number 2
28	STKZA	☐	STKZA	STKZA	CHAR	1	0	Indicator: Business Partner Subject to Equalization Tax?
29	SFINAMT	☐	SFINAMT	SPARTNR	CHAR	10	0	Tax office partner key	SPRT1
30	SORGAN	☐	SORGAN	SORGAN	NUMC	2	0	Loan to manager indicator	TZD1
31	SGRP1	☐	VVGRP_1	VVGRP_1	NUMC	3	0	Group Key 1 (Freely-Definable - 3 Figure Number)	TZDG1
32	SGRP2	☐	VVGRP_2	VVGRP_2	NUMC	3	0	Group Key 2 (Freely-Definable - 3 Figure Number)	TZDG2
33	SGRP3	☐	VVGRP_3	VVGRP_3	NUMC	3	0	Group Key 3 (Freely-Definable - 3 Figure Number)	TZDG3
34	SFRT1	☐	VVFREI_1	TEXT35	CHAR	35	0	User-defined text (freely definable - 35 character text)
35	SFRT2	☐	VVFREI_2	TEXT35	CHAR	35	0	User-defined text (freely definable - 35 character text)
36	YKONKURS	☐	VVYKONKURS	GJAHR	NUMC	4	0	Year of bankruptcy proceedings
37	YZWANG	☐	VVYZWANG	GJAHR	NUMC	4	0	Year of foreclosure
38	YEIDVER	☐	VVYEIDVER	GJAHR	NUMC	4	0	Year of affidavit
39	DSCHUFA	☐	VVDSCHUFA	DATUM	DATS	8	0	Date of last credit information
40	SPAVIP	☐	PAVIP	PAVIP	CHAR	1	0	VIP Partner	TVIP
41	SSAUSLA	☐	VVSSAUSLA	JANEI	CHAR	1	0	Non-resident tax indicator
42	SKWG18	☐	VVSKWG18	VVSKWG18	NUMC	2	0	Information in accordance with §18 GBA	TZV15
43	XAPARNR	☐	VVXAPARNR	CHAR15	CHAR	15	0	Partner ID in previous system
44	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	LFA1
45	ABUKR	☐	VVSABUKR	BUKRS	CHAR	4	0	Partner-company code allocation	T001
46	KALID	☐	SKALID	WFCID	CHAR	2	0	Factory calendar	TFACD
47	XID_AT	☐	VVXID_AT	VVXID_AT	CHAR	11	0	OeNB ID Number
48	SZG_AT	☐	VVSZG_AT	VVSZG_AT	CHAR	2	0	Target Group According to OeNB	TD05_AT
49	SID_AT	☐	VVSID_AT	JANEI	CHAR	1	0	Indicator: Assign Numbers for OeNB Externally

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VZPARZA	ABUKR	T001	BUKRS	KEY	1	CN
2	VZPARZA	KALID	TFACD	IDENT	KEY	1	CN
3	VZPARZA	LIFNR	LFA1	LIFNR	REF	C	CN
4	VZPARZA	MANDT	T000	MANDT	KEY	1	1
5	VZPARZA	PARTNR	SPRT1	PARTNR	KEY	1	CN
6	VZPARZA	ROLLBEA	TZRE	SROLEXT	KEY	1	CN
7	VZPARZA	ROLLERF	TZRE	SROLEXT	KEY	1	CN
8	VZPARZA	SFINAMT	SPRT1	PARTNR	KEY	1	1
9	VZPARZA	SGRDWHR	TCURC	WAERS	KEY	1	1
10	VZPARZA	SGRP1	TZDG1	SGRP1	KEY	1	CN
11	VZPARZA	SGRP2	TZDG2	SGRP2	KEY	1	CN
12	VZPARZA	SGRP3	TZDG3	SGRP3	KEY	1	CN
13	VZPARZA	SKRED	TIV61	SKRED
14	VZPARZA	SKWG18	TZV15	SKWG18	KEY	1	CN
15	VZPARZA	SORGAN	TZD1	SORGAN	KEY	1	CN
16	VZPARZA	SPAVIP	TVIP	PAVIP	REF	1	CN
17	VZPARZA	SZG_AT	TD05_AT	SZG_AT	KEY	1	CN
18	VZPARZA	SZIEL	TD05	SZIEL	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in