08-16-2007 10:50 AM
My table is "tcurr"
and my field is "gdatu" which contains date but in a different format. I have to change this date format to //---- for posting in a BDC table which only alows //---- format. if i have to use
CALL FUNCTION 'CONVERT_DATE_TO_INTERNAL/EXTERNAL' then how to use?
plz help
08-16-2007 12:23 PM
Hi,
Use this function module before applying the BDC process, CONVERSION_EXIT_PDATE_OUTPUT, this will definitly serve the perpose, reward if found usefull.
Regards,
Rama Murthy.P
08-16-2007 10:53 AM
USE write to ........... using edit mask STATEMENT FOR FORMATTING DATES.
S@meer
08-16-2007 11:11 AM
plz check once the field in taht tabel then give suggession....its very different from date field
08-16-2007 10:58 AM
Hi,
external_date = '2006.12.01'.
CALL FUNCTION 'KCD_EXCEL_DATE_CONVERT'
EXPORTING
EXCEL_DATE = external_date
DATE_FORMAT = 'JMT' "(T) Day,(M) Month,(J) Year
IMPORTING
SAP_DATE = sap_date
or
You have to do settings in SU3(T.CODE). In SU3 goto defaults there you find Date Format. try to keep your settings and save it. Your BDC will work.
aRs
08-16-2007 11:27 AM
08-16-2007 11:28 AM
Use the following code :
CONVERT INVERTED-DATE <d1> INTO DATE <d2>.
Regards,
Aparna
08-16-2007 11:46 AM
today is <b>1600807</b>...im giving this date
in the table its showing <b>79929183</b>
so is it inverted????
08-16-2007 12:04 PM
hi Aparna
i tried with this CONVERT but it is not working..
now what to do??
08-16-2007 12:15 PM
hi,
use this function to get the desired output 'CONVERSION_EXIT_INVDT_OUTPUT' where your input is Gdatu and output is correct date.
regards
Abhilasha Gupta
08-16-2007 12:16 PM
08-16-2007 12:23 PM
Hi,
Use this function module before applying the BDC process, CONVERSION_EXIT_PDATE_OUTPUT, this will definitly serve the perpose, reward if found usefull.
Regards,
Rama Murthy.P
08-16-2007 12:52 PM
thanks 4 your all sugessions.....but u can get my problem properly or i cant expline u properly....
see, Today is <b>1600807</b>the table TCURR which has a field <b>gdatu</b> is taking this date like <b>79929183</b>.
So this format is neither inverted nor any other fornmat....
now i have to convert that <b>79929183</b> to <b>1600807</b> for BDC.
the data type for date i have to give TCURR-GDATU_INV.....if differ from that i will give, in the selet statement it will not fatch data from the DB table....
so <b>79929183</b> what type of format is this???
08-17-2007 6:35 AM
subtract the GDATU date from 99999999... this will give you the date in 0calday format..
Regards,
Aparna
08-18-2007 7:33 AM
08-20-2007 12:57 PM
If the problem is solved assign points to the useful posts and close the thread,,
Regards,
Aparna