topic Re: Error when converting date/time time zone in time stamp in Application Development and Automation Discussions

Error when converting date/time time zone in time stamp

sachin_yadav3 — Fri, 09 Sep 2011 07:34:03 GMT

Hi,

I am implementing the BAPI "BAPI_OPPORTUNITY_CREATEMULTI".

But after execution i am getting below error

"Error when converting date/time time zone in time stamp".

I am passing below details to BAPI.

wa_appointment-DATE_FROM = wa_bapi_create-DATE_FROM.

APPEND wa_appointment to it_appointment.

Kindly help.

Re: Error when converting date/time time zone in time stamp

Former Member — Fri, 09 Sep 2011 15:43:08 GMT

are you using an Industry Solution? I don't have that BAPI....

a time stamp is usually described in the data like Decimal 15 or with the domain ICL_TIMESTAMP. Be sure you're providing valid values to the BAPI, particularly any date, time and time zone values.

Use the keyword CONVERT to create and break down a timestamp. There are other posts today on this subject...generally, one does something like:

convert date sy-datum

time sy-uzeit

into time stamp <my_ts_field> "type ICL_TIMESTAMP

time zone sy-zonlo.

or conversely....

convert time stamp <ts field>

time zone sy-zonlo

into date lv_date "(type d)

time lv_time. "(type t)....

Edited by: DaveL on Sep 9, 2011 5:43 PM

Re: Error when converting date/time time zone in time stamp

sjeevan — Fri, 09 Sep 2011 17:33:34 GMT

Make sure both are of same length and data type (one may be length 8 and type DATS and other may be 10 and type CHAR)

wa_appointment-DATE_FROM

wa_bapi_create-DATE_FROM

Re: Error when converting date/time time zone in time stamp

sachin_yadav3 — Sat, 10 Sep 2011 08:21:52 GMT

Hi,

I am using CRM system.

I tried with wat you suggested but still facing same issue,

Kindly help.

Regards

Sachin Yadav