cancel
Showing results for 
Search instead for 
Did you mean: 

Sample code of start routine filter out unwanted data by field value

jennychen1
Participant
0 Kudos

Hi, Experts:

We are using BW3.5. I need to run delta load from an ODS1 to another ODS2 or Cube2 with only selected data. The unwanted data will be idetified by a field ITEMCATEG with values in a exclude list like ("ABC", "DEF"...).

In the infopackage, the selection tab is blank. Reading from other posting, selection does not seem to be possible for delta load from a ODS source. Is it right?

If can't select from infopackage, I am thinking of using start routine to load only selected data. But I am not good at ABAP coding. Can someone please kindly provide me a sample code of start routine that can filter out unwanted data by a value of a field?

Many thanks!

Jenny

Accepted Solutions (0)

Answers (3)

Answers (3)

mansi_dandavate
Active Contributor
0 Kudos

Hi,

Use the following statement...

Delete data_package where item_categ in ('ABC' , 'DEF').

Regards,

Mansi

former_member208595
Active Participant
0 Kudos

Hi,

DELETE data_package where ITEMCATEG = 'ABC' ,'DEF', .....

ssurampally
Active Contributor
0 Kudos

Hi jenny,

if you wanted to eliminate the recodes with itemcateg has value ABC' You can put the code,

DELETE data_package where ITEMCATEG = 'ABC'