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.