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