topic Re: sy-datum conversion help required in Application Development and Automation Discussions

sy-datum conversion help required

Former Member — Tue, 11 Sep 2007 06:55:30 GMT

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.

Re: sy-datum conversion help required

amit_khare — Tue, 11 Sep 2007 07:00:41 GMT

Use this FM -

CONVERSION_EXIT_SDATE_OUTPUT

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.

Re: sy-datum conversion help required

Former Member — Tue, 11 Sep 2007 07:00:51 GMT

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

Re: sy-datum conversion help required

Former Member — Tue, 11 Sep 2007 07:03:57 GMT

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

Re: sy-datum conversion help required

varma_narayana — Tue, 11 Sep 2007 07:10:19 GMT

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

Re: sy-datum conversion help required

Former Member — Tue, 11 Sep 2007 07:13:06 GMT

You can use FM "CONVERSION_EXIT_IDATE_OUTPUT"

Re: sy-datum conversion help required

Former Member — Tue, 11 Sep 2007 07:17:58 GMT

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.

Re: sy-datum conversion help required

Former Member — Tue, 11 Sep 2007 07:22:47 GMT

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

Re: sy-datum conversion help required

Former Member — Tue, 11 Sep 2007 07:26:07 GMT

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

Re: sy-datum conversion help required

Former Member — Tue, 11 Sep 2007 09:26:09 GMT

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.