Skip to Content
0

Data load status for SAP BW/4 HANA optimized infoproviders

Nov 22, 2016 at 08:14 AM

665

avatar image

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.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

7 Answers

Lourdes Raj Nov 22, 2016 at 08:25 PM
0

Try checking table RSPMDATAPID

Share
10 |10000 characters needed characters left characters exceeded
Shanthi Bhaskar Nov 22, 2016 at 09:59 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Shanthi Bhaskar Nov 22, 2016 at 10:02 PM
0

you can refer the below program

Load Statistics

Share
10 |10000 characters needed characters left characters exceeded
Christian Lorenz Nov 23, 2016 at 03:18 PM
0

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.

Share
10 |10000 characters needed characters left characters exceeded
Shanthi Bhaskar Nov 24, 2016 at 08:13 AM
0

check these tables

RSPMXREFPROCVIEW

RSPMREQUEST

RSPMDATATARGET

RSPMPROCESS

RSPMXREF

Thanks

SB.

Share
10 |10000 characters needed characters left characters exceeded
Shanthi Bhaskar Nov 24, 2016 at 08:14 AM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Christian Lorenz Nov 24, 2016 at 12:37 PM
0

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.

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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!

1