Fetch USER STATUS for multiple sales orders

[Former Member]

Hello,

To get the user status for a sales order there is a standard fm STATUS_TEXT_EDIT.

But this works for 1 sales order per run.

Now, I have an internal table with list of sales orders and I need to get the user status for each sales order. I think using the above mentioned function wont be a good idea as it will hit database for each order number thus increasing the database hit to great extent.

So I wanted to know if there is any alternate way to fetch user statuses in mass.

Thank You,

Ashish Rawat

[Former Member]

Hello,

To get the user status for a sales order there is a standard fm STATUS_TEXT_EDIT.

But this works for 1 sales order per run.

Now, I have an internal table with list of sales orders and I need to get the user status for each sales order. I think using the above mentioned function wont be a good idea as it will hit database for each order number thus increasing the database hit to great extent.

So I wanted to know if there is any alternate way to fetch user statuses in mass.

Thank You,

Ashish Rawat

[gouravkumar64]

Hi,

You can try like this with the help of SELECT query.

Get object number of sales order from VBAK.

Then pass OBJNR to JEST table.

You will get mass user status.

Hope it will help you.

Thanks

Gourav.

[Former Member]

Means I have to achieve the result manually, that is the last resort. I wanted to know if there is any standard FM for the purpose.

[RaymondGiuseppi]

There is a FM : STATUS_READ_MULTI, easily found in same function group that shares same buffer, so you will then execute STATUS_TEXT_EDIT in a loop.

But don't worry too much, if you don't set BYPASS_BUFFER by inadvertency most tables will be buffered, and for most orders only JSTO  and JEST tables will usually be read if you don't use the STATUS_READ_MULTI FM.

Regards,

Raymond

[Former Member]

Hello Raymond,

STATUS_READ_MULTI has output copy of data in table JEST.

What I need is TJ30T-TXT04 against JEST-STAT and JSTO-STSMA i.e the current active user status for the OBJNR in VBAK.

Thank You.

[RaymondGiuseppi]

My suggestion was : "STATUS_READ_MULTI will "bufferize" most data, then call the STATUS_TEXT_EDIT in a loop " (AFAIK there is no FM that merche the functions of those two modules)

Regards,

Raymond

[Former Member]

Thank you Raymond. That is what I wanted to know if there is any FM available for the purpose.

So, I have to fetch the data from TJ30T manually.

Thank You,

Ashish Rawat

[RaymondGiuseppi]

Yes, but only once per Status Profile.

Regards,

Raymond