Skip to Content
author's profile photo Yan Ying Ng
0
Yan Ying Ng

Generate customer statement in excel format and email thru SAP

Posted on Jan 05, 2019 at 10:18 AM 657 Views Last edit Jan 05, 2019 at 10:18 AM 2 rev.

Hi,

Would like to ask if there is any T-code that able to generate customer statement in Excel format then directly sent to customer thru SAP.

Is F.27 able to generate statement in both Excel & PDF?

Thanks in advance

Add a comment
10|10000 characters needed characters exceeded

Comment on This Question

Assigned Tags

Related questions

3 Answers

  • author's profile photo Repakula Manoj
    Repakula Manoj
    Posted on Jan 09, 2019 at 10:53 AM
    1

    Hi Yan,

    There is an excellent blog has been written for the above requirement, kindly go thorough it.

    https://blogs.sap.com/2013/04/22/configuring-pdf-forms-for-generating-customer-account-statements/

    Best Regards,

    Repakula Manoj

    Add a comment
    10|10000 characters needed characters exceeded

    • Yan Ying Ng
      Jan 15, 2019 at 08:13 AM

      Hi Repakula,

      Thank you for your info. After reading thru the blog, it shows the ways to generate customer in PDF. Just wondering if there is anyway to generate in excel file and directly send to respective customer via SAP.

      Thank you.

      Best Regards,

      Yan

  • author's profile photo Repakula Manoj
    Repakula Manoj
    Posted on Jan 16, 2019 at 07:21 AM
    0

    Hi Yan,

    It depends on the form which your using, If your PDF is interactive form by Adobe, you can extract the data in Excel Format for processing where as transform into internal table, export of internal table as excel.

    or you can use this Functional module as well HRHAP_POPUP_EXCEL_DOWNLOAD with the help of abaper.

    Best Regards,

    Repakula Manoj

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 17, 2019 at 09:03 PM
    0

    https://www.guru99.com/accounts-receivable-sap.html

    List of t-codes regarding correspondence options,

    Cheers

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.