SAP - Client would like to know of an alternate transaction (S_ALR_87012086

[Former Member]

Hi all,

-client is attempting to run report looking up Vendors created on specific dates that include the following fields:

Created on, VAT registration no,

Tax info, Vendor number, C

ompany Code, Payment data,

Reconciliation account

-client would also like Vendor name if possible

-needs to Export from SAP to Excel

-report to run every day

Currently, client is running Tcode S_ALR_87012086, would like to know if another transaction will provide the above data and allow exporting of report

Verified extension and location

[Former Member · Accepted solution]

You could copy the program, make the changes, and then schedule it to run every day.

You will need to work with your BASIS team to get the report sent to a local folder, and work on some naming convention so the report does not get overwritten.

[Former Member]

I think you can get the required information from S_ALR_87012086 itself and you can download to excel also. (System - List -Save - Local file)

Assign points if useful.

[Former Member]

Hi,

You can develope the same report as a Query which will solve the problems.

Hope this helps, if yes, please assign points.

Regards,

Harish

[Former Member]

Hi Harish,

Thanks for the reply apologies for unable to catch you solution

Could you provide little bit clear pitcher please

Thanks and Regards,

Kumar