Transparent Table for RIWO00

[Former Member]

Hi,

I am working in PM, I need transparent table for RIWO00-STTXT(Structure). In IW22 when I give Notification Number I get the PM Notification Details. In this there is status (F1 Help) which is coming from RIWO00 this table. I need to write the User Exit to get this status value into Extract Structure.

Please give me your valuable inputs which helps to bet the base table for this Structure.

Thanks

Robbie.

[sudhindra_chandrashekar]

Hi,

You can get the system status through table JEST. First go to table QMEL. Get the OBJNR field for the notification number. Then using this OBJNR go to JEST table and you will get the system status.

The system status will start with number "I" and then to get the description use table TJ02T.

Hope this helps,

Sudhi

[Former Member]

Hi Sudhindra,

I am almost 50% is solved with your answer, But in table TJ02T I can see only NOCO which is Notification Closed and I cant see NOPR which is Notification open. Please could you tell me how to get this two values in one table.

Thanks

Robbie.

[sudhindra_chandrashekar]

Hi Robbie,

Does the document have the status NOPR? If yes then the following code might work.

TABLES: QMEL.

DATA: S_ITAB TYPE JEST OCCURS 0 WITH HEADER LINE,

S_TEXT TYPE TJ02T OCCURS 0 WITH HEADER LINE.

SELECT SINGLE * FROM QMEL WHERE QMNUM = (Notification No).

SELECT * FROM JEST INTO TABLE S_ITAB WHERE OBJNR = QMEL-OBJNR.

LOOP AT S_ITAB.

SELECT SINGLE * FROM TJ02T INTO S_TEXT WHERE ISTAT = S_ITAB-ISTAT.

APPEND S_TEXT.

ENDLOOP.

You will get all the entries in the table S_TEXT.

Hope this helps,

Sudhi

The system status should be present at the document level. You can view all the system statuses by clickin on the "i" icon in the transaction next to status.

Message was edited by:

Sudhindra Chandrashekar

[Former Member]

Hi Sudhi

I got it wht you mean, Iam working on this code and I let you know if I still have any issues. Thanks for you help.

Thanks

Robbie.

[Former Member]

Hi Sudhindra Chandrashekar ,

We got great results, thanks very much and I assigned points. Please can you give me your personnel email ID.

Thanks

Robbie.

[sudhindra_chandrashekar]

Thanks for the points. My email address is in my profile.

All the best,

Sudhi