Table Mapping VBEP between LIKP , LIPS

[Former Member]

Hi Experts,

i want to map table VBEP ,LIPS,LIKP,

Table VBEP-EDATU,VBEP-WMENG is for schedule line from where we r reading order quantity and date.

From table LIPS-LFIMG we r reading deliver quantity.

My requirement is to map both of these tables and want to read LFIMG(Deliver Quantity) from LIPS based on Schedule Line Date.

Header Table is LIKP.

How i will find that.

Thanks and Regards

abaper.

[Former Member]

Hi Experts,

i want to map table VBEP ,LIPS,LIKP,

Table VBEP-EDATU,VBEP-WMENG is for schedule line from where we r reading order quantity and date.

From table LIPS-LFIMG we r reading deliver quantity.

My requirement is to map both of these tables and want to read LFIMG(Deliver Quantity) from LIPS based on Schedule Line Date.

Header Table is LIKP.

How i will find that.

Thanks and Regards

abaper.

[Former Member]

Hi

<b>Pass the VBEP-VBELN and POSNR to LIPS-VGBEL and LIPS-VGPOS fields

And join the LIKP and LIPS with the VBELN field</b>

Reward points if useful

Regards

Anji

[Former Member]

Hi

thanks for reply , actually we want to mapp according to shedule line date

and there is no option for shedule line date in LIPS tabel

Thanks and regards

abaper

[Former Member]

Refer this thread to know the relation

http://erpgenie.com/sap/abap/tables_sd.htm

[Former Member]

hi,

U can relate the tables as follows:

VBEP & VBAP relation

VBEP-VBELN = VBAP-VBELN and

VBEP-POSNR = VBAP-POSNR .

VBAP &LIPS relation

VBAP-VBELN = LIPS- VGBEL.

LIPS & LIKP relation

LIPS-VBELN = LIKP-VBELN.

Revert back if any issues,

Reward with points if helpful.

Regards,

Naveen

[Former Member]

hi naveen,

i want to link the table on the basis of delivery date n not on document no. ,i got the document no, but the problem is i dont get it date wise as in LIPS there is no field which has delivery date of the sale order .............

so pl help in this regard

thanks n rgds

abaper