Skip to Content
author's profile photo Former Member
Former Member

Db Table for STATUS

Hi,

In IQ09 we will give Status Included and Status Excluded . In what table that status is storing ?

that status belongs to serial number.

Bye,

Satya.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on May 31, 2007 at 08:08 AM

    Hi

    Check table SER01(Document Header for Serial Numbers for Delivery).

    Here OBKNR will be Object list number and LIEF_NR will be the delivery number and POSNR will be the line item of delivery number.

    OBJK is the object table and you will have SERNR as serial number in this table

    Regards,

    Sree

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      I want STATUS OF The serial no. Just like

      ELOK - Locked

      ESTO - In the warehouse.

      when you press F4 in STATUS INCLUDE selection field in the IQ09 T.code you will get this.

      I want where this status will store ?

      Bye,

      Satya.

  • author's profile photo Former Member
    Former Member
    Posted on May 31, 2007 at 08:11 AM

    Hi,

    check the table SER01 . This is for "Document Header for Serial Numbers for Delivery".

    ***do rewards if usefull

    Regards,

    vijay

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi,

      I want STATUS OF The serial no. Just like

      ELOK - Locked

      ESTO - In the warehouse.

      when you press F4 in STATUS INCLUDE selection field in the IQ09 T.code you will get this.

      I want where this status will store ?

      Bye,

      Satya.

  • Posted on May 31, 2007 at 11:29 PM

    Hi Satya,

    The table for ELOK, ESTO status is TJ02T,

    normally you will find the stuses in TJ02 / TJ02T (system status) and TJ30 / TJ30T user status

    Cheers,

    Ganesh

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.