SAP ABAP Table PS0566 (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	PS0566	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	DOCNO	☐	P10_DOCNO	CHAR35	CHAR	35	0	QDRO Docket Number
2	ADATE	☐	P10_ADATE	DATUM	DATS	8	0	QDRO Award Date
3	QSTAT	☐	P10_QSTAT	CHAR1	CHAR	1	0	QDRO Status: Inactive
4	.INCLUDE	☐				0	0	US QDRO Court Information
5	CNAME	☐	P10_CNAME	TEXT40	CHAR	40	0	QDRO Court Name
6	JNAME	☐	P10_JNAME	TEXT40	CHAR	40	0	QDRO Judge Name
7	CADR1	☐	STRAS	TEXT30	CHAR	30	0	House number and street
8	CADR2	☐	LOCAT	TEXT30	CHAR	30	0	2nd Address Line
9	CCITY	☐	ORT01	TEXT25	CHAR	25	0	City
10	CSTAT	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
11	CZIP	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
12	CLAND	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
13	CTELN	☐	TELNR	TELNR	CHAR	14	0	Telephone Number
14	CFAXN	☐	TELNR	TELNR	CHAR	14	0	Telephone Number
15	CEMAI	☐	P10_EMAIL	TEXT40	CHAR	40	0	E-mail Address
16	.INCLUDE	☐				0	0	US QDRO Attorney Information
17	ANAME	☐	P10_ANAME	TEXT40	CHAR	40	0	QDRO Attorney Name
18	AADR1	☐	STRAS	TEXT30	CHAR	30	0	House number and street
19	AADR2	☐	LOCAT	TEXT30	CHAR	30	0	2nd Address Line
20	ACITY	☐	ORT01	TEXT25	CHAR	25	0	City
21	ASTAT	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
22	AZIP	☐	PSTLZ	PSTLZ	CHAR	10	0	Postal Code
23	ALAND	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
24	ATELN	☐	TELNR	TELNR	CHAR	14	0	Telephone Number
25	AFAXN	☐	TELNR	TELNR	CHAR	14	0	Telephone Number
26	AEMAI	☐	P10_EMAIL	TEXT40	CHAR	40	0	E-mail Address
27	BAREA	☐	BEN_AREA	BEN_AREA	CHAR	2	0	Benefit area	*
28	CURRK	☐	BEN_CURR	WAERS	CUKY	5	0	Benefit Currency Key	TCURC
29	.INCLUDE	☐				0	0	Benefit Repeat Structure for QDRO Plans
30	BPL01	☐	BEN_PLAN	BEN_PLAN	CHAR	4	0	Benefit plan	*
31	VAL01	☐	P10_VATYP	P10_VATYP	CHAR	1	0	QDRO Award Valuation Type
32	AMT01	☐	P10_AMT7S	P_AMT07V	CURR	13	2	QDRO Award Amount
33	BPL02	☐	BEN_PLAN	BEN_PLAN	CHAR	4	0	Benefit plan	*
34	VAL02	☐	P10_VATYP	P10_VATYP	CHAR	1	0	QDRO Award Valuation Type
35	AMT02	☐	P10_AMT7S	P_AMT07V	CURR	13	2	QDRO Award Amount
36	BPL03	☐	BEN_PLAN	BEN_PLAN	CHAR	4	0	Benefit plan	*
37	VAL03	☐	P10_VATYP	P10_VATYP	CHAR	1	0	QDRO Award Valuation Type
38	AMT03	☐	P10_AMT7S	P_AMT07V	CURR	13	2	QDRO Award Amount
39	BPL04	☐	BEN_PLAN	BEN_PLAN	CHAR	4	0	Benefit plan	*
40	VAL04	☐	P10_VATYP	P10_VATYP	CHAR	1	0	QDRO Award Valuation Type
41	AMT04	☐	P10_AMT7S	P_AMT07V	CURR	13	2	QDRO Award Amount
42	BPL05	☐	BEN_PLAN	BEN_PLAN	CHAR	4	0	Benefit plan	*
43	VAL05	☐	P10_VATYP	P10_VATYP	CHAR	1	0	QDRO Award Valuation Type
44	AMT05	☐	P10_AMT7S	P_AMT07V	CURR	13	2	QDRO Award Amount
45	BPL06	☐	BEN_PLAN	BEN_PLAN	CHAR	4	0	Benefit plan	*
46	VAL06	☐	P10_VATYP	P10_VATYP	CHAR	1	0	QDRO Award Valuation Type
47	AMT06	☐	P10_AMT7S	P_AMT07V	CURR	13	2	QDRO Award Amount
48	BPL07	☐	BEN_PLAN	BEN_PLAN	CHAR	4	0	Benefit plan	*
49	VAL07	☐	P10_VATYP	P10_VATYP	CHAR	1	0	QDRO Award Valuation Type
50	AMT07	☐	P10_AMT7S	P_AMT07V	CURR	13	2	QDRO Award Amount
51	BPL08	☐	BEN_PLAN	BEN_PLAN	CHAR	4	0	Benefit plan	*
52	VAL08	☐	P10_VATYP	P10_VATYP	CHAR	1	0	QDRO Award Valuation Type
53	AMT08	☐	P10_AMT7S	P_AMT07V	CURR	13	2	QDRO Award Amount
54	BPL09	☐	BEN_PLAN	BEN_PLAN	CHAR	4	0	Benefit plan	*
55	VAL09	☐	P10_VATYP	P10_VATYP	CHAR	1	0	QDRO Award Valuation Type
56	AMT09	☐	P10_AMT7S	P_AMT07V	CURR	13	2	QDRO Award Amount
57	BPL10	☐	BEN_PLAN	BEN_PLAN	CHAR	4	0	Benefit plan	*
58	VAL10	☐	P10_VATYP	P10_VATYP	CHAR	1	0	QDRO Award Valuation Type
59	AMT10	☐	P10_AMT7S	P_AMT07V	CURR	13	2	QDRO Award Amount
60	BPL11	☐	BEN_PLAN	BEN_PLAN	CHAR	4	0	Benefit plan	*
61	VAL11	☐	P10_VATYP	P10_VATYP	CHAR	1	0	QDRO Award Valuation Type
62	AMT11	☐	P10_AMT7S	P_AMT07V	CURR	13	2	QDRO Award Amount
63	BPL12	☐	BEN_PLAN	BEN_PLAN	CHAR	4	0	Benefit plan	*
64	VAL12	☐	P10_VATYP	P10_VATYP	CHAR	1	0	QDRO Award Valuation Type
65	AMT12	☐	P10_AMT7S	P_AMT07V	CURR	13	2	QDRO Award Amount
66	BPL13	☐	BEN_PLAN	BEN_PLAN	CHAR	4	0	Benefit plan	*
67	VAL13	☐	P10_VATYP	P10_VATYP	CHAR	1	0	QDRO Award Valuation Type
68	AMT13	☐	P10_AMT7S	P_AMT07V	CURR	13	2	QDRO Award Amount
69	BPL14	☐	BEN_PLAN	BEN_PLAN	CHAR	4	0	Benefit plan	*
70	VAL14	☐	P10_VATYP	P10_VATYP	CHAR	1	0	QDRO Award Valuation Type
71	AMT14	☐	P10_AMT7S	P_AMT07V	CURR	13	2	QDRO Award Amount
72	BPL15	☐	BEN_PLAN	BEN_PLAN	CHAR	4	0	Benefit plan	*
73	VAL15	☐	P10_VATYP	P10_VATYP	CHAR	1	0	QDRO Award Valuation Type
74	AMT15	☐	P10_AMT7S	P_AMT07V	CURR	13	2	QDRO Award Amount
75	BPL16	☐	BEN_PLAN	BEN_PLAN	CHAR	4	0	Benefit plan	*
76	VAL16	☐	P10_VATYP	P10_VATYP	CHAR	1	0	QDRO Award Valuation Type
77	AMT16	☐	P10_AMT7S	P_AMT07V	CURR	13	2	QDRO Award Amount
78	BPL17	☐	BEN_PLAN	BEN_PLAN	CHAR	4	0	Benefit plan	*
79	VAL17	☐	P10_VATYP	P10_VATYP	CHAR	1	0	QDRO Award Valuation Type
80	AMT17	☐	P10_AMT7S	P_AMT07V	CURR	13	2	QDRO Award Amount
81	BPL18	☐	BEN_PLAN	BEN_PLAN	CHAR	4	0	Benefit plan	*
82	VAL18	☐	P10_VATYP	P10_VATYP	CHAR	1	0	QDRO Award Valuation Type
83	AMT18	☐	P10_AMT7S	P_AMT07V	CURR	13	2	QDRO Award Amount
84	BPL19	☐	BEN_PLAN	BEN_PLAN	CHAR	4	0	Benefit plan	*
85	VAL19	☐	P10_VATYP	P10_VATYP	CHAR	1	0	QDRO Award Valuation Type
86	AMT19	☐	P10_AMT7S	P_AMT07V	CURR	13	2	QDRO Award Amount
87	BPL20	☐	BEN_PLAN	BEN_PLAN	CHAR	4	0	Benefit plan	*
88	VAL20	☐	P10_VATYP	P10_VATYP	CHAR	1	0	QDRO Award Valuation Type
89	AMT20	☐	P10_AMT7S	P_AMT07V	CURR	13	2	QDRO Award Amount
90	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PS0566	ALAND	T005	LAND1
2	PS0566	ASTAT	T005S	BLAND
3	PS0566	CLAND	T005	LAND1
4	PS0566	CSTAT	T005S	BLAND
5	PS0566	CURRK	TCURC	WAERS

History

Last changed by/on	SAP	20130529
SAP Release Created in