Skip to Content

How to get totals per vendor in transaction S_P99_41000099

Hi,

We are struggeling with the selections/settings of report S_P99_41000099 (Payment List).

After we have made a proposal in F110, we select this transaction to create the report.

What we would like to have there, is ONLY totals per VENDOR, without address and item detail information.

The information we would like to see is in fact a simple list, something like:

Vendor 1000 Total amount 500

Vendor 1001 Total amount 700

Vendor 1002 Total amount 1000

Total all vendors 2200 (which is the amount of the proposal)

Is it possible in this transaction? We have tried all kind of settings, but we get too many details/lines in every attempt.

Selection screen looks as follows:

Thanks for help!

payment-list.jpg (112.4 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Sep 25, 2017 at 03:29 PM

    Hi,

    Try and play with 'Display variant maintenance', but I'm afraid you cannot do it with this report.

    However, it is really easy to build your own report, looking at REGUP table, which contains the relevant data.

    You can even do it with a query (SQVI or SQ01), if you don't want to program an ABAP report.

    Regards,

    Eli

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 04 at 01:41 PM

    We solved this issued by creating a customized query.

    Add comment
    10|10000 characters needed characters exceeded