SAP BW Reporting For Non-Leading Ledger Account(s).

[bhavinvyas]

Introduction:

In SAP BI/BW there are standard data sources available to build FI-GL reports for Leading Ledger Reporting. By activating the functions and simply installing the Data sources we can use the standard data flows for the Leading Ledger Reporting.

To build the BW Report(s) for Non-Leading Ledgers, There is a separate procedure to activate and install the data source(s).This document point outs the procedure to generate the extractors for Non-leading ledgers in SAP BW.

What is Leading Ledger?

Leading Ledger is the ledger in which all the entries are posted originally. From leading ledger all entries flow into non leading ledger. You need not pass entries separately in leading or non-leading ledger.

The leading ledger is based on the same accounting principle as that of the consolidated financial statement.

Leading ledger is integrated with all subsidiary ledgers and is updated in all company codes. This means that it is automatically assigned to all company codes.

I

n each company code, the leading ledger receives exactly the same settings that apply to that company code currencies and posting periods. You can define a second and third parallel currency for your leading ledger for each company code.

Data sources for Leading Ledger Reporting in BW are as following,

General Ledger Accounting (New): Line Items of the Leading Ledger - 0FI_GL_14

General Ledger: Line Items - 0FI_GL_4

What is Non-Leading Ledger?

Non-leading ledgers are parallel ledgers to the leading ledger. They can be based on a local accounting principle of a country, ex: You have to activate a non-leading ledger for the individual company codes.

Procedure to generate Data-sources for Non Leading Ledgers:

To generate extractors for non-leading ledgers use transaction code FAGLBW03.

The generated extractors are called 3FI_GL_XX_SI or 3FI_GL_XX_TT,

Where,

                XX is the name of the ledger.

                SI is based on FAGLFLEXA table (General Ledger: Actual Line Items)

                TT is based on FAGLFLEXT table (General Ledger: Totals)

- Functions

Activate following function with the help of BASIS Team,

FIN_GL_CI_1 - Business Function (=> transaction code SFW5)

1> 3FI_GL_xx_TT General Ledger (New): Balances from Any Ledgers (FAGLFLEXT table)

Prerequisites

In the OLTP system, you have activated new General Ledger Accounting in Customizing for Financial Accounting under Financial Accounting Global Settings.

If table FAGLFLEXT is the totals table taken as the basis, then the extraction structure (FAGLFLEXB) must already exist. If you want to use your own totals table as your basis, you first have to create the corresponding extraction structure using transaction FAGLBW01. In this way, all fields of the totals table are transferred into the extraction structure. If you change your own totals table, you then have to regenerate the extraction structure and the Data Source. You also have to regenerate the Data Source if you use table FAGLFLECT and have changed it.

Activities

1.  In the OLTP system, call up transaction FAGLBW03. All ledgers are listed.

2.  In the row with the ledger for which you want to generate the Data Source, double-click the Assigned Data Source field.

The Data Source dialog box appears. You can change the name in the Data Source field. However, we recommend that you do not make any changes because the name corresponds to the convention cited above. You may not change the character "3" at the start of the name.

3. Choose Continue.

The Data Source: Edit Customer Version screen appears. In this screen, you can exclude individual fields of the underlying extraction structure from the selection or from the data transfer into BW.

4. Configure the Data Source and save your settings.

Result: You have generated for your ledger a Data Source with which to extract data into BW and you can now use this Data Source.

2> 3FI_GL_xx_SI General Ledger Accounting (New): Line Items of Any Ledger (FAGLFLEXA table)

This Data Source extracts the line items from a specified ledger in new General Ledger Accounting. The ledger specified can be the leading ledger or any other ledger.

Prerequisites

In Customizing of the OLTP system, you have activated new General Ledger Accounting under Financial Accounting -> Financial Accounting Global Settings.

The generated extractors use extract structure FAGLPOSBW.

Activities

1.  In the OLTP system, call up transaction FAGLBW03. All ledgers are listed.

2.  In the row with the ledger for which you want to generate the Data Source, double-click the Assigned Data Source field.

The Data Source dialog box appears. You can change the name in the Data Source field. However, we recommend that you do not make any changes because the name corresponds to the convention cited above. You may not change the character "3" at the start of the name

3. Choose Continue.

The Data Source: Edit Customer Version screen appears. In this screen, you can exclude individual fields of the underlying extraction structure from the selection or from the data transfer into BW.

4. Configure the Data Source and save your settings.

   Result: You have generated for your ledger a Data Source with which to extract data into BW and you can now use this Data Source.

Issues

1> Issue: Error message while activating the data sources from T-Code FAGLBW03

                   “Extractors for general ledger documents are not yet supported”

      Solution: Activate FIN_GL_CI_1 Business function from SBW5 t-code in ECC with the help of basis team.

2> Issue: Delta mode: Changed and cleared documents are missing.

                    When we use Data Source 0FI_GL_14 (or a generated Data Source 3FI_GL_xx_SI) in delta mode.

Many changed and cleared document line items are not copied to the BI system because there are no corresponding entries in the table BWFI_AEDAT.

In addition to the Data Source 0FI_GL_14 (or the generated Data Source 3FI_GL_xx_SI), you also use precisely one of the following extractors in delta mode only:

0FI_GL_4, 0FI_AP_4, 0FI_AR_4, 0FI_TX_4

When the initialization selections for one of these extractors are deleted, the BWFI_AEDAT entries necessary for the Data Source 0FI_GL_14 (or the generated Data Source 3FI_GL_xx_SI) are also deleted in the source system. This is incorrect.

     Solution: Implement SAP Note “1938533 - 0FI_GL_14: Delta mode: Changed and cleared documents are missing”

3> Issue: Performance is poor for delta extraction

During the delta extraction for the following Data Sources, missing secondary indexes or incorrectly defined secondary indexes cause performance problems.
1. 0FI_GL_14 (or the generated Data Source 3FI_GL_xx_SI), available as of Release 603
2. 0FI_GL_10 (or the generated Data Source 3FI_GL_xx_TT with the delta method AIED)
3. 0FI_GL_11 (or the generated Data Source 3FI_GL_xx_TT with the delta method ADD)
4. 0EC_PCA_3
5. 3FI_SL_xx_SI (FI-SL line items with the delta method NEWE)

      Solution: Implement SAP Note 1531175 - Performance is poor for delta extraction.

4> Issue: Program changes for exclusive lock in BW delta extraction

      Solution: Follow the steps mentioned in SAP KBA “2110876 - Program changes for exclusive lock in BW delta extraction:

References

SAP KBA:       1070629 - FAQs: Migration to General Ledger Accounting (new)