Skip to Content
Author's profile photo Former Member

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

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-basic-level

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-5part1doc


SAP HANA Information Model for Master Data

Blog_9_1.jpg

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.

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

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

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

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

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

LFB1

LFA1

T001

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

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)

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

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. 1..n

LFB1

LIFNR MANDT

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

5. Final Steps.

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

                                ———————————————————————————

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.

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

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

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

2. As a result you will see below screen.

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

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

LFA1

LFM1

T024E

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

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).

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

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

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

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

/wp-content/uploads/2013/05/6_213305.jpg

7. Final Steps.

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


Series 2 :

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


Assigned Tags

      Be the first to leave a comment
      You must be Logged on to comment or reply to a post.