Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

How we can send the customer statements using T-code F.27 in Excel format ?

Sushaku
Explorer

‎12-08-2020 11:17 AM

0 Kudos

Currently Customer statements are generated in PDF only using the T.code f.27

My requirement is to send the data in excel format rather than in PDF. Please suggest some BADI or exits if anybody came across a similar requirement.

4 REPLIES 4

abo
Active Contributor

‎12-08-2020 12:07 PM

0 Kudos

I assume the PDF is generated by a print program, you should find out how which one, because that's where you'll have to make changes.

Next, writing an Excel file can be done with abap2xlsx which comes with plenty of examples.

Sushaku
Explorer
In response to abo

‎12-08-2020 12:32 PM

0 Kudos

Hi Andrea,

Thanks for your comment, Yes print program is there for PDF.

Problem is this is a standard code. I want to know is there any BADI that can be used for this.

Regards,

Sushant

abo
Active Contributor
In response to abo

‎12-08-2020 1:37 PM

0 Kudos

Why? In OB96 you can configure a new printing program and then do as you want.

raymond_giuseppi
Active Contributor

‎12-08-2020 2:16 PM

You could look at BTE (process) 00002310 ‘User exit for different transmission media e.g. print, FAX, mail'.

However, I agree with c5e08e0478aa4727abc4482f5be390b2, to fulfil your requirement you will also have to define (*) a customer form report to generate a XLSX file by the available tools.

(*) SPRO: Financial Accounting Global Settings, Correspondence,