Booking data in extraction CO-PA

[Former Member]

Hello everyone,

I'm new in extraction CO-PA. It seems very special.

I've created extractor with KEB0, and test it with RSA3.

I created a sales order for testing, it appeas in the table CE1***. but with RSA3, it doesn't find my sales order.

Does standard extractor CO-PA take only the sales orders which has be billed? or is there any reason else?

Thanks for all help!!

Juan

[Former Member · Accepted solution]

hi,

when you are creating the CO-PA data source, weather you are mentioned the

correct OPERATING CONCERN(belonging to sales order's) for the data source.

check out the operating concern

regards

harikrishna.N

[Former Member]

Hi,

When ever you do any transaction in any module and if the same has any impact on the profitability. and necessay mapping is done, few additional documents will get posted along with the base document like FI document CCA doc or COPA document. If only a COPA document is posted for the transaction, only then will you get it in RSA3 for COPA datasource.

In your case to my knowledge a sales order does not have any direct impact on profitability,, and therefore no COAP document would be posted.

Hope I have clarified your doubt. If the answer is useful please assign some reward points to me.

Regards

[Former Member]

Hi

I've found my sales order now in rsa3. In fact, it's the selection by sales order doesn't work. Strange!!!

In addition, I have questions:

What's the field named Currency Type? I've seen two record are created for every item of a sales order. The difference between the two record is only the Curreny Type.

And once an incoming sales order is delivered and billed, is the Record Type changed from "A" to "F" or a new record marked "F" will be created?

Venkata: I don't understand what you mean exactly.

I've added points for all your kind answers.

Best regards

Juan

[Former Member]

Hi,

Thanks for the points, let them keep coming for every answer!!!

when any transaction is posted in FI and CO the same are posted in multiple currencies( company code currency, Controlling area currency and object currency) therefore when you extract the data to BW you will get multiple records for each transaction. To report the correct data you will have to put a filter for currency type = either company code currency(10) or controlling are currency (20)in the query.

Regards the record type, data from various modules and sub modules in R/3 will flow to COPA, the record type is to differenciate the transactions. the same is mapped to transaction type infoobject in BW.

hope I have clarified.

[Former Member]

Hi Venkata,

Your answer is very clear. Thanks!

Just I don't know in the case of a life cyle of a sales order:

Once a sales order ( VA01 ) is created, a record with type "A" is created in the table CE1***.

When this sales order is deliverd and billed, is there a new record with type "F" will be created in CE1*** or system will just modify type from A to F in this record?

In the first case, for a nomal order, we will finally have at least 3 record (type A, F, C) for an item line of an order (we ignore here the multiple currencies) in table CE1***.

Thanks to tell me if I'm wrong.

Regards

Juan

[Former Member]

Hi,

COPA extractor is getting all the PA documents generated on R/3 side.

So, I believe your problem can be because of:

- Is your extractor getting data from the same operating concern that you created the extractor for?

- I believe that COPA extractors have a security time interval (I believe is 30 min by default). So, at least you'll get your data after some time if you're patient.

Regards,

David.

[Former Member]

Hi Hari, hi David,

Thanks for your answer.

How can I check the operating concern for Sales Orders?

I've just re-test with rsa3, my order is not appeared. (so I think it's caused of security time...) Where can I check the security time of an extractor?

Best regards,

Juan

[Former Member]

It's an urgent question.

Could anyone help?

Regards