SAP ABAP Table P0617 (HR Master Record for 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	INTTAB	Structure
Structure	P0617	Table Relationship Diagram
Short Description	HR Master Record for Infotype 0617

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

Foreign Keys

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

History

Last changed by/on	SAP	20130529
SAP Release Created in