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: 

AVL excel inplace

Former Member

‎2006 Oct 12 1:23 PM

0 Kudos
614

Hello,

I am can also display data in an Excel view. The data is transferred to Excel and displayed there in an Excel sheet within the window instead of the grid. The ALV Grid Control toolbar is still visible and you can use its functions in the Excel view in my computer. But when it is run in another different equipment not it generates. It open Excell with each Shets but the data do not displayed.

Any guide to solve to this problem.

thanks

1 REPLY 1

Former Member

‎2006 Oct 12 1:41 PM

0 Kudos
251

Info collected from search..

To create the template you do:

1) Run the report.

2) When you see the result (the AVL GRID report), you go to change layout - the view tab - mark the excel radio button, choose template sap_om.xls by double click and press enter.

3) Now you see the report as 'excel Inplace'

4) In the excel menu you choose 'Save as' to save your file - and now you have a template ready to be modified.

Try to modify template :

1) The template has 15 sheets (Format, Header, Pivot etc. etc.) - don't delete any of these! (If you do the template won't work) (I would normally call these sheets 'tabs', but in excel they are sheets of an excel-book).

2) Add your own sheet or sheets

3) In your own sheet you make links to the data in the standard sheets Format or RawData.

You now have and modified template. In your own sheet you can add any formatting or calculations you want. Finally to clean the template I would clear the contents of the standard sheets Format and RawData

you can upload the template :

Refer the Oss note 358644 and 548409

You will have to build your own templates by creating modified copies of the SAP standard templates SAP_OM.XLS and SAP_MM.XLS. If you can find these see note 316728 to copy them from client 000.

You will have to work with transaction OAOR to administrate the templates and program BC_BDS_UPLOAD to upload new templates.

And finally run the report and choose the new layout instead of sap_om.xls.

Basis guys might able to help you.

regards

Vivek

  • award points for useful answers