topic Re: How to display User Status from Sales Order in report in Application Development and Automation Discussions

How to display User Status from Sales Order in report

Former Member — Tue, 05 Apr 2016 03:33:32 GMT

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

Re: How to display User Status from Sales Order in report

Hvshal4u — Tue, 05 Apr 2016 04:20:19 GMT

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

Re: How to display User Status from Sales Order in report

ec1 — Tue, 05 Apr 2016 04:58:59 GMT

Hi Danny,

How are you doing?

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

Stev

Re: How to display User Status from Sales Order in report

Former Member — Tue, 05 Apr 2016 05:18:29 GMT

Hi Stev,

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

Regards,

Danny

Re: How to display User Status from Sales Order in report

Former Member — Tue, 05 Apr 2016 05:21:22 GMT

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

Re: How to display User Status from Sales Order in report

RaymondGiuseppi — Tue, 05 Apr 2016 12:18:24 GMT

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

Regards,
Raymond

Re: How to display User Status from Sales Order in report

Jelena_Perfiljeva — Tue, 05 Apr 2016 22:38:26 GMT

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.