Hi Guys, how to do O2C process and AR process in one analysis.

Hello,

could you kindly provide more information? I assume that you've got error while doing data model load, about N:N relation between VBFA & VBAP? Right keys for connecting tables VBAP and VBFA seems to be:

VBFA.POSNV-VBAP.POSNR

VBFA.VBELV-VBAP.VBELN

VBFA.MANDT-VBAP.MANDT

Best Regards,

Mateusz Dudek

Hey Mateusz,

Thanks for the answer, we tried this.

Would you kindly refer to the attached file?

It shows the message we got when loading the data model.

Best Regards,

Omachi Satoshi

Hello,

In the message clearly the key between EKPO and VBFA is not created correctly or fields in table are not standard so they don't match. if the key seems to be ok, then I'm afraid you need to check tables manually in SE16N transaction to modify standard key in Celonis.

It would be good to do that with SD SAP SME (Subject Matter Expert), I would recommend to first find specific document and matching PO. Then find both items in their tables, and check columns that should be used for key, maybe on one the sides, there's additional field added or for example some single sign?

More details about joining purchasing data to sales data can found here:

https://answers.sap.com/questions/1145795/relation-between-tables-ekpo-and-vbak.html

https://answers.sap.com/questions/11038286/table-join-ekkoekpo-vbakvbap.html

Best Regards,

Mateusz Dudek

Hey Mateusz,

I really appreciate you responding to my question, we'll try this.

Best Regards,

Omachi Satoshi