financial statement version extraction

[Former Member]

Hi friends,

I want to extract financial statment version(different accounts range ) information from R/3 to BI7 system.

simply tr.code: fse3 information. What datasources are suitable to my requirement? could anybody tell procedure for extraction?

thanks,

naresh

[Former Member · Accepted solution]

Hi,

Check this link,

http://help.sap.com/saphelp_nw04/helpdata/en/57/dd153c4eb5d82ce10000000a114084/frameset.htm

[Data source - 0GLACCEXT_T011_HIER.]

Infocube : 0FIGL_VC1 General Ledger: Balance Sheet and P&L Statement

0FIGL_VC2 Cost of Sales Ledger: Balance Sheet and P&L Statement (for cost of sales accounting

Cost-of-Sales Ledger: Balance Sheet and P&L

0FIGL_VC2

This is a virtual cube with services. This means that it contains no data. Queries based on this cube are supplied by the implemented services with data from BasisCube 0FIGL_C02.

For queries for displaying a balance sheet and P&L according to a balance sheet/P&L structure, these services calculate the result (profit / loss) and ensure correct display of the balance-dependent accounts assigned in the balance sheet/P&L structure.

For Extraction check this link

Thanks ,

Hema

[Former Member · Accepted solution]

thanks for ur replies.

i'm viewing given links & threads...

naresh

[Former Member]

Hi, Naresh.

You should use infoobject "Financial Statement Item" (0GLACCEXT) and load versions with datasource 0GLACCEXT_T011_HIER.

Hope it helps,

Alexander Kuzmich

[Former Member]

thanks for ur reply..

After that for all GL accounts, wish to extract transaction data. Can i extract day(date) level information for these accounts to BI7. What datasources(transactional) are suitable to my requirement? could anybody tell procedure for extraction?

naresh

[Former Member]

Hi

help.sap.com would be the best source for this.

Try 0FIGL_C01 for the Transaction GL data.

This InfoCube contains all the transaction data from the general ledger that were loaded from the integrated source system(s).

Note

In all of the queries that are based on this InfoCube, you can branch to the query G/L: Balances, Period Breakdown. You can then explain the cumulative balance of a G/L account or a higher financial statement item in detail. The period view shows the allocation of the balance to the individual posting periods.

The query G/L: Balances, Period Breakdown is not however assigned to a role, and does not appear in a workbook. When you activate the Business Information Warehouse from roles and workbooks, you should also ensure that you activate this query.

http://help.sap.com/saphelp_nw70/helpdata/EN/2d/955a73da4d6d41a0a6128caf274ce8/frameset.htm

Hope it helps