SAP ABAP Table PIQAGR_APPRGRID (Display Structure for Appraisal Template (Modules))
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_APPRGRID   Table Relationship Diagram
Short Description Display Structure for Appraisal Template (Modules)    
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-APP       0   0   Appraisal Buffer Table  
2 INDXAPP PIQAGRLFNR INT4 INT4 10   0   Sequence Number  
3 .INCLUDE       0   0   Structure for Calculation Status Display (Appraisal)  
4 ICON_RESULTAPP PIQAGR_ICONRESULT CHAR35 CHAR 35   0   Result Origin (Icon)  
5 VALUE_RESULTAPP PIQAGR_VALUERESULT NUMC1 NUMC 1   0   Result Value  
6 ICON_CALCULATIONAPP PIQAGR_ICON_CALCULATION CHAR35 CHAR 35   0   Degree of Reliability (Icon)  
7 VALUE_CALCULATIONAPP PIQAGR_VALUECALCULATION NUMC1 NUMC 1   0   Calculation Status  
8 ICON_LOCKAPP PIQAGR_ICONLOCK CHAR35 CHAR 35   0   Calculation Lock (Icon)  
9 VALUE_LOCKAPP PIQAGR_LOCK NUMC1 NUMC 1   0   Calculation Lock  
10 .INCLUDE       0   0   Student Information for Appraisal  
11 STUDENTNUMBERAPP PIQSTUDENT12 PIQSTUDENT12 CHAR 12   0   Student Number  
12 STUDENTNAMEAPP STEXT TEXT40 CHAR 40   0   Object Name  
13 FIRST_NAMEAPP PAD_VORNA PAD_VORNM CHAR 40   0   First Name  
14 LAST_NAMEAPP PAD_NACHN PAD_NACHN CHAR 40   0   Last Name  
15 PERSIDNOAPP PIQ_PRDNI CHAR20 CHAR 20   0   Identification Number  
16 NAME_AT_BIRTHAPP PAD_NAME2 PAD_NACHN CHAR 40   0   Name at Birth  
17 .INCLUDE       0   0   BAPI Structure for Student: Org. Unit (Text Fields)  
18 ASSIGNED_ORGUNITAPP PIQSTORGUNIT_ASSIGNED HROBJID NUMC 8   0   Assigned Organizational Unit of Student *
19 ASSIGNED_ORGUNIT_TXTAPP PIQSTORGTX TEXT40 CHAR 40   0   Name of the Student's Organizational Unit  
20 ASSIGNED_ORGUNIT_SHTAPP PIQSTORGSHT TEXT12 CHAR 12   0   Organizational Unit of Student (Abbreviation)  
21 .INCLUDE       0   0   Program/Study (Short and Long Texts)  
22 .INCLUDE       0   0   Program/Study/Student  
23 PLVARAPP PLVAR PLVAR CHAR 2   0   Plan Version *
24 ST_OTYPEAPP OTYPE OTYPE CHAR 2   0   Object Type *
25 ST_OBJIDAPP PIQST_OBJID HROBJID NUMC 8   0   Object ID of Student *
26 CS_OTYPEAPP OTYPE OTYPE CHAR 2   0   Object Type *
27 CS_OBJIDAPP PIQCSOBJID HROBJID NUMC 8   0   Object ID of Study Object (CS) *
28 SC_OTYPEAPP OTYPE OTYPE CHAR 2   0   Object Type *
29 SC_OBJIDAPP PIQSCOBJID HROBJID NUMC 8   0   Program ID *
30 BEGDAAPP BEGDATUM DATUM DATS 8   0   Start Date  
31 ENDDAAPP ENDDATUM DATUM DATS 8   0   End Date  
32 PRIOXAPP PIQCSPRIOX CHAR2 CHAR 2   0   Program Priority (In Period)  
33 SC_SHORTAPP PIQSCSRK CHAR12 CHAR 12   0   Program of Study  
34 SC_STEXTAPP PIQSCTXT TEXT40 CHAR 40   0   Program Description  
35 .INCLUDE       0   0   Appraisal Buffer Structure  
36 .INCLUDE       0   0   Program Description  
37 STUDYAPP PIQAGRSTUDEY CHAR40 CHAR 40   0   Program  
38 .INCLUDE       0   0   Grading Scale Description  
39 GRADESCALETAPP PIQSCALE_TEXT PIQSCALE_TEXT CHAR 30   0   Academic Scale (Description)  
40 .INCLUDE       0   0   Appraisal  
41 AGRIDAPP PIQAGRID SYSUUID_C CHAR 32   0   Appraisal ID  
42 .INCLUDE       0   0   Appraisal: Administration Data  
43 ATTNOAPP PIQAGR_ATTNO NUM03 NUMC 3   0   Repetition Attempt Number  
44 AGRTYPEAPP PIQAGRTYPE PIQAGRTYPE NUMC 4   0   Appraisal Type T7PIQAGR_TYPE
45 AGRSTATAPP PIQAGRSTAT PIQAGRSTAT CHAR 5   0   Appraisal Status T7PIQAGRC_STAT
46 ARCH_STATUSAPP PIQAGR_ARCH_STATUS PIQAGR_ARCH_STATUS CHAR 1   0   Appraisal Archiving Status  
47 AGRREMARKAPP PIQAGRREMARK PIQAGRREMARK CHAR 2   0   Appraisal Remark *
48 AYEARAPP PIQPERYR PIQPERYR NUMC 4   0   Academic Year T7PIQYEAR
49 APERIODAPP PIQPERID PIQPERID NUMC 3   0   Academic Session T7PIQPERIOD
50 .INCLUDE       0   0   Appraisal Validity  
51 AGRBEGDAAPP PIQAGRBEGDA PIQDATE DATS 8   0   Start of Appraisal Validity  
52 AGRENDDAAPP PIQAGRENDDA PIQDATE DATS 8   0   End of Appraisal Validity  
53 AGRDATEEAPP PIQAGRDATEE PIQDATE DATS 8   0   Earliest Appraisal Date  
54 AGRDATELAPP PIQAGRDATEL PIQDATE DATS 8   0   Latest Appraisal Date  
55 .INCLUDE       0   0   Appraisal Relationship Information  
56 AGRWEIGHTAPP PIQAGRWEIGHT PIQAGRWEIGHT DEC 5   2   Appraisal Weighting  
57 UPAGRIDAPP PIQAGRID SYSUUID_C CHAR 32   0   Appraisal ID PIQDBAGR_GEN
58 .INCLUDE       0   0   Grading Information  
59 GRADESYMAPP PIQGRADESYM PIQGRADESYM CHAR 10   0   Grade Symbol  
60 GRADEAPP PIQSCALE_NORM_VAL PIQSCALE_NORM_VAL DEC 8   2   Std Value for Scale Value  
61 GRADESCALEAPP PIQSCALE_ID PIQSCALE_ID CHAR 4   0   Academic Scale Identification (ID) T7PIQSCALE
62 AGRNOTRATEDAPP PIQAGRNOTRATED PIQAGRNOTRATED CHAR 1   0   Appraisal Grade Not Relevant  
63 AGRDATEAPP PIQAGRDATE PIQDATE DATS 8   0   Appraisal Date  
64 AGRCOMPLETEDAPP PIQAGRCOMPLETED PIQAGRCOMPLETED CHAR 1   0   Appraisal Completed  
65 NOTEIDAPP PIQNOTE_GUID SYSUUID_C CHAR 32   0   GUID - Unique Note Identifier  
66 .INCLU-TXT       0   0   Appraisal (Description)  
67 AGRIDTXTAPP PIQAGRID SYSUUID_C CHAR 32   0   Appraisal ID  
68 .INCLUDE       0   0   Appraisal (Description)  
69 LANGUTXTAPP SPRAS SPRAS LANG 1   0   Language Key T002
70 AGRTEXTTXTAPP PIQAGRTEXT TEXT50 CHAR 50   0   Appraisal (Description)  
71 .INCLU-APE       0   0   Appraisee  
72 OTYPEAPEAPP OTYPE OTYPE CHAR 2   0   Object Type T778O
73 REALOAPEAPP REALO CHAR45 CHAR 45   0   Extended Object ID  
74 PLVARAPEAPP PLVAR PLVAR CHAR 2   0   Plan Version T778P
75 .INCLU-ASG       0   0   Appraised Object  
76 AGRPLVARASGAPP PLVAR PLVAR CHAR 2   0   Plan Version T778P
77 AGROTYPEASGAPP OTYPE OTYPE CHAR 2   0   Object Type T778O
78 AGRREALOASGAPP REALO CHAR45 CHAR 45   0   Extended Object ID  
79 INFTYASGAPP INFOTYP INFOTYP CHAR 4   0   Infotype T777D
80 RSIGNASGAPP RSIGN RSIGN CHAR 1   0   Relationship Specification  
81 RELATASGAPP RELAT RELAT CHAR 3   0   Relationship Between Objects T778V
82 ISTATASGAPP ISTAT_D ISTAT CHAR 1   0   Planning Status T778S
83 PRIOXASGAPP PRIOX CHAR2 CHAR 2   0   Priority  
84 BEGDAASGAPP BEGDATUM DATUM DATS 8   0   Start Date  
85 ENDDAASGAPP ENDDATUM DATUM DATS 8   0   End Date  
86 VARYFASGAPP VARYF CHAR10 CHAR 10   0   Variation Field for File PLOG  
87 SEQNRASGAPP SEQNR NUM03 NUMC 3   0   Number of Infotype Record With Same Key  
88 SCLASASGAPP SCLAS OTYPE CHAR 2   0   Type of Related Object T778O
89 SOBIDASGAPP SOBID CHAR45 CHAR 45   0   ID of Related Object  
90 MODREG_IDASGAPP PIQMODREG_ID SYSUUID_C CHAR 32   0   Module Booking Identification  
91 .INCLU-APR       0   0   Appraiser (Functions)  
92 SEQNRAPRAPP PIQAGR_FUNC_SEQNR PIQSEQNR NUMC 3   0   Sequence Number of Function  
93 .INCLUDE       0   0   Appraiser  
94 OTYPEAPRAPP PIQAGR_APPSER_TYPE OTYPE CHAR 2   0   Object Type of the Appraiser T778O
95 REALOAPRAPP PIQAGR_APPSER_ID CHAR45 CHAR 45   0   Identification (ID) of the Appraiser  
96 PLVARAPRAPP PLVAR PLVAR CHAR 2   0   Plan Version T778P
97 FUNCTIONAPRAPP PIQAGR_APPFUNCTION PIQAGR_APPFUNCTION CHAR 4   0   Function Exercised (Abbreviation *
98 .INCLU-FOL       0   0   Appraisal Additional Data  
99 CPATTEMPFOLAPP PIQCPATTEMP PIQCP QUAN 10   5   Attempted Credits  
100 CPEARNEDFOLAPP PIQCPEARNED PIQCP QUAN 10   5   Earned Credits  
101 CPGRADEDFOLAPP PIQCPGRADED PIQCP QUAN 10   5   Graded Credits  
102 CPUNITFOLAPP PIQCPUNIT MEINS UNIT 3   0   Unit of Measurement for Credits *
103 .INCLUDE       0   0    
104 AGRSTATTEXTAPP PIQAGRSTATTEXT TEXT30 CHAR 30   0   Appraisal Status (Description)  
105 AGRREMARKTEXTAPP PIQAGRREMARKTEXT TEXT35 CHAR 35   0   Appraisal Remark (Description)  
106 .INCLUDE       0   0   Additional Data for Relationship 506  
107 SMSTATUSAPP PIQSMSTATUS PIQSMSTATUS NUMC 2   0   Module Booking Status T7PIQSMSTAT
108 STORREASONAPP PIQSTORREASON PIQSTORREASON CHAR 4   0   Cancellation Reason T7PIQWITHDRAWN
109 STORDATEAPP PIQSTORDATE PIQSTORDATE DATS 8   0   Cancellation Date  
110 CPATTEMPAPP PIQCPATTEMP PIQCP QUAN 10   5   Attempted Credits  
111 CPGAINEDAPP PIQCPGAINED PIQCP QUAN 10   5   Earned Credits  
112 CPUNITAPP PIQCPUNIT MEINS UNIT 3   0   Unit of Measurement for Credits T006
113 NORM_VALAPP PIQSCALE_NORM_VAL PIQSCALE_NORM_VAL DEC 8   2   Std Value for Scale Value  
114 BOOKDATEAPP PIQDATE DATUM DATS 8   0   Booking Date  
115 BOOKTIMEAPP PIQWAITL_TIME TIME TIMS 6   0   Booking Time  
116 SMRATINGAPP PIQSMRATING PIQSMRATING CHAR 3   0   Alternative Assessment Method for Module T7PIQSMRATING
117 CHARGEFREEAPP PIQCHARGE PIQCHARGE CHAR 1   0   Free of Charge  
118 TRANSFERFLAGAPP PIQTRANSFER PIQTRANSFER CHAR 1   0   External Academic Work or Qualification Transferred  
119 PACKNUMBERAPP PIQSLNUM HROBJID NUMC 8   0   Event Package *
120 VARIDAPP PIQVARID PIQVARID CHAR 2   0   Session Variant T7PIQVARY
121 PERIDAPP PIQPERID PIQPERID NUMC 3   0   Academic Session T7PIQPERIOD
122 PERYRAPP PIQPERYR PIQPERYR NUMC 4   0   Academic Year T7PIQYEAR
123 ALT_SCALEIDAPP PIQSCALE_ID PIQSCALE_ID CHAR 4   0   Academic Scale Identification (ID) T7PIQSCALE
124 IDAPP PIQMODREG_ID SYSUUID_C CHAR 32   0   Module Booking Identification  
125 BOOKREASONAPP PIQBOOKREASON PIQBOOKREASON CHAR 4   0   Module Booking Reason T7PIQBOOKREASON
126 ANNULMENTAPP PIQMODREG_ANNULMENT PIQMODREG_ANNULMENT CHAR 1   0   Exclusion Indicator for Module Bookings T7PIQ_MR_ANNUL
127 LOCKFLAGAPP PIQAWLOCKFLAG FLAG CHAR 1   0   Change Lock  
128 COBOKAPP PIQPEPE_COBOK PIQPEPE_COBOK CHAR 1   0   Conditional Booking  
129 .INCLUDE       0   0    
130 SMSTATUSTAPP PIQSMSTATUST TEXT25 CHAR 25   0   Module Booking Status (Description)  
131 SMRATINGTAPP PIQSMRATINGT PIQSMRATINGT CHAR 40   0   Alternative Assessment Method for Module (Description)  
132 PUSHNOTESAPP PIQAGRPUSHNOTES CHAR30 CHAR 30   0   Notes  
133 GRADESUMAPP QUAN1 MENG8 QUAN 15   3   Quantity  
134 PIQFLAGAPP PIQAGRFLAG CHAR01 CHAR 1   0   Indicator  
135 SUBTYPTERMAPP PIQAGRSUBTYP PIQAGRSUBTYP NUMC 4   0   Appraisal Type (Obsolete)  
136 LFNRAPP PIQAGRLFNR INT4 INT4 10   0   Sequence Number  
137 REFINDXAPP PIQAGRLFNR INT4 INT4 10   0   Sequence Number  
138 ICONATTNOAPP PIQAGR_ICONATTNO CHAR35 CHAR 35   0   Repetition Attempt (Icon)  
139 ICONCOBOKAPP PIQAGR_ICONCOBOK TEXT35 CHAR 35   0   Conditional Booking (Icon)  
140 GRADETEXTAPP PIQSCALE_GRADETEXT PIQSCALE_GRADETEXT CHAR 20   0   Scale Value (Description)  
141 APPSERTEXTAPP PIQAGR_APPSER_TXT TEXT50 CHAR 50   0   Name of Appraiser  
142 .INCLU-EL1       0   0   Structure for Grading Grid Elements  
143 .INCLUDE       0   0   Transfer Structure for Appraisal Element  
144 AGRIDEL1 PIQAGRID SYSUUID_C CHAR 32   0   Appraisal ID  
145 .INCLUDE       0   0   Transfer Structure for Appraisal Element  
146 AGRELEIDEL1 PIQAGRID SYSUUID_C CHAR 32   0   Appraisal ID  
147 .INCLUDE       0   0   Appraisal Element  
148 ELEM_IDEL1 PIQAGRELEMID PIQAGRELEMID CHAR 4   0   Appraisal Element T7PIQAGR_ELEM
149 AGRRANKEL1 PIQAGRRANK PIQAGRRANK NUMC 4   0   Sequence of Appraisal Elements  
150 AGRWEIGHTEL1 PIQAGRWEIGHT PIQAGRWEIGHT DEC 5   2   Appraisal Weighting  
151 .INCLUDE       0   0   Appraisal Element Assignment  
152 AGRPLVAREL1 PLVAR PLVAR CHAR 2   0   Plan Version T778P
153 AGROTYPEEL1 OTYPE OTYPE CHAR 2   0   Object Type T778O
154 AGRREALOEL1 REALO CHAR45 CHAR 45   0   Extended Object ID  
155 AGRELEAGRIDEL1 PIQAGRID SYSUUID_C CHAR 32   0   Appraisal ID PIQDBAGR_GEN
156 .INCLUDE       0   0   Grading Information  
157 GRADESYMEL1 PIQGRADESYM PIQGRADESYM CHAR 10   0   Grade Symbol  
158 GRADEEL1 PIQSCALE_NORM_VAL PIQSCALE_NORM_VAL DEC 8   2   Std Value for Scale Value  
159 GRADESCALEEL1 PIQSCALE_ID PIQSCALE_ID CHAR 4   0   Academic Scale Identification (ID) T7PIQSCALE
160 AGRNOTRATEDEL1 PIQAGRNOTRATED PIQAGRNOTRATED CHAR 1   0   Appraisal Grade Not Relevant  
161 AGRDATEEL1 PIQAGRDATE PIQDATE DATS 8   0   Appraisal Date  
162 AGRCOMPLETEDEL1 PIQAGRCOMPLETED PIQAGRCOMPLETED CHAR 1   0   Appraisal Completed  
163 NOTEIDEL1 PIQNOTE_GUID SYSUUID_C CHAR 32   0   GUID - Unique Note Identifier  
164 .INCLU-TXT       0   0   Appraisal (Description)  
165 LANGUTXTEL1 SPRAS SPRAS LANG 1   0   Language Key *
166 AGRTEXTTXTEL1 PIQAGRTEXT TEXT50 CHAR 50   0   Appraisal (Description)  
167 GRADESCALESEL1 PIQAGRSCALE TEXT35 CHAR 35   0   Scale Description  
168 IS_PASSED PIQISPASSED CHAR35 CHAR 35   0   Indicator: Passed  
169 ELE_IS_PASSED PIQISPASSED CHAR35 CHAR 35   0   Indicator: Passed  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 PIQAGR_APPRGRID AGRELEAGRIDEL1 PIQDBAGR_GEN AGRID REF 1 CN
2 PIQAGR_APPRGRID AGROTYPEASGAPP T778O OTYPE REF 1 CN
3 PIQAGR_APPRGRID AGROTYPEEL1 T778O OTYPE REF 1 CN
4 PIQAGR_APPRGRID AGRPLVARASGAPP T778P PLVAR REF 1 CN
5 PIQAGR_APPRGRID AGRPLVAREL1 T778P PLVAR REF 1 CN
6 PIQAGR_APPRGRID AGRSTATAPP T7PIQAGRC_STAT AGRSTAT    
7 PIQAGR_APPRGRID AGRTYPEAPP T7PIQAGR_TYPE AGRTYPE    
8 PIQAGR_APPRGRID ALT_SCALEIDAPP T7PIQSCALE SCALEID    
9 PIQAGR_APPRGRID ANNULMENTAPP T7PIQ_MR_ANNUL ANNULMENT    
10 PIQAGR_APPRGRID APERIODAPP T7PIQPERIOD PERID    
11 PIQAGR_APPRGRID AYEARAPP T7PIQYEAR PERYR    
12 PIQAGR_APPRGRID BOOKREASONAPP T7PIQBOOKREASON BOOKREASON    
13 PIQAGR_APPRGRID CPUNITAPP T006 MSEHI    
14 PIQAGR_APPRGRID ELEM_IDEL1 T7PIQAGR_ELEM ELEM_ID    
15 PIQAGR_APPRGRID GRADESCALEAPP T7PIQSCALE SCALEID REF 1 CN
16 PIQAGR_APPRGRID GRADESCALEEL1 T7PIQSCALE SCALEID REF 1 CN
17 PIQAGR_APPRGRID INFTYASGAPP T777D INFTY REF 1 CN
18 PIQAGR_APPRGRID ISTATASGAPP T778S ISTAT REF 1 CN
19 PIQAGR_APPRGRID LANGUTXTAPP T002 SPRAS 1 CN
20 PIQAGR_APPRGRID OTYPEAPEAPP T778O OTYPE REF 1 CN
21 PIQAGR_APPRGRID OTYPEAPRAPP T778O OTYPE REF 1 CN
22 PIQAGR_APPRGRID PERIDAPP T7PIQPERIOD PERID 1 CN
23 PIQAGR_APPRGRID PERYRAPP T7PIQYEAR PERYR KEY 1 CN
24 PIQAGR_APPRGRID PLVARAPEAPP T778P PLVAR REF 1 CN
25 PIQAGR_APPRGRID PLVARAPRAPP T778P PLVAR REF 1 CN
26 PIQAGR_APPRGRID RELATASGAPP T778V RELAT REF 1 CN
27 PIQAGR_APPRGRID SCLASASGAPP T778O OTYPE    
28 PIQAGR_APPRGRID SMRATINGAPP T7PIQSMRATING SMRATING    
29 PIQAGR_APPRGRID SMSTATUSAPP T7PIQSMSTAT SMSTATUS    
30 PIQAGR_APPRGRID STORREASONAPP T7PIQWITHDRAWN STORREASON    
31 PIQAGR_APPRGRID UPAGRIDAPP PIQDBAGR_GEN AGRID    
32 PIQAGR_APPRGRID VARIDAPP T7PIQVARY VARID KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in 464