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

[Former Member]

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

Few Blogs on Attribute Views

http://scn.sap.com/community/hana-in-memory/blog/2013/05/01/sap-hana-information-models-for-finance-...

http://scn.sap.com/community/hana-in-memory/blog/2013/04/19/sap-hana-information-models-for-fianance

http://scn.sap.com/community/developer-center/hana/blog/2013/03/06/copa-scenario-in-sap-hana-10-sps-...

SAP HANA Information Model for Master Data

Attribute View for COMPANY CODE DATA FOR VENDOR

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

Below are SAP tables are 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.

LFB1

LFA1

T001

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

LIFNR

Vendor, MANDT, BUKRS, SPERR, ZTERM, VZSKZ, ZWELS, EIKTO, FDGRV, DATLZ, ZINRT,

ZINDT, ZGRUP (LFB1 Tables)

NAME1 (LFA1 Table)

WAERS, BUTXT ( T001 Table)

4. Connect MANDT & BUKRS (LFB1) to MANDT & BUKRS (T001), In the properties select join type as Inner Join, & Cardinality as N:1.

    Continue for below join,

LFA1

inner

LIFNR MANDT

1..n

LFB1

LIFNR MANDT

5. Final Steps.

                                ---------------------------------------------------------------------------------

Attribute View for VENDOR PURCHASE ORGANISATION

This attribute view provides purchasing organization data for a vendor. It also supplies the corresponding descriptions

Below  are SAP tables are used to create this attribute.

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

2. As a result you will see below screen.

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

LFA1

LFM1

T024E

4. In the details screen, select NAME1(LFA1) & Right Click > Add to Output.

Continue for below columns from the respective tables.

INCO1, XNBWY , BOPNR , WEBRE, BSTAE, LEBRE, LIND, WAERS,EIKTO, SPERM, PRFRE, MEGRU, RDPRF, LISER ,

XERSY, VERKF, KZAUT, INCO2, EXPVZ, VSBED, PAPRF, LFRHY, NRGEW (LFM1 Table).

5. Connect MANDT & LIFNR (LFA1) to MANDT & LIFNT (LFM1), In the properties select join type as Left Outer Join, & Cardinality as N:1.

6.Connect MANDT & EKORG (LFA1) to MANDT & EKORG (T024E), In the properties select join type as Left Outer Join, & Cardinality as N:1.

7. Final Steps.

Series 2 :

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