link between tables

[Former Member]

I have to know the link between AFKO,AUFM,LINK,LINP tables.

I m not able to find any common field in this tables.

Can any one tell me how these tables r linked.

Thnaks in advance.

[RichHeilman]

AUFNR is the link between AFKO and AUFM.

Regards

Rich Heilman

[RichHeilman]

You may need to go from AUFM to MSEG to get the LGNUM in order to link to LINK and then LINP.

AUFM and MSEG and be link using material document number

Regards,

Rich Heilman

[Former Member]

Hi,

LINK - Inventory document header in WM

LINP - Inventory document item in WM

<b>Link between LINK and LINP is LGNUM ( Warehouse Number ).</b>

AFKO - Order header data PP orders

AUFM - Goods movements for order

<b>The link between AFKO and AUFM is AUFNR ( Order number ).</b>

Table AUFK contains Order master data.

Regards,

RS

[former_member184495]

hi Maya,

the best way to find a link between multiple tables is using :

T-code SQVI.

enter any name in QuickViewer field.

Click Create.

Give any title.

Select <b>Table Join</b> from DataSource.

Click OK.

Click Icon <b>InserTable</b>.

add your table-1, again click the same Icon add your table-2 and so on...

It shall show you which field is common between them.

Reward if helpful.

Aditya.