RSDRD_SEL_DELETION - Selective Deletion of ODS??

[Former Member]

Hi,

I need to Delete certain records from the Active ODS table in an Update rule. Could anyone please provide me with an example of how to use this function Module or any other function module oo any other idea..

Appreciate your help,

Thanks and Regards

Andy

[Former Member]

Hi,

Please use the sample

CALL FUNCTION 'RSDRD_SEL_DELETION'

EXPORTING

i_datatarget = i_odsobject

i_thx_sel = l_thx_sel

I_DEL_ACTIV = RS_C_FALSE

I_DEL_UPDATE = RS_C_TRUE

I_AUTHORITY_CHECK = RS_C_FALSE

*INSERTAS 19122002 P9 <581897>

*table is not copied - only delete is performed

I_MODE = 'D' "RSDRD_C_MODE-DELETE

• I_MODE = 'C' "RSDRD_C_MODE-CHOOSE

*ENDINSERTAS 19122002

• I_THRESHOLD = '0.1'

• I_PARALLEL_DEGREE = 1

• I_NO_COMMIT = RS_C_TRUE

*INSERTAS 13082002 P12/05 <541698>

*Commit - No rollback segment overflow...

I_NO_COMMIT = RS_C_FALSE

*ENDINSERTAS

I_NO_ENQUEUE = RS_C_TRUE

I_SHOW_REPORT = RS_C_FALSE

I_TRANSACTIONAL_ODS = RS_C_FALSE

changing

c_t_msg = c_t_meldungen

EXCEPTIONS

X_MESSAGE = 1

INHERITED_ERROR = 2

INVALID_TYPE = 3

OTHERS = 4

.

Thank you

arun

[Former Member]

Hi Arun,

Thanks for your reply. Please help me understand this..

I need to Delete a single record with particular Deliv-Numb or an Internal table with delivery numbers which have been qualified to be deleted.

Where would I call this function and how do I provide this as INPUT to the function.

Is there any further information about the different parameter names.

Thanks and Regards

Andy

CALL FUNCTION 'RSDRD_SEL_DELETION'

EXPORTING

i_datatarget = i_odsobject

i_thx_sel = l_thx_sel

I_DEL_ACTIV = RS_C_FALSE

I_DEL_UPDATE = RS_C_TRUE

I_AUTHORITY_CHECK = RS_C_FALSE

*INSERTAS 19122002 P9 <581897>

*table is not copied - only delete is performed

I_MODE = 'D' "RSDRD_C_MODE-DELETE

• I_MODE = 'C' "RSDRD_C_MODE-CHOOSE

*ENDINSERTAS 19122002

• I_THRESHOLD = '0.1'

• I_PARALLEL_DEGREE = 1

• I_NO_COMMIT = RS_C_TRUE

*INSERTAS 13082002 P12/05 <541698>

*Commit - No rollback segment overflow...

I_NO_COMMIT = RS_C_FALSE

*ENDINSERTAS

I_NO_ENQUEUE = RS_C_TRUE

I_SHOW_REPORT = RS_C_FALSE

I_TRANSACTIONAL_ODS = RS_C_FALSE

changing

c_t_msg = c_t_meldungen

EXCEPTIONS

X_MESSAGE = 1

INHERITED_ERROR = 2

INVALID_TYPE = 3

OTHERS = 4