Function Module for selective deletion

[Former Member]

Hi Experts,

Is there any function module that will enable us to perform selective deletion of data from the InfoCube? I am aware that we can do selective deletion from the InfoCube using the front-end functionality in the following manner:

InfoCube >> Manage>>Contents>>Selective Deletion

But I want to know whether I can do the same thing using a function module.

If anyone has come across such a function module, please let me know

THank you for your inputs

Deepa

[Former Member · Accepted solution]

Deepti

Check this if it helps

Thnaks

Sat

[Former Member · Accepted solution]

Hi,

in the transaction 'DELETE_FACTS' it is possible to generate deletion programs .... that can be included in process chains or that can be run manually to delete the required data.

Siggi

[Former Member]

Hi,

You can use function module RSDRD_SEL_DELETION. Here's a sample code:

type-pools: rsdrd, rsdq.

data:

l_s_range type rsdrd_s_range,

l_sx_sel type rsdrd_sx_sel,

l_t_msg type rs_t_msg,

l_thx_sel type rsdrd_thx_sel,

l_t_seltxts type rsdq_t_seltext

with header line.

*Select 0MATERIAL selection

clear: l_sx_sel, l_s_range.

l_sx_sel-iobjnm = '0MATERIAL'.

move: c_i to l_s_range-sign,

c_eq to l_s_range-option,

space to l_s_range-high,

c_x to l_s_range-keyfl.

l_s_range-low = '123456'.

append l_s_range to l_sx_sel-t_range.

insert l_sx_sel into table l_thx_sel.

*Select 0PLANT selection

clear: l_sx_sel, l_s_range.

l_sx_sel-iobjnm = '0PLANT'.

move: c_i to l_s_range-sign,

c_eq to l_s_range-option,

space to l_s_range-high,

c_x to l_s_range-keyfl.

l_s_range-low = '1111'.

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 = 'ZYOURCUBE'

i_thx_sel = l_thx_sel

i_authority_check = rs_c_true

i_no_logging = space

i_parallel_degree = space

i_show_report = space

CHANGING

c_t_msg = l_t_msg.

Hope this helps.