SAP ABAP Table PIQAGR_PART_BUFFER (Part Appraisal Buffer Tables (Student, Module, 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_PART_BUFFER	Table Relationship Diagram
Short Description	Part Appraisal Buffer Tables (Student, Module, 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	.INCLU-BPA	☐				0	0	Buffer Structure for Part Appraisal
2	.INCLU-PRT	☐				0	0	Transfer Structure for Part Appraisal
3	AGRIDPRTBPA	☐	PIQAGRID	SYSUUID_C	CHAR	32	0	Appraisal ID
4	AGRSUBTYPPRTBPA	☐	PIQAGRSUBTYP	PIQAGRSUBTYP	NUMC	4	0	Appraisal Type (Obsolete)	*
5	TERMAGRIDPRTBPA	☐	PIQAGRID	SYSUUID_C	CHAR	32	0	Appraisal ID
6	.INCLUDE	☐				0	0	Grading Information
7	GRADESYMPRTBPA	☐	PIQGRADESYM	PIQGRADESYM	CHAR	10	0	Grade Symbol
8	GRADEPRTBPA	☐	PIQSCALE_NORM_VAL	PIQSCALE_NORM_VAL	DEC	8	2	Std Value for Scale Value
9	GRADESCALEPRTBPA	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
10	AGRNOTRATEDPRTBPA	☐	PIQAGRNOTRATED	PIQAGRNOTRATED	CHAR	1	0	Appraisal Grade Not Relevant
11	AGRDATEPRTBPA	☐	PIQAGRDATE	PIQDATE	DATS	8	0	Appraisal Date
12	AGRCOMPLETEDPRTBPA	☐	PIQAGRCOMPLETED	PIQAGRCOMPLETED	CHAR	1	0	Appraisal Completed
13	NOTEIDPRTBPA	☐	PIQNOTE_GUID	SYSUUID_C	CHAR	32	0	GUID - Unique Note Identifier
14	.INCLU-TXT	☐				0	0	Appraisal (Description)
15	AGRIDTXTBPA	☐	PIQAGRID	SYSUUID_C	CHAR	32	0	Appraisal ID
16	.INCLUDE	☐				0	0	Appraisal (Description)
17	LANGUTXTBPA	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
18	AGRTEXTTXTBPA	☐	PIQAGRTEXT	TEXT50	CHAR	50	0	Appraisal (Description)
19	.INCLU-APS	☐				0	0	Appraiser
20	OTYPEAPSBPA	☐	PIQAGR_APPSER_TYPE	OTYPE	CHAR	2	0	Object Type of the Appraiser	T778O
21	REALOAPSBPA	☐	PIQAGR_APPSER_ID	CHAR45	CHAR	45	0	Identification (ID) of the Appraiser
22	PLVARAPSBPA	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
23	.INCLU-STD	☐				0	0	Student Information for Appraisal
24	STUDENTNUMBERSTD	☐	PIQSTUDENT12	PIQSTUDENT12	CHAR	12	0	Student Number
25	STUDENTNAMESTD	☐	STEXT	TEXT40	CHAR	40	0	Object Name
26	FIRST_NAMESTD	☐	PAD_VORNA	PAD_VORNM	CHAR	40	0	First Name
27	LAST_NAMESTD	☐	PAD_NACHN	PAD_NACHN	CHAR	40	0	Last Name
28	PERSIDNOSTD	☐	PIQ_PRDNI	CHAR20	CHAR	20	0	Identification Number
29	NAME_AT_BIRTHSTD	☐	PAD_NAME2	PAD_NACHN	CHAR	40	0	Name at Birth
30	.INCLUDE	☐				0	0	BAPI Structure for Student: Org. Unit (Text Fields)
31	ASSIGNED_ORGUNITSTD	☐	PIQSTORGUNIT_ASSIGNED	HROBJID	NUMC	8	0	Assigned Organizational Unit of Student	*
32	ASSIGNED_ORGUNIT_TXTSTD	☐	PIQSTORGTX	TEXT40	CHAR	40	0	Name of the Student's Organizational Unit
33	ASSIGNED_ORGUNIT_SHTSTD	☐	PIQSTORGSHT	TEXT12	CHAR	12	0	Organizational Unit of Student (Abbreviation)
34	.INCLUDE	☐				0	0	Program/Study (Short and Long Texts)
35	.INCLUDE	☐				0	0	Program/Study/Student
36	PLVARSTD	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	*
37	ST_OTYPESTD	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
38	ST_OBJIDSTD	☐	PIQST_OBJID	HROBJID	NUMC	8	0	Object ID of Student	*
39	CS_OTYPESTD	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
40	CS_OBJIDSTD	☐	PIQCSOBJID	HROBJID	NUMC	8	0	Object ID of Study Object (CS)	*
41	SC_OTYPESTD	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
42	SC_OBJIDSTD	☐	PIQSCOBJID	HROBJID	NUMC	8	0	Program ID	*
43	BEGDASTD	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
44	ENDDASTD	☐	ENDDATUM	DATUM	DATS	8	0	End Date
45	PRIOXSTD	☐	PIQCSPRIOX	CHAR2	CHAR	2	0	Program Priority (In Period)
46	SC_SHORTSTD	☐	PIQSCSRK	CHAR12	CHAR	12	0	Program of Study
47	SC_STEXTSTD	☐	PIQSCTXT	TEXT40	CHAR	40	0	Program Description
48	.INCLU-ASG	☐				0	0	Appraised Object
49	AGRPLVARASG	☐	PLVAR	PLVAR	CHAR	2	0	Plan Version	T778P
50	AGROTYPEASG	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	T778O
51	AGRREALOASG	☐	REALO	CHAR45	CHAR	45	0	Extended Object ID
52	INFTYASG	☐	INFOTYP	INFOTYP	CHAR	4	0	Infotype	T777D
53	RSIGNASG	☐	RSIGN	RSIGN	CHAR	1	0	Relationship Specification
54	RELATASG	☐	RELAT	RELAT	CHAR	3	0	Relationship Between Objects	T778V
55	ISTATASG	☐	ISTAT_D	ISTAT	CHAR	1	0	Planning Status	T778S
56	PRIOXASG	☐	PRIOX	CHAR2	CHAR	2	0	Priority
57	BEGDAASG	☐	BEGDATUM	DATUM	DATS	8	0	Start Date
58	ENDDAASG	☐	ENDDATUM	DATUM	DATS	8	0	End Date
59	VARYFASG	☐	VARYF	CHAR10	CHAR	10	0	Variation Field for File PLOG
60	SEQNRASG	☐	SEQNR	NUM03	NUMC	3	0	Number of Infotype Record With Same Key
61	SCLASASG	☐	SCLAS	OTYPE	CHAR	2	0	Type of Related Object	T778O
62	SOBIDASG	☐	SOBID	CHAR45	CHAR	45	0	ID of Related Object
63	MODREG_IDASG	☐	PIQMODREG_ID	SYSUUID_C	CHAR	32	0	Module Booking Identification
64	.INCLU-506	☐				0	0	Additional Data for Relationship 506
65	SMSTATUS506	☐	PIQSMSTATUS	PIQSMSTATUS	NUMC	2	0	Module Booking Status	T7PIQSMSTAT
66	STORREASON506	☐	PIQSTORREASON	PIQSTORREASON	CHAR	4	0	Cancellation Reason	T7PIQWITHDRAWN
67	STORDATE506	☐	PIQSTORDATE	PIQSTORDATE	DATS	8	0	Cancellation Date
68	CPATTEMP506	☐	PIQCPATTEMP	PIQCP	QUAN	10	5	Attempted Credits
69	CPGAINED506	☐	PIQCPGAINED	PIQCP	QUAN	10	5	Earned Credits
70	CPUNIT506	☐	PIQCPUNIT	MEINS	UNIT	3	0	Unit of Measurement for Credits	T006
71	NORM_VAL506	☐	PIQSCALE_NORM_VAL	PIQSCALE_NORM_VAL	DEC	8	2	Std Value for Scale Value
72	BOOKDATE506	☐	PIQDATE	DATUM	DATS	8	0	Booking Date
73	BOOKTIME506	☐	PIQWAITL_TIME	TIME	TIMS	6	0	Booking Time
74	SMRATING506	☐	PIQSMRATING	PIQSMRATING	CHAR	3	0	Alternative Assessment Method for Module	T7PIQSMRATING
75	CHARGEFREE506	☐	PIQCHARGE	PIQCHARGE	CHAR	1	0	Free of Charge
76	TRANSFERFLAG506	☐	PIQTRANSFER	PIQTRANSFER	CHAR	1	0	External Academic Work or Qualification Transferred
77	PACKNUMBER506	☐	PIQSLNUM	HROBJID	NUMC	8	0	Event Package	*
78	VARID506	☐	PIQVARID	PIQVARID	CHAR	2	0	Session Variant	T7PIQVARY
79	PERID506	☐	PIQPERID	PIQPERID	NUMC	3	0	Academic Session	T7PIQPERIOD
80	PERYR506	☐	PIQPERYR	PIQPERYR	NUMC	4	0	Academic Year	T7PIQYEAR
81	ALT_SCALEID506	☐	PIQSCALE_ID	PIQSCALE_ID	CHAR	4	0	Academic Scale Identification (ID)	T7PIQSCALE
82	ID506	☐	PIQMODREG_ID	SYSUUID_C	CHAR	32	0	Module Booking Identification
83	BOOKREASON506	☐	PIQBOOKREASON	PIQBOOKREASON	CHAR	4	0	Module Booking Reason	T7PIQBOOKREASON
84	ANNULMENT506	☐	PIQMODREG_ANNULMENT	PIQMODREG_ANNULMENT	CHAR	1	0	Exclusion Indicator for Module Bookings	T7PIQ_MR_ANNUL
85	LOCKFLAG506	☐	PIQAWLOCKFLAG	FLAG	CHAR	1	0	Change Lock
86	COBOK506	☐	PIQPEPE_COBOK	PIQPEPE_COBOK	CHAR	1	0	Conditional Booking
87	.INCLUDE	☐				0	0
88	GRADINGSCALET	☐	PIQSCALE_TEXT	PIQSCALE_TEXT	CHAR	30	0	Academic Scale (Description)
89	TERMSUBTYP	☐	PIQAGRSUBTYP	PIQAGRSUBTYP	NUMC	4	0	Appraisal Type (Obsolete)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PIQAGR_PART_BUFFER	AGROTYPEASG	T778O	OTYPE	REF	1	CN
2	PIQAGR_PART_BUFFER	AGRPLVARASG	T778P	PLVAR	REF	1	CN
3	PIQAGR_PART_BUFFER	ALT_SCALEID506	T7PIQSCALE	SCALEID
4	PIQAGR_PART_BUFFER	ANNULMENT506	T7PIQ_MR_ANNUL	ANNULMENT
5	PIQAGR_PART_BUFFER	BOOKREASON506	T7PIQBOOKREASON	BOOKREASON
6	PIQAGR_PART_BUFFER	CPUNIT506	T006	MSEHI
7	PIQAGR_PART_BUFFER	GRADESCALEPRTBPA	T7PIQSCALE	SCALEID	REF	1	CN
8	PIQAGR_PART_BUFFER	INFTYASG	T777D	INFTY	REF	1	CN
9	PIQAGR_PART_BUFFER	ISTATASG	T778S	ISTAT	REF	1	CN
10	PIQAGR_PART_BUFFER	LANGUTXTBPA	T002	SPRAS		1	CN
11	PIQAGR_PART_BUFFER	OTYPEAPSBPA	T778O	OTYPE	REF	1	CN
12	PIQAGR_PART_BUFFER	PERID506	T7PIQPERIOD	PERID		1	CN
13	PIQAGR_PART_BUFFER	PERYR506	T7PIQYEAR	PERYR	KEY	1	CN
14	PIQAGR_PART_BUFFER	PLVARAPSBPA	T778P	PLVAR	REF	1	CN
15	PIQAGR_PART_BUFFER	RELATASG	T778V	RELAT	REF	1	CN
16	PIQAGR_PART_BUFFER	SCLASASG	T778O	OTYPE
17	PIQAGR_PART_BUFFER	SMRATING506	T7PIQSMRATING	SMRATING
18	PIQAGR_PART_BUFFER	SMSTATUS506	T7PIQSMSTAT	SMSTATUS
19	PIQAGR_PART_BUFFER	STORREASON506	T7PIQWITHDRAWN	STORREASON
20	PIQAGR_PART_BUFFER	VARID506	T7PIQVARY	VARID	KEY	1	CN

History

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