COPA R/3 vs BW(aCCOUNT BASED-PA)

[Former Member]

Can you tell the procedure for <b>Account based COPA Extraction</b>

I assume there are some additonal steps to be carried out to do the Account based COPA extraction and for this what are the base tables.

I undersatnd the base tables for Account base COPA is coej,coep,coss and cosp.

Any ways could be please explian in detail about COPA Extraction.

YOur help is highly appreciated.

Regards,

VJ

[p_geurts]

Hi,

One of the differences between account based CO-PA and costing-based CO-PA that there is no delta extraction. There is also 1 other rule. You can only select 1 fiscal-period. The set-up is similar to costing based CO-PA.

And the tables used,you described already.

The data is extracted from the COSS, COSP and CE4....

No individual postings.

Regards,

Peter

[Former Member]

Hi Peter,

Can you Explain me in detail.

Regards,

VJ

[p_geurts]

VJ,

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

Account based CO-PA 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).

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).

The way you generate the extractor is similar.

Hopelfully this gives you a bit more background of the CO-PA module.

Regards Peter

Cost

[Former Member]

Hi Peter,

Thanks for the information.

If you can explain me clearly the extraction strategy for COPA Account based it is very useful for me.

I hvae an aperating concern AB01 which is Account based based.

I checked the Tables COSS and COSP.

But am getting doubt the Fields transactional currency fields in my datasource are different when i compare with the fields in COSS and COSP tables.

<u><b>DataSource Fields</b></u>

<b><u>Fields</u></b>

BUKRS.............Company Code

COPA_KOSTL........Cost Centre

GJAHR............Fiscal Year

GSBER...........Business Area

KMKDGR..........Customer Group

KMLAND..........Country Key

KMMAKL..........Materail Group

<b>KOKRS...........Controlling Area</b>

KSTAR.............Cost Element

KTOPL.............Chart of Accounts

KWAER..............Controlling Area Crcy, Account-Based Profitability Analysis

MEGBTR................Total Quantity

MEINH................Unit of Measure

OWAER................Object Currency, Account-Based Profitability Analysis

<u><b>PERIO................Period/Year </b></u>

PERIV..............Fiscal Year Varaint

PRCTR..............Profit Centre

PRODH..............Product Hierarchy

PSTYV...............Sales document item category

REC_WAERS.............Currency of the data record

SPART............... Division

TWAER.............Transaction Currency, Account-Based Profitability Analysis

VERSI...........Plan version (CO-PA)

VKBUR................Sales office

VKORG..................Sales Organization

VTWEG....................Distribution Channel

WERKS....................Plant

WKFBTR...................Fixed Value in Controlling Area Currency

WKGBTR..............Total Value in Controlling Area Currency

WOGBTR.............Total Value in Object Currency

WRTTP............... Value type for Reporting

WTGBTR................ Total Value in Transaction Currency

In My Data source KOKRS and PERIO fileds are mandatory by default fields.

The main problem is when i check the Data thru Extractor checker(RSA3) and getting an msg as <u><b>Error occoured during extraction</b></u>.

Secondly in BW i assign infosource and maintain transfer and communication structure and activated.

<u>Third</u>

When i try to create info cube based on the infosource no key figures are transferred from infosource to Cube.

What could be the reason.

Your advice is highly appreciated.

Regards,

VJ

[p_geurts]

Hi,

It is a long time ago that I have defined my a new acct.based co-pa in BW.

The reason of the error message is that there is no summarization level in CO-PA available. This is used for full loads or for intialisations (from PI2001.1 available). With transaction KEDV you can define them in R/3 and they are loaded with KEDU.

Your datasource fields are right. The data in CO is always build on key-figures in transaction, object and in controlling are a currency. In the COSP/COSS you see them only 16 times (for each period). You hev ato map them to your own defined keyfigures with their own currency (similar to 0AMOUNT). I you add these keyfigures to the transfer rules and communication structure then it is also possible to update them in the info-cube.

Regards Peter

[Former Member]

Hi Peter,

it is very useful information which you have provided can you please elaboraretly explain me in detail about Summarization level how it will be useful for me in this scenario.

I request you to please explain me in detail.The key figures which i ahve in my data source are found in table COEP table.

And very detail step by step procedure for Account based COPA.

I Generated Data source Thru KEB0 and rest of the steps i follwed in BW.(replication of Datasource,assign infosource and create ODS or Cube.The mapping for Info source i used custom defined infoobjects)

Regards,

VJ

[Former Member]

<u><b> COPA Account Based Problem</b></u>

Hi Peter,

I would like to thank you for the information which you share with me.

In my system COEP and COBK having data.

And COSS and COSP are also having data.

But I could not able to compare the fields of my COPA Datasource fields with these tables.

Most of the fields are available in COEP.(mainly currency fields.)

There is no data in CE4XXXX table.

Can you please explain me in detail about.

<b>Segment Level, Segment Table, Line item and Summariztion Level and value fields</b> in Account based.

What will happen when I do Summarization level how the error will get resolve.

What is the Main source Table to populate data in BW for Accoutn based extarction (COPA).

Regards,

VJ

Message was edited by: VIJAY PUPPALA

[Former Member]

There is a lot of documentation available where you least expect it. In your R/3 system. To find it:

In R/3 go to SBIW.

-> Settings for Application-Specific DataSources (PI)

-> Profitability Analysis

There are documents attached to this entry and its sub-entries. You can open them by double clicking.

[Former Member]

Hi Vijay,

Refer to this How to document for COPA extraction

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/fb07ab90-0201-0010-c489-d52...

Not very sure about account based, not many clients implement that.

Hope it helps.

Cheers

Anurag