topic Re: Delta Extract in Application Development and Automation Discussions

Delta Extract

Former Member — Thu, 27 Nov 2008 09:03:35 GMT

Hi All,

The System Landscape of current environment is Development, Quality, Pre-Production & Production. In production system has live data / transaction data. On a daily basis, we need to extract the delta of Master Data from production system and push it to pre-production system.

Master Data like..........Article, Vendor, Customer etc.,

If anyone has idea, please pass on the same.

Regards,

Ramki.

Re: Delta Extract

Former Member — Thu, 27 Nov 2008 09:26:15 GMT

If I get you correctly you might be trying to extract delta data . In every master table their will be date field(say Changed on ).

When u create an extractor u need to use this field in the Generic delta tab.

Revert back if more help is required.

Rhea.

Re: Delta Extract

Former Member — Thu, 27 Nov 2008 10:11:31 GMT

Hi Rhea,

As an Example, Vendor & Customer table does not have change date. Please let me know.

Regards,

Ramki.

Re: Delta Extract

Former Member — Thu, 27 Nov 2008 10:32:43 GMT

One more approach is having data from CDHDR & CDPOS. Every correction in SAP will make an entry in these tables. We need to get the basic key information like object class, date, time, transaction, change indicator. Retrieve information from CDHDR & CDPOS and collect the master data values per type like Vendor, Customer etc. Finally you will get a list of master data to be retrieved. Then use interfaces to transfer data between systems.

Could get only this approach for now and will update you if come across other alternatives.

Regards,

Prasanth

Re: Delta Extract

Former Member — Thu, 27 Nov 2008 11:05:15 GMT

Standard extractors are available for most of the master data .

For ex 0customer_attr for customer data.

Rhea.