RE:[sap-dev] Trial Balance (Balance Sheet/P plus L Statement)
Posted by
Admin at
|
Share this post:
|
|
0 Comments
 | Posted by R. Neal Wilhite (Senior Project Manager) on Mar 23 at 4:38 PM |  Mark as helpful |
What version of SAP are you using? What version and patch of the SAP gui are you using? Have you looked for notes yet? Can you make a fresh install of both the SAP Gui and Excell '07 and verify that it still doesn't work?
Neal
---------------Original Message---------------
From: Madelaine
Sent: Tuesday, March 23, 2010 10:19 AM
Subject: Trial Balance (Balance Sheet/P plus L Statement)
> Could someone suggest a solution.
>
> When I run RFBILA00 / S_ALR_87012284 using the ALV grid control method, the info appears on my screen with no problem.
>
> I need to export it to Excel: when I use Ctrl+Shift+F7, a spreadsheet is opened with sheets of format, header, pivot, sub1 to sub10, rawdata and raw header but no data in any of the sheets. When I use List--> Export to--> Spreadsheet, a spreadsheet is opened with 800 rows but only headings for the first 3 lines of the TB. If I copy and paste from the ALV grid into this spreadsheet, I do not always receive all the items from the TB (on ocassion I do manage to paste all but it is inconsistent).
>
> Can someone please suggest what may be wrong - albeit my version of excel (2007) or something else I have overlooked. If my memory serves me correctly it worked on a previous version of excel (2003).
>
> I know of course that I can export to a local file, but this means a few extra clicks which no user can spare these days.
>
> I have other reports in the ALV grid format which I manage to download without any hassle. (thought you may need to know)
>
> Thanks
> madlg
__.____._ Neal
---------------Original Message---------------
From: Madelaine
Sent: Tuesday, March 23, 2010 10:19 AM
Subject: Trial Balance (Balance Sheet/P plus L Statement)
> Could someone suggest a solution.
>
> When I run RFBILA00 / S_ALR_87012284 using the ALV grid control method, the info appears on my screen with no problem.
>
> I need to export it to Excel: when I use Ctrl+Shift+F7, a spreadsheet is opened with sheets of format, header, pivot, sub1 to sub10, rawdata and raw header but no data in any of the sheets. When I use List--> Export to--> Spreadsheet, a spreadsheet is opened with 800 rows but only headings for the first 3 lines of the TB. If I copy and paste from the ALV grid into this spreadsheet, I do not always receive all the items from the TB (on ocassion I do manage to paste all but it is inconsistent).
>
> Can someone please suggest what may be wrong - albeit my version of excel (2007) or something else I have overlooked. If my memory serves me correctly it worked on a previous version of excel (2003).
>
> I know of course that I can export to a local file, but this means a few extra clicks which no user can spare these days.
>
> I have other reports in the ALV grid format which I manage to download without any hassle. (thought you may need to know)
>
> Thanks
> madlg
Copyright © 2010 Toolbox.com and message author.
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
R. Neal WilhiteSAP Development Helper
Posted helpful replies on 5 threads in a group to earn a Bronze Achievement
Related Content
In the Spotlight
White Papers
In the Spotlight
55% of IT Pros Use Social Media to Advance Their Careers. See the Survey Results
View this thread online
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
Manage group e-mails
Create an FAQ on this topic
Tell us what you think
Unsubscribe from discussion
