status field of Maintenance notification

[Former Member]

Hi,Friends

in which table status field of maintenance notification(IW21) can be found because my requirement is when ever data flows from Legacy to R/3 it has to generate Maint notification.if again click on same quary in legacy it has to check R/3 notification status if it in opened status ,R/3 should not allow to create maint notification.

Your response is highly appriciated.

Regards,

Sunil

[Former Member]

Hi,

Status information is found in JEST table. Query JEST table with QMEL-OBJNR. In table JEST, INACTIV field is blank for active status. To match status text fields with status codes check out table TJ02T.

Regards.