Generate text file (txt file) and excel file (xls) as a output of F110 and save on desktop

[Former Member]

Hello Experts,

I want your inputs in automatic payment program for following:

1. I am making payment to 2500 employees through tcode F110. F110 is making payment entry. However, it should generate one excel file which will have only four columns:

- Document Number

- Employee code (i.e. SAP Vendor code)

- Bank Account Number (maintained in SAP vendor master)

- Amount

I want to know, how can I achieve the above requirement of excel file. This file should get saved on the path of our network

2.I am making payment to 1000 vendors through tcode F110. F110 is making payment entry. However, it should generate one note pad file (txt file) which will have only 5 columns:

- Document Number

- SAP Vendor code)

- Bank Account Number (maintained in SAP vendor master)

- IFSC Code of vendor's bank (maintained in SAP vendor master)

- Amount

I want to know, how can I achieve the above requirement of txt file. This file should get saved on the path of our network

--

Deepak

[Former Member]

Dear Meena,

Payment list with all the above details is generated when F110 is executed. (F110 > Edit> Payment > Payment List). Also you can get the list from the transaction code S_P99_41000099. The list can be saved in txt format on the desktop or network. Else all the details required by you is also available in table REGUH & REGUP. You can check with the ABAPer to develop a report based on in this two table. However, I don't think we should go with the development, when existing report is available and only to save that is required.

Regards,

Sumti Bhadani

[Former Member]

Hello Sumit,

In this case, we need to do go to report, manual download and save files. My requirement is that, it should automatically generate txt files and excel files.

Please suggest.

[Former Member]

Hello Friends,

Please help.