09-11-2007 7:55 AM
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.
09-11-2007 8:22 AM
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
09-11-2007 8:00 AM
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.
09-11-2007 8:17 AM
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.
09-11-2007 8:00 AM
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
09-11-2007 8:03 AM
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
09-11-2007 8:10 AM
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
09-11-2007 8:13 AM
09-11-2007 8:22 AM
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
09-11-2007 8:26 AM
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
09-11-2007 10:26 AM
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.