topic Re: Date Conversion Problem in BDC in Application Development and Automation Discussions

Date Conversion Problem in BDC

Former Member — Mon, 03 Sep 2007 13:42:55 GMT

Hi Friends,

I have come across with date and time problem in my BDC program

as I have date in YYYYDDMM e.g. 20070309

and in my transaction i need to pass it as MM/DD/YYYY format?

what should I do.

l_date type char10.

I am passing wa_date to l_date using edit mask '__/__/____'.

but it is not solving my problem.

kindly help it's urgent.

regards,

pradeep.

Former Member — Mon, 03 Sep 2007 13:44:57 GMT

Hi,

Dont use mask..

DATA : w_date(10) TYPE n.

WRITE : <your date variable> TO w_date.

Pass w_date to the BDC table..

Thanks and Regards,

Vikas Bittera.

RaymondGiuseppi — Mon, 03 Sep 2007 13:47:25 GMT

When you fill a BDC data, its better to use WRITE than MOVE instruction to fill the value, especially amounts and dates.

Also insure to be in the same language when building BDC as when executing it.

Regards

Former Member — Mon, 03 Sep 2007 14:13:34 GMT

use following line of code for your requirement

CONCATENATE

sy-datum+6(2) '/'

sy-datum+4(2) '/'

sy-datum+0(4)

INTO date.

make sure that date is of char 10.

Former Member — Mon, 03 Sep 2007 15:50:38 GMT

Hi,

goto the transcation. Find the field name. give some value to the field. Then switch on the debugger.

check how the data is stored. u can convert it as required.

Regards,

Niyaz