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

delta init and selection criteria

Posted on Dec 03, 2004 at 12:32 PM 29 Views

hi

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?

Regards

Mihir

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

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

    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 selection..so, 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...

    Bye,

    Roberto

    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
    0

    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

    Regards

    /Frank

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member
      Dec 06, 2004 at 10:32 AM

      Murali,

      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...

      SELECT SINGLE * FROM ROOSFIELD

      WHERE OLTPSOURCE = Zxxxxx AND

      OBJVERS = 'A' AND

      FIELD = GREYFIELD.

      IF SY-SUBRC = 0.

      ROOSFIELD-SELECTION = 'X'.

      MODIFY ROOSFIELD.

      ENDIF.

      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 loaded...so, you can reach some inconsistencies....(or otherwise you have to re-init you r flow..)

      Bye,

      Roberto

    Comment on This Answer

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.