COPA Extarctor

[Former Member]

Hi Guys ,

I new to COPA extractor . I wanted some information on extarctor --> 1_CO_PA_NCH_2000D...

What is source table invloved ?

What is the extractor is for ?

Pls help , if anyone knows the things

Regards

Ankit Vaish

[srinivas_anilkumar]

Hi,

COPA datasources are built as per the organisational requirementts. Normally the data source format would be 1_CO_PA_ clnt_operating concenrn

The tables involved would be CE1xxxx (Actual Line item), CE2xxxx ( Plan Line item) , CE3xxxx(Segment table), CE4xxxx ( Segment Level)

XXXX is Operating concern

Assign points if ite helps

Regards,

Srinivas

Message was edited by:

Srinivas

[Former Member]

Thanks Srinivas for the reply ....but what all those table means ...

I will Tell you my actual Problem is to check that the Billing Item data coming from VDITM exist in this COPA extratcor or not...How can i do that ...Loading the data into BW is taking lot of time .....

Reagrds

Ankit Vaish

[srinivas_anilkumar]

Hi,

Check for the data source in RSA3 . HOpe it helps

Assign points if it helps

Regards,

Srinivas

[Former Member]

Hi Srinivas ,

Thaks for your mail . But Data is RSA3 is only showing 87 records , but while pulling in BW , there more than 200000 records .Is there any setup table concept for that .

Regards

Ankit

[Former Member]

Hi,

Go to the billing documnet in VF03.

Give your billing documnet number there.Then in the in the header tab click on the controlling tab.

If you see the a profitability analysis document then it is hitting the CO-PA.and you can find the documnet there.

OR there is another easy way.

In case if postings are done directly without billing document do this.

Go to the billing documnet in VF03.Say show documnet flow.

Take the accounting document number from there and then put this accounting documnet in the field in RBELN field of the table CE1NOVA.

you can see the sales documnet number associated woth that billing documnet in filed KAUFN of the table.

Just go to RSA3 and check the fields there.

Also

to check for billing document put billing number in the field RBELN.and repeat the above.

Also in the RSA3 of the data source you dont have selection for the document number so try to give company code and posting date of the CO-PA document to verify the result.

Hope it helps

Thanks