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.

Step1.jpg

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

Step2.jpg

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.

Step3.jpg

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

Step4.jpg

With Master Data is checked Medium Text is selected.

Step5.jpg

Now click on Propose HANA-Assignments

Step6.jpg

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.

Step7.jpg

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

Step8.jpg

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.

Step9.jpg

Click now on Maintain HANA – Assignments.

Step10.jpg

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.

Step11.jpg

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

Step12.jpg

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

Step13.jpg

Assigned Tags

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

      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

      Thanks

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

      Thanks!
      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?

      regards

      Thomas

      Author's profile photo Former Member
      Former Member

      Hi,Rohit

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

      Best regards

      Shinri

      Author's profile photo Former Member
      Former Member

      Hi,Rohit

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

      Rober

       

       

       

      Author's profile photo Former Member
      Former Member

       

      Hi,

       

      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?

      Br

      Kenneth