SAP ABAP Table PB0502 (Letter of appointment)

Hierarchy

☛ SAP_HRCSG (Software Component) Sub component SAP_HRCSG of SAP_HR
   ⤷ PY-SG-PS (Application Component) Public Sector
     ⤷ P25P1 (Package) Public Sector Singapore

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	PB0502	Table Relationship Diagram
Short Description	Letter of appointment

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 applicant data
3	PERNR	☑	APLNO	APLNO	NUMC	8	0	Applicant number	PB4004
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	PS-SG: Letter of appointment details
27	DATIS	☐	PSG_DATIS	DATS	DATS	8	0	Date of Issue of letter of appointment
28	APTYP	☐	PSG_APTYP	PSG_APTYP	CHAR	2	0	Appointment type	T5PBSR4A
29	APSTS	☐	PSG_APSTS	PSG_APSTS	CHAR	1	0	Appointment status
30	OVLDT	☐	PSG_OVLDT	DATS	DATS	8	0	Validity date of offer
31	REFNO	☐	PSG_REFNO	CHAR20	CHAR	20	0	MINDEF Reference Number
32	DATJO	☐	PSG_DATJO	DATS	DATS	8	0	Date of joining
33	TENOF	☐	PSG_TENOF	PSG_TENOF	CHAR	2	0	Tenure of office	T5PBSR4B
34	DIVST	☐	PSG_DIVIS	PSG_DIVIS	CHAR	2	0	Division	T5PBSR3G
35	JOBTI	☐	STELL	STELL	NUMC	8	0	Job	T513
36	SLTYP	☐	TRFAR	TRFAR	CHAR	2	0	Pay scale type	T510A
37	JOBGR	☐	TRFGB	TRFGB	CHAR	2	0	Pay Scale Area	T510G
38	JOBGD	☐	P_SLGRP	TRFGR	CHAR	8	0	Pay grade	*
39	SLLVL	☐	P_SLLVL	CHAR2	CHAR	2	0	Pay Grade Level
40	SCODE	☐	PSG_SCODE	PSG_SCODE	CHAR	5	0	Salary Code	T5PBSR6B
41	BARID	☐	PSG_BARID	CHAR2	CHAR	2	0	Bar Indicator
42	SLEVL	☐	TRFST	TRFST	CHAR	2	0	Pay Scale Level	*
43	HRSWK	☐	PSG_HRSWK	DEC2	DEC	2	0	Working time per period
44	TUNIT	☐	PSG_NSUNY	RPMSH	CHAR	3	0	Unit for duration of full time NS	T538A
45	AWSFL	☐	PSG_AWSFG	XFELD	CHAR	1	0	AWS flag
46	TRMSV	☐	PSG_TRMSV	CHAR40	CHAR	40	0	Terms of service
47	RCOST	☐	BETRG	WERTV5	CURR	9	2	Amount
48	FSIGN	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
49	LSIGN	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
50	WITN1	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
51	WITN2	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
52	PNUM2	☐	P25_IDNUM	CHAR30	CHAR	30	0	Identity Number
53	SCGRP	☐	PSG_SCGRP	CHAR8	CHAR	8	0	Grouping for Salary Code and Bar Indicator
54	ICTYP	☐	ICTYP	ICTYP	CHAR	2	0	Type of identification (IC type)	T5R05
55	ICNUM	☐	P25_IDNUM	CHAR30	CHAR	30	0	Identity Number
56	PRBZT	☐	PRBZT	DEC3	DEC	3	0	Probationary Period (Number)
57	PRUNT	☐	PSG_NSUNY	RPMSH	CHAR	3	0	Unit for duration of full time NS	T538A
58	PXTNS	☐	PRBZT	DEC3	DEC	3	0	Probationary Period (Number)
59	PXUNT	☐	PSG_NSUNY	RPMSH	CHAR	3	0	Unit for duration of full time NS	T538A
60	BETRG	☐	BETRG	WERTV5	CURR	9	2	Amount
61	SVINC	☐	PSG_SVINC	XFELD	CHAR	1	0	HR-PS-SG: Service increment
62	VPAYM	☐	PSG_VPAYM	XFELD	CHAR	1	0	HR-PS-SG: Variable Payment
63	ALLWN	☐	TEXT50	TEXT50	CHAR	50	0	Text Field
64	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PB0502	APTYP	T5PBSR4A	APTYP	KEY	1	CN
2	PB0502	DIVST	T5PBSR3G	DIVIS	KEY	1	CN
3	PB0502	ICTYP	T5R05	ICTYP
4	PB0502	JOBGR	T510G	TRFGB	KEY	1	CN
5	PB0502	JOBTI	T513	STELL	KEY	1	CN
6	PB0502	PERNR	PB4004	PERNR	KEY	1	CN
7	PB0502	PREAS	T530E	PREAS
8	PB0502	PRUNT	T538A	ZEINH	KEY	1	CN
9	PB0502	PXUNT	T538A	ZEINH	KEY	1	CN
10	PB0502	SCODE	T5PBSR6B	SCODE	KEY	1	CN
11	PB0502	SLTYP	T510A	TRFAR	KEY	1	CN
12	PB0502	TENOF	T5PBSR4B	TENOF	KEY	1	CN
13	PB0502	TUNIT	T538A	ZEINH	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in