Skip to Content

SAP Excel in Place

Applies to:

SAP NetWeaver 2004s, mySAP ERP 2005

Created on:

21-08-2013

Author:

Gaurang Gujar, Capgemini ,  Consultant , Appsone.

Summary

Many times it is an requirement to add an derived field to standard ALV report.

Normally It will take a lot of coding effort to get a derived in Standard or Your Custom ALV List.

Good News is this document SAP is very thought full about it and has introduced Excel in Place using which

Coding for requirement is not reduced but made absolutely zero.

Steps to use this Excel in Place

Lets us take an Example of View SFLIGHTS

Temp.JPG

      The view looks like below

Temp.JPG

       Now Here we have Two Columns Seats Max and Seats Occupied

       Suppose there is a requirement to have a derived column seats available. It would require a lot of coding for the same.

       SAP Excel in Place comes to our Rescue.

     Step 1

       Click on Excel In Place Icon

Temp.JPG

    Temp.JPG

          Enter the File Name

     Temp.JPG

     Step 2

     Create the formula or Macro for the derived column

     In our case l2-M2 and Drag it down.

Temp.JPG

Temp.JPG

     Save the file and Close it

    Step 3

     Go to Change layout

Temp.JPG

     Go to view Tab

Temp.JPG


     Select the view as Microsoft Excel

Temp.JPG

     Click on Upload Document from BDS

     Browse the File We Created and Saved

     Our File appear in the List

Temp.JPG

       Select the same and click on Save

Temp.JPG

     Save the layout

Temp.JPG

     Click on enter

     Tadaaaa

Temp.JPG


Seats available in Output

Excel in place can be used with Macro Recording with get derived Fields also Hide Columns’

with Value Zero and Many other stuffs

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. Bernd Klose

    Helle, we like to use user specific (ALV-Layout Templates?) Excel Templates, but our SAP-Support refuse it, because “development” authorizations are required for it (they made a trace and found development objects…).

    Can you tell me I this is realy needed or which are specific authorization objects are minum required to use ALV-Layout Templates?

    Thanks allot!

    (0) 
    1. Gaurang Gujar Post author

      Hello Bernd,

      Please go to SU53 transaction after your and provide the screen shot of the same to your authorization and Basis team. They will be able to help you with the neccessary authorization.

      Regards,

      Gaurang

      (0) 
  2. Bernd Klose

    Hello Gaurang,

    well, with a “standard” User the Buttons to check Out/in Templates aren’t visible, so I’m not able to execute it and get an error in SU53.

    If no “SAP standard” role/authorization exist which can be used to begin analysing the Requirements, I have to try to persuade the Basis team to create a new Role based on the trace only without the “development” objects.

    Hopefully it’s at least enough to execute it and do deeper analysis via SU53…

    THANKS!

    (0) 

Leave a Reply