Table for Status profile

[Former Member]

Hi

we are using two status in a status profile , one is BLKD and second is RLSD 

user have to select one  and same is appear ( BLKD or RLSD) in user status under status tab in sales doc

Now want to know on which table data of "BLKD or RLSD"  will find

Thansk

[ravi_kumar100]

Hi Sandeep,

Kindly check the below link where the technical details of the User status of Sales orders are provided.

At Table JEST:

At Table TJ30T

Regards,

SRK

[sez41]

Sandeep,

Check your status profile's code from BS03 transaction. Here in item level, you can see your statuses BLKD and RLSD. From tabel TJ30T you can see to which status numbers your statuses are assigned to (Check below info for an example).

Now from your question I'm not sure what info is exactly required by you, but the key field here is "ESTAT", which can be imported to status function parameters (i.e. call function 'status_change_extern')

[prashant_sharma21]

Hello Sandeep,

You will not find User status ( BLKD or RLSD) directly in Sales order table.

1. go to VBAK-  

2 take the value from OBJNR and now go to table JEST and put the value there JEST-OBJNR.

3. check the field value in table JEST-STAT

Thanks,

Prashant Sharma