Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

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

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
Not what you were looking for? View more on this topic or Ask a question