08-01-2006 12:17 PM
Hello,
Is there any SAP FM available which takes the date (DD.MM.YYY) and convert it sumthing like 'August 01 2006'
08-01-2006 12:18 PM
Hi shehryar,
1. we can use the fm
CONVERSION_EXIT_SDATE_OUTPUT
2. it will convert into
01-jan-2006 format.
regards,
amit m.
08-01-2006 12:18 PM
Hi shehryar,
1. we can use the fm
CONVERSION_EXIT_SDATE_OUTPUT
2. it will convert into
01-jan-2006 format.
regards,
amit m.
08-01-2006 12:20 PM
hi,
There is a FM <b>CONVERSION_EXIT_SDATE_OUTPUT</b> to do that.. just check it.
data: date type sy-datum, text(20).
date = sy-datum.
CALL FUNCTION 'CONVERSION_EXIT_SDATE_OUTPUT'
EXPORTING
INPUT = date
IMPORTING
OUTPUT = text
.
08-01-2006 12:20 PM
use table t247 with elect logic...
parameters: date like sy-datum.
data: begin of itab occurs 0,
SPRAS type SPRAS,
MNR LIKE T247-MNR,
KTX LIKE T247-KTX,
LTX LIKE T247-LTX,
end of itab.
DATA : month LIKE T247-MNR.
DATA: YEAR(4).
DATA: FINAL(18).
DATA: DAY(2).
DAY = DATE+6(2).
MONTH = DATE+4(2).
YEAR = DATE+0(4).
select SINGLE * from t247 into itab where mnr = month
AND SPRAS = 'E'.
APPEND ITAB.
CONCATENATE ITAB-KTX DAY YEAR INTO FINAL SEPARATED BY '-'.
WRITE: FINAL.
08-01-2006 12:22 PM
check out the table T247. You can convert months to text using this table.
Use function module DATE_COMPUTE_DAY for getting the day number.
11-23-2011 7:00 AM
11-23-2011 9:58 AM
you can use fm CONVERSION_EXIT_SDATE_OUTPUT for conversion of date to text. Hope this will solve your problem.
thanks
Edited by: Ankitesh on Nov 23, 2011 10:59 AM
09-06-2022 10:28 AM