Skip to Content

Data load status for SAP BW/4 HANA optimized infoproviders

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

7 Answers

  • avatar image
    Former Member
    Nov 22, 2016 at 08:25 PM

    Try checking table RSPMDATAPID

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 22, 2016 at 09:59 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 22, 2016 at 10:02 PM

    you can refer the below program

    Load Statistics

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 23, 2016 at 03:18 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 24, 2016 at 08:13 AM

    check these tables

    RSPMXREFPROCVIEW

    RSPMREQUEST

    RSPMDATATARGET

    RSPMPROCESS

    RSPMXREF

    Thanks

    SB.

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 24, 2016 at 08:14 AM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 24, 2016 at 12:37 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded

    • 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!