Skip to Content
Author's profile photo Rohit Kumar

How to Implement Virtual Master Data

This is  new type of Master Data InfoProvider  possible in SAP BW 7.4.This characteristic can be used with virtual master data in Virtual Provider.It is possible to use HANA Attribute, Analysis and Calculation Views to create Virtual Master Data in BW.

Steps to Implement

We are trying to create a Virtual Master Data for Employee Master Data from an Attribute view with following structure. Note : Field EMP_ID from Attribute view is of type and size VARCHAR and 4.


Start of creation is exactly same as creating any normal/standard Characteristic InfoObject.Virtual Key Figures cannot be created.


As EMP_ID is of Type and Size VARCHAR and 4 respectively Data Type and Length has been entered exactly of same type and size.


In Master data / text tab, down below select SAP HANA View as Master Data Access. Select SAP HANA Package and SAP HANA View


With Master Data is checked Medium Text is selected.


Now click on Propose HANA-Assignments


Select only those fields under Propose Mapping which needs to be added as attributes.EMP_ID and Name will not be mapped with Attributes so left unchecked.EMP_ID field of HANA View will be mapped with main master data object and Name will be mapped with Medium Text here.


Now a second pop up will request for selecting corresponding BW InfoObjects.System provides options of similar InfoObjects. Select One relevant for each.


Attributes will show now in Attributes tab. These are Assigned BW InfoObjects.To see all HANA field – BW Mapping Assignments and to Map Main Master data Object and Text follow steps as shown next.


Click now on Maintain HANA – Assignments.


Assignment of HANA View Field is not there for Main Master Data Object ZVIRTCH2. We need to add HANA View field EMP_ID for it.Similarly HANA View field NAME will be mapped with Medium Text.


Fields Added.Fields Transferred. Virtual Master Data ZVIRTCH2 Activated .


Right click and Display data shows Data from Attribute view of HANA.


Assigned Tags

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

      Hi Rohit,

      This forum belongs pure bw only.

      Please post your blogs which are belongs to bw on hana at

      SAP BW Powered by SAP HANA


      Author's profile photo Rohit Kumar
      Rohit Kumar
      Blog Post Author

      Is there any possibility to move it there now?

      Author's profile photo Ganesh Bothe
      Ganesh Bothe

      Hi Rohit,

      Good document..I will try this function. 🙂 .

      Author's profile photo Rohit Kumar
      Rohit Kumar
      Blog Post Author

      Thanks Ganesh!

      Author's profile photo Former Member
      Former Member

      Hi Ramesh,

      In extension to your above document scenario we came across the situation where an hana attribute view was exposed as virtual master data into BW, now the info objects via virtual master data we want to use as attributes to an existing BW info object.

      Result :

      When we executed the display data for the existing info objects we are able to see the columns information for the BW objects not the virtual attributes.

      did you got the chance to try the scenario?

      Author's profile photo Rohit Kumar
      Rohit Kumar
      Blog Post Author

      Hi Sharath,

      I am Rohit not Ramesh  🙂 .

      Can you elaborate the scenario little bit more?

      Author's profile photo Thomas Esser
      Thomas Esser

      Hi Rohit,

      is it possible to use time dependent attributes with virtual master data?



      Author's profile photo Former Member
      Former Member


      Is it possible to use hierarchy attributes with virtual master data?

      Best regards


      Author's profile photo Former Member
      Former Member


      we upgrade us to BW 7.5 SP7,now this connection type is disabled.
      Is it possible activated ?





      Author's profile photo Former Member
      Former Member




      We are on the same version BW 7.5 sp 7 and we face the same problem and want to have this functionality. Did you come to a solution on this missing functionality with Read access type : HANA view missing?