topic Re: ALV Problem in Application Development and Automation Discussions

ALV Problem

Former Member — Tue, 02 Oct 2007 03:47:54 GMT

Hi all,

I having problem in ALV reporting.

1. View in excel, it empty worksheet if press Excel button at the ALV report. Howerver, it show the data in the alv grid report.

[IMG]http://img.photobucket.com/albums/v615/tss2005/alv.gif[/IMG]

2. At ALV report, LIST>Export>Local File, it having the run time error in abap. Which wrote: The current statement only supports character-type data. May i know what is going on?

IMG]http://img.photobucket.com/albums/v615/tss2005/alv2.gif[/IMG]

Thanks for ur help

Re: ALV Problem

Former Member — Tue, 02 Oct 2007 03:51:21 GMT

Hi,

Can you paste your internal table defianation.

What is your SAP version?

Have you tried with some standard ALV program if these functionality working fine or not?

Regards,

Atish

Re: ALV Problem

Former Member — Tue, 02 Oct 2007 04:04:14 GMT

Hi, here is my internal table defination

TYPES: BEGIN OF ty_all,

matnr TYPE matnr, " Material No

werks TYPE werks_d, " Plant

eisbe TYPE eisbe, " Safety Stock Level

bismt TYPE bismt, " Old Material No

vkorg TYPE vkorg, " Sales Org

vtweg TYPE vtweg, " Distribute Channel

mvgr4 TYPE mvgr4, " Material Group 4

END OF ty_all.

My sap version is :

Release: 640 Beta Release

File Version:6400.2.0.2885 (sapfront.dll)

Build: 661550

I have try other alv, also display the blank excel sheet..

Re: ALV Problem

Former Member — Tue, 02 Oct 2007 04:11:09 GMT

Hi,

If you are facing this problem with standard ALV's also then there must be something wrong with the system setttings. Better check with your Basis and also search in OSS notes.

Regards,

Atish

Re: ALV Problem

Former Member — Tue, 02 Oct 2007 05:02:01 GMT

try using the button next to next to Excel (save as local file) and save it as .xls

rgds,

Raman.

Re: ALV Problem

Former Member — Tue, 02 Oct 2007 05:23:46 GMT

hi,

if u r able to convet the Standard ALV to Excel sheet then i think u need to ask ur basis team whether a template or layout is been set or not.

regards

Maneesh Chandran

Re: ALV Problem

Former Member — Tue, 02 Oct 2007 05:37:41 GMT

Hi,

it just having the same error once i click to tat button.

IMG]http://img.photobucket.com/albums/v615/tss2005/alv2.gif[/IMG]

Re: ALV Problem

former_member199581 — Tue, 02 Oct 2007 12:55:14 GMT

Can you please provide the full Short Dump?

However, the last line of your screenshot talks about a STRLEN statement.

Try (even if it's strange) to convert the internal table in a full char form and then try to export this in an Excel sheet...and see what happens...

Re: ALV Problem

Former Member — Wed, 03 Oct 2007 00:33:53 GMT

Hi pagni,

here is my full short dump.

http://img.photobucket.com/albums/v615/tss2005/alv3.gif

you mean convert the data type of internal table to C char?

Back to my first problem of ALV, it had no short dump, but excel sheet is blank. Do u have any idea on it?

Thanks & Regards

TEE

Message was edited by:

SIM SHU TEE

Re: ALV Problem

Former Member — Wed, 03 Oct 2007 00:44:48 GMT

Hi Tee,

As I said earlier have you searched OSS and checked with your basis.

Regards,

Atish

Re: ALV Problem

Former Member — Wed, 03 Oct 2007 00:55:10 GMT

Hi Sarda,

Thanks for ur help

regards

TEE