SAP Table PIQDBAGR_ASSIGNM
Appraisal: Appraised Object
PIQDBAGR_ASSIGNM (Appraisal: Appraised Object) 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_ASSIGNM to other SAP tables.
Source: PIQDBAGR_ASSIGNM (Appraisal: Appraised Object)
PIQDBAGR_ASSIGNM table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| AGRID | Appraisal ID | PIQAGRID | PIQDBAGR_APPR | CHAR | 32 | 0 | ||||||
| AGRPLVAR | Plan Version | PLVAR | T778P | CHAR | 2 | 0 | ||||||
| AGROTYPE | Object Type | OTYPE | T778O | CHAR | 2 | 0 | ||||||
| AGRREALO | Extended Object ID | REALO | CHAR | 45 | 0 | |||||||
| INFTY | Infotype | INFOTYP | T777D | CHAR | 4 | 0 | ||||||
| RSIGN | Relationship Specification | RSIGN | CHAR | 1 | 0 |
Possible values
|
||||||
| RELAT | Relationship Between Objects | RELAT | T778V | CHAR | 3 | 0 | ||||||
| ISTAT | Planning Status | ISTAT_D | T778S | CHAR | 1 | 0 | ||||||
| PRIOX | Priority | PRIOX | CHAR | 2 | 0 | |||||||
| BEGDA | Start Date | BEGDATUM | DATS | 8 | 0 | |||||||
| ENDDA | End Date | ENDDATUM | DATS | 8 | 0 | |||||||
| VARYF | Variation Field for File PLOG | VARYF | CHAR | 10 | 0 | |||||||
| SEQNR | Number of Infotype Record with Same Key | SEQNR | NUMC | 3 | 0 | |||||||
| SCLAS | Type of Related Object | SCLAS | T778O | CHAR | 2 | 0 | ||||||
| SOBID | ID of Related Object | SOBID | CHAR | 45 | 0 | |||||||
| MODREG_ID | Module Booking Identification | PIQMODREG_ID | CHAR | 32 | 0 | |||||||
| AUDR_ID | Audit ID | PIQAUDR_ID | CHAR | 32 | 0 | |||||||
PIQDBAGR_ASSIGNM foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| PIQDBAGR_ASSIGNM | AGRID | PIQDBAGR_ASSIGNM | MANDT | PIQDBAGR_APPR | Appraisal | MANDT |
| PIQDBAGR_ASSIGNM | AGRID | PIQDBAGR_ASSIGNM | AGRID | PIQDBAGR_APPR | Appraisal | AGRID |
| PIQDBAGR_ASSIGNM | AGROTYPE | SYST | MANDT | T778O | Object Types | MANDT |
| PIQDBAGR_ASSIGNM | AGROTYPE | PIQDBAGR_ASSIGNM | AGROTYPE | T778O | Object Types | OTYPE |
| PIQDBAGR_ASSIGNM | AGRPLVAR | SYST | MANDT | T778P | Plan Versions | MANDT |
| PIQDBAGR_ASSIGNM | AGRPLVAR | PIQDBAGR_ASSIGNM | AGRPLVAR | T778P | Plan Versions | PLVAR |
| PIQDBAGR_ASSIGNM | INFTY | PIQDBAGR_ASSIGNM | INFTY | T777D | Infotypes - Dialog/Database Assignment | INFTY |
| PIQDBAGR_ASSIGNM | ISTAT | SYST | MANDT | T778S | Planning Status | MANDT |
| PIQDBAGR_ASSIGNM | ISTAT | PIQDBAGR_ASSIGNM | ISTAT | T778S | Planning Status | ISTAT |
| PIQDBAGR_ASSIGNM | MANDT | PIQDBAGR_ASSIGNM | MANDT | T000 | Clients | MANDT |
| PIQDBAGR_ASSIGNM | RELAT | SYST | MANDT | T778V | Relationships | MANDT |
| PIQDBAGR_ASSIGNM | RELAT | PIQDBAGR_ASSIGNM | RELAT | T778V | Relationships | RELAT |
| PIQDBAGR_ASSIGNM | SCLAS | SYST | MANDT | T778O | Object Types | MANDT |
| PIQDBAGR_ASSIGNM | SCLAS | PIQDBAGR_ASSIGNM | SCLAS | T778O | Object Types | OTYPE |
