SAP ABAP Table PV021 (HR Master Record: View V021 (Total Overview 0021 PS Germany))
Hierarchy
SAP_HRCNL (Software Component) Sub component SAP_HRCNL of SAP_HR
   PA-PA-NL (Application Component) Netherlands
     PB05 (Package) HR Master Data: Netherlands
Basic Data
Table Category INTTAB    Structure 
Structure PV021   Table Relationship Diagram
Short Description HR Master Record: View V021 (Total Overview 0021 PS Germany)    
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 .INCLUDE       0   0   Headers for Infotype Records  
2 .INCLUDE       0   0   Keys for HR Master Data  
3 PERNR PERNR_D PERNR NUMC 8   0   Personnel Number  
4 INFTY INFTY INFOTYP CHAR 4   0   Infotype T582A
5 SUBTY SUBTY SUBTY CHAR 4   0   Subtype  
6 OBJPS OBJPS OBJPS CHAR 2   0   Object Identification  
7 SPRPS SPRPS SPRPS CHAR 1   0   Lock Indicator for HR Master Data Record  
8 ENDDA ENDDA DATUM DATS 8   0   End Date  
9 BEGDA BEGDA DATUM DATS 8   0   Start Date  
10 SEQNR SEQNR NUM03 NUMC 3   0   Number of Infotype Record With Same Key  
11 .INCLUDE       0   0   HR Master Record: Control Field  
12 AEDTM AEDAT DATUM DATS 8   0   Last Changed On  
13 UNAME AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
14 HISTO HISTO CHAR1 CHAR 1   0   Historical Record Flag  
15 ITXEX ITXEX XFELD CHAR 1   0   Text Exists for Infotype  
16 REFEX PRFEX XFELD CHAR 1   0   Reference Fields Exist (Primary/Secondary Costs)  
17 ORDEX ORDEX XFELD CHAR 1   0   Confirmation Fields Exist  
18 ITBLD ITBLD CHAR2 CHAR 2   0   Infotype Screen Control  
19 PREAS PREAS PREAS CHAR 2   0   Reason for Changing Master Data T530E
20 FLAG1 NUSED NUSED CHAR 1   0   Reserved Field/Unused Field  
21 FLAG2 NUSED NUSED CHAR 1   0   Reserved Field/Unused Field  
22 FLAG3 NUSED NUSED CHAR 1   0   Reserved Field/Unused Field  
23 FLAG4 NUSED NUSED CHAR 1   0   Reserved Field/Unused Field  
24 RESE1 NUSED2 NUSED2 CHAR 2   0   Reserved Field/Unused Field of Length 2  
25 RESE2 NUSED2 NUSED2 CHAR 2   0   Reserved Field/Unused Field of Length 2  
26 GRPVL PCCE_GPVAL PCCE_GPVAL CHAR 4   0   Grouping Value for Personnel Assignments  
27 .INCLUDE       0   0   HR Master Record: Infotype 0021 (Family)  
28 FAMSA FAMSA SUBTY CHAR 4   0   Type of Family Record  
29 FGBDT GBDAT GBDAT DATS 8   0   Date of Birth  
30 FGBLD GBLND LAND1 CHAR 3   0   Country of Birth T005
31 FANAT NATSL LAND1 CHAR 3   0   Nationality T005
32 FASEX GESCH GESCH CHAR 1   0   Gender Key  
33 FAVOR PAD_VORNA PAD_VORNM CHAR 40   0   First Name  
34 FANAM PAD_NACHN PAD_NACHN CHAR 40   0   Last Name  
35 FGBOT PAD_GBORT PAD_ORT01 CHAR 40   0   Birthplace  
36 FGDEP GBDEP REGIO CHAR 3   0   State T005S
37 ERBNR ERBNR CHAR12 CHAR 12   0   Reference Personnel Number for Family Member  
38 FGBNA PAD_NAME2 PAD_NACHN CHAR 40   0   Name at Birth  
39 FNAC2 PAD_NACH2 PAD_NACHN CHAR 40   0   Second Name  
40 FCNAM PAD_CNAME TEXT80 CHAR 80   0   Complete Name  
41 FKNZN KNZNM KNZN2 NUMC 2   0   Name Format Indicator for Employee in a List  
42 FINIT INITS TEXT10 CHAR 10   0   Initials  
43 FVRSW VORSW TITEL CHAR 15   0   Name Prefix T535N
44 FVRS2 VORSW TITEL CHAR 15   0   Name Prefix T535N
45 FNMZU NAMZU TITEL CHAR 15   0   Other Title T535N
46 AHVNR AHVNR P02_AHVNR CHAR 11   0   AHV Number  
47 KDSVH KDSVH AUSPR CHAR 2   0   Relationship to Child T577
48 KDBSL KDBSL AUSPR CHAR 2   0   Allowance Authorization T577
49 KDUTB KDUTB AUSPR CHAR 2   0   Address of Child T577
50 KDGBR KDGBR AUSPR CHAR 2   0   Child Allowance Entitlement T577
51 KDART KDART AUSPR CHAR 2   0   Child Type T577
52 KDZUG KDZUG AUSPR CHAR 2   0   Child Bonuses T577
53 KDZUL KDZUL AUSPR CHAR 2   0   Child Allowances T577
54 KDVBE KDVBE AUSPR CHAR 2   0   Sickness Certificate Authorization T577
55 ERMNR ERMNR CHAR8 CHAR 8   0   Authority Number  
56 AUSVL AUSVL NUM4 NUMC 4   0   1st part of SI number (sequential number)  
57 AUSVG AUSVG NUM8 NUMC 8   0   2nd part of SI number (birthdate)  
58 FASDT FASDT DATUM DATS 8   0   End of Family Member's Education/Training  
59 FASAR FASAR SLART CHAR 2   0   School Type of Family Member T517T
60 FASIN FASIN TEXT20 CHAR 20   0   Educational Institute  
61 EGAGA EGAGA VARGA CHAR 8   0   Employer of Family Member  
62 FANA2 NATS2 LAND1 CHAR 3   0   Second Nationality T005
63 FANA3 NATS3 LAND1 CHAR 3   0   Third Nationality T005
64 BETRG BETRG WERTV5 CURR 9   2   Amount  
65 TITEL TITEL TITEL CHAR 15   0   Title T535N
66 EMRGN PAD_EMRGN XFELD CHAR 1   0   Emergency Contact  
67 .INCLUDE       0   0    
68 .INCLUDE       0   0   HR Master Record: Infotype 0264 (Family NL)  
69 ZKVGP P05_ZKVGP P05_ZKVGP CHAR 2   0   Private Health Insurance Group T5N1F
70 PKLAS P05_PKLAS P05_PKLAS CHAR 2   0   Contribution Scale for Health Insurance T5N1F
71 BSNCD P05_BSN NUM9 NUMC 9   0   Citizen Service Number [BSN]  
72 .INCLUDE       0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 PV021 FANA2 T005 LAND1    
2 PV021 FANA3 T005 LAND1    
3 PV021 FANAT T005 LAND1    
4 PV021 FASAR T517T SLART    
5 PV021 FGBLD T005 LAND1    
6 PV021 FGDEP T005S BLAND    
7 PV021 FNMZU T535N TITEL    
8 PV021 FVRS2 T535N TITEL    
9 PV021 FVRSW T535N TITEL    
10 PV021 INFTY T582A INFTY    
11 PV021 KDART T577 AUSPR    
12 PV021 KDBSL T577 AUSPR    
13 PV021 KDGBR T577 AUSPR    
14 PV021 KDSVH T577 AUSPR    
15 PV021 KDUTB T577 AUSPR    
16 PV021 KDVBE T577 AUSPR    
17 PV021 KDZUG T577 AUSPR    
18 PV021 KDZUL T577 AUSPR    
19 PV021 PKLAS T5N1F PKLAS REF 1 CN
20 PV021 PREAS T530E PREAS    
21 PV021 TITEL T535N TITEL    
22 PV021 ZKVGP T5N1F ZKVGP 1 CN
History
Last changed by/on SAP  20110901 
SAP Release Created in