Skip to Content

Analytic View

SAP HANA Information Models for Finance ( Analytic View)_1

SAP HANA Information Models for Finance ( Analytic View)_2

Analytic Model for Due A/R Items

This Analytic View enables analyzing the open items of the FI Account Receivables according to their due date. The open items into are grouped according to due dates between 1 and 10, 11 and 60, 61 and 120 etc. In addition, the view provides the total amount of the receivables, the amount of the due receivables, and the amount of the not due receivables. Also, various categories can be used, such as the company code, or country and region.

The due data analysis restricts to the customer line items for the calculation. Archived documents, or documents posted to a summary posting are not considered.

Data Model

Data Model.jpg

1. Select your package. Right Click à New Attribute View & Give name details.

/wp-content/uploads/2013/05/1_222331.jpg

/wp-content/uploads/2013/05/2_222332.jpg

2. As result you will get below screen.

/wp-content/uploads/2013/05/3_222333.jpg

3. Drag & drop BSEG, BKPF tables in to Data Foundation.

    Add Attribute Views AT_CUSTOMER_COMPANY.

/wp-content/uploads/2013/05/4_222334.jpg

4.   Add below columns fron BGEG & BKPK Tables.

MANDT     BUKRS      BELNR      GJAHR      BUZEI      AUGDT      AUGBL      MANST       GSBER

ZFBDT      BSEG         SHKZG     ZBD3T       KUNNR    UMSKS     XUMSW     DMBTR       MONAT

BLART      BLDAT      BUDAT      HWAER

/wp-content/uploads/2013/05/5_222335.jpg

As result you see columns are added in Data Foundation.

/wp-content/uploads/2013/05/5_1_222336.jpg

5.  Connect below joins in data foundation.

/wp-content/uploads/2013/05/6_1_222337.jpg

/wp-content/uploads/2013/05/6_2_222338.jpg

6. Connect below joins from attribute view fields to Data Foundation columns.

/wp-content/uploads/2013/05/7_1_222339.jpg

/wp-content/uploads/2013/05/7_2_222340.jpg

7.  Create below calculated columns.

/wp-content/uploads/2013/05/8_2_222341.jpg

/wp-content/uploads/2013/05/8_1_222342.jpg

/wp-content/uploads/2013/05/8_3_222343.jpg

/wp-content/uploads/2013/05/8_4_222344.jpg

8. Final Steps.

Final.jpg




To report this post you need to login first.

Be the first to leave a comment

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

Leave a Reply