topic Function module for Month Name? Urgent in Application Development and Automation Discussions

Function module for Month Name? Urgent

Former Member — Thu, 30 Aug 2007 08:08:59 GMT

Hi,

Is there any function module to get month name for a date, like

if input is 30.08.2007, then output should be 'AUG' or 'August'.

Anyone can help me...

Thanks in Advance.

Siva Sankar.

Re: Function module for Month Name? Urgent

Former Member — Thu, 30 Aug 2007 08:17:54 GMT

Hi,

Just use this FM: ISP_GET_MONTH_NAME.

Regards,

Re: Function module for Month Name? Urgent

Former Member — Thu, 30 Aug 2007 08:18:01 GMT

HI,

ZQUA_CONV_DATE_MONTH

regards

Nicole

Re: Function module for Month Name? Urgent

alpesh_saparia3 — Thu, 30 Aug 2007 08:18:34 GMT

You can find month names in table T015M.

- Alpesh

Re: Function module for Month Name? Urgent

Former Member — Thu, 30 Aug 2007 08:18:36 GMT

Hi,

for this you can just write a logic.Split the date and get the month no in one variable and then write a case statemnt to get the moth name...

date = 30082007

month = date+2(2)

you will have the value 08 in variable month.

now

case month.

when '01'.

month_alpha = 'JAN'.

when '02'.

month_alpha = 'FEB'.

.......

......

when '12'.

month_alpha = 'DEC'.

hence you can do the task.

please reward if helpful.

thanks

vivekanand

Re: Function module for Month Name? Urgent

former_member189059 — Thu, 30 Aug 2007 08:18:36 GMT

hello,

you can refer to the table T247 to get the months of the year

the function module MONTH_NAMES_GET will fetch all the months of the calendar

Re: Function module for Month Name? Urgent

Former Member — Thu, 30 Aug 2007 08:19:08 GMT

Hi siva,

  check this if it can help u

REPORT ZTEST.

TABLES : T247.

DATA : V_DATE(10) VALUE '30.08.2007',
       V_MON(2) TYPE N,
       V_LTX LIKE T247-LTX.

V_MON = V_DATE+3(2).

SELECT SINGLE  LTX FROM T247 INTO V_LTX WHERE MNR EQ V_MON AND SPRAS EQ SY-LANGU.

WRITE : V_LTX.

Re: Function module for Month Name? Urgent

varma_narayana — Thu, 30 Aug 2007 08:19:16 GMT

hi Shiva..

Call the FM

ISP_GET_MONTH_NAME

Pass the Date in User(External) format and Language.

It will return the Name of the Month

<b>reward if Helpful</b>

Re: Function module for Month Name? Urgent

Former Member — Thu, 30 Aug 2007 08:22:09 GMT

MONTH_NAMES_GET

Re: Function module for Month Name? Urgent

Former Member — Thu, 30 Aug 2007 08:30:55 GMT

hi,

Refer this sample code

REPORT ztest_tmp.

DATA : mname(10) TYPE c.

PARAMETER : d TYPE sy-datum.

PERFORM getmonth USING d mname.

write 😕 mname.

&----

*& Form getmonth

&----

text

----

-->M text
-->MNAME text

----

FORM getmonth USING d mname.

DATA : month_names LIKE t247 OCCURS 0 WITH HEADER LINE.

DATA : m(2) TYPE c.

m = d+4(2).

CALL FUNCTION 'MONTH_NAMES_GET'

EXPORTING
LANGUAGE = SY-LANGU
IMPORTING
RETURN_CODE =

TABLES

month_names = month_names

EXCEPTIONS

month_names_not_found = 1

OTHERS = 2

READ TABLE month_names INDEX m.

IF sy-subrc = 0.

mname = month_names-ltx.

ENDIF.

ENDFORM. "getmonth

Re: Function module for Month Name? Urgent

Former Member — Thu, 30 Aug 2007 08:43:58 GMT

Hi Siva,

You can go for any one of the following methods

Method 1******************************

parameters: p_date type sy-datum default sy-datum.

data: v_month like t247-ktx.

select single ktx into v_month from t247

where spras = sy-langu and

mnr = p_date+4(2).

write:/ 'Month = ', v_month.

Method 2******************************

parameters: p_date type sy-datum default sy-datum.

data: v_month like t247-ktx,

month_names like t247 occurs 0 with header line.

CALL FUNCTION 'MONTH_NAMES_GET'

EXPORTING

LANGUAGE = SY-LANGU

IMPORTING
RETURN_CODE = RETURN_CODE

TABLES

MONTH_NAMES = MONTH_NAMES

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 month_names with key spras = sy-langu

mnr = p_date+4(2).

if sy-subrc = 0.

v_month = month_names-ktx.

endif.

write:/ 'Month = ', v_month.

Re: Function module for Month Name? Urgent

Former Member — Mon, 10 Feb 2014 11:31:37 GMT

that's for single date if it is range like that:

09.09.2001 to 06.06.2002

in that case how to do that??????

Re: Function module for Month Name? Urgent

Former Member — Mon, 10 Feb 2014 11:41:23 GMT

This message was moderated.

Re: Function module for Month Name? Urgent

nabheetscn — Mon, 10 Feb 2014 11:44:08 GMT

Mukesh Das

Srinivas P

My dear friends its a 7 year old thread

Nabheet