COPA Data source and Underlying tables

[#1]

Hi All,

I need to create COPA data source.

As per my understanding whenever we create Operating Concern for a project/bisuness, four underlying COPA database table will be created automatically( CE1XXXX,CE2XXXX,CE3XXXX,CE4XXXX). These tables store different data at different levels, to be specific CE1XXXX stores Atual line item data, CE2XXXX stores Plan line item data and like wise.

I just want to know:

when we create COPA datasource that will be based on these four tables. As they have different data at different level, how does COPA datasource accomodate these data? generally when we create one data source from different tables, then data should be at same granullar level.

Kindly provide some input

Thanks in Advance

Shubhramukta

[kr_pavankumar]

Hi Rana

Go thru these links

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c0e0d25d-cb7f-2e10-6abd-de25831a4...

http://scn.sap.com/thread/1243577

http://scn.sap.com/thread/1177206

Hope it clarifies ur doubt. If not revert your questions.

-- KRPK

[shubhramukta_rana]

Thanks Pavan,

Documents and links are helpful.

But my concern is:

How does COPA datasource fetch data from these four tables which are having different granularity?

All these four tables have different data. In normal scenario, if we create one generic data source based on more than one database tables, then we need to have these tables have data at same granularity and we need to define join conditions.

for example: two tables are there, one for header data and one for item data. We need to create one data source based on these two tables. Then the data source need to have data at header level, because we can not split header data into different items but we can aggregate item level data to header level.

In COPA, though we are not defining all these manually, still system must be having some mechanism to do this automatically.

can you focus some light regarding this. When we extract COPA data source in RSA3, the data which it shows are contents of four COPA tables. Then how does it(COPA data source) define granularity and aggregate these data?

Thanks

Shubhramukta