SAP HANA Information Models for Finance ( Basic Level)

[Former Member]

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

This Attribute View provides global company data.

Below SAP tables are used to create this Attribute View.

Attribute view for Global Company Information

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

2. As a result you should see following screen.

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

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

Continue for below columns

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

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

Continue for CCOMP Column also.

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

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

11.    As result you will see below screen.

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

13. Click Distinct Values to see the distinct values.

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

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

Attribute view for Chart_Of_Accounts

This Attribute View provides chart-of-accounts information.

Below SAP tables are used to create this attribute.

15. Select your package, Give name details.

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

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

     Continue for below fields for T001 Table

     MANDT,BUKRA,BUTXT,ORT01

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

     Continue for SAKNR field from SKA1 Table.

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

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

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

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

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

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

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

26.As Result will appear below screen.

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

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