required table for user status in work clerance document in wcm

[Former Member]

Hi experts,

I need table for user status in wcd line item which required to develop report.

kindly help

[former_member200331 · Accepted solution]

peter james,

You will find the User Status profiles in table:                           TJ20T

All User Statuses for Particular Status profile in table:             TJ30T

All User Statuses assigned to particular WCM object in table: JEST

Also to add to my reply, User Status will start with "E0...".

Hope this helps.

Please do reply.

Chin2.

[Former Member · Accepted solution]

hi Chintan,

In JEST Table when i entered object no. it shown following data how can i find which is my desired user status

[former_member200331 · Accepted solution]

peter james

Here as per your screenshot E0003 and E0004 are User Statuses put at present E0004 is active status(As Inactive field I = X means status is inactive).

And as I mentioned in my previous reply, the Text for the same can be founf in table TJ30T (with reference to your Status Profile and Status)

Hope this is clear to you.

Chin2.