Skip to Content
author's profile photo Former Member
Former Member

Save data to SAP from ALV Excel-in Place functionality

Hi Experts,

I have a SE38 report which will display the output in ALV grid and with the help of built-in-function 'Excel-in-place' i can view the same output in excel format as well.

Is there any way to save the data (eg: in sap ztable) from excel in which the user might have changed/added some values.

Regards,
Bala.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2014 at 02:38 PM

    Hi Balasubramanian,

    To Save changed data back to SAP you have to write code .

    You can create your flow as below.

    1) Create 1 Button on ALV Grid O/P Display on GUI Status.

    2) When User Click on this button , Write code to Make ALV Grid Report Editable. You can use My attached Demo Program Code for your reference.

    3) Ones User change the data and Press Save Button, Write code to Update it in Z table.

    Just copy this whole code and Execute it. You will get overall idea. Hope this will help.

    Regards,

    Sagar


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Sudeesh,

      As per my understanding what he his req. is : he is displaying 1 report in ALV, he wants to change data in ALV (Weather it is using EXCEL displaying or directly in ALV report itself ) and want to save changed data to Z.

      @Bala: Please correct me if my understanding is wrong.

      I had post the solution for this understanding. Sorry for the inconvenience if i am wrong.

      Regards,

      Sagar.

  • Posted on Nov 24, 2014 at 05:51 AM

    This message was moderated.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2014 at 02:13 PM
    -1

    This message was moderated.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 24, 2014 at 05:05 AM
    -1

    Hi all,

    Thanks for your replies.

    Mr. Sudeesh Soni and Mr. Peter Jonker both are correct.


    The requirement is upon clicking 'Save' button (in tool bar), the values which user had edited in the Excel needs to be saved in the Ztable.


    Regards,
    Bala.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 14, 2019 at 03:05 PM
    -2

    Hi,

    can you explain how to do that please?

    Regards,

    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.