Question Re: How to calculate difference between two dates in Technology Q&A

How to calculate difference between two dates

Former Member — Wed, 27 Feb 2013 15:49:23 GMT

Hi,

I know there are similar posts related to this; I've gone over them but didn't quite get what I wanted. I need to calculate the difference between two dates ClearingDate and NetDueDate and the result should be a number stored into a Characteristic called OnTime which will be in a Standard DSO and the cube above it. How can I achieve this? I would appreciate a step-by-step solution if possible. I am not proficient in ABAP and hence if there is coding involved, please provide the actual code too. I need it urgently. I will appreciate the help and points will be awarded.

Thanks in advance.

Re: How to calculate difference between two dates

Former Member — Wed, 27 Feb 2013 16:10:38 GMT

so you will have to connect to the 2 dates to your info object in your transformation.

define routine on this object and in your routine do this

DATA: EDAYS LIKE VTBBEWE-ATAGE,

EMONTHS LIKE VTBBEWE-ATAGE,

EYEARS LIKE VTBBEWE-ATAGE.

PARAMETERS: clearingdate LIKE VTBBEWE-DBERVON,

netduedate LIKE VTBBEWE-DBERBIS .

call function 'FIMA_DAYS_AND_MONTHS_AND_YEARS'

exporting

i_date_from = clearingdate

i_date_to = netduedate

* I_FLG_SEPARATE = ' '

IMPORTING

E_DAYS = EDAYS

E_MONTHS = EMONTHS

E_YEARS = EYEARS.

that should give you the number of days your edays will the difference in days.. the fucntion moduel exists in R/3 i am not sure if it exists in Bw system, so you could copy the code from r/3 and create your own function module in Bw and call your..

Re: How to calculate difference between two dates

Former Member — Wed, 27 Feb 2013 16:20:18 GMT

Thanks Amer. Appreciate the quick response. As I said earlier, I'm not too comfortable with writing routines, etc. but the code that you mentioned in your response, is that exactly what I can copy and paste into the field routine? Will my characterstic "OnTime" show the number of days with the code above? We are particularly looking for a positive, negative or a zero value to be populated into OnTime.

What is the name of the function module in ECC?

Re: How to calculate difference between two dates

anshu_lilhori — Wed, 27 Feb 2013 17:20:44 GMT

Hi,

Just map your two date fields to the infoobject in which you want to get the difference.

And write simple field level routine.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/609eea32-455e-2c10-c08a-c23adf8c934e?quicklink=index&overridelayout=true

Check the page 7 of the above doc.it has the code with screen shot.

No need to use any function module for it.

Regards,

Re: How to calculate difference between two dates

Former Member — Wed, 27 Feb 2013 17:25:39 GMT

Thanks Anshu. I was going through the transformations and noticed that there is a formula called DATE_DIFF (Date Difference: Calculates the difference in days between two specified dates). Why can't we use that? Why does it have to be a routine? Just curious about it. Please advise.

Thanks!

Re: How to calculate difference between two dates

Former Member — Wed, 27 Feb 2013 17:30:10 GMT

You can use this formula but you need to specify the dates as key figure in your cube/dso.

Cheers!

Re: How to calculate difference between two dates

bishwajit_das — Wed, 27 Feb 2013 17:32:55 GMT

Hi,

Please try this FM:

DAYS_BETWEEN_TWO_DATES

you have other options also if you want..

DAYS_BETWEEN_TWO_DATES

LEAP_DAYS_BETWEEN_TWO_DATES

HR_SEN_CALE_DAYS_DATE

ISB_DAYS_BETWEEN_TWO_DATES

FIMA_DAYS_BETWEEN_TWO_DATES

FIMA_DAYS_BETWEEN_TWO_DATES_2

FIMA_LEAP_DAYS_BETWEEN_2_DATES

SD_DATETIME_DIFFERENCE Give the difference in Days and Time for 2 dates

Regards,

Bishwajit.

Re: How to calculate difference between two dates

bishwajit_das — Wed, 27 Feb 2013 17:37:06 GMT

Hi,

Try this code:-

PARAMETER:p_date1 TYPE dats,

p_date2 TYPE dats.

DATA:lv_diff TYPE i,

lv_no_date type i.

CALL FUNCTION 'DAYS_BETWEEN_TWO_DATES'

EXPORTING

i_datum_bis = p_date1

i_datum_von = p_date2

IMPORTING

e_tage = lv_diff

EXCEPTIONS

days_method_not_defined = 1

OTHERS = 2.

IF sy-subrc <> 0.

WRITE:/ 'Error'.

ELSE.

WRITE:/ lv_diff.

ENDIF.

if lv_diff < 0.

lv_diff = lv_diff * -1.

endif.

lv_no_date = lv_diff - 1.

Thanks,

Bishwajit.

Re: How to calculate difference between two dates

anshu_lilhori — Wed, 27 Feb 2013 17:37:25 GMT

Hi,

Yes you can use that formula as well.it should produce the same result what that routine is gonna do.

Re: How to calculate difference between two dates

Former Member — Wed, 27 Feb 2013 17:42:05 GMT

Hey Suyash,

How would I do that (specify as keyfigures in DSO and cube)? I have two dates, 0CLEAR_DATE and 0NETDUEDATE. Simply using the formula won't work? Please advise.

Re: How to calculate difference between two dates

Former Member — Wed, 27 Feb 2013 18:29:21 GMT

yes it should work , 1 way to find out, is to plug and try it :-), there is a check in the bottom of transformation for you to test it out, if u r on 7.0 version of bw

Re: How to calculate difference between two dates

Former Member — Thu, 28 Feb 2013 15:53:07 GMT

Hey Anshu,

I have been asked to get only Open Items managed into the DSO. How can I do that? I have been researching a LOT and I'm confused now. There is an indicatory in BSEG called XOPVW which is called Open Item Management. There were a few suggestions of checking if the GL account masterdata has an attribute to indicate OI management but I don't see it. We don't want to bring it at the transaction level (because thats what XOPVW is). Any suggestions? I'm stuck bad and not sure how to proceed.

The issue is that we are using 0fi_gl_14 and need to leverage that. We have added aging related fields to the extractor and are loading into a write-optimized. I've been looking at BSEG and there is an Open Items Management field (XOPVW) which we are not bringing to the extractor (yet). Any idea what I could do from this point onwards?

If there is another route you can suggest, then please do in a step-by-step manner. It's urgent. I appreciate the help. The end goal is to create Aging reports for Customer and Vendor. HELP.

Re: How to calculate difference between two dates

anshu_lilhori — Thu, 28 Feb 2013 16:10:11 GMT

Hi,

It would be better if you open up a new thread with proper subject line.As this thread is already closed and had a different content.

More people may give inputs if you do as stated above.

Regards,