on 06-30-2010 5:18 PM
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.
does not permit two secuencially delete
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.