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

delta init and selection criteria


While initializing delta for a datasource you can specify a selection criteria.. for e.g. in 0ARTICLE_ATTR you can specify selection criteria for MATNR field.

What is the meaning of this selection criteria?

Is this used to track delta changes?

Is there any doc that explains the use of this selection criteria?



Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2004 at 01:06 PM

    Hi Mihir !

    If you use MATNR in selection, you will be able to extract only these MATNR codes!

    clearly, when you perform a delta, all the records extracted will be in coherence with the init, if you'wll need some other articles, you have to add these codes in additional init loads.

    Generally speacking:

    - in your source system, in table ROOSFIELD, you can see all the fields for which you can perform a selection per datasource (field 'selection' = 'X')

    - when you perform an init, data are loaded in accordance to these selections

    - if you don't put anything, you will extract all

    - when you perform a delta load, you will extract records in accordance to the same init selections

    - if you do several init (this is possible, but the selection conditions have to be not overlapping!), you will be able to perform only one delta with all the selections of all the init load (merged)

    Hope it helps...



    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 03, 2004 at 01:08 PM

    Hi Mihir

    The selection criteria for the init delta can very much be compared with a standard full load. Basiclly it means that you will only get an initial load of data for the criterias which you enter ex. material number 9999 or calender day 01.2004 to 12.2004.

    However since this is a init delta it also means that all the future delta loads will only deliver delta data which is included in your initial delta selections. That is only records which are new or have been changed and where the calender day is between 01.2004 to 12.2004. All other data wil not be loaded wit your delta loads.

    Hope this helps You



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member


      if in your datasource management screen you are not able to set for selection your field, the reason it's the content of the field SELECTION in the table ROOSOURCE for your datasource...

      In SE38 you can write a little pgm that modifies the property of the field...



      OBJVERS = 'A' AND


      IF SY-SUBRC = 0.




      But if you are using this field for your generic delta I don't think you can use this field for your selection, because in extraction code in R/3 there is a check (and a comparison) between the new extracted records and the NUMC of the last record, you can reach some inconsistencies....(or otherwise you have to re-init you r flow..)



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.