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
Showing results for 
Search instead for 
Did you mean: 

ALV Grid Format.

Former Member
0 Kudos

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.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

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

2 REPLIES 2

Former Member
0 Kudos

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

0 Kudos

Thanks Amit for providing this useful information.

Regards,

Pratibha.