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

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.

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

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

LFA1

T005U

T005T

T077Y

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

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.

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.

6. Final Steps.

Series 3

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