08-25-2009 10:39 AM
Hi all,
I have Sales Order and Sales Item with me.I want to check that whether this Sales Order and its Item has been already posted in COPA.I'm trying to check it by using the Select Condition on Ce1xxxx table but it is taking too much time to check.Is there any other way to get the data?
Thanks in advance.
Sarbajit.
08-25-2009 11:23 AM
Hi,
Make sure you specify the period and fiscal year in your query because the CE* tables are very huge in size.
Similarly you can check Tcode KE24 which gives you COPA postings by line item and you have sales order as a selection parameter.
Also check FM
CATT_COPA_READ_LINE_ITEM
****************************************
COPA_SD_DOCUMENT_ITEM_CREATE
COPA_SD_DOCUMENT_ITEM_POST
COPA_SDTRACE_LOG_GET_ITEMS
COPA_SDTRACE_LOG_SEND_ITEMS
Usually COPA reports are created using internal report painter tool by functional ppl from
SAP Menu->Accounting ->Controlling ->Profitability Analysis ->Information System ->Define Report ->all tool inside it.
Regards,
Amit