In which table the status of a equipement is stored

[Former Member]

Hi,

In which table the status of a equipement is stored?

Thanks in advance

Godadhar

[Former Member · Accepted solution]

Hi,

Is the status that you are looking for the one that tells if the equipment is installed or Available and so on?

If that is the case then:

Take the equipment number, then look in table EQUI for the Objekt number for this equipment, table EQUI with key EQUNR (the field EQUI-OBJNR) .

With the objekt number look at table JEST. This table contains a relationship of an objekt and its Customer Status asigned to it, this table tells you also which status are active.

Once you have the active status you can check table TJ02T to get the description of the status.

JEST-STAT = TJ02T-ISTAT

Hope this helps

Carlos

[Former Member]

Hi,

You will get it in table EGERS field KZSTICH.

Grant me points if it is useful to you.

Regards,

Pranaya