topic Re: Function Module in Application Development and Automation Discussions

Function Module

Former Member — Thu, 09 Nov 2006 11:37:36 GMT

Hi ,

I have two internal tables with following fields

ITAB1

DATE1

TIME1

ITAB2

DATE2

TIME2

Now i need to subtract these two date and time from two internal tables and get the result in Hours .

Give function module name or sample code

Thanks

Points Will be assigned

Re: Function Module

Former Member — Thu, 09 Nov 2006 11:40:41 GMT

Hello,

Loop at itab1.

read table itab2 index sy-tabix.

if sy-subrc eq 0.

date = itab1-date1 - itab2-date2.

time = itab1-time1 - itab2-time2.

endif.

clear itab1.

clear itab2.

endloop.

Re: Function Module

Former Member — Thu, 09 Nov 2006 11:43:44 GMT

U can use the FM CCU_TIMESTAMP_DIFFERENCE, it gives the difference in seconds which can be divided by 3600 to get hours.

loop at itab1.

read table itab2 index sy-tabix.

concatenate itab1-date1 itab1-time1 into lts1.

concatenate itab1-date2 itab1-time2 into lts2.

call function 'CCU_Timestamp_difference'

exporting

timestamp1 = lst1

timestamp2 = lst2

importing

difference = ldiff.

ldiff = ldiff / 3600.

endloop.

Re: Function Module

Former Member — Thu, 09 Nov 2006 11:45:07 GMT

Loop at itab1.

read table itab2 index sy-tabix.

if sy-subrc eq 0.

date = itab1-date1 - itab2-date2.

time = itab1-time1 - itab2-time2.

total_hrs = (date * 24) + time.

append total_hrs.

endif.

endloop.

santhosh

Message was edited by: Kaluvala Santhosh

Re: Function Module

Former Member — Thu, 09 Nov 2006 11:49:14 GMT

good

go through this function module

RP_CALC_DATE_IN_INTERVAL Add/subtract years/months/days from a date

thanks

mrutyun^

Re: Function Module

Former Member — Thu, 09 Nov 2006 11:50:50 GMT

use fm...
call function 'GET_DELTA_TIME_FROM_DT'
     exporting
          t1 = uzeit1
          t2 = uzeit2
          d1 = datum1
          d2 = datum2
     importing
          t3 = result.
 
 
          write:/ result.

Re: Function Module

Former Member — Thu, 09 Nov 2006 11:56:49 GMT

Hi Shiba,

you can use the function module CCU_TIMESTAMP_DIFFERENCE. This will give the difference in seconds.

You can convert it to years or days as per your requirement.

data : dt1 like CCUPEAKA-TIMESTAMP,

dt2 like CCUPEAKA-TIMESTAMP,

diff type i,

days type i,

years type i.

dt1 = '20050101111111'.

dt2 = '20040101112222'.

CALL FUNCTION 'CCU_TIMESTAMP_DIFFERENCE'

EXPORTING

timestamp1 = dt1

timestamp2 = dt2

IMPORTING

DIFFERENCE = diff

write : / 'Difference in seconds', diff.

*If you want diff in hours

diff = diff / 3600.

reward if helpful.

regards,

keerthi.

Re: Function Module

Former Member — Thu, 09 Nov 2006 11:58:04 GMT

hi,

d = itab2-v - itab1-v. diff of dates

t2 = itab2-t - itab1-t. diff of times

translate d using '- '. to remove '-' sign at the end

translate t2 using '- '.

(or)

d = itab1-v - itab2-v. diff of dates

t2 = itab1-t - itab2-t. diff of times

d = d * 24. to convert days into hours

t2 = t2 / ( 60 * 60 ). to convert seconds into hours

r = d + t2. total

write:/ d,t2,r.

do assign points if it helps you

Re: Function Module

Former Member — Fri, 10 Nov 2006 05:15:41 GMT

Thanks for your replies . Assigned Points to everyone

Re: Function Module

Former Member — Fri, 10 Nov 2006 10:05:08 GMT

hi,

i think this is usefull to u........

call function 'GET_DELTA_TIME_FROM_DT'

exporting

t1 = uzeit1

t2 = uzeit2

d1 = datum1

d2 = datum2

importing

t3 = result.

write:/ result.

with regards

m.srikanth.(review the points if it is usefull)

Re: Function Module

Former Member — Fri, 10 Nov 2006 10:09:08 GMT

Hi,

For avoiding confusiong , try to put all data in one internal table and use an use FM sd_datetime_difference, pass date1 as earlier date, date2 as later date and enter time1 and time2 .

Regards,

Raghav