Skip to Content
0
Former Member
Jan 11, 2006 at 09:50 PM

Help needed in Abap

24 Views

Hi all;

I am trying to delete the request from cube except the last load of the month(we have daily load now so assume that last day of the month) of the fiscal period. I am writing the following code in the delete routine, but can't figure out how to avoid the lastday of the month in fiscal period.

Could anyone help me!

TABLES: RSMONICDP.
DATA:  request LIKE RSMONICDP-RNR,
ts LIKE RSMONICDP-TIMESTAMP.
   
 loop at l_t_request_to_delete.

        SELECT DISTINCT RNR INTO request FROM RSMONICDP
               WHERE ICUBE = 'Zdis_c01'.
               SELECT TIMESTAMP INTO ts FROM RSMONICDP
               WHERE RNR = request.
               ENDSELECT.
    (how do I avoid the last day of the month here ?)

        CALL FUNCTION 'RSSM_DELETE_REQUEST'
        EXPORTING REQUEST = request
        INFOCUBE = 'Zdis_c01'.
        ENDSELECT.

  endloop.

     clear p_subrc.

Thank you.

Krishma.