Table ROOSGENDLM

[#1]

Hi experts,

Is there anyway to track the changes on ECC table ROOSGENDLM  for a particular BW datasource?

Thanks.

Amine

[RamanKorrapati · Accepted solution]

Hi,

Above table is related generic data source delta settings.

Whats your data source and what you need find?

by using above table we can see last loaded delta details.

Thanks

[Former Member · Accepted solution]

Hi Raman,

I need for example to check the value of the pointer of a FIGL datasource for the 3 last loadings.

Is that possible?

Amine

[anshu_lilhori · Accepted solution]

In case of FI you need to check the following tables

BWOM2_TIMEST

BWFI_AEDAT

Alternatively you can also check the SAP Note 401646.

Hope this is what you are looking for.

Regards,

AL

[Former Member · Accepted solution]

Hi Anshu,

Thanks for your answer.

What i am looking for is the following :

Sometimes, we have datasources working with timestamp as delta. So when the loading is done, the value of the the timestamp is registred in ECC table ROOSGENDLM.

Let's say that today the value of the timestamp was 20140417.

Tomorrow it will be 20140418. So the previous value 20140417 was deleted from ROOSGENDLM and replaced by 20140418.

Me i am looking for a way to know that the yesterday the value was 20140417.

Hope it's more clear . I don't know if there are other tables where those information are stored.

Amine

[RamanKorrapati · Accepted solution]

we can't see request basis but you can find date basis change record history for

FI -GL at table - BWFI_AEDA2:

Based on your delta loaded request time you can keep filter on time or find the records of last 3 requests.

[anshu_lilhori · Accepted solution]

In case of FI datasources you can check the timestamp value in the table which i gave in my last reply.

If you have some other datasources then we need to check and understand where the history is stored.

Regards,

AL

[Former Member]

Thanks guys.

Amine

[Former Member]

Yes..

The concept is 'Change document'.

ABAPer is aware of this concept.

[Former Member]

Hi Roger Federer

You mean that there are any other tables where the changed information are stored?

Amine

[Former Member]

Hi,

We can track the changes related to FI Datsource throught the table BWFI_AEDAT.

else u can also go for View *AEDAT will give the list of view for AR,AP and GL  Docs .

[Former Member]

Hi Sachin,

In fact it's useful. But it would be nice if there is a generic tool for all the datasources, not only the FI ones.

Amine

[Former Member]

yes.

every change of a table is stored in another R/3 table.

CDHDR

CDPOS

[Former Member]

Those are MM tables.

Amine