Skip to Content
avatar image
Former Member

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Jan 09, 2015 at 03:51 PM

    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

    Add comment
    10|10000 characters needed characters exceeded