Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

RSDRD_SEL_DELETION ODS problems

Hi,

I am working on an abap program in my process chain before load data to an ods. This abap selectively delete from an ods. I need in the ODS only data between a date range. I tried with l_s_range-option = 'NB' assuming this in "Not between" but this option delete all the ODS, I tried to with GT start date and then LT end date, but when insert the LT in l_thx_sel this record is not inserted. So I tried to GT first and execute the FM RSDRD_SEL_DELETION, clear the internal table, change the l_thx_sel to LT and the end date then execute the FM RSDRD_SEL_DELETION. And this FM does not work.

I assume is because is very close to each other, but is really for this?

What else I can do?

Thanks.

code example

startdate = SY-DATUM.

enddate = FECHAI - 91.

clear: l_sx_sel, l_s_range.

l_sx_sel-iobjnm = 'ZDATE'.

l_s_range-sign = 'I'.

l_s_range-option = 'GT'.

l_s_range-low = startdate.

l_s_range-keyfl = 'X'.

append l_s_range to l_sx_sel-t_range.

insert l_sx_sel into table l_thx_sel.

call function 'RSDRD_SEL_DELETION'

EXPORTING

i_datatarget = 'ZCR_DCRP'

I_THX_SEL = L_THX_SEL

I_AUTHORITY_CHECK = 'X'

I_THRESHOLD = '1.0000E-01'

I_MODE = 'C'

I_NO_LOGGING = ''

I_PARALLEL_DEGREE = 1

I_NO_COMMIT = ''

I_NO_ENQUEUE = ''

CHANGING

C_T_MSG = L_T_MSG.

clear: l_sx_sel, l_s_range.

l_sx_sel-iobjnm = 'ZDATE'.

l_s_range-sign = 'I'.

l_s_range-option = 'LT'.

l_s_range-low = enddate.

l_s_range-keyfl = 'X'.

append l_s_range to l_sx_sel-t_range.

insert l_sx_sel into table l_thx_sel.

call function 'RSDRD_SEL_DELETION' " THIS CODE IS NOT WORKING!!!!!!!!!!!!

EXPORTING

i_datatarget = 'ZCR_DCRP'

I_THX_SEL = L_THX_SEL

I_AUTHORITY_CHECK = 'X'

I_THRESHOLD = '1.0000E-01'

I_MODE = 'C'

I_NO_LOGGING = ''

I_PARALLEL_DEGREE = 1

I_NO_COMMIT = ''

I_NO_ENQUEUE = ''

CHANGING

C_T_MSG = L_T_MSG.

Former Member
Not what you were looking for? View more on this topic or Ask a question