Generic Delta

We have seen Extraction from Table, View , Infoset , and Fucntional module...

But the data sources created using all these wont have delta capability...

To get delta capability for this datasources we use generic delta

This is how delta mechanism work with calendar day... we must have a date field in source table...

we have an Upper time interval and Lower time interval.

we are doing our first data load on  2.01.2011

now upper time interval becomes 2.01.2011... and lower time interval is blank...

data will be loaded from source to target till 2.01.2011,

so SO1 and SO2 reaches target...

some new data is availabe in ECC tables... and we are doing a load on 4.01.2011

now value in upper time interval moves to lower time interval and date on which data loading is happening becomes the new upper time interval... so data records between the lower and upper time interval is only pulled to target... 

So,  SO3 and SO4 reaches Target...

This is how delta is handled using Calendar day..

Draw back..

Consider this scenario,

We have 2 postings on same day one at 10.00 AM and other at 5.00PM..

Now consider our first data load is happening at 12.00 AM on 2.01.2011...

On first load we will get SO1 and SO2...

Now second load is happening on 4.01.2011, our lower time interval will be set to 2.01.2011 and upper limit will be set to 4.01.2011

In this case we will loose our 1 record, ie, SO3

to avoid this we use safety interval upper limit and safety interval lower limit...

In this we ignore one day for a safety interval...

first load happens on 2.01.2011, upper limit set to 1.01.2011 and lower limit blank

when we load data to target 1 day is ignored .. so only SO1 reaches target...

second load happens on 4.1.2011, upper limit is set to 3.01.2011 and lower limit is set to 1.01.2011

Only disadvantage in this method is we will have a data latency of 1 day..

To overcome this data latency we can use Time stamp delta method..

The procedure is same as of Calendar day... only difference is we use TIME instead of DATE in upper limit and lower limit... 

If data is being loaded to DSO or Master data(Infoobject) then choose "new Status for changed Records"

If data loaded to Infocube, then choose "Additive Delta"

now we can see that our datasource have delta capability....

Best SAP training in Kerala

Best SAP training in Kochi

Best SAP training in Ernakulam

SAP FICO, SAP MM, SAP SD, SAP PP, SAP ABAP, SAP Basis, SAP SAC, S4Hana