How to display User Status from Sales Order in report

[Former Member]

Hi ABAP Experts,

I create a status profile and assign it to Standard Sales Order.  It is captured in the field User Status (NEW DT02) in Text tab (Header Data).

I would be grateful if you can advise solutions how to show it in the report ?

Best regards,

Danny

[Hvshal4u]

Hi can find the user status in JEST and JSTO table. In VBAK u will find the OBJNR filed grab this objnr and pass it to JEST/JSTO table you will the the user status.

You can the table TJ30/TJ30T to get the text.

Regards,

Vishal

[Former Member]

Hi Vishal,

Thank you and I will try your tips.  I go to Technical Information but SAP does not provide the table.  It shows a structure.

Regards,

Danny

[ec1]

Hi Danny,

How are you doing?

I found a blog which can help you out in building your report.

Stev

[Former Member]

Hi Stev,

Thank you for sharing the blog.  I will read it through .

Regards,

Danny

[raymond_giuseppi]

Once you get VBAK-OBJNR, call the FM STATUS_TEXT_EDIT.

Regards,
Raymond

[Jelena]

There is not always a table provided in the technical information. Many times we can use ST05 (SQL trace) to find the table names. The statuses are stored the same way (JEST table & Co) for the sales orders, production orders and a bunch of other documents.

This question has already been asked on SCN before, kindly do some research before posting.