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

generic delta?

hi sdn,

i have created generic data source on kna1 for the field lifnr as numeric pointer,so when i am creating the entries into kna1 other than lifnr field,then will the data populate in RSA7,or until the change happens to that particular record ?,if i create entries by leaving that delta field blank,to where the data will move?to application tables or to somewhere else..

thanks in advance

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jun 28, 2012 at 01:12 PM

    Hi Kumar,

    When you are going with Numeric Pointer then that fields should populated for new and changed records(new value for changed/new records). when you have change in field lifnr then you will get records in RSA7.

    Regards,

    Venkatesh

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 29, 2012 at 05:34 AM

    Hi Kumar

    Normally Data will be in application tables unless delta works it will not be in RSA7 and later to Application Tables..
    But Basically how come without having a primary key you can create a table ? Its meaning less.. so

    Field for Numeric pointer must be a Key field or primary key as said..

    As the generic data goes with Numerical Pointer As Delta update , the Field lifnr contents will be New and the first Load will Take all the data.. As Delta Update Always checks For NEW/CHANGED Records......

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 29, 2012 at 04:22 AM

    HI

    Whenever u made the lifnr as numeric delta then that field act like a primary key , so u have to pass some value and the extractor will decide whether the coming record is change / new record based on this lifnr field only . so u have to pass some value to that field.

    Hope u got it,

    Regadrs,

    RaviChandra

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 29, 2012 at 09:34 AM

    Safety intervals will be available for calendar day & Time stamp..... 😊

    For Time stamp there will be two intervals available

    Upper Limit [ ]
    Lower Limit [ ]

    There is a time stamp scenario set for 1/2 an hour 30mins... so for every half an hour delta load takes place and updates the new records....

    so consider

    1. A process RQ7 has been initiated @9.55 AM and the request status is yellow till 10.00 AM and gets completed @ 10.10 AM

    2. Now @10.00 AM a delta load1 is triggered when it reaches the RQ7 the status of the request is yellow(as it saved @10.10 oly) so this delta leaves the request thinking that it will be fetched by next load after saved so this delta load1 leaves the RQ7 .

    3. Now @10.30 AM the next load Delta2 triggers this delta2 when reaches the RQ7 thinks that it had been saved @10.10AM so it would have been Fetched by the Delta1 itself , so it ignores RQ7.

    At last RQ7 is not fetched and there will be Data Loss....

    In This scenario we will have

    Upper Limit [30mins]

    Lower Limit [30mins]

    so the delta1 will check from 9.30 and loads , similarly delta2 will check 30mins prior and loads the data so there will be all Requests loaded successfully.

    Lower Limit [ last success full load ]


    Upper limit[9.30]

    Lower Limit[Time That delta1 finish i.e green status]

    Think that this would have helped you to understand the concept as a whole.......😎

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 29, 2012 at 06:46 AM

    Hi Kumar

    See What ever may be the delta type for generic source , there must be a key field...

    Ie either Numerical pointer, calendar day ,time stamp...

    Coz.. Take a scenario for calendar day... we set 1 day as period.. so for every one day the check for new or changed record goes... but based on which condition it will check whether its a new record or changed record ..??? so based on any change in key field the delta works... and Updation goes as Delta Update...

    Same case for Time Stamp.. But there we set Time limit.. Upper limit & lower limit it takes quite long to explain...

    If needed 'l...

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi,

      Safety intervals are applicable for all delta types; however it is mostly usable with 'Timestamp' only (with CALDAY, it is normal to have the lower limit blank and upper limit as '1').


      Consider values are Upper limit (5), lower limit (1) [specified in safety intervals]

      Case 1 - Numeric pointer (last extracted value 10011; Data in underlying table (Max value = 10025) )
      Data would be extracted from a min-value of 10010 (lower limit adjusts the last counter 10011 by specified value -1) max-value of 10020 (after adjustment for upper safety limit by -5). The current pointer would now indicate 10020 in RSA7.


      Case 2 - Timestamp (Last extracted value 20060804113000; current system time: 20060805080000)
      Next extraction will select records from timestamp value 20060804112959 (after adjusting 1 second as specified in lower limit) to timestamp value 20060805075955 (adjusting it by 5 seconds as specified in upper limit).

      Similar would be the case for calendar days, however, since there is not a likelihood of records overlapping over days, the limits are not used for such delta type.

      Regards

      Chandu

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.