Question:
Gurus,
We are trying to get the Incremental data from the SAP Transparent tables.
As much as we have seen , the Update Date columns are not updated for some of the tables.Some of the tables do not even have update columns.
We are aware of the CDHDR table( the change log) has the updates to most of the tables.
We are also aware of other interfaces like the Biz Content provided with the BW.
The API's provided with the same could be used.
But we want to hit directly the Core R3 tables for the data.
The questions as follows:
1.Are the Update dates reliable for the tables which have them?Or are they subject to the configuration/implementation of the SAP instance?
2.Are there are any key fields to look for in each of the subject areas with regards to the incremental load?
3.Do all the modules write to the CDHDR table?Any caveats of using this table?
4.Is there a different strategy required to pull data from Different subject areas (Transaction/Master Tables)
Your comments much appreciated,
thx
Answer:
Extracting data in delta mode requires analysis in each different case. Some objects are logged in CD-tables, but not all. You need an experienced ABAPer that will look at each case and create appropriate logic. As most of systems are customized to suit particular company and business processes, don't expect any general recipe.
_________________
ilya
More input data: http://abaplog.wordpress.com
Sapfans ABAP FAQ: /forums/viewtopic.php?t=94198
R's ABAP Knowledge Corner: http://www.Rard-harper.net/kb/kb.html
Function modules documentation: http://www.se37.com