Skip to Content

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


To report this post you need to login first.

1 Comment

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

  1. Manish Danani

    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

    (0) 

Leave a Reply