Scenario : To read BW-BEx query report output into R/3(any other SAP system)
Conventionally, it is being achieved by reading BW query via function module such as WREX_GET_DATA in R/3 or any other SAP system. The performance with this approach on data read is slightly on slower side and cannot handle greater volumes of data. In this blog I will describe accessing BEx report output into other SAP system via HANA as secondary connection.
Explanation :
From NW740 SP9 BW on HANA, BEx queries can be consumed as external HANA view, in other words you can generate calculation views for queries in the SAP HANA database. Below are the prerequisites for generating HANA view on BEx query.
Preconditions for generating HANA view:
Precondition for using HANA as secondary connection:
R&A - (BW Side) :
INFOPROVIDER : Infoprovider on which the query is built
TLOGO : Object Type of Infoprovider
HANAMODELFL : X (External SAP HANA view for reporting)
USERNAME : BW User ALE(refer RSADMIN)
DBMSUSER : DB user that login to BW to read HANA view(ECC --> BW)
VALUE :
TSTPNM :
TIMESTMP :
Execution in ECC(consuming SAP system) :
After generation of HANA view and DB connection setup, a program can call BW HANA view from R/3 in following possible ways:
Connection Via Open SQL
Connection Via Native SQL
Connection Via Native SQL - ADBC
Read more at : ABAP/HANA Connectivity via Secondary Database Connection
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
5 | |
5 | |
4 | |
4 | |
4 | |
4 | |
4 | |
3 | |
3 |