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

COPA Dimension wise TB

Hi Experts,

We are having standard trial balance in sap system.

We have activated Account based COPA. I want to create Custom Trial Balance. This trial balance would be at COPA dimension level. We have five dimensions. MMCP, Product, Channel, Location and underwriting years. All this will be columns in our Trial Balance including one more column for values having no Dimensions (only cost centre posting).

Now confusion is which Table we have to read to get these different values. We have to read the tables from FI, CO and COPA.

If we read CO table COEP we only get Cost Centre and not Dimension. If we check COPA table we get values with cost centre having COPA dimension.

If you have any idea of tables to use for this report, please guide.

Regards

Zunaid

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on May 21, 2013 at 05:45 AM

    Hi Zunaid,

    Why are you trying to built a "Z" report (Custom Report) without using the Standard functions of Report building in COPA. It would be wise if you use Tr Codes KE30,KE31,KE34 Transaction and choose Account Based COPA and build these reports.

    Best Regards

    Surya

    Add a comment
    10|10000 characters needed characters exceeded

    • Hi

      Sorry Bro, You are not clear on what to expect from the system... Expectation management is very important in an ERP implementation.. If you expect SAP to wash the car on your behalf, that cant happen

      COPA is not intended to give you Trial balance... Only the sales related entries (Sales Rev, Discounts, COGS) flow to COPA... Then when you settle the prod orders, variances flow to COPA... And when you allocate the mktg overhead, the same flows to COPA

      WHat you get from COPA is a profitability statement and not P&L Account... A P&L account is one where you get GL by GL balance, and Prof statement is one where you summarize the GL accounts and arrive at a figure

      Br, Ajay M

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.