Skip to Content
Author's profile photo Shanthi Bhaskar

Filling Setup table for processing multiple orders

It is very common that we will doing the setup table fill up when ever there is major go live or enhancement happens. And there would lot of scenarios where we will be asked to extract  selective Orders/documents.

 

But SAP Statistical setup screen doesn’t support for processing multiple sales orders/documents.

There were work around techniques mentioned below.

  • Processing the Sales documents one by one, If we have big list then it would be very laborious process.
  • Processing as a large range which will fit given multiple documents. This way we will end up processing more records.
  • Creating the Z program by copying the existing SAP program so that it would accept multiple single values, This requires additional development and need to expert ABAP skills.

 

Recently I found out a simple technique which would be very useful for processing multiple documents.

 

T-code:  OLI7BW for Sales Orders.

Enter 10 and 8 in the Sales Document ranges as shown below.

/wp-content/uploads/2016/03/setup_1_908021.png

 

Execute

 

/wp-content/uploads/2016/03/setup_2_908022.png

Press OK and takes us to next screen shown below.

 

/wp-content/uploads/2016/03/setup_3_908023.png

 

This screen shows selection option on the right hand side, Now we can go ahead remove 10 and 8 and click on the Select options for entering the multiple documents as shown below.

 

/wp-content/uploads/2016/03/setup_4_908033.png

Enter list of documents to process and say execute.

 

 

Hope this document would be helpful.

 

Thanks,,

Bhaskar Shanthi.

Assigned tags

      9 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Hi,

      Thanks for Sharing...

      Regards,

      Nikhil

      Author's profile photo Yash Parikh
      Yash Parikh

      Hi Shanthi,

      This is very useful Document. Please let me know if its tried and tested in Production. 😆

      Regards,

      Yash Parikh

      Author's profile photo Shanthi Bhaskar
      Shanthi Bhaskar
      Blog Post Author

      Yeah Yash it's been tested in Production.

      Author's profile photo Former Member
      Former Member

      Hi Shanthi,

      This is very useful Document. Thanks for sharing.

      Author's profile photo Pankaj Purohit
      Pankaj Purohit

      Hi Bhaskar,

      tried this on OLI3BW (02 Application) didnt worked at all. Didnt get any Pop and tried it both in Dialog execution as well as Background execution. May be it only works ok OLI7BW didnt tried there. could you please try this on OLI3BW.

      Thanks,

      Pankaj

      Author's profile photo Former Member
      Former Member

      Hi Bhaskar,

      Good, to note this technique.

      Thanks,

      Srinu

      Author's profile photo Vipin A
      Vipin A

      Hi Bhaskar,

      Nice and useful technique 🙂

      Thanks,

      Vipin

      Author's profile photo Dominik Kacprzak
      Dominik Kacprzak

      ABAP Programming Error

      SAPSQL_STMNT_TOO_LARGE

      CX_SY_OPEN_SQL_DB

      nice trick 🙂

      Author's profile photo Saurabh Dubey
      Saurabh Dubey

      Nice technique