Maintenance Work Center, user status, system s into notification print out.

[former_member226856]

I want to copy Maintenance Work Center(GEWRK), active user status and active system status to notification print out. I am not able to search from which table this field is coming. Can any body tell me the name of table ?

Regards,

VM

Edited by: V M on Oct 5, 2008 4:03 PM

[peter_atkin · Accepted solution]

VM,

Just to confirm a few things:

- You are using TCode IW22 or IW52 when you are performing the print (not IW32)

- Is there a possibility that the order has been changed, but not saved

PeteA

[former_member226856 · Accepted solution]

• I am using IW22.

• Notification user status should be taken after saving it.

Regards,

VM

[peter_atkin · Accepted solution]

Is there a possibility that the order has been changed, but not saved 

[former_member226856 · Accepted solution]

No, there is no such possibility.

VM

[peter_atkin · Accepted solution]

VM,

You can get the system/user status texts via function module STATUS_TEXT_EDIT using VIAUFKS-OBJNR

The work centre key can be obtained from VIAUFKS (probably GEWRK as you state) and the work centre name from CRHD

PeteA

[former_member226856 · Accepted solution]

If there is a notification without order then how can we have work center, system and user status on notification print out.

Regards,

VM

Edited by: V M on Oct 6, 2008 10:58 AM

[peter_atkin · Accepted solution]

VM,

Maybe there's some confusion here..

Do you, or do you not want ORDER information on your NOTIFICATION prin-out?

PeteA

[former_member226856 · Accepted solution]

I want only order number(if any) on the notification print out. rest all data should come from notification itself.

Regards,

VM

[peter_atkin · Accepted solution]

VM,

Got is now..

The work centre name still comes from table CRHD.

You'll need to find a suitable fucntion module to get the status infor from the buffer - try STATUS_READ_MULTI

PeteA

[former_member226856 · Accepted solution]

Hello Pete,

Maintenance Work Center is now coming on notification print. For user ans system status, can you tell me from which table does this 'action log' is generated. As the user status is changed the change will be captured by action log and we will pick it from action log and print to notification.

But it is not clear from which table this status is appearing in the 'actionl log'.

Regards,

VM

[peter_atkin · Accepted solution]

VM,

No it won't be in the action log until you save the notification...

Try the function module specified above.

PeteA

[former_member226856 · Accepted solution]

I have run the function module(STATUS_READ_MULTI ) in SE37. In the import tab there is a parameter ONLY_ACTIVE. In the table tab I found a paramete STATUS. I executed the function by F8, here I reached Test Function Module - Initial Screen. Then I put 'X' for the 'Only active' parameter and RUN this test function. On the result screen there is no entry. How can I utilize this functional module to get active user ans system status.

Regards.

VM

[peter_atkin · Accepted solution]

VM,

It may not work with print programs, but try putting the following code in your ABAP program:

* get notification statuses
data: lt_jest      type standard table of jest. 

    call function 'STATUS_READ_MULTI'
      exporting  
        all_in_buffer  = 'X'
      importing
        status         = lt_jest.

If that fails, then try this:

data: lt_jsto_pre type table of jsto_pre with header line.
data: lt_jest      type standard table of jest. 

  call function 'STATUS_READ_MULTI'
       exporting
            client      = sy-mandt
            only_active = 'X'
       tables
            objnr_tab   = lt_jsto_pre
            status      = lt_jest.

[Former Member]

VM,

Looks like you have the work center figured out and it's just the user status and system status you need.

If you get the object number from table QMEL, you can read all the system and user statuses in table

JEST (don't forget to exclude the inactive statuses) For the status description goto table TJ02.

If you prefer to use the FM approach and want to test using SE37, you will need to limit the selection by the object number for the notification.

Then when you run the FM you will see your status ID's in the report. User statuse are prefixed by E, system statuses by I.

[peter_atkin]

H.SB,

Yes you can do this, but what if someone has changed the notification status in IW22, but not saved the notification yet? In this case the current values will NOT be in the database (i.e. JEST), they'll be in the buffer (ABAP memory).

The first set of code above goes to the buffer to get the information. The second set of code goes to JEST (and others) for the data from the database.

PeteA

[Former Member]

Are you looking for Table AFIH - Order header

System Status : TJ02

User Status : TJ30

K.K

[former_member226856]

Hello,

I want to print active User Status for Notification, not for order.

Regards,

VM

Edited by: V M on Oct 6, 2008 8:49 AM

[Former Member]

U mean only Notification status

k.k