topic Re: Function module to count periods elapsed in Application Development and Automation Discussions

Function module to count periods elapsed

Former Member — Wed, 20 Jul 2005 22:39:40 GMT

Hi SAPients!

Is there an FM to get the number of periods elapsed counting from one date or period.

Example:

If I send as parameter 200207 or 20020701 the FM should return 36, because 36 (monthly) periods have elapsed since then.

I tried SE37 but I can´t find the right one.

Or... do you know other way to do this?

Thank you.

Former Member — Thu, 21 Jul 2005 03:12:55 GMT

Hi Ricardo,

Try this one:

SD_DATETIME_DIFFERENCE

Give the difference in Days and Time for 2 dates

also check out :

DAYS_BETWEEN_TWO_DATES

Regards,

Anjali

andreas_mann3 — Thu, 21 Jul 2005 06:24:47 GMT

Hi,

try fm FIMA_DAYS_AND_MONTHS_AND_YEARS

-> but i think, it's not exact, so you should try this:

mthp = ( ( sy-datum - p_datum ) /   ( 365 / 12 ) ).
month = trunc( mthp ).

regards Andreas

Former Member — Thu, 21 Jul 2005 06:29:03 GMT

hi,

try these

HR_99S_MONTHS_BETWEEN_DATES

MONTHS_BETWEEN_TWO_DATES_NEW

MONTHS_BETWEEN_TWO_DATES

HR_MONTHS_BETWEEN_TWO_DATES

regards,