Date Condition for payment due.

[Former Member]

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

[Former Member]

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

[Clemenss]

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

[Former Member]

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