Skip to Content
avatar image
Former Member

How to display User Status from Sales Order in report

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

Capture12.PNG (32.1 kB)
Capture13.PNG (34.1 kB)
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • Apr 05, 2016 at 12:18 PM

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


    Regards,
    Raymond

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 05, 2016 at 04:20 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Apr 05, 2016 at 04:58 AM

    Hi Danny,

    How are you doing?

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

    User and System Statuses in Sales Orders

    Stev

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 05, 2016 at 10:38 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded