This document describes activities to check SAP HANA financial reporting model correctness and completeness. It summarizes business process activities in a  logical sequence

The scenario includes the following process steps:

Financial reporting analysis by banker in SAP business objects Crystal Reports

Financial reporting analysis by a banker in SAP Business Objects Business Explorer

The target groups for this document are SAP customers and consultants with little knowledge of the SAP Bank Analyzer, SAP HANA and SAP Business Objects reporting concept and features.

Content target groups for this scenario are banks and financial institutes, particularly the departments within these, which are enabled to do faster reporting processing on a daily and ad  hoc sub ledger reporting.


2   Prerequisites

2.1   Master Data and Organizational Data

A preparation of the master data is not necessary. The master data is created directly in the SAP Bank Analyzer system. An example of how to maintain the master and flow data of a financial product, see the appendix of this document.


2.2. Business Conditions

In this case, the business conditions are maintained on the financial product in the SAP Bank Analyzer. An example of how to maintain the  financial conditions, see the appendix of this document.


2.3  Roles

Business roles are not included in the delivery of the solution. However, the following process is modeled for particular users.


User description
BankerBank clerk who creates financial transactions in the SAP Bank Analyzer and who analyzes the financial reporting afterwards
Technical ExpertThe technical expert verifies the proper replication of newly created data in the


(Optional)SAP HANA Studio (this role is optional). See the Appendix of this document


3   Process Overview Table

The following summary describes the relevant process steps:

Process step                   Business                           Business Role                Expected Results


Create Financial               Customer request           Banker                         New Financial Transaction with

Transaction/Financial                                                                                          business transactions are

instrument with                                                                                                      created and posted / RDL

business                                                                                                                      Postings


Financial Reporting                     ---                             Banker                         Financial Reporting results

Analysis via SBO

Crystal Reports

and/or SBO Explorer

Verify data in SAP                        ---                              Technical Expert     The postings are replicated and

HANA (optional)                                                                                                     available in SAP HANA

4 Process Steps

4.1 Create Financial Product


In this activity, you create a financial product in the SAP Bank Analyzer.


Make sure that the user has access and the necessary authorizations to create financial products in the SAP Bank Analyzer.


  1. Log on to the SAP Bank Analyzer system via the SAP logon:

    <System name>; <Client>, <Username>, <Logon language>;

  2. To Crate an account, access the transaction using one of the following navigation options

SAP MenuFinancial Services               Bank Analyzer                     Source Data LayerPrimary Object            Account                      Create Account
Transaction Code/BA1/F1_ACC_01


  1. To create a financial produce, access the transaction using one of the following navigation options:

SAP Menu:Financial Services           Bank Analyzer                          Source Data LayerPrimary ObjectFinancial transaction                  Create Financial Transaction/

Financial instrument                Create financial Instrument

(Please create a financial transaction or financial instrument)

Transaction Code:/BA1/F1_CF_00_01 (Financial transaction)/BA1/F1_CF_01_01 (Financial instrument)


  1. Create relevant business transactions for the financial product


  1. Execute the following process steps for the created financial product


Create Business Transaction:

SAP Menu:Financial Services              Bank Analyzer              Processes and Methods

Set SDL timestamp

Transaction Code:/BA1/B0_CLOSE_SDL


Aggregation (using the Run Accounting Daily Report for the aggregation):

Note:1592938 (Applying SAP note)
ALTERNATIVE:Run the whole Aggregation processes step by step:/BA1/F2_PB_PR,











Post External Business Transaction:

SAP Menu:Financial Services             Bank Analyzer          Processes and Methods         Accounting for Financial products          Automatic processing           Accounting processes             Post external business transaction
Transaction Code:/BA1/B1_PBTP_FDB_SL

Update Secondary:

SAP Menu:Financial Services             Bank Analyzer          Processes and Methods            Accounting for Financial products            Automatic processing           Accounting processes           Update Secondary business transactions
Transaction Code:/BA1/B1_US_SL


  1. Verify the postings in the Result – Viewer of the SAP Bank Analyzer.


SAP Menu:Financial Services         Bank Analyzer         Result Data Layer

Display Result Data

Transaction  Code:/BA1/HW_RESULT VIEWER



You have created a financial product and executed the relevant SAP Bank Analyzer processes. You have creatd postings in the Result Data Layer. You can display them via the Result-Viewr.


4.2   Financial Reporting Analysis with  SAP Business Objects Crystal Reports

