Skip to Content
Author's profile photo ASHUTOSH SHRIVASTAVA

Step by Step Extracting ECC tables to SAP HANA using BODS and consuming data to SAP BW Powered by HANA. PART-2

We saw how to do Extraction of ECC tables to SAP-HANA using First part –

Step by Step Extracting ECC tables to SAP HANA using BODS and consuming data to SAP BW Powered by HANA

Now in this part we will create Calculation view on same Extracted ECC tables in to HANA and also consume this calculation view in SAP BW powered by HANA.

Step1> Log into SAP HANA .

           Go to Catalog–>Expand–>Expand the Schema (which we have given while creating Target Table as a owner name )  –> Expand Schema–> Expand Table

           Observe the table– VBAKVBAP


     Check the Definition and Content of Table by Right click on Table.


     Step 2> Now we will create Calculation view based upon the Table—“VBAKANDVBAP” with Data category Cube.


     Select your Package–>Right click–>New–>Calculation view



               Click OK


          Here we will Drag and drop the VBAKANDVBAP table to projection or by clicking on plus icon.


          Select the desired fields by clicking on Circle icon right before the field name from Details Output


         Step 3> Create calculated column.

                    Under Column folder I have NETWR field “Net value of the Order item in document currency”

                    Business requirement is to add one more filed is called VAT.

                    Formula for VAT is “NETWR”*0.5/100


          Click on Calculated Column Folder–>Right click–>New



          Click on Validate Syntax for any Error.

          Observe the VAT field under calculated column.


          Save and Activate

          See the Raw Data and Observe the Newly added field “VAT”


       Step 3> Apply Rank node.

     Business Scenario — is to generate the one report which will show TOP 4 sales document date wise.I have made some changes in calculation view.

      Do below mentioned things as it is , like below pic–

     Remove “VBAKANDVBAP” table from projection. Drag and Drop “Rank” node to the modeling panel.

     Now add “VBAKANDVBAP” table to RANK node.

     Add Rank node to Projection node.


     Now will define RANK but first we need to know the functionality of RANK.

     Threshold—this value is used by the system to filter the result data set after it calculates the rank.

     Order By—this column is used to perform Order By after the system performs partition.

     Partition—this column is used to partition the source data set based on the columns we define.

     When you Drag and drop the RANK node to the right panel. check the RANK node properties.


     Give the values like mentioned in below–


      Sort Direction– Descending (Top N)

      Threshold- 4

      Order By- VBELN

      Partitioned- ERDAT


     NOTE—Make sure at each node, we have selected the fields which you want to see in report output.


     Go to Aggregation level, Select the measures (NETWR,WAERK and VAT) –>Right click–>Add as a Aggregated Column.     



      Go to Semantic–> Under Column Tab.


     Mark All measures fields as Measure and rest of the fields as a Attribute.


     Save and Validate.

     Data Preview

     Raw Data

     Observe the Raw data based upon your Rank fields.


     we have successfully created Information view in HANA DB.

     PHASE 3—


     So far we have Extracted ECC tables into HANA DB and there we have created calculation views and performed some operations, now we will consume      this calculation view in to SAP BW by using Virtual provider.

     Step 1> Log in to SAP BW.


     Go to System menu–>Status. My Database System is HDB.


     Click on component (Magnifying glass symbol)—



     Now we will create Transient Provider to consume HANA model (calculation view) in SAP BW powered by HANA


     In Transient Provider Analytical/ Calculation views allowed.

     Creation of Bex allowed.

     Multi provider allowed— There is a new tab has been added in Multiprovider to add Transient data.

     Composite Provider is allowed.

     Master data is allowed but only for Display Attribute.


     Step2 > Create Infoarea

     Step 3> T-CODE- rsdd_hm_publish

     Enter your same package name under which you have designed your calculation views.



     Click on create, a new window will appear. Enter the InfoArea name.



     Observe Characteristics Tab, give the Ref. InfoObject name if any



     Observe Key figures Tab



     Here Characteristics are what we had defined as Attribute in HANA and Key figures are measures.

     Here name of Infoprovider is @3CALV_VBAKANDVBAP

     Transient Provider names start with @3 followed by information views name.


     Transient Provider are Virtual provider.

          Go To SE–>@3CALV_VBAKANDVBAP–>Display


          No Table Exist

     We can create Transient Provider directly in Production system, but with the help of RSLTIP we can create Transport request in Dev.

          Go to –> SE11–> RSLTIP–> Display–>Content






     We can create Transport request form Table Entry menu and move the object.


     Now you can create the Query on Infoprovider- @3CALV_VBAKANDVBAP and observe the report.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Ashutosh, very useful step by step document, thanks for sharing.

      Author's profile photo ASHUTOSH SHRIVASTAVA
      Blog Post Author

      Thanks Emily..

      Author's profile photo suresh jetti
      suresh jetti

      Hi ashutosh,

      I have read both part 1 and part 2 , It is very good .