Skip to Content

This blog explains deep dive of Attribute Views  (Basic Level)  for Finance.

Attribute Views are used to model an entity based on the relationships between attribute data contained in multiple source tables.

Process Flow for Creating Attribute View Creation

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

This Attribute View provides global company data.

Below SAP tables are used to create this Attribute View.

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

Attribute view for Global Company Information


1. Select the Content Package > Right Click > New Attribute View.

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

1A.jpg

2. As a result you should see following screen.

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

3. Drag & drop T880 & T880G table in to Data Foundation.

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

4. In the details screen, select MATNR & Right Click > Add to Output.

Continue for below columns

MANDT,RCOMP,NAME1,CNTRY,MODCP ( T880 Table).

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

5. In the details screen, select CGSBR & Right Click > Add to Output.

Continue for CCOMP Column also.

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

6. Connect MANDT(T880) to MANDT (T880G), In the properties select join type as Inner Join , & Cardinality as 1:N.

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

7. Select Semantics , Click MADNT to enable as a Key Attribute.

/wp-content/uploads/2013/05/7_211559.jpg

/wp-content/uploads/2013/05/8_1_211560.jpg

/wp-content/uploads/2013/05/8_2_211561.jpg

/wp-content/uploads/2013/05/9_1_211562.jpg

/wp-content/uploads/2013/05/9_2_211563.jpg

/wp-content/uploads/2013/05/10_1_211564.jpg

/wp-content/uploads/2013/05/10_2_211565.jpg

11.    As result you will see below screen.


/wp-content/uploads/2013/05/11_211566.jpg

12. Click Raw Data to see the output of the view in the column format.

/wp-content/uploads/2013/05/12_211567.jpg

13. Click Distinct Values to see the distinct values.

/wp-content/uploads/2013/05/13_211568.jpg

14. Click Analysis to see the output of the view in the graphical representation.

/wp-content/uploads/2013/05/14_211569.jpg

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

Attribute view for Chart_Of_Accounts

This Attribute View provides chart-of-accounts information.


Below SAP tables are used to create this attribute.

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

15. Select your package, Give name details.

/wp-content/uploads/2013/05/15_211571.jpg

16. Drag & drop T001,SKAT & SKA1 tables in to Data Foundation.

/wp-content/uploads/2013/05/16_211572.jpg

17. In the details screen, select MATNR & Right Click > Add to Output.

     Continue for below fields for T001 Table

     MANDT,BUKRA,BUTXT,ORT01

/wp-content/uploads/2013/05/17_211573.jpg

18. In the details screen, select KTOPL & Right Click > Add to Output.

     Continue for SAKNR field from SKA1 Table.

/wp-content/uploads/2013/05/18_211574.jpg

19.Connect MATNR(T001) to MATNR (SKA1), In the properties select join type as Inner Join & Cardinality as N:1.

/wp-content/uploads/2013/05/19_211575.jpg

20. Connect KTOPL(T001) to KTOPL (SKA1), In the properties select join type as Inner Join & Cardinality as N:1.

/wp-content/uploads/2013/05/20_211576.jpg

21. Connect MANDT(SKA1) to MANDT (SKAT), In the properties select join type as Text Join , Language column as SPARS & Cardinality as 1:1.

/wp-content/uploads/2013/05/21_211577.jpg

22.Connect KTOPL(SKA1) to KTOPL (SKAT), In the properties select join type as Text Join & Cardinality as 1:1.

/wp-content/uploads/2013/05/22_211578.jpg

23.Connect SAKNR(SKA1) to SAKNR (SKAT), In the properties select join type as Text Join & Cardinality as 1:1.

/wp-content/uploads/2013/05/23_211579.jpg

24.Click  Save & Validate after that Click  Save & Activate.

http://i40.tinypic.com/6epwye.jpg

25. Click Data Preview to see the output of the view.

http://i42.tinypic.com/17d7gw.jpg

26.As Result will appear below screen.

http://i39.tinypic.com/21jufsn.jpg

27.Raw Data to see the output of the view in the column format.

http://i43.tinypic.com/snj8lg.jpg

Advance level Blog :

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

Analytic View

SAP HANA Information Models for Finance ( Analytic View)_1

SAP HANA Information Models for Finance ( Analytic View)_2

SAP HANA Information Models for Finance ( Analytic View)_3


To report this post you need to login first.

7 Comments

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

  1. Nishan Dev S

    Hello Mahesh Kumar:

    Excellent information for Finance folk to have a basic understanding, good information. Thanks for sharing !

    -Nishan Dev

    (0) 
  2. abilash n

    Thanks Mahesh for sharing this.

    I have a small confusion – in recent blog on SPS11 sap is recommending to move to calculation views and use projections to max extent instead of Attr and Analytic view if possible. By this the performance will be good and its where sap is thinking and moving to even in future releases. I had just now saw another blog mentioning the same.

    Please share your suggestions on this.

    SAP HANA Modeling – Project Learnings and Tips

    (0) 

Leave a Reply