SAP HANA Information Models for Finance ( Advance Level)

[Former Member]

Basic Level Blog :

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

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

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 the ledgers in a customer’s system.

Below SAP tables are used to create this attribute.

Table Name	Description
T881	Ledger Master
T881T	FI-SL Ledger text

Attribute View for Ledger Master with Text

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

2. As a result you should see following screen.

3.Add T881 & T881T tables in to Data Foundation.

4. As a result you should see following screen.

5. Connect MANDT(T881) to MANDT(T881T), In the properties select join type as Text Join & Cardinality as 1:1.

6. In the details screen, select XLEADING & Right Click > Add to Output.

Continue for the below columns

RLDNR       

MATNR

T881T.NAME

7. Select Samantics, click MANDT to enable as Key Attribute ,Continue same for RLDNR

8. Click Save & Validate

   

9. Click  Save & Activate.

10. Click Data Preview to see data.

11. As result it will display below screen.

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

Attribute View for Company Code Customer information

This Attribute View provides Company Code Customer information.

Below SAP tables are used to create this attribute.

1. Select your package. Give name details.

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

KNB1

T001

KNA1

T005T

T005U

TKUKT

TNLST

3. In the details screen, select BUTXT(T001) & Right Click > Add to Output.

Continue for below columns from the respective tables.

NIELS,LAND1,NAME1,ORT01,PSTLZ,REGIO (KNA1 Table)

BUKRS,KUNNR,MANDT,AKONT ( KNB1 Table)

LANDX ( T005T Table)

BEZEI (T005U Table)

VTEXT (TKUKT)

BEZEI (TNLST)

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

5.Connect MANDT & BUKRS(KNA1) to MANDT & BUKRS(KNB1), In the properties select join type as Inner Join , & Cardinality as 1:N.

6. Continue for the below joins

KNA1	TextTable	MANDT LAND1	1..1	SPRAS	T005T	MANDT LAND1
KNA1	TextTable	MANDT LAND1 REGIO	1..1	SPRAS	T005U	MANDT LAND1 BLAND
KNA1	TextTable	MANDT KUKLA	1..1	SPRAS	TKUKT	MANDT KUKLA
KNA1	TextTable	MANDT NIELS	1..1	SPRAS	TNLST	MANDT NIELS

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

10. Click Distinct Values to see the distinct values.

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

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