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