This chapter gives an overview on the SAP Business Objects Crystal Report templates. Please note that the whole reporting is based on the sub ledger postings on SAP Bank Analyzer and does not consider postings for  general ledger.


Balance Report

The balance statement is provided as a SAP Business Objects Crystal Report template (Balance Report). The  Balance Report is based on a point in the Calculation. For detailed information regarding the structures and result and result objects of the Balance Report see the configuration guide (Appendix).


Profit & Loss Report

The profit and loss is provided as SAP Business Objects Crystal Report template (Profit & Loss Report). The Profit & Loss Report is based on a period time calculation. The income statement considers the balance of income and expenses. It is part of the annual financial statements. For detailed information regarding the structures and result objects of the Profit & Loss Report see the configuration guide (Appendix).


General Remarks

The basic framework is the sub ledger reporting reconciled balance statement and profit and loss statement. The balance sheet from the accounting sub leger for financial accounting  is based on the definitions given by the committee of  European Bank Supervisors within the core section of framework of the guidelines of financial reporting.

The two sub ledger report templates – Balance Report and Profit & Loss Report – are based on a three-level structure hierarchy which reflect the respective balance sheet positions. The reports provide the option to drill down directly to G/L account by choosing the relevant balance position in the main report. It is also possible to check the composition of a position, which can contain multicurrency amounts (by choosing the $ amount icon in the main report.)

The main reports present the amounts in two different approaches. The first column is based on actual-figures in reporting currency in the Result Data Layer. The second column – Ad hoc amount – represents the converted figures from the reporting currency with current exchange rate. Note that it is a conversation only and not a valuation.


  1. Access to SAP Business objects crystal reports via the BI Launch pat


  1. Input username and password and choose Log on.
  2. On the Documents tab pages, go to the SAP Crystal Reports (for example Documents                                 Folders                 Public Folders                  SAP                        SAP.FS                  SAP.FS.BA).   Crystal Reports are marked as the type Crystal Report.
  3. The the adjustment of the Crystal Report templates is described in the configuration guide (chapter SAP Crystal Report Enhancement).


4.3   Financial Reporting Analysis with SAP Business Objects Explorer

This chapter gives an overview on how to use the SAP Business Objects Explores for exploring data of created information Spaces.

  • The Creation of Information Spaces is described in the configuration guide (chapter SAP Business Objects information Space Creation).

The following Information Spaces examples are listed in the configuration guide:

  • Sub ledger

    The Sub ledger Information Space is created for exploring the RDL postings

  • Sub ledger Details

    The Sub ledger Details Information Space is created for explain the RDL postings with SDL enhancements. Some additional SDL attributes like Profit Center are available in this information Space.

  • An Information Space is a collection of objects mapped to data for a specific business operation or activity. In this case, the information Spaces are designed to provide information regarding the financial reporting.


The following steps describe the launch of information spaces:

  1. Access SAP business objects Explorer via the BI launch – pad:



  1. Input your username and password and choose Log on.
  2. Under My Applications, go to the SBO Explorer.
  3. Scroll through the available information Spaces or use the search function to select the relevant Information Space and start the selected information Space.
  4. An Explore tab page opens. Then you can navigate through the information Space.


5 Appendix

5.1 Example of Master Data and Flow Data

The Following table shows an example of how to fill the master data and flow data in the prerequisite section in case of a BOND:

Account – Securities Position Account


Template VersionSV1
Account CategorySecurities Position Account
External NumberInsert your name for the settlement account


Business record data01.01.2000
Authorizations GroupNONE
Account Status00Active
Source SystemMANUAL 
Organizational UnitPC11-11


Banking/Trading Book1Banking Book
Legal EntityInsert your legal entity




Template VersionSV1
External NumberLEXX DOND 2010
Authorization GroupMANUAL
Business Record Data01.01.2010
Node Number1


Source SystemMANUELL
State Date of Obj01.01.2010End Data of Obj31.12.2013
Start Fixed Inl01.01.2010End of Fixed inL31.12.2013
Calendar01Germany (Standard)
Customer Rate0.000000000
Day Count Conv3Act/365
Templ. VariantSFICFinancial condition
Class. Risk Basis


Activity TypeSTDStandard
Condition Group Type2002Securities
Valid From01.01.2010
End Date31/12/2013
Tab Calculation
Condition formFixed Condition
Payment CurrencyUSD
Exchange Rate0,00000000
Payment Rate0,00000000
Frequency Cat.Periodic
Repeat. Period0
1st Cal. Date01.01.2010
Key Date0
Frequency Cat.Relative

