topic Re: BDC Date error in Application Development and Automation Discussions

BDC Date error

Former Member — Mon, 10 Aug 2009 20:20:39 GMT

Hello friends, I have written a BDC and it has 2 date fields,

Valied from and Valid to.

The valid from works good but the valid to has an issue. I need to hardcode the valid to to 12/31/9999

Below is the code.

DATA: g_date_begin(8), g_date_end(8).

g_date_end = '12319999'.

write g_date_end to g_date_end.

write sy-datum to g_date_begin.

PERFORM fill_bdc_table USING:

'X' 'SAPLMEOR' '0205',

' ' 'EORD-VDATU(1)' g_date_beg,

' ' 'EORD-BDATU(1)' g_date_end,

Any suggestions on how would I handle the VALID TO.

Bob

Re: BDC Date error

Former Member — Mon, 10 Aug 2009 20:30:07 GMT

You might be overflowing the date maximum capacity for your sap version. Try seting it around 2030.

Re: BDC Date error

Former Member — Mon, 10 Aug 2009 20:31:09 GMT

for some users it works but not all. the error message is invalid date.

bob

Re: BDC Date error

former_member194669 — Mon, 10 Aug 2009 20:33:29 GMT

May be u can use

FM CONVERT_DATE_TO_EXTERNAL.

a®

Re: BDC Date error

Former Member — Mon, 10 Aug 2009 22:29:55 GMT

Hi Bob,

Please try this.

DATA: w_date(10) .

WRITE sy-datum TO w_date USING EDIT MASK '__/__/____' .

and pass the w_date to your perform bdc_field.

Rgds

Raj.

Re: BDC Date error

Former Member — Tue, 11 Aug 2009 02:00:13 GMT

Hi Bob,

***get date format

select single datfm into g_datfm

from usr01

where bname = sy-uname.

case g_datfm.

when '1' .

concatenate l_day '.' l_month '.' l_year into l_date.

when '2' .

concatenate l_month '/' l_day '/' l_year into l_date.

when '3' .

concatenate l_month '-' l_day '-' l_year into l_date.

when '4'.

concatenate l_year '.' l_month '.' l_day into l_date.

when '5'.

concatenate l_year '/' l_month '/' l_day into l_date.

when '6'.

concatenate l_year '-' l_month '-' l_day into l_date..

endcase.

Regards

Jerry

Edited by: foxconn_jerry on Aug 11, 2009 4:00 AM

Edited by: foxconn_jerry on Aug 11, 2009 4:01 AM

Re: BDC Date error

Former Member — Wed, 12 Aug 2009 13:29:02 GMT

Hello all,

I have tried all of the above and nothng seems to be working.

any FM to achieve this

Edited by: Bob Dan on Aug 12, 2009 3:31 PM

Re: BDC Date error

Former Member — Wed, 12 Aug 2009 13:39:36 GMT

Hi Bob,

You can offset the date and can make it however you want.

data :g_date_end1 type char10.

concatenate g_date_end(2) '/' g_date_end2(2) '/' g_date_end+4(4) into g_date_end1

now pass g_date_end1 inthe BDC screen field.

Hope this tip may help

Rgds,

Sripal

Re: BDC Date error

Former Member — Wed, 12 Aug 2009 13:46:17 GMT

hello Sripaleshwar ,

nope this wont help because each user has a different date setting.

Bob

Re: BDC Date error

Former Member — Wed, 12 Aug 2009 13:50:03 GMT

Hi Bab,

then declare the date variables of type sy-datum, this may help

Sripal

Re: BDC Date error

Former Member — Wed, 12 Aug 2009 14:02:33 GMT

Declare both fields as char(10) and use '99991231'.

Rob

Re: BDC Date error

Former Member — Wed, 12 Aug 2009 15:02:18 GMT

Hi,

What i feel is date will be taken in the input format YYYYMMDD. Now when you say 12139999 the actual date considered as 99.99.1213 if the external format of date is separated by . now the catch is 99 date doesn't exists may be thats the reason you are getting this error.

Or else check what date is going to the BDC while running online you will get a fair idea.