1. Home
  2. Resources
  3. SAP Tables
  4. PIQDBAGR_GEN - DB Table for Appraisals

SAP Table PIQDBAGR_GEN

DB Table for Appraisals

PIQDBAGR_GEN (DB Table for Appraisals) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link PIQDBAGR_GEN to other SAP tables.

Source: PIQDBAGR_GEN (DB Table for Appraisals)

PIQDBAGR_GEN table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
AGRID Appraisal ID PIQAGRID CHAR 32 0
GRADESYM Grade Symbol PIQGRADESYM CHAR 10 0
GRADE Std Value for Scale Value PIQSCALE_NORM_VAL DEC 8 2
GRADESCALE Academic Scale Identification (ID) PIQSCALE_ID T7PIQSCALE CHAR 4 0
AGRNOTRATED Appraisal Grade Not Relevant PIQAGRNOTRATED CHAR 1 0
NULL Grade Relevant
X Grade Not Relevant
AGRDATE Appraisal Date PIQAGRDATE DATS 8 0
AGRCOMPLETED Appraisal Completed PIQAGRCOMPLETED CHAR 1 0
NULL Incomplete
X Complete
NOTEID GUID - Unique Note Identifier PIQNOTE_GUID CHAR 32 0
REGNUM Graduation Number PIQ_NL_GRDNUMBER CHAR 20 0
GRADECHANGED Appraisal Grade Changed PIQAGRCHANGED CHAR 1 0
X Flag set. Event has occurred.
NULL Flag is Not Set

PIQDBAGR_GEN foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
PIQDBAGR_GEN GRADESCALE SYST MANDT T7PIQSCALE Academic Scales MANDT
PIQDBAGR_GEN GRADESCALE PIQDBAGR_GEN GRADESCALE T7PIQSCALE Academic Scales SCALEID