how LIPS item link the MSEG item?

[Former Member]

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 MKPF_{MBLNR MSEG}ERFMG MKPF_{XBLNR MSEG}MATNR

INTO CORRESPONDING FIELDS OF TABLE IT_MSEG

FROM MSEG INNER JOIN MKPF ON MKPF_{MBLNR = MSEG}MBLNR AND

MKPF_{MJAHR = MSEG}MJAHR

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]

Link LIPS & MSEG with the below Fields

KDAUF KDAUF CHAR 10 0 Sales Order Number

KDPOS KDPOS NUMC 6 0 Item Number in Sales Order

[robert_altenstraer]

Hi

may it´s better to get the data from table: VBFA

Robert

[Former Member]

Dear ALl,

Thanks

the table is VBFA.

I will close this issue.

[Former Member]

Hi,

There is a link between

VBRP AND LIPS

LIPS-VBELN = VBRP-VBELN

LIPS-POSNR = VBRP-POSNR

[Former Member]

Hi Sun,

Just open SQVI,

Enter a Quick view name,

and create..

then insert tables,,,(mseg, Lips)

It shows all the possible links,,,

Thanks & regards,

Dileep .C