Basic Level Blog :

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

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.

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

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