-1

I am using SAP GUI for Windows (SAP NetWeaver; 730 Final Release, Version 7300.3.15.1085), SAP ERP, and I need to find a faster way to do part of my routine. I use the form MB51 along with some criteria to find all transactions I need. Then, I select the Quantity in UnE column and hit the sigma (Add Up Values) symbol at the top. This gives me the sum total of all rows at the bottom.

The goal is to simplify this process. I want to be able to add in the material, the plant, the reference, and the document header texts and just return the sum of all rows. I literally only need the final sum and nothing else. Does anyone know of a form in SAP that can help me do this? Or does anyone know of a way to customize MB51 so that I achieve my desired output?

Sandra Rossi
  • 11,934
  • 5
  • 22
  • 48
DarthVoid
  • 604
  • 3
  • 9
  • 21
  • 2
    not sure if you can do this yourself, but often relatively simple requirements like this are solved with SAP queries (transaction SQ01). You will need to know the underlying tables involved in your requirement. If there is a SAP support team available to you I would recommend to contact them about your request. – Dirk Trilsbeek Jul 25 '17 at 18:42
  • 1
    The version number you quote appears to be a GUI version (and an outdated and unsupported one at that) which is mostly irrelevant for this case. Are you sure you're looking for programming solution - do you have the permission to develop anything in the system at all? – vwegert Jul 25 '17 at 18:56

2 Answers2

1

In addition to a Dirk's proposal to use SAP Query, you can consider creating SAP transaction variant and running it in a background mode.

This allows executing a transaction with the specified parameters (including summation) periodically and sending results to email.

It looks like you lack development permissions on the system, so this can be simplest way for acquiring a MB51 sum. Besides permissions, your task also requires knowledge of MB51 tables and their relations.

Suncatcher
  • 10,355
  • 10
  • 52
  • 90
0

Just create a layout variant and create a variant for the selection screen with the layout variant. You can also hide unused fields with the selection variant.

  • Could you help me get started? How would I do this? I looked around on all the button on the results page of MB51 and I couldn't find anything called a layout variant. – DarthVoid Aug 04 '17 at 11:24