Cancelled inspection lot (LTCA) field

[Former Member]

Hi,

I have cancelled an inspection lot.I need the TABLE AND FIELD for status text.

I found the structure is RMQEA and the field STATUSTEXT.But unable to find the table .

Can help on this.

Thank You,

[Former Member · Accepted solution]

Use the following code as per ur requirement. I also had the same problem and i didnt find any table and field for that. But using this BAPI FM we can get the status of the lot......

DATA: STAT LIKE BAPI2045SS OCCURS 0 WITH HEADER LINE,

USTAT LIKE BAPI2045US OCCURS 0 WITH HEADER LINE,

LANG LIKE BAPI2045LA OCCURS 0 WITH HEADER LINE,

LOT TYPE QALS-PRUEFLOS.

SELECT QUERY FOR QALS----

---

LOT = ITAB-PRUEFLOS.

LANG-LANGU = 'E'.

CALL FUNCTION 'BAPI_INSPLOT_GETSTATUS'

EXPORTING

NUMBER = LOT

LANGUAGE = LANG

• IMPORTING

• RETURN =

TABLES

SYSTEM_STATUS = STAT

USER_STATUS = USTAT

.

IF STAT-SY_ST_TEXT = 'LTCA'.

CONTINUE.

ENDIF.

Hope it will solve ur problem..........

[Former Member · Accepted solution]

Thank you very much Mujib....really a excellent replay..I'll award Max points.

[Former Member]

Hi sridhar reddy,

Can You tell in which T-code you have cancelled Inspection lot and you can find the table and field

in SQL trace.

Regards,

Suneel G

[Former Member]

Hi suneel,

when we go to QA03 there is one field System Status .For this I want to find the table and field when use F1 help its showing structure field. but need table and field.

Thank You,,