I am using the DFKKKO and DFKKOP table to get the invoices. Can someone help me get the SQL query for Cancel invoice?

Hi Onkar, have you tried installing the process connectors from the marketplace? Celonis has process connectors for Accounts Payable / Accounts Receivable. These should help you get started with the SQL code. Most activities you need are available from there!

Hi Dennis,

Yes i tried but they are based on BSEG and BKPF table. I need the query that is for DFKKKO and DFKKOP table.

Not the query but may help:

https://www.tcodesearch.com/sap-tables/TE505?expand_article=1

https://answers.sap.com/questions/5877889/table-for-cancelled-and-original-billing-document.html