SAP ABAP Table PA0020 (HR Master Record Infotype 0020 (DUEVO))

Hierarchy

☛ SAP_HRCDE (Software Component) Sub component SAP_HRCDE of SAP_HR
   ⤷ PA-PA-DE (Application Component) Germany
     ⤷ PB01 (Package) HR Master Data: Germany

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PA0020	Table Relationship Diagram
Short Description	HR Master Record Infotype 0020 (DUEVO)

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	T000
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	HR Master Record: Infotype 0020 (DEUEV)
27	DUETA	☐	DUETA	P014_DUETA	CHAR	3	0	DEUEV Occupational Code	T5D4A
28	STBRF	☐	STBRF	STBRF	CHAR	1	0	DEUEV Occupational Status
29	AUSBG	☐	AUSBG	AUSBG	CHAR	1	0	DEUEV Education/Training
30	MFBTG	☐	MFBTG	XFELD	CHAR	1	0	DEUEV Indicator for Concurrent Employment
31	REANT	☐	REANT	REANT	CHAR	2	0	DEUEV Key for Pensioners/Applicants	T5D4C
32	DUVSP	☐	DUVSP	XFELD	CHAR	1	0	DEUEV Lock
33	EGSVN	☐	EGSVN	CHAR16	CHAR	16	0	Social Insurance Number within EU
34	TTKKN	☐	TTKKN	P014_TTKKN	CHAR	5	0	Miners' DUEVO Activity	T5D4G
35	BESKN	☐	BESKN	P014_BESKN	CHAR	1	0	DUEVO Special Key: Miners' and Mine Employees' Insurance	T5D4K
36	DUVST	☐	DUVST	DUVST	CHAR	1	0	DEUEV Start
37	WLGRD	☐	WLGRD	P014_WLGRD	CHAR	1	0	DEUEV Reason for Change - Miners	T5D4L
38	BPRAE	☐	P014_BPRAE	P014_BPRAE	CHAR	2	0	Miner's Bonus
39	GRBWR	☐	P014_GRBWR	XFELD	CHAR	1	0	Indicator: Mine Rescue Brigade
40	KZMAN	☐	P014_KZMAN	XFELD	CHAR	1	0	Flag: Lock Automatic Calculation
41	NBPBR	☐	P014_NBPBR	XFELD	CHAR	1	0	Not Authorised for Payment of Miners' Premiums
42	PRBEG	☐	P014_PRBEG	DATUM	DATS	8	0	DEUEV Start of Production
43	SONMD	☐	P014_SONMD	XFELD	CHAR	1	0	DEUEV Special Registration
44	KONMD	☐	P014_KONMD	XFELD	CHAR	1	0	DEUEV: Indicator: Pension Similar to Civil Service
45	PGRD3	☐	D3PERSGR	D3PERSGR	NUMC	3	0	DEUEV: Person Group Key	T5D4P
46	KZSTA	☐	P01_KZSTA	P01_KZSTA	CHAR	1	0	DEUEV: Indicator: Status Determination Procedure
47	TTSCH	☐	P01_D3_TTSCH	P01_D3_TTSCH	CHAR	5	0	DEUEV Current Position	T5D4ATS
48	TTBRF	☐	P01_D3_TTBRF	P01_D3_TTBRF	CHAR	3	0	DEUEV Occupation Key	T5D4ATS_BRF
49	ABSCH	☐	P01_D3_ABSCH	P01_D3_ABSCH	CHAR	1	0	DEUEV Education
50	ABBRF	☐	P01_D3_ABBRF	P01_D3_ABBRF	CHAR	1	0	DEUEV Vocational Training
51	ANUEB	☐	P01_D3_ANUEB	P01_D3_ANUEB	CHAR	1	0	DEUEV Leasing of Temporary Personnel
52	VTFRM	☐	P01_D3_VTFRM	P01_D3_VTFRM	CHAR	1	0	DEUEV Contract Form
53	MMDAG	☐	P01_D3_MMDAG	P01_D3_MMDAG	CHAR	1	0	SHI Monthly Declaration, EE/ER Declaration
54	MMDKK	☐	P01_D3_MMDKK	P01_D3_MMDKK	CHAR	1	0	SHI Monthly Declaration, HI Fund Declaration
55	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PA0020	BESKN	T5D4K	BESKN
2	PA0020	DUETA	T5D4A	DUETA
3	PA0020	MANDT	T000	MANDT	KEY	1	CN
4	PA0020	PERNR	PA0003	PERNR	KEY	1	CN
5	PA0020	PGRD3	T5D4P	PERSGR
6	PA0020	PREAS	T530E	PREAS	REF	C	CN
7	PA0020	REANT	T5D4C	REANT	REF	C	CN
8	PA0020	TTBRF	T5D4ATS_BRF	TTBRF
9	PA0020	TTKKN	T5D4G	TTKKN
10	PA0020	TTSCH	T5D4ATS	TTSCH
11	PA0020	WLGRD	T5D4L	WLGRD

History

Last changed by/on	SAP	20130529
SAP Release Created in