ALV Problem

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

rgds,

Raman.

[Former Member]

Hi,

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

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

[former_member199581]

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

[Former Member]

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

[Former Member]

Hi Tee,

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

Regards,

Atish

[Former Member]

Hi Sarda,

Thanks for ur help

regards

TEE

[Former Member]

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