Skip to Content
Author's profile photo Former Member

SAP HANA Information Models for Master Data ( Attribute View) Series_2

This Blog covers the technical steps  to create Attribute Views ( Highlighted one in the below Model ).

Series 1:

http://scn.sap.com/community/hana-in-memory/blog/2013/05/06/sap-hana-information-models-for-master-data-attribute-view-series1

SAP HANA Information Model for Master Data

Blog_10.jpg

Attribute View for VENDOR

This attribute view provides company code data for a vendor, It also supplies the corresponding descriptions also.


Below are SAP tables used to create this attribute.

/wp-content/uploads/2013/05/first_213312.jpg

1. Select your package. Right Click New Attribute View & Give name details.

/wp-content/uploads/2013/05/1_213313.jpg

2. Drag & drop below tables in to Data Foundation.

LFA1

T005U

T005T

T077Y

/wp-content/uploads/2013/05/2_213315.jpg

3. In the details screen, select below listed columns, Right Click > Add to Output.

MANDT,LIFNR,KTOKK,KUNNR,COUNTRY,STREET,TITLE,NAME1,CITY1,REGION (LFA1 Table)

T077Y.TXT30


T005T.LANDX


T005U.BEZEI


/wp-content/uploads/2013/05/3_213324.jpg

4. Connect  MANDT  , LAND1 & REGIO (LFA1) to MANDT , LAND1 & BLAND (T005U), In the properties select join type as Text Join, , Language as SPRAS &  Cardinality as 1:1.


/wp-content/uploads/2013/05/4_213325.jpg

5. Connect MANDT , LAND1 (LFA1) to MANDT , LAND1 (T005T), In the properties select join type as Text Join, , Language as SPRAS & Cardinality as 1:1.

/wp-content/uploads/2013/05/5_213327.jpg

6. Final Steps.

/wp-content/uploads/2013/05/last_213328.jpg

Series 3

http://scn.sap.com/community/hana-in-memory/blog/2013/05/06/sap-hana-information-models-for-master-data-analytic-views-series3


Assigned Tags

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

      Thanks for posting this.


      Slight amendement, below are the actual field names:


      LAND1 = COUNTRY,

      ???=STREET,

      POSTL=TITLE,

      NAME1=NAME1,

      ORT01=CITY1,

      REGIO=REGION


      BR


      MD