SAP ABAP Table HCMT_BSP_PA_SP_R0487 (Infotype 0487 (Security / Medical Clearance))

Hierarchy

☛ EA-HRCSG (Software Component) Sub component EA-HRCSG of EA-HR
   ⤷ PY-SG-PS (Application Component) Public Sector
     ⤷ PAOC_PAD_UI_SG_PS (Package) User Interface for Personnel Administration - Singapore

Basic Data

Table Category	INTTAB	Structure
Structure	HCMT_BSP_PA_SP_R0487	Table Relationship Diagram
Short Description	Infotype 0487 (Security / Medical Clearance)

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	OBJECT_KEY	☐	HCM_OBJECT_KEY		CHAR	100	0	HCM Object Key
2	.INCLUDE	☐				0	0	Header Fields of an Infotype Version
3	.INCLUDE	☐				0	0	Header Fields of an Infotype Version
4	PERNR	☐	PERNR_D	PERNR	NUMC	8	0	Personnel Number
5	AEDTM	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
6	UNAME	☐	AENAM	USNAM	CHAR	12	0	Name of Person Who Changed Object
7	SPRPS	☐	SPRPS	SPRPS	CHAR	1	0	Lock Indicator for HR Master Data Record
8	SPRTX	☐	SPRPSTEXT	SPRPSTEXT	CHAR	40	0	Lock indicator for HR master record (text)
9	ITBLD	☐	ITBLD	CHAR2	CHAR	2	0	Infotype Screen Control
10	BEGDA	☐	PAD_BEGDA	DATUM	DATS	8	0	Valid-From Date
11	ENDDA	☐	PAD_ENDDA	DATUM	DATS	8	0	Valid To Date
12	SCTYP	☐	PSG_SCTYP	SUBTY_591A	CHAR	4	0	Type Of Clearance	T591A
13	STEXT	☐	SBTTX	TEXT40	CHAR	40	0	Name of Subtype
14	SCCAT	☐	PSG_SCCAT	PSG_SCCAT	CHAR	2	0	Level of clearance	T5PBSR1J
15	CATDS	☐	PSG_CATDS	TEXT50	CHAR	50	0	Description Of Category
16	SCSTA	☐	PSG_SCSTA	PSG_SCSTA	CHAR	2	0	Status Of Clearance	T5PBSR1K
17	CLRDS	☐	PSG_CLRDS	TEXT50	CHAR	50	0	Description Of Status Of Clearance
18	REFNO	☐	PSG_REFNO	CHAR20	CHAR	20	0	MINDEF Reference Number
19	TEXT1	☐	ITXTZ	TEXT72	CHAR	72	0	Excerpt from infotype text module
20	TEXT2	☐	ITXTZ	TEXT72	CHAR	72	0	Excerpt from infotype text module
21	TEXT3	☐	ITXTZ	TEXT72	CHAR	72	0	Excerpt from infotype text module
22	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	HCMT_BSP_PA_SP_R0487	SCCAT	T5PBSR1J	SCCAT	KEY	1	CN
2	HCMT_BSP_PA_SP_R0487	SCSTA	T5PBSR1K	SCSTA	KEY	1	CN
3	HCMT_BSP_PA_SP_R0487	SCTYP	T591A	SUBTY	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	100