table join using for all entries

[Former Member]

hi

i need to join the tables likp,lips,kna1 and vbak.can anyone tell me the linking fields between lips and kna1??

and the linking fields between all the tables....

urgent please.

sharmila tagore.

[Former Member]

Hi,

vbak-vbeln = lips-vgbel get lips-vbeln and vbak-

kunnr.

lips-vbeln = likp-vbeln.

vbak-kunnr = knan1-kunnr.

Regards

Amole

[RichHeilman]

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.

              lips-vgbel = vbap-vbeln
              lips-vgpos = vbap-posnr

You can link VBAK to KNA1 using the KUNNR field.

Regards,

Rich Heilman

[Former Member]

Hi

Link between LIKP/VBAK

LIPS-VBELN = LIKP-VBELN

U can try the sales order number in item data:

LIPS-VGBEL = VBAP-VBELN

LIPS-VGPOS = VBAP-POSNR

U can try the link in VBFA table too

VBAK-VBELN = VBAP-VBELN

Link VBAK/KNA1

KNA1-KUNNR = VBAK-KUNAG

U can try the link in VBPA table too

Max

[Former Member]

Hi,

vbak-vbeln = lips-vgbel get lips-vbeln and vbak-

kunnr.

lips-vbeln = likp-vbeln.

vbak-kunnr = knan1-kunnr.

Regards

Amole