Skip to Content
0
Former Member
Jun 14, 2014 at 09:28 AM

ALV to excel

14 Views

Hi,

I am facing problem in dowloading alv to excel for one particular field.

Code for the column is:

month - yy.

for ex: July -13 But after dowloading it shows 13 - July.

CALL FUNCTION 'ISP_GET_MONTH_NAME'

EXPORTING

DATE = wa_final-lwd

language = SY-LANGU

* MONTH_NUMBER = '00'

IMPORTING

* LANGU_BACK =

* LONGTEXT =

SHORTTEXT = month

* EXCEPTIONS

* CALENDAR_ID = 1

* DATE_ERROR = 2

* NOT_FOUND = 3

* WRONG_INPUT = 4

* OTHERS = 5

.

IF sy-subrc <> 0.

* Implement suitable error handling here

ENDIF.

CONCATENATE month '-' wa_final-lwd+2(2) INTO wa_final-month_yy.

Please help.

Thanks in advance.