Skip to Content
author's profile photo Former Member
Former Member

ABAP assistance

I want to write some logic in an update rule which will look up a master data (0CUSTOMER) object and will only load the data for the particular info object 0CUSTOMER in the cube if the value in the transaction data exists in the master data table. My thoughts are:

1. In the start routine carry out a lookup to the master data which I need to refer to - this I can do

2. In the info object routine delete or set to "" (not sure which is best) any record which does not match to a lookup value - need help with this

Could someone assist?

Thanks

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 18, 2008 at 01:45 PM

    Hi,

    I would also recommend the start routine. Read the master data into a internal table first using the 'for all entries' statement in the select clause and while looping at the datapackage make a read of the internal table with the customer no. If the customer no doesn't exist in the table, delete the current row from the datapackage.

    regards

    Siggi

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      well it is something like this:

      data: it_cust type standard table of /bi0/pcustomer,

      wa_cust type /bi0/pcustomer,

      l_index type sy-tabix.

      select * into table it_cust from /bi0/pcustomer for all entries in data_package where customer = data_package-customer.

      loop at data_package.

      read table it_cust into wa_cust

      with key customer = data_package-customer.

      if sy-subrc <> 0.

        • now its up to you. you either delete the record

      • delete data_package index l_index.

        • or you post a dummy value like space or '9999999999' to the field customer.

      • data_package-customer = '9999999999'.

      • modify data_package index l_index.

      • endif.

        endloop.

        No warrenty that it is syntactically correct.

        regards

        Siggi

    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.