SAP ABAP Table PA0617 (HR Master Record: Infotype 0617)

Hierarchy

☛ SAP_HRCGB (Software Component) Sub component SAP_HRCGB of SAP_HR
   ⤷ PY-GB-PS (Application Component) Öffentlicher Dienst
     ⤷ P08P_HER (Package) HR Public Sector Great Britain (Higher Education)

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PA0617	Table Relationship Diagram
Short Description	HR Master Record: Infotype 0617

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	HR Master data: Clinical Details (GB)
27	NTNUM	☐	P08_CLIN_NTNUM	CHAR13	CHAR	13	0	National training number
28	REGTY	☐	P08_CLIN_REGTY	P08_CLIN_REGTY	CHAR	3	0	Registration type	T5GPBSC_REG
29	REGNO	☐	P08_CLIN_REGNO	CHAR16	CHAR	16	0	Registration number
30	REGDT	☐	P08_CLIN_REGDT	DATUM	DATS	8	0	Expiry date of professional registration
31	SPECL	☐	P08_CLIN_SPECL	P08_CLIN_SPECL	CHAR	3	0	Clinical specialty	T5GPBSC_SPE
32	BASED	☐	P08_CLIN_BASED	P08_CLIN_BASED	CHAR	3	0	Hospital	T5GPBSC_BAS
33	CLACC	☐	P08_CLIN_CLACC	XFELD	CHAR	1	0	Clinical access confirmed
34	TRUST	☐	P08_CLIN_TRUST	P08_CLIN_TRUST	CHAR	3	0	Health Trust	T5GPBSC_TRU
35	NHSPC	☐	P08_CLIN_NHSPC	DEC3_2	DEC	5	2	% time worked for NHS
36	NHSSL	☐	P08_CLIN_NHSSL	DEC3_2	DEC	5	2	% salary from NHS
37	UNISW	☐	P08_CLIN_UNISW	P08_SESSIONS	DEC	3	1	University sessions worked
38	NHSSW	☐	P08_CLIN_NHSSW	P08_SESSIONS	DEC	3	1	NHS sessions worked
39	UNISC	☐	P08_CLIN_UNISC	P08_SESSIONS	DEC	3	1	University sessions charged
40	NHSSC	☐	P08_CLIN_NHSSC	P08_SESSIONS	DEC	3	1	NHS sessions charged
41	APLSB	☐	P08_CLIN_APLSB	XFELD	CHAR	1	0	A+B appointment
42	HONHS	☐	P08_CLIN_HONHS	P08_CLIN_HONHS	CHAR	3	0	Honorary NHS type	T5GPBSC_HON
43	HEINHS	☐	P08P_CLIN_HEINHS	XFELD	CHAR	1	0	HESA: Joint HEI/NHS contract (clinical)
44	CLINICAL	☐	P08P_CLIN_CLINICAL	P08P_HESA_CLINICAL	CHAR	1	0	HESA: Clinical Status
45	CLINARD	☐	P08P_HESA_CLINARD	P08P_HESA_CLINARD	CHAR	2	0	HESA: Clinical excellence award
46	SUBCL1	☐	P08P_HESA_SUBCLIN	P08P_HESA_SUBCLIN	CHAR	4	0	HESA: Clinical sub-specialty
47	SUBCL2	☐	P08P_HESA_SUBCLIN	P08P_HESA_SUBCLIN	CHAR	4	0	HESA: Clinical sub-specialty
48	SUBCL3	☐	P08P_HESA_SUBCLIN	P08P_HESA_SUBCLIN	CHAR	4	0	HESA: Clinical sub-specialty
49	SPECL2	☐	P08_CLIN_SPECL	P08_CLIN_SPECL	CHAR	3	0	Clinical specialty	T5GPBSC_SPE
50	SPECL3	☐	P08_CLIN_SPECL	P08_CLIN_SPECL	CHAR	3	0	Clinical specialty	T5GPBSC_SPE
51	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PA0617	BASED	T5GPBSC_BAS	BASED	KEY
2	PA0617	HONHS	T5GPBSC_HON	HONHS	KEY	1	CN
3	PA0617	PERNR	PA0003	PERNR
4	PA0617	PREAS	T530E	PREAS
5	PA0617	REGTY	T5GPBSC_REG	REGTY	KEY	1	CN
6	PA0617	SPECL	T5GPBSC_SPE	SPECL	KEY
7	PA0617	SPECL2	T5GPBSC_SPE	SPECL
8	PA0617	SPECL3	T5GPBSC_SPE	SPECL
9	PA0617	TRUST	T5GPBSC_TRU	TRUST	KEY

History

Last changed by/on	SAP	20130529
SAP Release Created in