topic Re: table join using for all entries in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/table-join-using-for-all-entries/m-p/1589668#M265521 <HTML><HEAD></HEAD><BODY><P>The line between LIKP and LIPS is VBELN, this is delivery note number. You can link VBAK with LIPS via VBAK-VBELN = LIPS-VGBEL, also, VBAP to LIPS like this.</P><P></P><PRE><CODE> lips-vgbel = vbap-vbeln lips-vgpos = vbap-posnr</CODE></PRE><P></P><P>You can link VBAK to KNA1 using the KUNNR field.</P><P></P><P>Regards,</P><P>Rich Heilman</P></BODY></HTML> Sun, 10 Sep 2006 13:10:28 GMT RichHeilman 2006-09-10T13:10:28Z table join using for all entries https://community.sap.com/t5/application-development-and-automation-discussions/table-join-using-for-all-entries/m-p/1589667#M265520 <HTML><HEAD></HEAD><BODY><P>hi</P><P></P><P>i need to join the tables likp,lips,kna1 and vbak.can anyone tell me the linking fields between lips and kna1??</P><P>and the linking fields between all the tables....</P><P></P><P>urgent please.</P><P></P><P>sharmila tagore.</P></BODY></HTML> Sun, 10 Sep 2006 13:00:42 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-join-using-for-all-entries/m-p/1589667#M265520 Former Member 2006-09-10T13:00:42Z Re: table join using for all entries https://community.sap.com/t5/application-development-and-automation-discussions/table-join-using-for-all-entries/m-p/1589668#M265521 <HTML><HEAD></HEAD><BODY><P>The line between LIKP and LIPS is VBELN, this is delivery note number. You can link VBAK with LIPS via VBAK-VBELN = LIPS-VGBEL, also, VBAP to LIPS like this.</P><P></P><PRE><CODE> lips-vgbel = vbap-vbeln lips-vgpos = vbap-posnr</CODE></PRE><P></P><P>You can link VBAK to KNA1 using the KUNNR field.</P><P></P><P>Regards,</P><P>Rich Heilman</P></BODY></HTML> Sun, 10 Sep 2006 13:10:28 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-join-using-for-all-entries/m-p/1589668#M265521 RichHeilman 2006-09-10T13:10:28Z Re: table join using for all entries https://community.sap.com/t5/application-development-and-automation-discussions/table-join-using-for-all-entries/m-p/1589669#M265522 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Link between LIKP/VBAK</P><P></P><P>LIPS-VBELN = LIKP-VBELN</P><P></P><P>U can try the sales order number in item data:</P><P>LIPS-VGBEL = VBAP-VBELN</P><P>LIPS-VGPOS = VBAP-POSNR</P><P></P><P>U can try the link in VBFA table too</P><P></P><P>VBAK-VBELN = VBAP-VBELN</P><P></P><P>Link VBAK/KNA1</P><P></P><P>KNA1-KUNNR = VBAK-KUNAG </P><P></P><P>U can try the link in VBPA table too</P><P></P><P>Max</P></BODY></HTML> Sun, 10 Sep 2006 13:19:26 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-join-using-for-all-entries/m-p/1589669#M265522 Former Member 2006-09-10T13:19:26Z Re: table join using for all entries https://community.sap.com/t5/application-development-and-automation-discussions/table-join-using-for-all-entries/m-p/1589670#M265523 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P> vbak-vbeln = lips-vgbel get lips-vbeln and vbak-</P><P> kunnr.</P><P> lips-vbeln = likp-vbeln.</P><P> vbak-kunnr = knan1-kunnr.</P><P>Regards</P><P>Amole</P></BODY></HTML> Sun, 10 Sep 2006 13:48:34 GMT https://community.sap.com/t5/application-development-and-automation-discussions/table-join-using-for-all-entries/m-p/1589670#M265523 Former Member 2006-09-10T13:48:34Z