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

Date format in BDC

Former Member — Tue, 16 Dec 2008 11:19:59 GMT

Hi Friends,

Presently I am working on a BDC report wherein one of the field to give as input is DATE. I am first giving the data in an excel sheet then converting it into text file and trying to upload.

While uploading , the date field is mis interpreted and its giving a wrong input to my BDC report as a result my BDC report is giving wrong output.

Can anyone suggest me with this issue ?

Edited by: Swapna Vadlamani on Dec 16, 2008 12:20 PM

Re: Date format in BDC

Former Member — Tue, 16 Dec 2008 11:23:19 GMT

u can use

WRITE lwa_febko-azdat TO lv_date.

Re: Date format in BDC

Former Member — Tue, 16 Dec 2008 11:23:35 GMT

Hi,

While uploading the date field from Text file, the date field will be as '20081216',But while passing to BDC you have to pass date as '12/16/2008'.

So you have to format the date before passing to BDC.

Hope this may be helpful.

Regrads,

Sravanthi

Re: Date format in BDC

GauthamV — Tue, 16 Dec 2008 11:23:55 GMT

hi,

Declare your date field like this.

data: Date(10) type c.

Re: Date format in BDC

Former Member — Tue, 16 Dec 2008 11:25:28 GMT

Use FM CONVERT_DATE_TO_EXTERNAL to change the date fromat from 99991231 to 31.12.9999

pass this value to BDC

Re: Date format in BDC

Former Member — Tue, 16 Dec 2008 11:33:53 GMT

Hi Swapna,

I had the similar issue and I did it like this.

i_date     = lv_date.  --> Actual date obtained (20081231) format
      lv_year    = lv_date+0(4).
      lv_day     = lv_date+6(2).
      lv_month   = lv_date+4(2).
      CONCATENATE lv_day  lv_month  lv_year INTO lv_final_date SEPARATED BY '.'.
      MOVE lv_final_date TO wa_it_date-d_date.

Please incorporate the same and lemme know.

Regards,

-Syed.

Re: Date format in BDC

Former Member — Tue, 16 Dec 2008 11:49:14 GMT

Hi There,

when you uploading it ...jus format the data in the way you wanted and use the same in your BDC .

Thanks

Re: Date format in BDC

Former Member — Tue, 16 Dec 2008 12:10:30 GMT

hi,

can i know what you are giving input and what you are getting output(DATE)

Re: Date format in BDC

Former Member — Tue, 16 Dec 2008 13:00:56 GMT

Hi,

Do One thing.

Create a variable LV_DATE(10) type C.

Now, Write your date to Local variable.

Write: YourDate to LV_DATE.

And, Pass this LV to your recording, frm where the date field is getting populated to your ITAB.

Hope It helps.

Regards,

Vikas

Re: Date format in BDC

rainer_hbenthal — Tue, 16 Dec 2008 13:12:09 GMT

Use


write var to char10 dd/mm/yyyy.

This will give you the representation of the date due tor your user settings (dont be confused, it will not write day month year with slashes, it will write it according to your user settings in transaction SU3).

Still there is one problem: if a user executes this BDC with a different user setting for the date representation, it will still fail.

Re: Date format in BDC

Former Member — Tue, 16 Dec 2008 13:15:56 GMT

Hi Friends,

Thanks a ton for everyone for replying. I will surely incorporate the required and hope I will succeed.

-Regards,

Swapna Vadlamani