Skip to main content

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