SAP ABAP Table PIQAGR_BUFF_FINAL (Buffer Structure for Final Appraisal)

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_BUFF_FINAL	Table Relationship Diagram
Short Description	Buffer Structure for Final Appraisal

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 Final Appraisal
2	AGRID	☐	PIQAGRID	SYSUUID_C	CHAR	32	0	Appraisal ID
3	.INCLUDE	☐				0	0	Final Appraisal
4	AGRSTAT	☐	PIQAGRSTAT	PIQAGRSTAT	CHAR	5	0	Appraisal Status	*
5	AYEAR	☐	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year	*
6	APERIOD	☐	PIQPERID	PIQPERID	NUMC	3	0	Academic Session	*
7	.INCLUDE	☐				0	0	Appraisal Validity
8	AGRBEGDA	☐	PIQAGRBEGDA	PIQDATE	DATS	8	0	Start of Appraisal Validity
9	AGRENDDA	☐	PIQAGRENDDA	PIQDATE	DATS	8	0	End of Appraisal Validity
10	AGRDATEE	☐	PIQAGRDATEE	PIQDATE	DATS	8	0	Earliest Appraisal Date
11	AGRDATEL	☐	PIQAGRDATEL	PIQDATE	DATS	8	0	Latest Appraisal Date
12	.INCLUDE	☐				0	0	Grading Information
13	GRADESYM	☐	PIQGRADESYM	PIQGRADESYM	CHAR	10	0	Grade Symbol
14	GRADE	☐	PIQSCALE_NORM_VAL	PIQSCALE_NORM_VAL	DEC	8	2	Std Value for Scale Value
15	GRADESCALE	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
16	AGRNOTRATED	☐	PIQAGRNOTRATED	PIQAGRNOTRATED	CHAR	1	0	Appraisal Grade Not Relevant
17	AGRDATE	☐	PIQAGRDATE	PIQDATE	DATS	8	0	Appraisal Date
18	AGRCOMPLETED	☐	PIQAGRCOMPLETED	PIQAGRCOMPLETED	CHAR	1	0	Appraisal Completed
19	NOTEID	☐	PIQNOTE_GUID	SYSUUID_C	CHAR	32	0	GUID - Unique Note Identifier
20	.INCLU-TXT	☐				0	0	Appraisal (Description)
21	AGRIDTXT	☐	PIQAGRID	SYSUUID_C	CHAR	32	0	Appraisal ID
22	.INCLUDE	☐				0	0	Appraisal (Description)
23	LANGUTXT	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
24	AGRTEXTTXT	☐	PIQAGRTEXT	TEXT50	CHAR	50	0	Appraisal (Description)
25	.INCLU-APE	☐				0	0	Appraisee
26	OTYPEAPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
27	REALOAPE	☐	REALO	CHAR45	CHAR	45	0	Extended Object ID
28	PLVARAPE	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
29	.INCLU-ASG	☐				0	0	Appraised Object
30	AGRPLVARASG	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
31	AGROTYPEASG	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
32	AGRREALOASG	☐	REALO	CHAR45	CHAR	45	0	Extended Object ID
33	INFTYASG	☐	INFOTYP	INFOTYP	CHAR	4	0	Infotype	T777D
34	RSIGNASG	☐	RSIGN	RSIGN	CHAR	1	0	Relationship Specification
35	RELATASG	☐	RELAT	RELAT	CHAR	3	0	Relationship Between Objects	T778V
36	ISTATASG	☐	ISTAT_D	ISTAT	CHAR	1	0	Planning Status	T778S
37	PRIOXASG	☐	PRIOX	CHAR2	CHAR	2	0	Priority
38	BEGDAASG	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
39	ENDDAASG	☐	ENDDATUM	DATUM	DATS	8	0	End Date
40	VARYFASG	☐	VARYF	CHAR10	CHAR	10	0	Variation Field for File PLOG
41	SEQNRASG	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
42	SCLASASG	☐	SCLAS	OTYPE	CHAR	2	0	Type of Related Object	T778O
43	SOBIDASG	☐	SOBID	CHAR45	CHAR	45	0	ID of Related Object
44	MODREG_IDASG	☐	PIQMODREG_ID	SYSUUID_C	CHAR	32	0	Module Booking Identification
45	.INCLU-APR	☐				0	0	Appraiser
46	OTYPEAPR	☐	PIQAGR_APPSER_TYPE	OTYPE	CHAR	2	0	Object Type of the Appraiser	T778O
47	REALOAPR	☐	PIQAGR_APPSER_ID	CHAR45	CHAR	45	0	Identification (ID) of the Appraiser
48	PLVARAPR	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
49	.INCLU-FOL	☐				0	0	Appraisal Additional Data
50	CPATTEMPFOL	☐	PIQCPATTEMP	PIQCP	QUAN	10	5	Attempted Credits
51	CPEARNEDFOL	☐	PIQCPEARNED	PIQCP	QUAN	10	5	Earned Credits
52	CPGRADEDFOL	☐	PIQCPGRADED	PIQCP	QUAN	10	5	Graded Credits
53	CPUNITFOL	☐	PIQCPUNIT	MEINS	UNIT	3	0	Unit of Measurement for Credits	*
54	.INCLUDE	☐				0	0
55	.INCLUDE	☐				0	0	Grading Scale Description
56	GRADESCALET	☐	PIQSCALE_TEXT	PIQSCALE_TEXT	CHAR	30	0	Academic Scale (Description)
57	.INCLUDE	☐				0	0	Organizational Unit Name
58	ORGUNIT	☐	PIQAGRORGUNIT	CHAR40	CHAR	40	0	Organizational Unit
59	.INCLUDE	☐				0	0	Program Description
60	STUDY	☐	PIQAGRSTUDEY	CHAR40	CHAR	40	0	Program

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQAGR_BUFF_FINAL	AGROTYPEASG	T778O	OTYPE	REF	1	CN
2	PIQAGR_BUFF_FINAL	AGRPLVARASG	T778P	PLVAR	REF	1	CN
3	PIQAGR_BUFF_FINAL	GRADESCALE	T7PIQSCALE	SCALEID	REF	1	CN
4	PIQAGR_BUFF_FINAL	INFTYASG	T777D	INFTY	REF	1	CN
5	PIQAGR_BUFF_FINAL	ISTATASG	T778S	ISTAT	REF	1	CN
6	PIQAGR_BUFF_FINAL	LANGUTXT	T002	SPRAS		1	CN
7	PIQAGR_BUFF_FINAL	OTYPEAPE	T778O	OTYPE	REF	1	CN
8	PIQAGR_BUFF_FINAL	OTYPEAPR	T778O	OTYPE	REF	1	CN
9	PIQAGR_BUFF_FINAL	PLVARAPE	T778P	PLVAR	REF	1	CN
10	PIQAGR_BUFF_FINAL	PLVARAPR	T778P	PLVAR	REF	1	CN
11	PIQAGR_BUFF_FINAL	RELATASG	T778V	RELAT	REF	1	CN
12	PIQAGR_BUFF_FINAL	SCLASASG	T778O	OTYPE

History

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