SAP ABAP Table Q0490 (HR-PS-SG: Repeat Structure for Employee Suggestion Scheme)

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	Q0490	Table Relationship Diagram
Short Description	HR-PS-SG: Repeat Structure for Employee Suggestion Scheme

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	CRTCD	☐	P25_CRTCD	P25_CRTCD	CHAR	4	0	Evaluation Criteria for Staff Suggestion	T5RPBS1R
2	CRTXT	☐	P25_CRTXT	TEXT30	CHAR	30	0	Description of evaluation criteria
3	PTAWD	☐	P25_PTAWD	DEC3_2	DEC	5	2	Point awarded by evaluator
4	MEMBR	☐	P25_MEMBR	PERSNO	NUMC	8	0	Employee ID of group member	PA0003
5	CNAME	☐	PAD_CNAME	TEXT80	CHAR	80	0	Complete Name
6	LINDR	☐	P25_LINDR	CHECKBOX	CHAR	1	0	Leader Indicator used in Staff Suggestion Scheme
7	WEIGH	☐	P25_WEIGH	DEC3_2	DEC	5	2	Weighting of evaluation criteria
8	NETPT	☐	P25_PTAWD	DEC3_2	DEC	5	2	Point awarded by evaluator
9	EVALG	☐	P25_EVALG	P25_EVALG	NUMC	4	0	Evaluator Identification	*
10	ENAME	☐	PAD_CNAME	TEXT80	CHAR	80	0	Complete Name
11	TOTNT	☐	P25_TOTNT	DEC4_2	DEC	6	2	Total Net Points For Staff Suggestion
12	ESSRK	☐	P25_ESSRK	P25_ESSRK	CHAR	2	0	Ranking for Staff Suggestion	T5RPBS1X
13	SINGL	☐	P25_SINGP	CHAR1_X	CHAR	1	0	Single Suggestion Indicator
14	SGROP	☐	P25_SGROP	CHAR1_X	CHAR	1	0	Group Suggestion Indicator
15	AVGPT	☐	P25_AVGPT	DEC4_2	DEC	6	2	Average Points
16	ESSTA	☐	P25_ESSTA	P25_ESSTA	CHAR	4	0	Evaluator's Status in Staff Suggestion Scheme	*
17	EVAID	☐	P25_EVAID	PERSNO	NUMC	8	0	Evaluator Personal Number	PA0003
18	ESSTD	☐	P25_ESSTD	TEXT30	CHAR	30	0	Description of Evaluator's Status in SSS
19	ESSRT	☐	P25_ESSRT	TEXT30	CHAR	30	0	Ranking text for staff suggestion

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	Q0490	CRTCD	T5RPBS1R	CRTCD	KEY	1	CN
2	Q0490	ESSRK	T5RPBS1X	ESSRK	KEY	1	CN
3	Q0490	EVAID	PA0003	PERNR	KEY	1	CN
4	Q0490	MEMBR	PA0003	PERNR		1	CN

History

Last changed by/on	SAP	19991201
SAP Release Created in