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

Extract BS/PS

Hello everyone,

as Im in IT and not FI/CO and I have a request-

How would I extract the Balance Sheet (or P&L) for a period to a flat file?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 14, 2015 at 10:19 AM

    (I men, is there a standard transaction or we need a create a new one)

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 14, 2015 at 10:28 AM

    Hi,

    if you are using the standard report 0FIGL_C10_Q0001 , then you can extract the query data to excel using tcode RSCRM_BAPI

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      I am assuming, you have 0FIGL_C10 cube which is receiving GL data from ECC, if yes, then you can make use of the standard Query which is on top of this cube,and follow below.

      Using this T.code RSCRM_BAPI -- you can extract the report to CSV only to application server.

      if you want it to be saved in your local drive, then use APD (T.code RSANWB ) , choose your query as Data source and PC(give your local path here) as target.. in this way you can extract query to local drive.

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.