SAP Table PIQDBAGR_APPR
Appraisal
PIQDBAGR_APPR (Appraisal) 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_APPR to other SAP tables.
Source: PIQDBAGR_APPR (Appraisal)
PIQDBAGR_APPR table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| AGRID | Appraisal ID | PIQAGRID | PIQDBAGR_GEN | CHAR | 32 | 0 | ||||||
| ATTNO | Repetition Attempt Number | PIQAGR_ATTNO | NUMC | 3 | 0 | |||||||
| AGRTYPE | Appraisal Type | PIQAGRTYPE | T7PIQAGR_TYPE | NUMC | 4 | 0 | ||||||
| AGRSTAT | Appraisal Status | PIQAGRSTAT | T7PIQAGRC_STAT | CHAR | 5 | 0 | ||||||
| ARCH_STATUS | Appraisal Archiving Status | PIQAGR_ARCH_STATUS | CHAR | 1 | 0 |
Possible values
|
||||||
| AGRREMARK | Appraisal Remark | PIQAGRREMARK | CHAR | 2 | 0 | |||||||
| AYEAR | Academic Year | PIQPERYR | T7PIQYEAR | NUMC | 4 | 0 | ||||||
| APERIOD | Academic Session | PIQPERID | T7PIQPERIOD | NUMC | 3 | 0 | ||||||
| AGRBEGDA | Start of Appraisal Validity | PIQAGRBEGDA | DATS | 8 | 0 | |||||||
| AGRENDDA | End of Appraisal Validity | PIQAGRENDDA | DATS | 8 | 0 | |||||||
| AGRDATEE | Earliest Appraisal Date | PIQAGRDATEE | DATS | 8 | 0 | |||||||
| AGRDATEL | Latest Appraisal Date | PIQAGRDATEL | DATS | 8 | 0 | |||||||
| AGRWEIGHT | Appraisal Weighting | PIQAGRWEIGHT | DEC | 5 | 2 | |||||||
| UPAGRID | Appraisal ID | PIQAGRID | PIQDBAGR_GEN | CHAR | 32 | 0 | ||||||
| LAST_DAY_ATT | Last Day of Attendance | PIQAGR_LASTATT | DATS | 8 | 0 | |||||||
PIQDBAGR_APPR foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| PIQDBAGR_APPR | AGRID | PIQDBAGR_APPR | MANDT | PIQDBAGR_GEN | DB Table for Appraisals | MANDT |
| PIQDBAGR_APPR | AGRID | PIQDBAGR_APPR | AGRID | PIQDBAGR_GEN | DB Table for Appraisals | AGRID |
| PIQDBAGR_APPR | AGRSTAT | SYST | MANDT | T7PIQAGRC_STAT | Appraisal Statuses | MANDT |
| PIQDBAGR_APPR | AGRSTAT | PIQDBAGR_APPR | AGRSTAT | T7PIQAGRC_STAT | Appraisal Statuses | AGRSTAT |
| PIQDBAGR_APPR | AGRTYPE | SYST | MANDT | T7PIQAGR_TYPE | Appraisal Types | MANDT |
| PIQDBAGR_APPR | AGRTYPE | PIQDBAGR_APPR | AGRTYPE | T7PIQAGR_TYPE | Appraisal Types | AGRTYPE |
| PIQDBAGR_APPR | APERIOD | SYST | MANDT | T7PIQPERIOD | Academic Sessions | MANDT |
| PIQDBAGR_APPR | APERIOD | PIQDBAGR_APPR | APERIOD | T7PIQPERIOD | Academic Sessions | PERID |
| PIQDBAGR_APPR | AYEAR | SYST | MANDT | T7PIQYEAR | Academic Years | MANDT |
| PIQDBAGR_APPR | AYEAR | PIQDBAGR_APPR | AYEAR | T7PIQYEAR | Academic Years | PERYR |
| PIQDBAGR_APPR | MANDT | PIQDBAGR_APPR | MANDT | T000 | Clients | MANDT |
| PIQDBAGR_APPR | UPAGRID | SYST | MANDT | PIQDBAGR_GEN | DB Table for Appraisals | MANDT |
| PIQDBAGR_APPR | UPAGRID | PIQDBAGR_APPR | UPAGRID | PIQDBAGR_GEN | DB Table for Appraisals | AGRID |
