ABAP FM to check timestamp datasource/infosource

[Former Member]

Is there an ABAP FM to check the time-stamps of a datasource / infosource?

I want to use this to check if there are any datasources that need replicating before we start the main dataload process chain.

[Former Member · Accepted solution]

Hi,

You need to refer the table in R/3(source system). In BW check the table RSOLTPSOURCE.

Bye

Dinesh

[Former Member · Accepted solution]

in R/3 the table ROOSPRMSC contains only 11 records so this is hardly the place to check the timestamps for the >200 datasources that we use.

In BW the table RSOLTPSOURCE appears to be the correct table though.

[Former Member · Accepted solution]

Hi,

you need to check the fields tstpdat and tstptim of table roosource in the source system. I once created such a fm by myself and additionally a program that replicated the datasource and activated the communication structure for the same purpose.

regards

Siggi

[Former Member · Accepted solution]

I am trying to write exactly such a FM. Would you be willing to share the source-code of your FM?

[Former Member]

Hi,

You can refer the table ROOSPRMSC for time-stamp values.

Bye

Dinesh

[Former Member]

This table is far from complete. It only contains datasources from BW internal (i.e. ODS). There is no data from datasources in the source system (like 0MATERIAL_ATTR).