Finding changes in SAP tables

[Former Member]

Hi,

I have problem with SAP - Cognos interface. It functions like an ABAP program that generates a file from spec. fields of some SAP tables like BKPF, BSEG, BSID, BSIK, etc. And this is all OK, but problem is that report always selects ALL data, and in FI case(those table that I mentioned) this is complicated. For example one item is in some period open item, and in few days it will go to closed items. As COGNOS interface runs once in a Month or something like that, it is problem how to select proper data, because of huge amount FI data.

Any Idea how to select only changes at table level? This must be also applicable to MM, SD and CO data. I thought of CHANGE DOCUMENTS, but what if change is not traced in CDHDR table because some data element is used in SAP table is not check to be observed as Change Document?

[Former Member]

Mario,

For the changes, when ever there is a change done in the system a change number is created which will be available in table CDHDR, based on the Object classes extract the data and the required dates of changes made pull out the data.

In case for AP, AR, G/L you can check with some tables ( there are some tables which will be only be updated based in the process AP/AR/GL ). Based on the list of these tables, extract data from table CDPOS using the Change Number obtained from CDHDR.

Anmol Saxena.

[Former Member]

Hello,

If for a specific set of tables no change documents are triggered by SAP you can always setup your own Change Document Object with transaction SCDO.

Of course you need to be careful with this transactions (how big is the table data, how many changes, etc...).

Wim Van den Wyngaert

[Former Member]

Hi,

Table CDPOS, CDHDR contains database changed values.

Regrds,

Rajneesh