SAP ABAP Table P0486 (HR-SG-PS: Master Data (National Service))

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	INTTAB	Structure
Structure	P0486	Table Relationship Diagram
Short Description	HR-SG-PS: Master Data (National Service)

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-SG-PS: Master Data (National Service)
28	NSTYP	☐	PSG_NSTYP	SUBTY_591A	CHAR	4	0	Type of National Service	T591A
29	NSUNT	☐	PSG_NSUNT	PSG_NSUNT	CHAR	5	0	Unit	T5PBSR1A
30	STATS	☐	PSG_STATS	PSG_STATS	CHAR	2	0	Status Of National Service	T5PBSR1B
31	NSDUY	☐	PSG_NSDUR	DEC3	DEC	3	0	Duration Of Full-Time National Service
32	NSUNY	☐	PSG_NSUNY	RPMSH	CHAR	3	0	Unit for duration of full time NS	T538A
33	NSDUM	☐	PSG_NSDUR	DEC3	DEC	3	0	Duration Of Full-Time National Service
34	NSUNM	☐	PSG_NSUNY	RPMSH	CHAR	3	0	Unit for duration of full time NS	T538A
35	ORDRK	☐	PSG_RANKC	PSG_RANKC	CHAR	3	0	RANK at ORD / Reservist	T5PBSR1C
36	RESRK	☐	PSG_RANKC	PSG_RANKC	CHAR	3	0	RANK at ORD / Reservist	T5PBSR1C
37	ORDVC	☐	PSG_VOCAC	PSG_VOCAC	CHAR	5	0	Vocation at ORD / Reservist	T5PBSR1D
38	RESVC	☐	PSG_VOCAC	PSG_VOCAC	CHAR	5	0	Vocation at ORD / Reservist	T5PBSR1D
39	RODDT	☐	PSG_RODDT	DATS	DATS	8	0	ORD / ROD Date
40	CMDTN	☐	PSG_CMDTN	PSG_CMDTN	CHAR	5	0	Commendation	T5PBSR1E
41	CMDDT	☐	PSG_CMDDT	DATS	DATS	8	0	Commendation Date
42	NSPFR	☐	PSG_NSPFR	PSG_NSPFR	CHAR	2	0	Performance Rating	T5PBSR1F
43	NSCDR	☐	PSG_NSCDR	PSG_NSCDR	CHAR	2	0	Conduct Rating	T5PBSR1G
44	NSMCD	☐	PSG_NSMCD	PSG_NSMCD	CHAR	4	0	Mobilisation Code	T5PBSR1H
45	NSMCS	☐	PSG_NSMCD	PSG_NSMCD	CHAR	4	0	Mobilisation Code	T5PBSR1H
46	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	P0486	CMDTN	T5PBSR1E	CMDTN	KEY	1	CN
2	P0486	INFTY	T582A	INFTY
3	P0486	NSCDR	T5PBSR1G	NSCDR	KEY	1	CN
4	P0486	NSMCD	T5PBSR1H	NSMCD	KEY	1	CN
5	P0486	NSMCS	T5PBSR1H	NSMCD	KEY	1	CN
6	P0486	NSPFR	T5PBSR1F	NSPFR	KEY	1	CN
7	P0486	NSTYP	T591A	SUBTY	KEY	1	CN
8	P0486	NSUNM	T538A	ZEINH	KEY	1	CN
9	P0486	NSUNT	T5PBSR1A	NSUNT	KEY	1	CN
10	P0486	NSUNY	T538A	ZEINH	KEY	1	CN
11	P0486	ORDRK	T5PBSR1C	RANKC	KEY	1	CN
12	P0486	ORDVC	T5PBSR1D	VOCAC	KEY	1	CN
13	P0486	PREAS	T530E	PREAS
14	P0486	RESRK	T5PBSR1C	RANKC	KEY	1	CN
15	P0486	RESVC	T5PBSR1D	VOCAC	KEY	1	CN
16	P0486	STATS	T5PBSR1B	STATS	KEY	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in