Skip to Content

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Posted on May 24, 2009 at 05:22 AM

    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'

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 24, 2009 at 02:50 PM

    Hi,

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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 24, 2009 at 03:06 PM

    Hi,

    Use the following statement...

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

    Regards,

    Mansi

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.