12-12-2009 6:13 AM
Dear All Expert's.
i wnt to calculate pending payment day. my query as follows
if 30_DAYS = 'X'.
DELETE ITAB WHERE C_DATE > 30.
endif.
if 45_DAYS = 'X'.
DELETE ITAB WHERE C_DATE > 45
endif.
if 60_DAYS = 'X'.
DELETE ITAB WHERE C_DATE < 45 and C_DATE > 60.
endif.
if 90_DAYS = 'X'.
DELETE ITAB WHERE C_DATE < 60 and C_DATE > 90.
endif.
if GT_180 = 'X'.
DELETE ITAB WHERE C_DATE < 180.
endif.
* APPEND ITAB.
ENDLOOP.
C_DATE = no of due day.
i put redio button option for due day select.
if user select 45 day option then show only data between 30 and 45 days.
Please give me idea,
Thanks
Bhavesh
12-12-2009 9:32 PM
Hi Bhavesh Panchal,
I don't see the question. You can calculate the no of due day by subtracting SY-DATUM from DUE DATE.
Regards,
Clemens
12-14-2009 4:52 AM
Dear Sir,
Thnks for Reply,
i already calculated due date form system date.
here i put 4 option for report selection. i wnt to fetch data only like this "which is due day = 30", "which is due day = 30 to 60", "which is due day = 60 to 90",
Please give me some idea,
above query is for that.
thanks
Bhavesh