Condition Group Type 2002

Create Condition101100
Valid From01.01.2010
End Date31.12.2013

Tab calculation

Condition Form
Rounding Cat.Round to the


Interest Calc. MethodAct/365
Rounding Unit0,0000000
Interest Calc.Straight-line
Percentage Rate3,00
Pro Rate CalculationPro rate calculation in shortend/extended per.
Base Amount0,00
Base Reference0300
Payment CurrencyUSD
Exchange Rate0,0000000
Frequency CalPeriodic
Repeat Period4
1st Calc. Date01.01.2010
Key Date0
Frequency Cat.Relative


Valid From01.01.2008
Valid To31.12.9999
ID TypeID TP13
Partner ID Number7879
Instrument TypeSBOND
ISIN numberDE0987654366Own Issue
Quotation01Percentage QuotationTradebleYes
Nominal Amount22,000.000.00USD
Issue Amount27.000.000.00USD
Product type430BOND
Recognize Exchange1Yes


Accounting StandardIASInternational  Accounting Standard
Generate FPO2Generate
Financial Position TypeODEBINSTDebt Instruments
Component ClassMMain Part
Determination Acquisition Value1Not Residual
Accounting StandardHGBGerman commercial code
Generate FPO2Generate
Financial Position TypeODEBINSTDebt Instruments
Component ClassMMain Part
Determination Acquisition Value1Not Residual


Valid From01.01.2008
Valid To31.12.2013
Key Fig. CatPayoff amount


Business TransactionLEXX BOND 2010 BT1
Source SystemMANUAL
Business Transaction ClassSBTS – Flow Trans. (Investment Prod.)


Business Record DateAutomatically Filled
Posting Date01.01.2010
Value Date01.01.2010


Business Trams typeDI01
Legal EntityLEXXLegal Entity
Item 001
Account Category03 – Securities position Account
Account NumberInsert your settlement account
Template Category01 Financial Instrument
External  NumberInsert your financial transaction
Nominal Amount22.000.000.00
Nominal CurrencyUSD
Position Amount22.000.000.00
Position CurrencyUSD
Transaction Amount22.000.000.00
Transaction CurrencyUSD


Role in Sender/Receiver RelationshipNNeutral
Item TypeI00A[P] Long Term Receivables (Debit)


5.2 Verify Data in SAP HANA Studio (optional) Use           

You can verify and check master data and postings in the Result Data Layer via the SAP HANA Studio after the replication to SAP HANA. A technical expert, mentioned in chapter Roles, can carry out this activity.



SAP HANA Studio must be installed on client side to get access to the data.



  1. Choose StartUntitled All Programs   Untitled   SAP HANA Untitled  Studio to open your SAP HANA Studio
  2. In the navigator panel, expand your SAP HANA System Content  Untitled SAP.fs.ba / sap.fs.fnd.ba and expand the respective Calculation Views / Analytic views folder or Attribute Views folder.
  3. Right-click the respective view (for example CA_BALANCE) and choose Data Preview.
  4. Verify that the replicated data are by filtering according to the relevant object.



You have Master data and postings in the Result Data Layer are verified and checked in SAP HANA studio.


SAP Best Practices


December 2011



SAP Bank Analyzer rapid- deployment solution for  financial reporting with  SAP HANA (v35)

Building Block Configuration Guide


1) Preparation

2) Prerequisites


3         Configuration

3.1                Creation of Aggregated Data Table in SAP Bank Analyzer

3.2                 Implementation of Rapid-Deployment Solution Specific Programs (SAP Note   1614443) in SAP BANK Analyzer

3.3                          SAP HANA – Data Model Overview

3.4                          SAP HANA – Used Tables

3.5                          SAP HANA – Use of Tables in Views

3.6                         SAP HANA – Creating and Filling the REPORTING_STUCTURE Table

3.7                          Balance Sheet Model Overview

3.8                          Profit & Loss Model Overview

3.9                        Sub ledger Models Overview

3.10                       SAP Business Objects information Space Creation


4. Extension of Delivered Package and Associated Reporting Objects

4.1.1                      Add Additional Attributes to Views in SAP HANA Package

4.1.2                      Universe Enhancement

4.1.3                      SAP Crystal Report Enhancement