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

Generic Delta

Hi all,

I need soem help in deciding the best option.

Generic delta can be achieved in two ways.

1. Create two Datasources on R/3 side and give two different fields for generic delta

2.Create two infopackages for one datasource.Routine for Selection criteria of those two delta fields.

can anyone suggest which one will be the best option to implement in BI 7.0

Thanks in advance

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 21, 2008 at 11:05 AM

    Hi,

    I think your option 1) will be the best. But anyway, did you also think about deletions? How do you get deleted records to bw?

    regards

    Siggi

    Add a comment
    10|10000 characters needed characters exceeded

    • Hello,

      I think it is not necessary to create two datasources. If you will implement an datasource by a function module, you can use the field for delta (e.g. date field) for selection of create date and change date. So you have one datasource which can deliver created and changed records.

      Example:

      Delta-Field: ZDATE.

      OPEN CURSOR L_CURSOR AS

      SELECT *

      FROM Z_TABLE

      WHERE ERDAT IN R_ZDATE

      OR AEDAT IN R_ZDATE.

      So you will get created record and changed records since the last update to BW.

      Regards,

      André

  • Posted on May 21, 2008 at 11:07 AM

    Hi,

    Its better if you prefer the first option.

    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.