SAP ABAP Table PA0699 (Personnel Master Record Infotype 0699)

Hierarchy

☛ SAP_HRCDE (Software Component) Sub component SAP_HRCDE of SAP_HR
   ⤷ PY-DE (Application Component) Germany
     ⤷ PC01 (Package) HR Payroll: Germany

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PA0699	Table Relationship Diagram
Short Description	Personnel Master Record Infotype 0699

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	*
2	.INCLUDE	☑				0	0	Key for HR Master Data
3	PERNR	☑	PERSNO	PERSNO	NUMC	8	0	Personnel number	PA0003
4	SUBTY	☑	SUBTY	SUBTY	CHAR	4	0	Subtype
5	OBJPS	☑	OBJPS	OBJPS	CHAR	2	0	Object Identification
6	SPRPS	☑	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
7	ENDDA	☑	ENDDA	DATUM	DATS	8	0	End Date
8	BEGDA	☑	BEGDA	DATUM	DATS	8	0	Start Date
9	SEQNR	☑	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
10	.INCLUDE	☐				0	0	HR Master Record: Control Field
11	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
12	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
13	HISTO	☐	HISTO	CHAR1	CHAR	1	0	Historical Record Flag
14	ITXEX	☐	ITXEX	XFELD	CHAR	1	0	Text Exists for Infotype
15	REFEX	☐	PRFEX	XFELD	CHAR	1	0	Reference Fields Exist (Primary/Secondary Costs)
16	ORDEX	☐	ORDEX	XFELD	CHAR	1	0	Confirmation Fields Exist
17	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
18	PREAS	☐	PREAS	PREAS	CHAR	2	0	Reason for Changing Master Data	T530E
19	FLAG1	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
20	FLAG2	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
21	FLAG3	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
22	FLAG4	☐	NUSED	NUSED	CHAR	1	0	Reserved Field/Unused Field
23	RESE1	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
24	RESE2	☐	NUSED2	NUSED2	CHAR	2	0	Reserved Field/Unused Field of Length 2
25	GRPVL	☐	PCCE_GPVAL	PCCE_GPVAL	CHAR	4	0	Grouping Value for Personnel Assignments
26	.INCLUDE	☐				0	0	Pers. Master Record Infotype 0699 (German Pension Reform D)
27	ANLAR	☐	P01_ANLAR	P01_ANLAR	CHAR	4	0	AVmG: Investment Type	T5DR1
28	AINSL	☐	P01_AINSL	P01_AINSL	CHAR	8	0	AVmG: Key for Investment Institution	T5DRB
29	AINTX	☐	P01_AINTX	TEXT60	CHAR	60	0	AVmG: Text for Investment Institution
30	ANNUM	☐	P01_ANNUM	TEXT20	CHAR	20	0	AVmG: Contract Number
31	ZDATE	☐	DZDATE	DATUM	DATS	8	0	First payment date
32	ZFPER	☐	DZFPER	PABRP	NUMC	2	0	First payment period
33	ZANZL	☐	DZANZL	DEC3	DEC	3	0	Number for determining further payment dates
34	ZEINZ	☐	DZEINZ	RPMSH	CHAR	3	0	Time unit for determining next payment	T538A
35	EMFTX	☐	EMFTX	TEXT40	CHAR	40	0	Payee Text
36	BANKS	☐	BANKS	LAND1	CHAR	3	0	Bank country key	T005
37	BANKL	☐	BANKK	BANKK	CHAR	15	0	Bank Keys
38	BANKN	☐	BANKN	BANKN	CHAR	18	0	Bank account number
39	BKPLZ	☐	BKPLZ	PSTLZ	CHAR	10	0	Postal Code
40	BKORT	☐	ORT01	TEXT25	CHAR	25	0	City
41	ZLSCH	☐	PCODE	ZLSCH	CHAR	1	0	Payment Method	T042Z
42	ZWECK	☐	DZWECK	TEXT40	CHAR	40	0	Purpose of Bank Transfers
43	VTMOD	☐	P01_VTMOD	P01_VTMOD	CHAR	4	0	AVmG: Contract Model	T5DR3
44	BST01	☐	P01_BAUST	P01_BAUST	CHAR	4	0	AVmG: Module	T5DR2
45	BEI01	☐	P01_BEITG	P01_BEITG	CURR	9	2	AVmG: Contribution
46	ZBT01	☐	P01_ZBTRG	P01_BEITG	CURR	9	2	AVmG: Additional Amount Field
47	ANT01	☐	P01_ANTEI	DEC5_2	DEC	7	2	AVmG: Share
48	ERG01	☐	P01_BSERG	XFELD	CHAR	1	0	AVmG: Module of Contract Model
49	SOR01	☐	P01_SOREG	CHAR2	CHAR	2	0	AVmG: Special Rule
50	EVN01	☐	P01_ERGVN	CHAR2	CHAR	2	0	AVmG: Supplementary Contract Number BVV
51	BKL01	☐	P01_BTRKL	CHAR2	CHAR	2	0	AVmG: BVV Contribution Scale
52	ANB01	☐	P01_ANBTR	P01_BEITG	CURR	9	2	AVmG: Eligible Contribution EE BVV
53	BST02	☐	P01_BAUST	P01_BAUST	CHAR	4	0	AVmG: Module	T5DR2
54	BEI02	☐	P01_BEITG	P01_BEITG	CURR	9	2	AVmG: Contribution
55	ZBT02	☐	P01_ZBTRG	P01_BEITG	CURR	9	2	AVmG: Additional Amount Field
56	ANT02	☐	P01_ANTEI	DEC5_2	DEC	7	2	AVmG: Share
57	ERG02	☐	P01_BSERG	XFELD	CHAR	1	0	AVmG: Module of Contract Model
58	SOR02	☐	P01_SOREG	CHAR2	CHAR	2	0	AVmG: Special Rule
59	EVN02	☐	P01_ERGVN	CHAR2	CHAR	2	0	AVmG: Supplementary Contract Number BVV
60	BKL02	☐	P01_BTRKL	CHAR2	CHAR	2	0	AVmG: BVV Contribution Scale
61	ANB02	☐	P01_ANBTR	P01_BEITG	CURR	9	2	AVmG: Eligible Contribution EE BVV
62	BST03	☐	P01_BAUST	P01_BAUST	CHAR	4	0	AVmG: Module	T5DR2
63	BEI03	☐	P01_BEITG	P01_BEITG	CURR	9	2	AVmG: Contribution
64	ZBT03	☐	P01_ZBTRG	P01_BEITG	CURR	9	2	AVmG: Additional Amount Field
65	ANT03	☐	P01_ANTEI	DEC5_2	DEC	7	2	AVmG: Share
66	ERG03	☐	P01_BSERG	XFELD	CHAR	1	0	AVmG: Module of Contract Model
67	SOR03	☐	P01_SOREG	CHAR2	CHAR	2	0	AVmG: Special Rule
68	EVN03	☐	P01_ERGVN	CHAR2	CHAR	2	0	AVmG: Supplementary Contract Number BVV
69	BKL03	☐	P01_BTRKL	CHAR2	CHAR	2	0	AVmG: BVV Contribution Scale
70	ANB03	☐	P01_ANBTR	P01_BEITG	CURR	9	2	AVmG: Eligible Contribution EE BVV
71	BST04	☐	P01_BAUST	P01_BAUST	CHAR	4	0	AVmG: Module	T5DR2
72	BEI04	☐	P01_BEITG	P01_BEITG	CURR	9	2	AVmG: Contribution
73	ZBT04	☐	P01_ZBTRG	P01_BEITG	CURR	9	2	AVmG: Additional Amount Field
74	ANT04	☐	P01_ANTEI	DEC5_2	DEC	7	2	AVmG: Share
75	ERG04	☐	P01_BSERG	XFELD	CHAR	1	0	AVmG: Module of Contract Model
76	SOR04	☐	P01_SOREG	CHAR2	CHAR	2	0	AVmG: Special Rule
77	EVN04	☐	P01_ERGVN	CHAR2	CHAR	2	0	AVmG: Supplementary Contract Number BVV
78	BKL04	☐	P01_BTRKL	CHAR2	CHAR	2	0	AVmG: BVV Contribution Scale
79	ANB04	☐	P01_ANBTR	P01_BEITG	CURR	9	2	AVmG: Eligible Contribution EE BVV
80	BST05	☐	P01_BAUST	P01_BAUST	CHAR	4	0	AVmG: Module	T5DR2
81	BEI05	☐	P01_BEITG	P01_BEITG	CURR	9	2	AVmG: Contribution
82	ZBT05	☐	P01_ZBTRG	P01_BEITG	CURR	9	2	AVmG: Additional Amount Field
83	ANT05	☐	P01_ANTEI	DEC5_2	DEC	7	2	AVmG: Share
84	ERG05	☐	P01_BSERG	XFELD	CHAR	1	0	AVmG: Module of Contract Model
85	SOR05	☐	P01_SOREG	CHAR2	CHAR	2	0	AVmG: Special Rule
86	EVN05	☐	P01_ERGVN	CHAR2	CHAR	2	0	AVmG: Supplementary Contract Number BVV
87	BKL05	☐	P01_BTRKL	CHAR2	CHAR	2	0	AVmG: BVV Contribution Scale
88	ANB05	☐	P01_ANBTR	P01_BEITG	CURR	9	2	AVmG: Eligible Contribution EE BVV
89	BST06	☐	P01_BAUST	P01_BAUST	CHAR	4	0	AVmG: Module	T5DR2
90	BEI06	☐	P01_BEITG	P01_BEITG	CURR	9	2	AVmG: Contribution
91	ZBT06	☐	P01_ZBTRG	P01_BEITG	CURR	9	2	AVmG: Additional Amount Field
92	ANT06	☐	P01_ANTEI	DEC5_2	DEC	7	2	AVmG: Share
93	ERG06	☐	P01_BSERG	XFELD	CHAR	1	0	AVmG: Module of Contract Model
94	SOR06	☐	P01_SOREG	CHAR2	CHAR	2	0	AVmG: Special Rule
95	EVN06	☐	P01_ERGVN	CHAR2	CHAR	2	0	AVmG: Supplementary Contract Number BVV
96	BKL06	☐	P01_BTRKL	CHAR2	CHAR	2	0	AVmG: BVV Contribution Scale
97	ANB06	☐	P01_ANBTR	P01_BEITG	CURR	9	2	AVmG: Eligible Contribution EE BVV
98	BST07	☐	P01_BAUST	P01_BAUST	CHAR	4	0	AVmG: Module	T5DR2
99	BEI07	☐	P01_BEITG	P01_BEITG	CURR	9	2	AVmG: Contribution
100	ZBT07	☐	P01_ZBTRG	P01_BEITG	CURR	9	2	AVmG: Additional Amount Field
101	ANT07	☐	P01_ANTEI	DEC5_2	DEC	7	2	AVmG: Share
102	ERG07	☐	P01_BSERG	XFELD	CHAR	1	0	AVmG: Module of Contract Model
103	SOR07	☐	P01_SOREG	CHAR2	CHAR	2	0	AVmG: Special Rule
104	EVN07	☐	P01_ERGVN	CHAR2	CHAR	2	0	AVmG: Supplementary Contract Number BVV
105	BKL07	☐	P01_BTRKL	CHAR2	CHAR	2	0	AVmG: BVV Contribution Scale
106	ANB07	☐	P01_ANBTR	P01_BEITG	CURR	9	2	AVmG: Eligible Contribution EE BVV
107	BST08	☐	P01_BAUST	P01_BAUST	CHAR	4	0	AVmG: Module	T5DR2
108	BEI08	☐	P01_BEITG	P01_BEITG	CURR	9	2	AVmG: Contribution
109	ZBT08	☐	P01_ZBTRG	P01_BEITG	CURR	9	2	AVmG: Additional Amount Field
110	ANT08	☐	P01_ANTEI	DEC5_2	DEC	7	2	AVmG: Share
111	ERG08	☐	P01_BSERG	XFELD	CHAR	1	0	AVmG: Module of Contract Model
112	SOR08	☐	P01_SOREG	CHAR2	CHAR	2	0	AVmG: Special Rule
113	EVN08	☐	P01_ERGVN	CHAR2	CHAR	2	0	AVmG: Supplementary Contract Number BVV
114	BKL08	☐	P01_BTRKL	CHAR2	CHAR	2	0	AVmG: BVV Contribution Scale
115	ANB08	☐	P01_ANBTR	P01_BEITG	CURR	9	2	AVmG: Eligible Contribution EE BVV
116	BST09	☐	P01_BAUST	P01_BAUST	CHAR	4	0	AVmG: Module	T5DR2
117	BEI09	☐	P01_BEITG	P01_BEITG	CURR	9	2	AVmG: Contribution
118	ZBT09	☐	P01_ZBTRG	P01_BEITG	CURR	9	2	AVmG: Additional Amount Field
119	ANT09	☐	P01_ANTEI	DEC5_2	DEC	7	2	AVmG: Share
120	ERG09	☐	P01_BSERG	XFELD	CHAR	1	0	AVmG: Module of Contract Model
121	SOR09	☐	P01_SOREG	CHAR2	CHAR	2	0	AVmG: Special Rule
122	EVN09	☐	P01_ERGVN	CHAR2	CHAR	2	0	AVmG: Supplementary Contract Number BVV
123	BKL09	☐	P01_BTRKL	CHAR2	CHAR	2	0	AVmG: BVV Contribution Scale
124	ANB09	☐	P01_ANBTR	P01_BEITG	CURR	9	2	AVmG: Eligible Contribution EE BVV
125	BST10	☐	P01_BAUST	P01_BAUST	CHAR	4	0	AVmG: Module	T5DR2
126	BEI10	☐	P01_BEITG	P01_BEITG	CURR	9	2	AVmG: Contribution
127	ZBT10	☐	P01_ZBTRG	P01_BEITG	CURR	9	2	AVmG: Additional Amount Field
128	ANT10	☐	P01_ANTEI	DEC5_2	DEC	7	2	AVmG: Share
129	ERG10	☐	P01_BSERG	XFELD	CHAR	1	0	AVmG: Module of Contract Model
130	SOR10	☐	P01_SOREG	CHAR2	CHAR	2	0	AVmG: Special Rule
131	EVN10	☐	P01_ERGVN	CHAR2	CHAR	2	0	AVmG: Supplementary Contract Number BVV
132	BKL10	☐	P01_BTRKL	CHAR2	CHAR	2	0	AVmG: BVV Contribution Scale
133	ANB10	☐	P01_ANBTR	P01_BEITG	CURR	9	2	AVmG: Eligible Contribution EE BVV
134	PRITY	☐	P01_PRITY	P01_PRITY	CHAR	1	0	AVmG: Priority for Contracts
135	ANNU2	☐	P01_ANNU2	TEXT15	CHAR	15	0	AVmG: Contract Number
136	ZVMAH	☐	P01P_ZVMAH	XFELD	CHAR	1	0	SP PS: Surviving Dependents' Entitlement Exclusion
137	ZVMAE	☐	P01P_ZVMAE	XFELD	CHAR	1	0	SP PS: Red. Earning Cap. Pension Entit. Exclusion
138	ZVMVV	☐	P01P_ZVMVV	XFELD	CHAR	1	0	SP PS: Voluntary and Transferable Previous Insurance
139	AVNPF	☐	P01_AVNPF	XFELD	CHAR	1	0	Pension Cannot Be Seized Section 851c
140	IBAN	☐	IBAN	IBAN	CHAR	34	0	IBAN (International Bank Account Number)
141	NTREL	☐	P01_VA_NTREL	XFELD	CHAR	1	0	Not Relevant for Split
142	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PA0699	AINSL	T5DRB	AINSL	REF	1	CN
2	PA0699	ANLAR	T5DR1	ANLAR	REF	1	CN
3	PA0699	BANKS	T005	LAND1	REF	1	CN
4	PA0699	BST01	T5DR2	BAUST	KEY	1	CN
5	PA0699	BST02	T5DR2	BAUST	KEY	1	CN
6	PA0699	BST03	T5DR2	BAUST	KEY	1	CN
7	PA0699	BST04	T5DR2	BAUST	REF	1	CN
8	PA0699	BST05	T5DR2	BAUST	REF	1	CN
9	PA0699	BST06	T5DR2	BAUST	REF	1	CN
10	PA0699	BST07	T5DR2	BAUST	REF	1	CN
11	PA0699	BST08	T5DR2	BAUST	REF	1	CN
12	PA0699	BST09	T5DR2	BAUST	REF	1	CN
13	PA0699	BST10	T5DR2	BAUST	REF	1	CN
14	PA0699	PERNR	PA0003	PERNR
15	PA0699	PREAS	T530E	PREAS
16	PA0699	VTMOD	T5DR3	VTMOD	REF	1	CN
17	PA0699	ZEINZ	T538A	ZEINH	REF
18	PA0699	ZLSCH	T042Z	ZLSCH	REF	C	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	470