Skip to Content

Attribute Views:

SAP HANA Information Models for Finance ( Basic Level)
SAP HANA Information Models for Finance ( Advance Level)

Analytic View for Customer Line Items


This Analytic View supports flexible reporting for customer line items. The view combines both accounting document header data and accounting document line item data and has the following evaluation features:

Display customer line items according to various selection criteria, such as company code or address data for the customer

Display open items with an initial clearing date as selection criterion

Display open items by a key date with one of the following selection criteria:

  • Posting date before the key date and clearing date after the key date.
  • Posting date before the key date and an initial clearing date.

Display cleared items with a non-initial clearing date as selection criterion.

The following amounts can be aggregated:

  • Debit/credit amount in local currency
  • Debit/credit amount in document currency
  • Debit/credit amount for updating in the general ledger

Data Model

data model.jpg

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

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

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

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

Add Attribute Views AT_BUSINESS_AREA,  AT_CUSTOMER_COMPANY & AT_CUR_KEY.

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


3. Add below Columns from tables BSEG & BFPF


MANDT    BUKRS     BELNR     GJAHR     BUZEI      AUGDT       AUGBL      KOART        SHKZG        GSBER     

SAKNR     KUNNR    PSWSL    SGTXT   ZFBDT       ZTERM       ZLSCH     MSCHL        MANST        ZUONR

XUMSW     WRBTR   DMBTR    PSWBT    MWSTS   HWBAS     ZBD3T      BLART         BLDAT         BUDAT

MONAT      STBLG   BKTXT     WAERS    UMSKZ    XBLNR      STJAH      BSTAT         HWAER        MANDT/wp-content/uploads/2013/05/4_222303.jpg 

4.Connect below joins in data foundation.

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

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

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

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

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

6. Final Steps

Final.jpg

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. Former Member

    Thanks for the brilliant write up. Just pointing out that, I am not seeing the definitions of AT_CLIENT, AT_BUSINESS_AREA in the previous articles. Did you miss something out? Thanks!

    (0) 
  2. Former Member

    Thanks for writing this up, I do see measures mentioned but there is no mention of the setup in the Semantics tab. Is that intentional? Will the model be saved with just this much information?

    Look forward to hearing your thoughts.

    MD

    (0) 
  3. Former Member

    hi mahesh,

    i just completed my training i have created all basic and advance attribute views, but in this article we have to Add Attribute Views AT_BUSINESS_AREA,  AT_CUSTOMER_COMPANY & AT_CUR_KEY.  can you please share those details, it will help full to do a complete project  reqired attr_views.PNG

    (0) 

Leave a Reply