SAP table PIQDBAGR_ASSIGNM (Appraisal: Appraised Object)

SAP table PIQDBAGR_ASSIGNM 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 T000 MANDT
AGRID Appraisal ID CHAR 32 0 PIQDBAGR_APPR PIQAGRID
AGRPLVAR Plan Version CHAR 2 0 T778P PLVAR
AGROTYPE Object Type CHAR 2 0 T778O OTYPE
AGRREALO Extended Object ID CHAR 45 0 REALO
INFTY Infotype CHAR 4 0 T777D INFOTYP
RSIGN Relationship Specification CHAR 1 0 RSIGN
A bottom up
B top down
RELAT Relationship Between Objects CHAR 3 0 T778V RELAT
ISTAT Planning Status CHAR 1 0 T778S ISTAT_D
PRIOX Priority CHAR 2 0 PRIOX
BEGDA Start Date DATS 8 0 BEGDATUM
ENDDA End Date DATS 8 0 ENDDATUM
VARYF Variation Field for File PLOG CHAR 10 0 VARYF
SEQNR Number of Infotype Record With Same Key NUMC 3 0 SEQNR
SCLAS Type of Related Object CHAR 2 0 T778O SCLAS
SOBID ID of Related Object CHAR 45 0 SOBID
MODREG_ID Module Booking Identification CHAR 32 0 PIQMODREG_ID
AUDR_ID Audit ID CHAR 32 0 PIQAUDR_ID

PIQDBAGR_ASSIGNM foreign key relationships

Table Field Check Table Check Field
0 PIQDBAGR_ASSIGNM AGRID PIQDBAGR_APPR Appraisal MANDT
0 PIQDBAGR_ASSIGNM AGRID PIQDBAGR_APPR Appraisal AGRID
1 PIQDBAGR_ASSIGNM AGROTYPE T778O Object Types MANDT
1 PIQDBAGR_ASSIGNM AGROTYPE T778O Object Types OTYPE
0 PIQDBAGR_ASSIGNM AGRPLVAR T778P Plan Versions MANDT
1 PIQDBAGR_ASSIGNM INFTY T777D Infotypes - Dialog/Database Assignment INFTY
0 PIQDBAGR_ASSIGNM ISTAT T778S Planning Status MANDT
1 PIQDBAGR_ASSIGNM MANDT T000 Clients MANDT
0 PIQDBAGR_ASSIGNM RELAT T778V Relationships MANDT
1 PIQDBAGR_ASSIGNM SCLAS T778O Object Types MANDT
1 PIQDBAGR_ASSIGNM SCLAS T778O Object Types OTYPE