SAP table PIQDBAGR_GEN (DB Table for Appraisals)

SAP table PIQDBAGR_GEN has 2 primary key fields being MANDT,AGRID.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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