topic month display in Application Development and Automation Discussions

month display

Former Member — Fri, 09 Dec 2005 03:01:54 GMT

Hi,

I am entering the date in the select-options.

But in the report i want to display only Month & year of the particular entry in the select-options.

Can any one tell me how to display that?

I dont want to hard code for every month.Is there any SAP standard variables?

Points guaranteed

cheers

kaki

Message was edited by: Kaki R

Re: month display

Former Member — Fri, 09 Dec 2005 03:07:25 GMT

select-options : s_date like sy-datum

system store it as yyyymmdd

v_month = s_date-low + 4(2).

v_year = s_date-low + 0(4).

Message was edited by: chandrasekhar jagarlamudi

Re: month display

Former Member — Fri, 09 Dec 2005 03:09:11 GMT

Hi Shekhar,

I want to display with month like "jan 2005 to may 2005"

kaki

Re: month display

Former Member — Fri, 09 Dec 2005 03:14:22 GMT

Hi ,

Use function

CACS_DATE_GET_YEAR_MONTH

this gives you month and year.

Then write a case statement as

Case Emonth.

When 01.

V_month = 'JAN'.

..... so on..

Endcase.

Re: month display

Former Member — Fri, 09 Dec 2005 03:19:50 GMT

use FM MONTH_NAMES_GET

u con concatenate with the year

Re: month display

Former Member — Fri, 09 Dec 2005 03:31:42 GMT

tables : t247.

data:it_t247 type standard table of t247 with header line.

CALL FUNCTION 'MONTH_NAMES_GET'

EXPORTING

LANGUAGE = SY-LANGU

IMPORTING
RETURN_CODE =

TABLES

month_names = it_t247

EXCEPTIONS

MONTH_NAMES_NOT_FOUND = 1

OTHERS = 2

IF sy-subrc <> 0.

MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

ENDIF.

read table it_t247 with key mnr = v_month.

v_mon_desc = it_t247-ktx.

concatenate v_mon_desc v_year

Re: month display

Former Member — Fri, 09 Dec 2005 03:39:10 GMT

Thanks for all replies..

Points allowted

cheers

kaki