SAP Table P0502
HR-SG-PS:Letter of Appointment details
P0502 (HR-SG-PS:Letter of Appointment details) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link P0502 to other SAP tables.
Source: P0502 (HR-SG-PS:Letter of Appointment details)
P0502 table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| PERNR | Personnel Number | PERNR_D | NUMC | 8 | 0 | |||||||||||
| INFTY | Infotype | INFTY | T582A | CHAR | 4 | 0 | ||||||||||
| SUBTY | Subtype | SUBTY | CHAR | 4 | 0 | |||||||||||
| OBJPS | Object Identification | OBJPS | CHAR | 2 | 0 | |||||||||||
| SPRPS | Lock Indicator for HR Master Data Record | SPRPS | CHAR | 1 | 0 | |||||||||||
| ENDDA | End Date | ENDDA | DATS | 8 | 0 | |||||||||||
| BEGDA | Start Date | BEGDA | DATS | 8 | 0 | |||||||||||
| SEQNR | Number of Infotype Record with Same Key | SEQNR | NUMC | 3 | 0 | |||||||||||
| AEDTM | Changed On | AEDAT | DATS | 8 | 0 | |||||||||||
| UNAME | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 | |||||||||||
| HISTO | Historical Record Flag | HISTO | CHAR | 1 | 0 | |||||||||||
| ITXEX | Text Exists for Infotype | ITXEX | CHAR | 1 | 0 |
Possible values
|
||||||||||
| REFEX | Reference Fields Exist (Primary/Secondary Costs) | PRFEX | CHAR | 1 | 0 |
Possible values
|
||||||||||
| ORDEX | Confirmation Fields Exist | ORDEX | CHAR | 1 | 0 |
Possible values
|
||||||||||
| ITBLD | Infotype Screen Control | ITBLD | CHAR | 2 | 0 | |||||||||||
| PREAS | Reason for Changing Master Data | PREAS | T530E | CHAR | 2 | 0 | ||||||||||
| FLAG1 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||||||
| FLAG2 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||||||
| FLAG3 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||||||
| FLAG4 | Reserved Field/Unused Field | NUSED | CHAR | 1 | 0 | |||||||||||
| RESE1 | Reserved Field/Unused Field of Length 2 | NUSED2 | CHAR | 2 | 0 | |||||||||||
| RESE2 | Reserved Field/Unused Field of Length 2 | NUSED2 | CHAR | 2 | 0 | |||||||||||
| GRPVL | Grouping Value for Personnel Assignments | PCCE_GPVAL | CHAR | 4 | 0 | |||||||||||
| DATIS | Date of Issue of letter of appointment | PSG_DATIS | DATS | 8 | 0 | |||||||||||
| APTYP | Appointment type | PSG_APTYP | T5PBSR4A | CHAR | 2 | 0 | ||||||||||
| APSTS | Appointment status | PSG_APSTS | CHAR | 1 | 0 |
Possible values
|
||||||||||
| OVLDT | Validity date of offer | PSG_OVLDT | DATS | 8 | 0 | |||||||||||
| REFNO | MINDEF Reference Number | PSG_REFNO | CHAR | 20 | 0 | |||||||||||
| DATJO | Date of joining | PSG_DATJO | DATS | 8 | 0 | |||||||||||
| TENOF | Tenure of office | PSG_TENOF | T5PBSR4B | CHAR | 2 | 0 | ||||||||||
| DIVST | Division | PSG_DIVIS | T5PBSR3G | CHAR | 2 | 0 | ||||||||||
| JOBTI | Job | STELL | T513 | NUMC | 8 | 0 | ||||||||||
| SLTYP | Pay scale type | TRFAR | T510A | CHAR | 2 | 0 | ||||||||||
| JOBGR | Pay Scale Area | TRFGB | T510G | CHAR | 2 | 0 | ||||||||||
| JOBGD | Pay grade | P_SLGRP | CHAR | 8 | 0 | |||||||||||
| SLLVL | Pay Grade Level | P_SLLVL | CHAR | 2 | 0 | |||||||||||
| SCODE | Salary Code | PSG_SCODE | T5PBSR6B | CHAR | 5 | 0 | ||||||||||
| BARID | Bar Indicator | PSG_BARID | CHAR | 2 | 0 | |||||||||||
| SLEVL | Pay Scale Level | TRFST | CHAR | 2 | 0 | |||||||||||
| HRSWK | Working time per period | PSG_HRSWK | DEC | 2 | 0 | |||||||||||
| TUNIT | Unit for duration of full time NS | PSG_NSUNY | T538A | CHAR | 3 | 0 | ||||||||||
| AWSFL | AWS flag | PSG_AWSFG | CHAR | 1 | 0 |
Possible values
|
||||||||||
| TRMSV | Terms of service | PSG_TRMSV | CHAR | 40 | 0 | |||||||||||
| RCOST | Amount | BETRG | CURR | 9 | 2 | |||||||||||
| FSIGN | First Name | PAD_VORNA | CHAR | 40 | 0 | |||||||||||
| LSIGN | Last Name | PAD_NACHN | CHAR | 40 | 0 | |||||||||||
| WITN1 | First Name | PAD_VORNA | CHAR | 40 | 0 | |||||||||||
| WITN2 | Last Name | PAD_NACHN | CHAR | 40 | 0 | |||||||||||
| PNUM2 | Identity Number | P25_IDNUM | CHAR | 30 | 0 | |||||||||||
| SCGRP | Grouping for Salary Code and Bar Indicator | PSG_SCGRP | CHAR | 8 | 0 | |||||||||||
| ICTYP | Type of identification (IC type) | ICTYP | T5R05 | CHAR | 2 | 0 | ||||||||||
| ICNUM | Identity Number | P25_IDNUM | CHAR | 30 | 0 | |||||||||||
| PRBZT | Probationary Period (Number) | PRBZT | DEC | 3 | 0 | |||||||||||
| PRUNT | Unit for duration of full time NS | PSG_NSUNY | T538A | CHAR | 3 | 0 | ||||||||||
| PXTNS | Probationary Period (Number) | PRBZT | DEC | 3 | 0 | |||||||||||
| PXUNT | Unit for duration of full time NS | PSG_NSUNY | T538A | CHAR | 3 | 0 | ||||||||||
| BETRG | Amount | BETRG | CURR | 9 | 2 | |||||||||||
| SVINC | HR-PS-SG: Service increment | PSG_SVINC | CHAR | 1 | 0 |
Possible values
|
||||||||||
| VPAYM | HR-PS-SG: Variable Payment | PSG_VPAYM | CHAR | 1 | 0 |
Possible values
|
||||||||||
| ALLWN | Text Field | TEXT50 | CHAR | 50 | 0 | |||||||||||
P0502 foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| P0502 | APTYP | P0502 | APTYP | T5PBSR4A | Appointment type | APTYP |
| P0502 | APTYP | SYST | MANDT | T5PBSR4A | Appointment type | MANDT |
| P0502 | DIVST | P0502 | DIVST | T5PBSR3G | Division | DIVIS |
| P0502 | DIVST | SYST | MANDT | T5PBSR3G | Division | MANDT |
| P0502 | ICTYP | P0502 | ICTYP | T5R05 | Types of Identification | ICTYP |
| P0502 | ICTYP | '25' | T5R05 | Types of Identification | MOLGA | |
| P0502 | ICTYP | SYST | MANDT | T5R05 | Types of Identification | MANDT |
| P0502 | INFTY | P0502 | INFTY | T582A | Infotypes: Customer-Specific Settings | INFTY |
| P0502 | INFTY | SYST | MANDT | T582A | Infotypes: Customer-Specific Settings | MANDT |
| P0502 | JOBGR | P0502 | JOBGR | T510G | Pay Scale Areas | TRFGB |
| P0502 | JOBGR | T001P | MOLGA | T510G | Pay Scale Areas | MOLGA |
| P0502 | JOBGR | SYST | MANDT | T510G | Pay Scale Areas | MANDT |
| P0502 | JOBTI | * | T513 | Jobs | ENDDA | |
| P0502 | JOBTI | P0502 | JOBTI | T513 | Jobs | STELL |
| P0502 | JOBTI | SYST | MANDT | T513 | Jobs | MANDT |
| P0502 | PREAS | P0502 | INFTY | T530E | Reasons for Changes | INFTY |
| P0502 | PREAS | SYST | MADNT | T530E | Reasons for Changes | MANDT |
| P0502 | PREAS | P0502 | PREAS | T530E | Reasons for Changes | PREAS |
| P0502 | PRUNT | SYST | MANDT | T538A | HR Time/Measurement Units | MANDT |
| P0502 | PRUNT | P0502 | PRUNT | T538A | HR Time/Measurement Units | ZEINH |
| P0502 | PXUNT | SYST | MANDT | T538A | HR Time/Measurement Units | MANDT |
| P0502 | PXUNT | P0502 | PXUNT | T538A | HR Time/Measurement Units | ZEINH |
| P0502 | SCODE | SYST | MANDT | T5PBSR6B | Salary Code | MANDT |
| P0502 | SCODE | T500L | MOLGA | T5PBSR6B | Salary Code | MOLGA |
| P0502 | SCODE | P0502 | SCODE | T5PBSR6B | Salary Code | SCODE |
| P0502 | SLTYP | P0502 | SLTYP | T510A | Pay Scale Types | TRFAR |
| P0502 | SLTYP | T001P | MOLGA | T510A | Pay Scale Types | MOLGA |
| P0502 | SLTYP | SYST | MANDT | T510A | Pay Scale Types | MANDT |
| P0502 | TENOF | SYST | MANDT | T5PBSR4B | Tenure of office | MANDT |
| P0502 | TENOF | P0502 | TENOF | T5PBSR4B | Tenure of office | TENOF |
| P0502 | TUNIT | SYST | MANDT | T538A | HR Time/Measurement Units | MANDT |
| P0502 | TUNIT | P0502 | TUNIT | T538A | HR Time/Measurement Units | ZEINH |
