SAP Table
TQ80O Object info parameters
SAP table TQ80O has 2 primary key fields being MANDT,INFO_WIND.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
TQ80O columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||
| KeyINFO_WIND | Parameter ID Object Info | CHAR | 10 | 0 | I_INFOWIND | ||||||||||
| BEZUG | Reference Object Info | CHAR | 1 | 0 | I_BEZUG | ||||||||||
|
|||||||||||||||
| CONTRACT | Display if Contract Exists | CHAR | 1 | 0 | I_CONTRACT | ||||||||||
| CLASS | Display Characteristics if Corresponding Class Data | CHAR | 1 | 0 | I_CLASS | ||||||||||
| SMOFN | No.of recorded notifications | DEC | 9 | 0 | SMOFN | ||||||||||
| SMMAB | No. of completed notifications | DEC | 9 | 0 | SMMAB | ||||||||||
| SABTG | No. processing days creation to completion | DEC | 9 | 0 | SABTG | ||||||||||
| SGMSAUS | Number of machine breakdowns reported | DEC | 9 | 0 | SGMSAUS | ||||||||||
| IAOFN | PMIS: number of maintenance orders created | DEC | 9 | 0 | IAOFN | ||||||||||
| IAABG | PMIS: number of completed maintenance orders | DEC | 9 | 0 | IAABG | ||||||||||
| PMIS_DAYS | No. of Days in the Past for PMIS Selection | NUMC | 4 | 0 | I_PMIS_DAY | ||||||||||
| NOT_ANZ_OF | Display Object Information if Outstanding Notifs Exist | CHAR | 1 | 0 | I_ANZ_OFN | ||||||||||
| NOT_ANZ_AB | Display Object Information if Completed Notifications Exist | CHAR | 1 | 0 | I_ANZ_AB | ||||||||||
| NOT_SEL_AB | Select Completed Notifications | CHAR | 1 | 0 | I_SEL_AB | ||||||||||
| NOT_DAYS | Selection Days - For Notifications | NUMC | 4 | 0 | I_NOT_DAYS | ||||||||||
| KLART | View Indicator | CHAR | 1 | 0 | * | I_KLART_EQ | |||||||||
| KLART_TP | Display indicator for view | CHAR | 1 | 0 | * | I_KLART_TP | |||||||||
| AUTOMATIC | Display Object Info Automatically | CHAR | 1 | 0 | I_INFO_AUT | ||||||||||