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
Possible values
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