SAP ABAP Table PIQAGR_ELEM (Structure for Grading Grid Elements)

Hierarchy

☛ IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
   ⤷ IS-HER-CM-AD (Application Component) Administration
     ⤷ PMIQ (Package) Campus Management

Basic Data

Table Category	INTTAB	Structure
Structure	PIQAGR_ELEM	Table Relationship Diagram
Short Description	Structure for Grading Grid Elements

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	Transfer Structure for Appraisal Element
2	AGRID	☐	PIQAGRID	SYSUUID_C	CHAR	32	0	Appraisal ID
3	.INCLUDE	☐				0	0	Transfer Structure for Appraisal Element
4	AGRELEID	☐	PIQAGRID	SYSUUID_C	CHAR	32	0	Appraisal ID
5	.INCLUDE	☐				0	0	Appraisal Element
6	ELEM_ID	☐	PIQAGRELEMID	PIQAGRELEMID	CHAR	4	0	Appraisal Element	T7PIQAGR_ELEM
7	AGRRANK	☐	PIQAGRRANK	PIQAGRRANK	NUMC	4	0	Sequence of Appraisal Elements
8	AGRWEIGHT	☐	PIQAGRWEIGHT	PIQAGRWEIGHT	DEC	5	2	Appraisal Weighting
9	.INCLUDE	☐				0	0	Appraisal Element Assignment
10	AGRPLVAR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
11	AGROTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
12	AGRREALO	☐	REALO	CHAR45	CHAR	45	0	Extended Object ID
13	AGRELEAGRID	☐	PIQAGRID	SYSUUID_C	CHAR	32	0	Appraisal ID	PIQDBAGR_GEN
14	.INCLUDE	☐				0	0	Grading Information
15	GRADESYM	☐	PIQGRADESYM	PIQGRADESYM	CHAR	10	0	Grade Symbol
16	GRADE	☐	PIQSCALE_NORM_VAL	PIQSCALE_NORM_VAL	DEC	8	2	Std Value for Scale Value
17	GRADESCALE	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
18	AGRNOTRATED	☐	PIQAGRNOTRATED	PIQAGRNOTRATED	CHAR	1	0	Appraisal Grade Not Relevant
19	AGRDATE	☐	PIQAGRDATE	PIQDATE	DATS	8	0	Appraisal Date
20	AGRCOMPLETED	☐	PIQAGRCOMPLETED	PIQAGRCOMPLETED	CHAR	1	0	Appraisal Completed
21	NOTEID	☐	PIQNOTE_GUID	SYSUUID_C	CHAR	32	0	GUID - Unique Note Identifier
22	.INCLU-TXT	☐				0	0	Appraisal (Description)
23	LANGUTXT	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
24	AGRTEXTTXT	☐	PIQAGRTEXT	TEXT50	CHAR	50	0	Appraisal (Description)
25	GRADESCALES	☐	PIQAGRSCALE	TEXT35	CHAR	35	0	Scale Description

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQAGR_ELEM	AGRELEAGRID	PIQDBAGR_GEN	AGRID	REF	1	CN
2	PIQAGR_ELEM	AGROTYPE	T778O	OTYPE	REF	1	CN
3	PIQAGR_ELEM	AGRPLVAR	T778P	PLVAR	REF	1	CN
4	PIQAGR_ELEM	ELEM_ID	T7PIQAGR_ELEM	ELEM_ID
5	PIQAGR_ELEM	GRADESCALE	T7PIQSCALE	SCALEID	REF	1	CN

History

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