Data load status for SAP BW/4 HANA optimized infoproviders

[cl7]

Hi all.

We are using the SAP BW/4 HANA optimized infoproviders (ADSO, Composite Provider).

Now I would like to create an overview or report which includes the latest date of data load for each or selected infoproviders.

This data was stored in several SAP BW tables for previous infoproviders (e.g. DSO, multi provider, ...).

Where do I find this status/statistical information for HANA optimized infoproviders?
Does the statistic BW Content includes this information already?

Thank you very much.

[cl7]

Hi.

Thanks for your reply and the list of tables. However I was not able to find the information needed wihtin these tables.

I did not meant the Composite Provider in SAP BW. Instead I meant the info providers created by using the BW Modelling Tools in SAP Hana Studio: new Composite Provider and ADSO.

As far as I know information regarding mentioned info providers will not be saved in SAP BW tables.

Could anyone tell me if there is another way to get access.

Thanks.

[Former Member]

Hi,

The requests in the ADSO:s are listed in table RSPMREQUEST. However, I have not found a way to list which infoproviders that are included in the composite providers. Any ideas regarding that?

Thanks!

[shanthi_bhaskar]

Composite providers are virtual so there won't be any stats related to that..

[shanthi_bhaskar]

check these tables

RSPMXREFPROCVIEW

RSPMREQUEST

RSPMDATATARGET

RSPMPROCESS

RSPMXREF

Thanks

SB.

[cl7]

Hi.

Thanks for your hints.

But I am not able to find the HANA optimized infoproviders - new Composite Providers and ADSO's - within the tables mentioned.

Is there any other way to find out the status or statistical data?

Thanks.

[shanthi_bhaskar]

you can refer the below program

Load Statistics

[shanthi_bhaskar]

Use below tables

RSSTATMANPART which will store all the infoprovider information with all the requests

RSMDATASTATE will have latest request in all the infoproviders across the system

[lourdes_raj3]

Try checking table RSPMDATAPID