SAP ABAP Table P0566 (US Pension Plan QDRO Information)
Hierarchy
☛ SAP_HRCUS (Software Component) Sub component SAP_HRCUS of SAP_HR
   ⤷ PA-PA-US (Application Component) USA
     ⤷ PB10 (Package) HR master data: USA
Basic Data
Table Category INTTAB    Structure 
Structure P0566   Table Relationship Diagram
Short Description US Pension Plan QDRO Information    
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   US Pension Plan QDRO Information  
28 DOCNO P10_DOCNO CHAR35 CHAR 35   0   QDRO Docket Number  
29 ADATE P10_ADATE DATUM DATS 8   0   QDRO Award Date  
30 QSTAT P10_QSTAT CHAR1 CHAR 1   0   QDRO Status: Inactive  
31 .INCLUDE       0   0   US QDRO Court Information  
32 CNAME P10_CNAME TEXT40 CHAR 40   0   QDRO Court Name  
33 JNAME P10_JNAME TEXT40 CHAR 40   0   QDRO Judge Name  
34 CADR1 STRAS TEXT30 CHAR 30   0   House number and street  
35 CADR2 LOCAT TEXT30 CHAR 30   0   2nd Address Line  
36 CCITY ORT01 TEXT25 CHAR 25   0   City  
37 CSTAT REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
38 CZIP PSTLZ PSTLZ CHAR 10   0   Postal Code  
39 CLAND LAND1 LAND1 CHAR 3   0   Country Key T005
40 CTELN TELNR TELNR CHAR 14   0   Telephone Number  
41 CFAXN TELNR TELNR CHAR 14   0   Telephone Number  
42 CEMAI P10_EMAIL TEXT40 CHAR 40   0   E-mail Address  
43 .INCLUDE       0   0   US QDRO Attorney Information  
44 ANAME P10_ANAME TEXT40 CHAR 40   0   QDRO Attorney Name  
45 AADR1 STRAS TEXT30 CHAR 30   0   House number and street  
46 AADR2 LOCAT TEXT30 CHAR 30   0   2nd Address Line  
47 ACITY ORT01 TEXT25 CHAR 25   0   City  
48 ASTAT REGIO REGIO CHAR 3   0   Region (State, Province, County) T005S
49 AZIP PSTLZ PSTLZ CHAR 10   0   Postal Code  
50 ALAND LAND1 LAND1 CHAR 3   0   Country Key T005
51 ATELN TELNR TELNR CHAR 14   0   Telephone Number  
52 AFAXN TELNR TELNR CHAR 14   0   Telephone Number  
53 AEMAI P10_EMAIL TEXT40 CHAR 40   0   E-mail Address  
54 BAREA BEN_AREA BEN_AREA CHAR 2   0   Benefit area *
55 CURRK BEN_CURR WAERS CUKY 5   0   Benefit Currency Key TCURC
56 .INCLUDE       0   0   Benefit Repeat Structure for QDRO Plans  
57 BPL01 BEN_PLAN BEN_PLAN CHAR 4   0   Benefit plan *
58 VAL01 P10_VATYP P10_VATYP CHAR 1   0   QDRO Award Valuation Type  
59 AMT01 P10_AMT7S P_AMT07V CURR 13   2   QDRO Award Amount  
60 BPL02 BEN_PLAN BEN_PLAN CHAR 4   0   Benefit plan *
61 VAL02 P10_VATYP P10_VATYP CHAR 1   0   QDRO Award Valuation Type  
62 AMT02 P10_AMT7S P_AMT07V CURR 13   2   QDRO Award Amount  
63 BPL03 BEN_PLAN BEN_PLAN CHAR 4   0   Benefit plan *
64 VAL03 P10_VATYP P10_VATYP CHAR 1   0   QDRO Award Valuation Type  
65 AMT03 P10_AMT7S P_AMT07V CURR 13   2   QDRO Award Amount  
66 BPL04 BEN_PLAN BEN_PLAN CHAR 4   0   Benefit plan *
67 VAL04 P10_VATYP P10_VATYP CHAR 1   0   QDRO Award Valuation Type  
68 AMT04 P10_AMT7S P_AMT07V CURR 13   2   QDRO Award Amount  
69 BPL05 BEN_PLAN BEN_PLAN CHAR 4   0   Benefit plan *
70 VAL05 P10_VATYP P10_VATYP CHAR 1   0   QDRO Award Valuation Type  
71 AMT05 P10_AMT7S P_AMT07V CURR 13   2   QDRO Award Amount  
72 BPL06 BEN_PLAN BEN_PLAN CHAR 4   0   Benefit plan *
73 VAL06 P10_VATYP P10_VATYP CHAR 1   0   QDRO Award Valuation Type  
74 AMT06 P10_AMT7S P_AMT07V CURR 13   2   QDRO Award Amount  
75 BPL07 BEN_PLAN BEN_PLAN CHAR 4   0   Benefit plan *
76 VAL07 P10_VATYP P10_VATYP CHAR 1   0   QDRO Award Valuation Type  
77 AMT07 P10_AMT7S P_AMT07V CURR 13   2   QDRO Award Amount  
78 BPL08 BEN_PLAN BEN_PLAN CHAR 4   0   Benefit plan *
79 VAL08 P10_VATYP P10_VATYP CHAR 1   0   QDRO Award Valuation Type  
80 AMT08 P10_AMT7S P_AMT07V CURR 13   2   QDRO Award Amount  
81 BPL09 BEN_PLAN BEN_PLAN CHAR 4   0   Benefit plan *
82 VAL09 P10_VATYP P10_VATYP CHAR 1   0   QDRO Award Valuation Type  
83 AMT09 P10_AMT7S P_AMT07V CURR 13   2   QDRO Award Amount  
84 BPL10 BEN_PLAN BEN_PLAN CHAR 4   0   Benefit plan *
85 VAL10 P10_VATYP P10_VATYP CHAR 1   0   QDRO Award Valuation Type  
86 AMT10 P10_AMT7S P_AMT07V CURR 13   2   QDRO Award Amount  
87 BPL11 BEN_PLAN BEN_PLAN CHAR 4   0   Benefit plan *
88 VAL11 P10_VATYP P10_VATYP CHAR 1   0   QDRO Award Valuation Type  
89 AMT11 P10_AMT7S P_AMT07V CURR 13   2   QDRO Award Amount  
90 BPL12 BEN_PLAN BEN_PLAN CHAR 4   0   Benefit plan *
91 VAL12 P10_VATYP P10_VATYP CHAR 1   0   QDRO Award Valuation Type  
92 AMT12 P10_AMT7S P_AMT07V CURR 13   2   QDRO Award Amount  
93 BPL13 BEN_PLAN BEN_PLAN CHAR 4   0   Benefit plan *
94 VAL13 P10_VATYP P10_VATYP CHAR 1   0   QDRO Award Valuation Type  
95 AMT13 P10_AMT7S P_AMT07V CURR 13   2   QDRO Award Amount  
96 BPL14 BEN_PLAN BEN_PLAN CHAR 4   0   Benefit plan *
97 VAL14 P10_VATYP P10_VATYP CHAR 1   0   QDRO Award Valuation Type  
98 AMT14 P10_AMT7S P_AMT07V CURR 13   2   QDRO Award Amount  
99 BPL15 BEN_PLAN BEN_PLAN CHAR 4   0   Benefit plan *
100 VAL15 P10_VATYP P10_VATYP CHAR 1   0   QDRO Award Valuation Type  
101 AMT15 P10_AMT7S P_AMT07V CURR 13   2   QDRO Award Amount  
102 BPL16 BEN_PLAN BEN_PLAN CHAR 4   0   Benefit plan *
103 VAL16 P10_VATYP P10_VATYP CHAR 1   0   QDRO Award Valuation Type  
104 AMT16 P10_AMT7S P_AMT07V CURR 13   2   QDRO Award Amount  
105 BPL17 BEN_PLAN BEN_PLAN CHAR 4   0   Benefit plan *
106 VAL17 P10_VATYP P10_VATYP CHAR 1   0   QDRO Award Valuation Type  
107 AMT17 P10_AMT7S P_AMT07V CURR 13   2   QDRO Award Amount  
108 BPL18 BEN_PLAN BEN_PLAN CHAR 4   0   Benefit plan *
109 VAL18 P10_VATYP P10_VATYP CHAR 1   0   QDRO Award Valuation Type  
110 AMT18 P10_AMT7S P_AMT07V CURR 13   2   QDRO Award Amount  
111 BPL19 BEN_PLAN BEN_PLAN CHAR 4   0   Benefit plan *
112 VAL19 P10_VATYP P10_VATYP CHAR 1   0   QDRO Award Valuation Type  
113 AMT19 P10_AMT7S P_AMT07V CURR 13   2   QDRO Award Amount  
114 BPL20 BEN_PLAN BEN_PLAN CHAR 4   0   Benefit plan *
115 VAL20 P10_VATYP P10_VATYP CHAR 1   0   QDRO Award Valuation Type  
116 AMT20 P10_AMT7S P_AMT07V CURR 13   2   QDRO Award Amount  
117 .INCLUDE       0   0    
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 P0566 ALAND T005 LAND1    
2 P0566 ASTAT T005S BLAND    
3 P0566 CLAND T005 LAND1    
4 P0566 CSTAT T005S BLAND    
5 P0566 CURRK TCURC WAERS    
6 P0566 INFTY T582A INFTY    
7 P0566 PREAS T530E PREAS    
History
Last changed by/on SAP  20130529 
SAP Release Created in