topic Re: ALV Grid Format. in Application Development and Automation Discussions

ALV Grid Format.

Former Member — Sat, 25 Mar 2006 09:28:06 GMT

Hi All,

I am using function 'RH_START_EXCEL_WITH_DATA' to export data from ALV grid report to excel.

In report I have LTAP-ALTME (Alternative unit of measure for stockkeeping unit). In ALV report values displayed are EA, DOZ. But when taken into excel, it displays ST, DEZ etc.

What can be reason of this wrong data display.

Thanks,

Pratibha.

Re: ALV Grid Format.

Former Member — Sat, 25 Mar 2006 09:31:37 GMT

Hi pratbiha,

1. There must be some internal table

which u must be passing to

the FM, and downloading the data .

2. Try with GUI_DOWNLOAD

and check if values are coming proper or not !

*----

3. The reason why its happening is :

that field has domain MEINS

which as conversion routine

CUNIT

(CONVERSION_EXIT_CUNIT_INPUT

CONVERSION_EXIT_CUNIT_OUTPUT)

4. So what is there inside the internal table

(although it shows different on alv bcos of convesion),

the raw data in internal table

is getting output in excel.

5. So either u have to take another one

column in the internal table itself,

and fill this column using the FM mentioned above,

and then save to excel.

<b>6. (this behaviour is nothing but similar

to DATE field in an internal table)

Date field in alv will always show in dd.mm.yyyy format

, but when we download,

it will always download as YYYYMMDD</b>

regards,

amit m.

Message was edited by: Amit Mittal

Re: ALV Grid Format.

Former Member — Sat, 25 Mar 2006 09:45:13 GMT

Thanks Amit for providing this useful information.

Regards,

Pratibha.