Skip to Content
Author's profile photo Gaurang Gujar

SAP Excel In Place

SAP Excel in Place

Applies to:

SAP NetWeaver 2004s, mySAP ERP 2005

Created on:



Gaurang Gujar, Capgemini ,  Consultant , Appsone.


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


      The view looks like below


       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



          Enter the File Name


     Step 2

     Create the formula or Macro for the derived column

     In our case l2-M2 and Drag it down.



     Save the file and Close it

    Step 3

     Go to Change layout


     Go to view Tab


     Select the view as Microsoft Excel


     Click on Upload Document from BDS

     Browse the File We Created and Saved

     Our File appear in the List


       Select the same and click on Save


     Save the layout


     Click on enter



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

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      It is very systematically and explained in a very lucid and simple manner.

      Author's profile photo Former Member
      Former Member

      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!

      Author's profile photo Gaurang Gujar
      Gaurang Gujar
      Blog 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.



      Author's profile photo Former Member
      Former Member

      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...