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

CCSS extraction in BW

Hi,

I need to extract data of CCSS in order to replicate an R3 report (made with report painter) in BW. But CCSS is a structure: how can I see which tables are involved?

Thank you

Francesco

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Mar 08, 2012 at 10:40 AM

    Hi,

    You can try Table COEP. This should help you.

    Regards,

    Sanjay

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 08, 2012 at 11:39 AM

    Hi,

    If it's for BW why won't you work with Infosources? Here is the link to all relevant BI content for Controlling:

    http://help.sap.com/saphelp_nw73ehp1/helpdata/en/85/1f383fe58d5900e10000000a114084/frameset.htm

    Anyway, for totals look at COSS and COSP tables; these are the tables behind CCSS structure in R/3 reports.

    Regards,

    Eli

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 27, 2013 at 11:27 PM

    Hi,

    I am also trying to replicate GR55 into BW. I have WBS_1 and 6 datasources enabled but the Cost for Production Orders ( Actual Cost) is missing in these 2 DS.

    Do you know how to get the Cost for the Orders- PRODUCTION at WBS level. user report is at WBS level.

    thanks,

    BJ.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 28, 2013 at 02:48 AM

    Hi..

    Before you execute the report that you want to display using GR55, you activate “SQL Trace” using t-code ST05.

    After you execute the report, you deactivate “SQL Trace” and display trace result

    to get standard tables which are used by the report.

    Add a comment
    10|10000 characters needed characters exceeded

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.