Which table we can get the information about on which date a particular User status has been set in a maintenance order? We get that information in Order Log, but I want to know in which table that information is stored.
Table JEST gives the system /user status associated with an order, but it doesnot give any information about on which date a given status was set. I tried search infomation in table CDHDR/CDPOS but no success.
I found out the related table. Its JCDS.
I believe that’s user status of Equipment, not Maintenance order.
He is correct. JCDS is the change document or version history
of JEST which is the primary status table.
Statuses are handled separately from the object in question since each
object can have multiple statuses and since statuses can be applicable
to more than one object type. That means that the status tables contain
statuses for many different objects like equipment, work orders, functional
locations, sales orders, etc.
The status tables are based on object numbers which are a concatenation
of the object type and the table of that object. Order #816025 would
be stored as "OR000000816025". Equipment 20701817 would be stored
as "IE000000000020701817". Sales order item 10 of 5215 would be stored
as "VB0000005215000010".
Here are some key status tables:
JEST - Object Status
JCDS - Change Documents for Statuses
JSTO - Status Object Information
JCDO - Change Documents for Status Objects
TJ02 - System Statuses
TJ03 - Object Types
TJ04 - Status Control for Object Type
TJ20 - Status Profiles
TJ30 - User Statuses
Just to add in your valuable info on table...
TJ02T - Text for system status
TJ30T - Text for user status.
Many "check" tables (like TJ02 and TJ03) also have text tables as you've
mentioned. You can easily find a text table for another table by
going to "goto --> Text table" (not to mention that they're usually suffixed
with a "T" anyway).
SAP Tips by: Tim
Fast Links:
Have a SAP PM Problems?
Do you have
a SAP PM Question?
SAP Books
SAP Functional,
Basis Administration and ABAP Programming Reference Books
SAP PM
SAP PM Tips and Plant Maintenance
Discussion Forum
Best regards,
SAP Basis, ABAP Programming and Other IMG Stuff
http://www.sap-img.com
All the site contents are Copyright © www.sap-img.com
and the content authors. All rights reserved.
All product names are trademarks of their respective
companies. The site www.sap-img.com is in no way affiliated with
SAP AG.
Every effort is made to ensure the content integrity.
Information used on this site is at your own risk.
The content on this site may not be reproduced
or redistributed without the express written permission of
www.sap-img.com or the content authors.