Skip to Content

SAP HANA Information Models for Finance ( Basic Level)

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


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