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: 

sy-datum conversion help required

Former Member
0 Kudos

Hi

I have to convert sy-datum into date format like DateMonthYear

eg 12.12.2007 to 12 December 2007.,using FM.

Please send me the way for this.

Regards.

1 ACCEPTED SOLUTION

Former Member
0 Kudos

hi,

TABLES : T247.

DATA : V_DATE(10) VALUE '30.08.2007',

V_MON(2) TYPE c,

V_LTX LIKE T247-LTX,

v_day(2) type c,

v_year(4) type c.

v_day = V_date+0(2).

V_year = v_date+6(4).

V_MON = V_DATE+3(2).

data str type string.

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

condense v_year.

CONCATENATE v_day v_ltx v_year into str SEPARATED BY space.

write str.

<b>your result would be: 30 August 2007.</b>

plz reward points if it helps

rgds

9 REPLIES 9

amit_khare
Active Contributor
0 Kudos

Use this FM -

CONVERSION_EXIT_SDATE_OUTPUT

OR

v_mm = sy-datum+4(2).

SELECT single LTX FROM T247 INTO TABLE v_month

WHERE SPRAS = LANGUAGE

and MNR = v_mm.

Now concatenate it to other values.

Regards,

Amit

Reward all helpful replies.

0 Kudos

Try with this code:

DATA: ZTEMP(9),zdd(2),zmmm(3),zyyyy(4),zfinal(12), v_date like sy-datum.

CLEAR: Zdate, ZDD, ZMMM, ZYYYY.

*v_date = '072307'. "mm/dd/yy

v_date = sy-datum.

CALL FUNCTION 'CONVERSION_EXIT_IDATE_OUTPUT'

EXPORTING

INPUT = v_date

IMPORTING

OUTPUT = Zdate.

write zdate.

Former Member
0 Kudos

Check all available FM for DATE

DATE_CONVERT_TO_FACTORYDATE

DATE_GET_WEEK

WEEK_GET_FIRST_DAY

DATE_COMPUTE_DAY

DAY_IN_WEEK

GET_WEEK_INFO_BASED_ON_DATE

LAST_WEEK

NEXT_WEEK

DATE_TO_DAY

DATE_GET_FIRST_DAY_OF_WEEK

CONVERT_DATE_TO_ALPHA_NUMERIC

CONVERT_DATE_TO_EXTERNAL

CONVERT_DATE_TO_INTERNAL

PERIOD_AND_DATE_CONVERT_INPUT

PERIOD_AND_DATE_CONVERT_OUTPUT

DATE_IN_FUTURE

RS_VARI_V_1_ACTUAL_MONTH

RS_VARI_V_1_LAST_MONTH

RS_VARI_V_1_NEXT_MONTH

RS_VARI_V_ACTUAL_MONTH

RS_VARI_V_LAST_MONTH

RS_VARI_V_DAYS_UP_TO_NOW

RS_VARI_V_WDAYS_UP_TO_NOW

RS_VARI_V_MONTH_XXX_YYY

RS_VARI_V_L_LAST_MONTH

RS_VARI_V_MONTH_UP_TO_NOW

RS_VARI_V_QUARTER1XXXX

RS_VARI_V_QUARTER2XXXX

RS_VARI_V_QUARTER3XXXX

RS_VARI_V_QUARTER4XXXX

RS_VARI_V_TODAY

RS_VARI_V_TODAY_X

RS_VARI_V_TODAY_XWD

RS_VARI_V_XWD_ACTUAL_MONTH

DATUMSAUFBEREITUNG

CCM_GO_BACK_MONTHS

HR_PT_ADD_MONTH_TO_DATE

RE_ADD_MONTH_TO_DATE

RP_LAST_DAY_OF_MONTHS

DAYS_BETWEEN_TWO_DATES

MONTHS_BETWEEN_TWO_DATES

PRICING_DETERMINE_DATES

MONTHS_BETWEEN_TWO_DATES_NEW

MONTH_NAMES_GET

DAY_NAMES_GET

FACTORY_CALENDAR_GET

HOLIDAY_CALENDAR_GET

FACTORY_CALENDAR_ATTRIBUTE_GET

HOLIDAY_GET

DAY_ATTRIBUTES_GET

Rewards if useful................

Minal

former_member208856
Active Contributor
0 Kudos

Hi,

please take the help from this code :

you can use sy-datum in place of idate.

data : date(10),

text1(26),

num1(10),

test_day(15),

o_date(20),

idate type sy-datum.

data : Day(2), month(2), Year(4).

data : ODay(2), Omonth(2), OYear(4).

data : Ltext Type T247-LTX.

date = '12-12-2007'.

day = date+0(2).

month = date+3(2) + 1.

year = date+6(4).

concatenate year month day into idate.

CALL FUNCTION 'HR_IN_GET_DATE_COMPONENTS'

EXPORTING

idate = idate "can use sy-datum here

IMPORTING

DAY = oday

MONTH = omonth

YEAR = oyear

LTEXT = ltext.

concatenate oday ltext oyear into o_date separated by SPACE.

write : O_date.

Reward points, if helpful,

Sandeep Kaushik

Message was edited by:

Sandeep Kaushik

varma_narayana
Active Contributor
0 Kudos

Hi Vipin..

Call the FM

CONVERSION_eXIT_SDATE_OUTPUT.

IN this FM

Export the Date in Internal format

It will return the Date in DD.MONTH.YYYY format..

reward if Helpful

Former Member
0 Kudos

You can use FM "CONVERSION_EXIT_IDATE_OUTPUT"

Former Member
0 Kudos

hi,

TABLES : T247.

DATA : V_DATE(10) VALUE '30.08.2007',

V_MON(2) TYPE c,

V_LTX LIKE T247-LTX,

v_day(2) type c,

v_year(4) type c.

v_day = V_date+0(2).

V_year = v_date+6(4).

V_MON = V_DATE+3(2).

data str type string.

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

condense v_year.

CONCATENATE v_day v_ltx v_year into str SEPARATED BY space.

write str.

<b>your result would be: 30 August 2007.</b>

plz reward points if it helps

rgds

Former Member
0 Kudos

Hi,

Try with this code:

DATA: ZTEMP(9),zdd(2),zmmm(3),zyyyy(4),zfinal(12), v_date like sy-datum.

CLEAR: ZTEMP, ZDD, ZMMM, ZYYYY.

*v_date = '072307'. "mm/dd/yy

v_date = sy-datum.

CALL FUNCTION 'CONVERSION_EXIT_IDATE_OUTPUT'

EXPORTING

INPUT = v_date

IMPORTING

OUTPUT = ZTEMP.

write ztemp.

Regards,

Bhaskar

Former Member
0 Kudos

Do this -

REPORT ZSKC_TEST2.

PARAMETER : P_date TYPE sy-datum,
            p_char type char50.

at selection-screen.

CALL FUNCTION 'CONVERSION_EXIT_SDATE_OUTPUT'
  EXPORTING
    INPUT         = p_date
  IMPORTING
    OUTPUT        = p_char.

SKC.