Skip to main content
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,
Lukasz

Best 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


Reply