COPA Dimension wise TB

[Former Member]

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

[suryavarma_co]

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

[Former Member]

Hi Surya,

If i use KE30 and other tcodes i will get balances only for COPA entries. what about FI entries and CO entries which are not having COPA dimensions. Our purpose is to create the trial balance with CC, PC and COPA dimension columns.

Regards

Zunaid

[ajaycwa1981]

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