Hello,Do you have any experience how to in corporate MSEG & MKPF into O2C data model? Seems that we can join MSEG to MARA through material number. I would be grateful for any hints.Best regards,LukaszBest regards,Lukasz

Hi Łukasz,

I've you've got O2C case I can assume that you've having both VBAP & VBAK tables (one of them probably will be also a case table). It seems in order to connect MKPF/MSEG tables to these, you'll have to create connection like the one proposed below, as just joining it to MARA via MATNR is probably not the best idea:

VBAP-LIPS-LIKP-MKPF-MSEG

VBAP.VBELN=LIPS.VGBEL

LIPS.VGBEL = LIKP.XBLNR

LIKP.VEBLN=MKPF.XBLNR

MKPF.MJAHR=MSEG.MJAHR + MKPF.MBLNR = MSEG.MBLNR (I've readed that inner join between these two tables can be very slow)

Useful links:

https://answers.sap.com/questions/687956/connecting-mseg-to-vbap.html

https://answers.sap.com/questions/1493701/relationship-between-tables-urgent.html

https://answers.sap.com/questions/3046998/join-likp-and-lips-points-will-be-awarded.html

http://sapnet.ru/viewtopic.php?t=4240

Not sure if that was helpful, let us know if that was good approach and how it worked! :)

Best Regards,

Mateusz Dudek

Thanks! I will try to test such an approach and share the outcome.

Regards,

Lukasz

Hi,

Suggested approach works fine. Thanks for your help!

-------------------------------------------------

LIPS.VBELN = LIKP.VBELN

LIPS.MANDT = LIKP.MANDT

LIKP.VBELN = MKPF.XBLNR

MKPF.MJAHR = MSEG.MJAHR

MKPF.MBLNR = MSEG.MBLNR

MKPF.MANDT = MSEG.MANDT

-------------------------------------------------

Regards,

Lukasz

Hi Lukasz,

Thanks a lot for sharing the outcome, and I'm glad it worked :)

Wishing happy Christmas and fruitfull new year!

Best Regards,

Mateusz Dudek