Skip to Content
author's profile photo Former Member
Former Member

financial statement version extraction

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 23, 2008 at 12:56 PM

    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

    extraction-from-r3-to-bw

    Thanks ,

    Hema

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 23, 2008 at 12:10 PM

    Hi, Naresh.

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

    Hope it helps,

    Alexander Kuzmich

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member 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

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.