SAP table P0502 (HR-SG-PS:Letter of Appointment details)

Field Description Data Type Length Decimals Checktable Data Element
PERNR Personnel Number NUMC 8 0 PERNR_D
INFTY Infotype CHAR 4 0 T582A INFTY
SUBTY Subtype CHAR 4 0 SUBTY
OBJPS Object Identification CHAR 2 0 OBJPS
SPRPS Lock Indicator for HR Master Data Record CHAR 1 0 SPRPS
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
SEQNR Number of Infotype Record With Same Key NUMC 3 0 SEQNR
AEDTM Last Changed On DATS 8 0 AEDAT
UNAME Name of Person Who Changed Object CHAR 12 0 AENAM
HISTO Historical Record Flag CHAR 1 0 HISTO
ITXEX Text Exists for Infotype CHAR 1 0 ITXEX
REFEX Reference Fields Exist (Primary/Secondary Costs) CHAR 1 0 PRFEX
ORDEX Confirmation Fields Exist CHAR 1 0 ORDEX
ITBLD Infotype Screen Control CHAR 2 0 ITBLD
PREAS Reason for Changing Master Data CHAR 2 0 T530E PREAS
FLAG1 Reserved Field/Unused Field CHAR 1 0 NUSED
FLAG2 Reserved Field/Unused Field CHAR 1 0 NUSED
FLAG3 Reserved Field/Unused Field CHAR 1 0 NUSED
FLAG4 Reserved Field/Unused Field CHAR 1 0 NUSED
RESE1 Reserved Field/Unused Field of Length 2 CHAR 2 0 NUSED2
RESE2 Reserved Field/Unused Field of Length 2 CHAR 2 0 NUSED2
GRPVL Grouping Value for Personnel Assignments CHAR 4 0 PCCE_GPVAL
DATIS Date of Issue of letter of appointment DATS 8 0 PSG_DATIS
APTYP Appointment type CHAR 2 0 T5PBSR4A PSG_APTYP
APSTS Appointment status CHAR 1 0 PSG_APSTS
1 Created
2 Released
3 Accepted
4 Verified
OVLDT Validity date of offer DATS 8 0 PSG_OVLDT
REFNO MINDEF Reference Number CHAR 20 0 PSG_REFNO
DATJO Date of joining DATS 8 0 PSG_DATJO
TENOF Tenure of office CHAR 2 0 T5PBSR4B PSG_TENOF
DIVST Division CHAR 2 0 T5PBSR3G PSG_DIVIS
JOBTI Job NUMC 8 0 T513 STELL
SLTYP Pay scale type CHAR 2 0 T510A TRFAR
JOBGR Pay Scale Area CHAR 2 0 T510G TRFGB
JOBGD Pay grade CHAR 8 0 * P_SLGRP
SLLVL Pay Grade Level CHAR 2 0 P_SLLVL
SCODE Salary Code CHAR 5 0 T5PBSR6B PSG_SCODE
BARID Bar Indicator CHAR 2 0 PSG_BARID
SLEVL Pay Scale Level CHAR 2 0 * TRFST
HRSWK Working time per period DEC 2 0 PSG_HRSWK
TUNIT Unit for duration of full time NS CHAR 3 0 T538A PSG_NSUNY
AWSFL AWS flag CHAR 1 0 PSG_AWSFG
TRMSV Terms of service CHAR 40 0 PSG_TRMSV
RCOST Amount CURR 9 2 BETRG
FSIGN First Name CHAR 40 0 PAD_VORNA
LSIGN Last Name CHAR 40 0 PAD_NACHN
WITN1 First Name CHAR 40 0 PAD_VORNA
WITN2 Last Name CHAR 40 0 PAD_NACHN
PNUM2 Identity Number CHAR 30 0 P25_IDNUM
SCGRP Grouping for Salary Code and Bar Indicator CHAR 8 0 PSG_SCGRP
ICTYP Type of identification (IC type) CHAR 2 0 T5R05 ICTYP
ICNUM Identity Number CHAR 30 0 P25_IDNUM
PRBZT Probationary Period (Number) DEC 3 0 PRBZT
PRUNT Unit for duration of full time NS CHAR 3 0 T538A PSG_NSUNY
PXTNS Probationary Period (Number) DEC 3 0 PRBZT
PXUNT Unit for duration of full time NS CHAR 3 0 T538A PSG_NSUNY
BETRG Amount CURR 9 2 BETRG
SVINC HR-PS-SG: Service increment CHAR 1 0 PSG_SVINC
VPAYM HR-PS-SG: Variable Payment CHAR 1 0 PSG_VPAYM
ALLWN Text Field CHAR 50 0 TEXT50

P0502 foreign key relationships

Table Field Check Table Check Field
0 P0502 APTYP T5PBSR4A Appointment type MANDT
0 P0502 APTYP T5PBSR4A Appointment type APTYP
1 P0502 DIVST T5PBSR3G Division MANDT
1 P0502 DIVST T5PBSR3G Division DIVIS
0 P0502 ICTYP T5R05 Types of Identification MOLGA
0 P0502 ICTYP T5R05 Types of Identification ICTYP
1 P0502 INFTY T582A Infotypes: Customer-Specific Settings MANDT
1 P0502 INFTY T582A Infotypes: Customer-Specific Settings INFTY
0 P0502 JOBGR T510G Pay Scale Areas MANDT
0 P0502 JOBGR T510G Pay Scale Areas MOLGA
0 P0502 JOBGR T510G Pay Scale Areas TRFGB
1 P0502 JOBTI T513 Jobs MANDT
1 P0502 JOBTI T513 Jobs STELL
1 P0502 JOBTI T513 Jobs ENDDA
0 P0502 PREAS T530E Reasons for Changes MANDT
0 P0502 PREAS T530E Reasons for Changes INFTY
0 P0502 PREAS T530E Reasons for Changes PREAS
1 P0502 PRUNT T538A HR Time/Measurement Units MANDT
1 P0502 PRUNT T538A HR Time/Measurement Units ZEINH
0 P0502 PXUNT T538A HR Time/Measurement Units MANDT
0 P0502 PXUNT T538A HR Time/Measurement Units ZEINH
1 P0502 SCODE T5PBSR6B Salary Code MANDT
1 P0502 SCODE T5PBSR6B Salary Code MOLGA
1 P0502 SCODE T5PBSR6B Salary Code SCODE
0 P0502 SLTYP T510A Pay Scale Types MANDT
0 P0502 SLTYP T510A Pay Scale Types MOLGA
0 P0502 SLTYP T510A Pay Scale Types TRFAR
1 P0502 TENOF T5PBSR4B Tenure of office MANDT
1 P0502 TENOF T5PBSR4B Tenure of office TENOF
0 P0502 TUNIT T538A HR Time/Measurement Units MANDT
0 P0502 TUNIT T538A HR Time/Measurement Units ZEINH