Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

how LIPS item link the MSEG item?

Dear ALl,

I have a program need to LIPS link MSEG to calculate the posting quantity.I know in MIGO,table MKPF have field saved the DN number.but not saved the item.

current my program is :

SELECT MKPFMBLNR MSEGERFMG MKPFXBLNR MSEGMATNR

INTO CORRESPONDING FIELDS OF TABLE IT_MSEG

FROM MSEG INNER JOIN MKPF ON MKPFMBLNR = MSEGMBLNR AND

MKPFMJAHR = MSEGMJAHR

WHERE MKPF~XBLNR = LIPS-VBELN AND

MSEG~MATNR =LIPS-MATNR.

now when the LIPS have many material ,then the program get wrong data.because i want get the item from LIPS item.

Please give me some advise,

Thanks

Sun

Former Member
Not what you were looking for? View more on this topic or Ask a question