First, we have created O2C process and added tables that are required for AR process. The extraction part is done, but we have stuck in the data model. The connection between vbap and vbfa may be failing.
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
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
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
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.