topic Re: Function Module to get month name in Application Development and Automation Discussions

Function Module to get month name

Former Member — Mon, 17 Dec 2007 09:47:17 GMT

Hi all,

I need to capture the month name in a variable.Example if the month is 02 then i need the result as February or if it is 12 then i need the result as December..

Is there any Function Module for the same..

Please suggest..

Thanks,

Arun

Re: Function Module to get month name

Sougata — Mon, 17 Dec 2007 09:50:00 GMT

Not that I'm aware of but its easy to write one. Build a case statement around a FM/Routine Importing/Using the month number and Exporting/Changing the variable containing the month name. There are only 12 months so it should be short and simple.

Cheers,

Sougata.

Re: Function Module to get month name

amit_khare — Mon, 17 Dec 2007 09:50:27 GMT

Use this code -

TABLES : t247.

DATA : v_mon(2) TYPE n,

v_date(10) VALUE '04.09.2007',

v_ltx LIKE t247-ltx,

v_ktx LIKE t247-ktx.

SELECT SINGLE ktx

ltx

INTO (v_ktx , v_ltx)

FROM t247

WHERE spras = sy-langu AND

mnr EQ v_date+3(2).

WRITE : v_ktx , v_ltx.

Otherwise use FM MONTH_NAME_GET.

I will prefer the above quote.

Re: Function Module to get month name

vallamuthu_madheswaran2 — Mon, 17 Dec 2007 09:53:43 GMT

hi,

using the following function module MONTH_NAMES_GET.

data: l_month(10) type c.

select ltx form t247

into l_month

where spras = 'EN'

and mnr = 12 "==> month.

Thanks & regards,

Vallamuthu.M

Re: Function Module to get month name

former_member386202 — Mon, 17 Dec 2007 09:53:45 GMT

Hi,

Use FM MONTH_NAME_GET

Regards,

Prashant

Re: Function Module to get month name

Former Member — Mon, 17 Dec 2007 09:54:39 GMT

3 ways;

data:itab_month type standard table of T247

data: month_name type table of t247 with header line.

data: mm(2) type n.

mm = sy-datum+4(2).

CALL FUNCTION 'MONTH_NAMES_GET'

TABLES

MONTH_NAMES = month_name.

read table month_name index mm.

write: / month_name-ltx.

REPORT ychatest2.

TABLES : t247.

DATA : v_mon(2) TYPE n,

v_date(10) VALUE '04.09.2007',

v_ltx LIKE t247-ltx,

v_ktx LIKE t247-ktx.

SELECT SINGLE ktx

ltx

INTO (v_ktx , v_ltx)

FROM t247

WHERE spras = sy-langu AND

mnr EQ v_date+3(2).

WRITE : v_ktx , v_ltx.

Hi,

use sub srtingoperation, as below.

MONTH_NAMES_GET cannot be used to spell the month, it is used to retrieve the available month options in a perticular system and their possible representation.

if you want to spell the month use the FM ' SPELL_AMOUNT'.

Use sub string operation for this.

data: c1(2) type c,

d1 type d value '04.09.2007,

WORDS LIKE SPELL.

c1 = d1+3(2).

call function 'SPELL AMOUNT'

EXP

AMOUNT = C1

LANGUAGE = SY-LANGU

IMPORTING

IN_WORDS = WORDS

WRITE: WORDS-WORD

Re: Function Module to get month name

Former Member — Mon, 17 Dec 2007 09:56:12 GMT

Hi Arun,

You can use FM " Month_name_get"..

It would be better to write Case statements and create some piece of code.

Reward If Useful.

Regards,

Chitra Parameswaran