Skip to Content
avatar image
Former Member

Cancelled inspection lot (LTCA) field

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,

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    May 06, 2009 at 04:51 AM

    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..........

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 06, 2009 at 03:56 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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,,