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
⤷ 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
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 464 |