SAP HANA Information Models for Finance ( Analytic View)_1
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
1. Select your package. Right Click à New Attribute View & Give name details.
2. Drag & drop BSEG, BKPF tables in to Data Foundation.
Add Attribute Views AT_BUSINESS_AREA, AT_CUSTOMER_COMPANY & AT_CUR_KEY.
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
4.Connect below joins in data foundation.
5. . Connect below joins from attribute view fields to Data Foundation columns.
6. Final Steps
SAP HANA Information Models for Finance ( Analytic View)_2
SAP HANA Information Models for Finance ( Analytic View)_3
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!
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
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