topic Re: Simple error in Application Development and Automation Discussions

Simple error

Former Member — Wed, 02 Jul 2008 07:17:20 GMT

Hi Experts,

I am doing aging report. In the for the days i should subtract duedate from document date.

days = duedate - document date.

Here the problem is some times bcoz of the wrong data.. im getting -days(minus ) . so in order to avaoid this i want to skip the document number.. when ever - or * anything come like this.

How to solve this problem.

Regards,

Sunita.

Edited by: Craig Cmehil on Jul 3, 2008 3:30 PM

Re: Simple error

Subhankar — Wed, 02 Jul 2008 07:20:55 GMT

please use the FM..HR_SGPBS_YRS_MTHS_DAYS

DATA: l_day TYPE i,

l_month TYPE i.

IF p_dper = c_check.

CALL FUNCTION 'HR_SGPBS_YRS_MTHS_DAYS'

EXPORTING

beg_da = s_budat-low

end_da = s_budat-high

IMPORTING

no_day = l_day

no_month = l_month

EXCEPTIONS

dateint_error = 1

OTHERS = 2.

IF sy-subrc <> 0.

MESSAGE e000 WITH

'Date range can not be calculated'(037).

ENDIF.

Re: Simple error

sachin_mathapati — Wed, 02 Jul 2008 07:22:53 GMT

Hi Sunita ,

Check if Document date is less than duedate before Subtracting.

If Doc date is Greater than due date the use the FM to subtract two dates..

FIMA_DAYS_AND_MONTHS_AND_YEARS -- u2013 Calculates the difference between two dates

Regards,

Sachin M M

Edited by: Jan Stallkamp on Jul 2, 2008 12:59 PM

Re: Simple error

former_member195383 — Wed, 02 Jul 2008 07:28:51 GMT

data : wf_char type char10.

wf_char = days.

if wf_char+0(1) eq '-'.

skipp the rest of the logic.....

Try the above...it will work..

Edited by: Jan Stallkamp on Jul 2, 2008 12:59 PM

Re: Simple error

Former Member — Wed, 02 Jul 2008 07:29:15 GMT

hi sunitha, check due date & doc. date

LOOP AT wa_tab INTO itab.

IF wa_tab-duedate GT wa_tab-Docdate.

days = w_tab-duedate - wa_tab-document date.

ELSE.

CONTINUE.

ENDIF.

ENDLOOP.

or in else part u can delete that record before continue.

Edited by: venkat reddy on Jul 2, 2008 9:29 AM

Re: Simple error

Former Member — Wed, 02 Jul 2008 08:41:33 GMT

Hey Prasana,

Thanks For your help. Issue completed.

Regards

Sunita.

Re: Simple error

kesavadas_thekkillath — Wed, 02 Jul 2008 08:46:24 GMT

if days < 0.

skip.........

endif.