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

Selecting the correct User Status from TJ30T

I am retrieving User Status values for Work Order Notifications (see thread http://scn.sap.com/thread/3166139) but there are several status values returned for the supplied OBJNR. These are fairly self-evident but I have a couple of questions:

1) Is there a way of ordering the response, e.g through the option string, from RFC_READ_TABLE so that the latest status is always first (or do I have to order it within MII after retrieving the information)?

2) What filter criteria (apart from date and time) do I need to apply to get the correct latest status of the notification. E.g there are 2 entries for the last change I made on the attached example, to change the notification to approved (STAT = E0004, UDATE = 20120511, CHGNR = 3 and 4). One is a few seconds after the other and has the INACT flag set - can I ignore this one?

Fields showing in the example are:

MANDT - Client

OBJNR - Object Number

STAT - Object status

CHGNR - Change Number

USNAM - username

UDATE - Date

UTIME - Time

TCODE - Transaction

CDTCODE - transaction in which change made (IW22 in this case)

INACT - Indicates Status is inactive (but what does that mean?)

CHIND - Change indicator ( I assume I = Insert and U = Update)

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jun 04, 2012 at 11:06 AM

    Hi Richard,

    did you tried the function STATUS_READ to read the status? With this function you get every status only once.

    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.