Skip to Content

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

/wp-content/uploads/2013/04/111111111_207355.jpg

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.

/wp-content/uploads/2013/04/1_207381.jpg

2. As a result you should see following screen.

/wp-content/uploads/2013/04/2_207382.jpg

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

/wp-content/uploads/2013/04/3_207383.jpg

4. As a result you should see following screen.

/wp-content/uploads/2013/04/4_207384.jpg

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

/wp-content/uploads/2013/04/5_207385.jpg

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

 

Continue for the below columns

RLDNR       

MATNR

T881T.NAME

/wp-content/uploads/2013/04/6_207395.jpg

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

/wp-content/uploads/2013/04/7_207396.jpg

8. Click Save & Validate

    /wp-content/uploads/2013/04/8_207397.jpg

9. Click  Save & Activate.

/wp-content/uploads/2013/04/9_207407.jpg

10. Click Data Preview to see data.

/wp-content/uploads/2013/04/10_207408.jpg

11. As result it will display below screen.

/wp-content/uploads/2013/04/11_207409.jpg

————————————————————————————————————————————————————-


Attribute View for Company Code Customer information


This Attribute View provides Company Code Customer information.

Below SAP tables are used to create this attribute.

/wp-content/uploads/2013/04/11111111111_207428.jpg

  1. Select your package. Give name details.

/wp-content/uploads/2013/04/1_207381.jpg

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

KNB1

T001

KNA1

T005T

T005U

TKUKT

TNLST

/wp-content/uploads/2013/04/2_207382.jpg

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)

/wp-content/uploads/2013/04/3_207383.jpg

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

/wp-content/uploads/2013/04/4_207384.jpg

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

/wp-content/uploads/2013/04/5_207385.jpg

6. Continue for the below joins


KNA1

TextTable

MANDT LAND1

  1. 1..1

SPRAS

T005T

MANDT LAND1

KNA1

TextTable

MANDT LAND1 REGIO

  1. 1..1

SPRAS

T005U

MANDT LAND1 BLAND

KNA1

TextTable

MANDT KUKLA

  1. 1..1

SPRAS

TKUKT

MANDT KUKLA

KNA1

TextTable

MANDT NIELS

  1. 1..1

SPRAS

TNLST

MANDT NIELS

/wp-content/uploads/2013/04/6_207395.jpg

7A.jpg

/wp-content/uploads/2013/04/7_207396.jpg

8A.jpg

/wp-content/uploads/2013/04/8_207397.jpg

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

/wp-content/uploads/2013/04/9_207407.jpg

10. Click Distinct Values to see the distinct values.

/wp-content/uploads/2013/04/10_207408.jpg

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

/wp-content/uploads/2013/04/11_207409.jpg

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.

3 Comments

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

  1. Prathap Naik

    Good document Mahesh .I really appreciate  for the time you take out from the project  and do the knowledge sharing .

    Ones again thanks for your efforts…

    PNaik

    (0) 
  2. Hemendra Sabharwal

    Thanks Mahesh,

    Simple and nice blog. This blog series is really helping me in one of Simple Finance implementation project.

    Thanks Again…

    Warm Regards

    Hemendra

    (0) 

Leave a Reply