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

To report this post you need to login first.

7 Comments

You must be Logged on to comment or reply to a post.

  1. sharath b

    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?

    (0) 

Leave a Reply