topic Re: BDC in Application Development and Automation Discussions

BDC

Former Member — Tue, 31 Jul 2007 12:36:44 GMT

How to handle user specific settings as time and date in the BDC?

Re: BDC

Former Member — Wed, 01 Aug 2007 21:03:41 GMT

Try this piece of code :

select single * from usr02 where bname = sy-uname.

if sy-subrc = 0.

if usr02-tzone is initial.

usr02-tzone = 'PST'.

endif.

call function 'TZ_SYSTEM_TO_LOCAL'

exporting

date_system = sy-datum

timezone = usr02-tzone

time_system = sy-uzeit

importing

date_local = w_datlo

timestamp_local = w_timestamp

time_local = w_timlo

exceptions

no_parameters = 1

too_many_parameters = 2

conversion_error = 3

others = 4.

You can pass the date and time to BDC.

Reward points if useful..

Amruta

Re: BDC

Former Member — Wed, 01 Aug 2007 21:07:56 GMT

Just use WRITE as follows

data: v_date(10), v_time(8).

write sy-datum to v_date.

write sy-uzeit to v_time.

Now use v_date and v_time in your BDC.

Re: BDC

Former Member — Wed, 01 Aug 2007 21:20:41 GMT

CONVERT_DATE_TO_INTERN_FORMAT -> This FM Will convert the date into user profile date format

CONVERT_TIME_INPUT -> this fm will convert time into user profile time format

Thanks

Seshu

Re: BDC

Former Member — Wed, 01 Aug 2007 22:49:19 GMT

Hi john,

use the below function modules for date conversion

CONVERSION_EXIT_PDATE_OUTPUT

CONVERT_TIME_INPUT

regards,

srinu reddy.

Re: BDC

Former Member — Wed, 01 Aug 2007 22:49:46 GMT

Hi john,

use the below function modules for date conversion

CONVERSION_EXIT_PDATE_OUTPUT

CONVERT_TIME_INPUT

regards,

srinu reddy.