copa extractor

[Former Member]

Hi Everyone,

Iam having an interview today. can u plz guide me as iam new to CO-PA what can be the possible questions n answwrs for :

This

resource should understand the COPA cubes in BW, the likely reporting

requirements for Profitability Analysis, and have the ability to

understand how multiple data sources have to lead to Profitability

Reporting in BW. They should have a deep understanding of how COPA works

in R/3, and why certain COPA reporting should be moved to BW. On the BW

side, the resource should understand how the COPA cubes are usually

structured, how to create reports (both Bex and Web),

can u plz reply as soon as possible. will assign points

thanks

[Former Member · Accepted solution]

Hi Haritha;

The most common question asked are:-

1> Difference between Cost Based and Account based Profitability Analysis ?

2> When do we used them ?

3> How many tables are you created on R/3 Side,what are they?

4> How do you get COPA data from R/3 to BW.?

5>How many datasources you need to create and why?

6> Which currency did you used ?

Hope this helps

[Former Member · Accepted solution]

Hi,

Thanks for ur response. Can u plz post some interview questions ad hoc reporting?

That would be a great help. Kindly post the answers also.

Thanks and assigned points for it

[RenjithKumar]

<a href="http://help.sap.com/saphelp_sm40/helpdata/en/08/965b423be8de54e10000000a155106/content.htm">This</a> can help u

[Former Member]

Thanks so much.

But can u gimme me interview questions in ad hoc and reporting?

Once again thanks

[RenjithKumar]

Hi ,

The Difference between Cost based and Account Based COPA

The big difference between Account Based CO-AP and Costing Based CO-PA is of course the data is stored in the CO Modules.

<b>Account based CO-PA</b>

It is part of the CO concept. This means when you post to a cost element the data is posted to a CO-module (CCA, OPA, PA, PS etc). The way the data is stored is also different from costing based PA.

The CO tables like COEP, COBK (for the individual item are used and the COSS and COSP are used for the totals.

The object where the posting are related to they are stored in the CE4... table. So if you want to analyse the data there is 1 keyfigure and the cost-element is a characteristic (account model).

<b>Cost Based CO PA</b>

Costing Based CO-PA data is statistical data. This means that the update of CO-PA is not always equal to what is stored in the CO modules or in finance. The cost element is also not always updated and there are also more key-figures used to store info about the type of costs or revenues. Tables as CE1, CE2 , CE3 and CE4 are used.

Extraction for Account Based CO-PA is only based on the total records (full loads are only possible). For costing based CO-PA there it is possible work with init and delta packages and also to select data from the individual postings databases (CE1, CE2).

But in both The way you generate the extractor is similar.

[Former Member]

Hi Renjith,

Seems you are expert in COPA Extraction. I have a requierment , where I need to use 11 fileds out of 11 , 10 are coming from one single Info Object (i.e, 0WBS_ELMT) ,1 field is coming from a different table called COBK.(Posting Date). Now I need to show a report with this 11 fields.Does it requier COPA Extraction ? How Actually COPA Extraction Works. Is it in the same way as LO etc...

Here 1. How can I show the report out of an info object. Is it adviceble to report from Info Object / Do I need to create a DSO for this (We are on BI7 and ECC6).

2. How can I get this Posting date data in my report. Do I need to create a generic DS for a single field to get in to BI .(Postind Date is Transactional Data).

Please advice.

[Former Member]

Hi Haritha

Did u already go through this interview. If so please email me some questions from your interview. email: adityayn@gmail.com

Aditya