Skip to Content

SAP table data to BW report

Hi Team,

My requirement is to get a SAP metadata table in a tab of SAP BW report which we can use as further reference in calculation and many other thing in the same report. The table is in BW system only.

One way which I can go thru is by creating extractor and loading data in CUBE then designing BEX query to pull the data for that in the sheet. And the number of rows in this table will not go more than 100 and I don't wanna create whole setup CUBE, transformation, Infopackage DTP and all for this small amount of data.

Can anyone of you suggest any other alternative ways thru which we can bring table data into one of BW report tab to satisfy the requirement. Any help in this case would be greatly appreciated.

Thanks!!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 10, 2017 at 02:54 PM

    Hi Harsh,

    You can create CDS view on top of the table, and consume it in the Bex report. for more info regarding CDS please see https://wiki.scn.sap.com/wiki/display/ABAP/CDS+-+Core+Data+Services

    Kind regards,

    Andrey

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 10, 2017 at 01:53 PM

    Hi,

    I created something similar, I described it in this blog

    https://blogs.sap.com/2015/05/11/metadata-reporting-restricted-key-figures/

    the idea was to use a virtual provider and it worked brilliantly for me, so for 100 records, you will be set!

    grtz

    Koen

    Add comment
    10|10000 characters needed characters exceeded