cancel
Showing results for 
Search instead for 
Did you mean: 

Data Extraction From Fi to BI

Former Member
0 Kudos

Hai

Can any one please provide the steps for extraction of the data from FI to BI for the reporting in graphical view.

The tables are FAGLFLEXT consisting of Assets and Liabilities.

and FAGLFLEXA consisting of Incomes and Expences.

Thanks in Advance

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

Hi,

Datasource 0FI_GL_12 will give you data from the tables you mentioned.

Regards,

Muthu.

Former Member
0 Kudos

Hi,

You can extract the Data by creating the Genaric extraction useing View.

1.Goto RSO2.

Datasource can be created for

a). Transaction Data

b). Master data Attributes

c). Master data Text

2.Specify Application component(FI)

3.Select extraction method extracts the data from a transparent table or database view.

4.Select Extraction from View, then we have to create the View.

a).Specify the view name.

b).Choose the view type (Database view) from bellow mentioned views.

i). Database view.

ii). projection view.

iii).maintainance view.

iv). help view.

5. Specify Tables and Join Conditions and define view fields.

6. Assign View to Datasource

7. Once you specify view in Data source, the extract structure willgenerate.

8. Select the filds in selection column.

9. Testing the Generic extraction by useing RSA3

10. Replicate the Datasouce in BI side

Regards,

Suman

mr_v
Active Contributor
0 Kudos

With New G/L in R/3, the tables FAGLFLEXT (totals), FAGLFLEXA, BSEG, BKPF (Line Item) get filled. in BI side u have to use following data model

0FI_GL_10 -> 0FI_GL_10 -> 0FIGL_C10 -> 0FIGL_V10(for Totals)........Datasource 0FI_GL_10 is based on table FAGLFLEXT

0FI_GL_14 --> 0FIGL_O14 (for Line item). .. .... .......Datasource 0FI_GL_14 is based on tables FAGLFLEXA, BSEG, BKPF

SAP delivered function module RS_BCT_FIGL_DATA_GET_VC10 pulls data from 0FIGL_C10 to load 0FIGL_V10... Logic for cumulative balances considering carry forward balances from previous year for Balance sheet & P/L reports, is maintained in that function module.

(So, make sure this FM got installed while u installed standard content for GL model

Do the following, to see weather FM got installed.

Goto change mode of virtual provider (ZFIGL_V10). click information icon (blue 'i')

click 'Type/ Namespace'.. Then click 'details' button

If there is no FM, u won't get any data to 0FIGL_V10 and related queries.

And also 0FIGL_V10 uses Financial Statement Version object (0GLACCEXT), which is not available in 0FIGL_C10.

For Balance sheet & P/L reports, 0GLACCEXT is key object, so 0FIGL_VC10 is must.

U should install & load master (attr, hier, text) data for 0GLACCEXT.

http://help.sap.com/bp_bw370/BBLibrary/documentation/B70_BB_ConfigGuide_EN_DE.doc

Former Member
0 Kudos

Hi,

As per my knowledge there is no standard extractor based on the tables mentioned by you.

The following link will provide you the source tables for all stadard extractors like SD,MM and FI

http://wiki.sdn.sap.com/wiki/display/BI/BWSDMMFIDATASOURCES

So you need to go with custom extractor ( Generic) and load the data into Custom Cube.

To see the report in a graphical representation you need use WAD Reporting.

Regards

Ram.