topic Re: link between tables in Application Development and Automation Discussions

link between tables

Former Member — Fri, 30 Mar 2007 14:39:22 GMT

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 — Fri, 30 Mar 2007 14:48:09 GMT

AUFNR is the link between AFKO and AUFM.

Regards

Rich Heilman

RichHeilman — Fri, 30 Mar 2007 14:50:13 GMT

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 — Fri, 30 Mar 2007 14:54:23 GMT

Hi,

LINK - Inventory document header in WM

LINP - Inventory document item in WM

Link between LINK and LINP is LGNUM ( Warehouse Number ).

AFKO - Order header data PP orders

AUFM - Goods movements for order

The link between AFKO and AUFM is AUFNR ( Order number ).

Table AUFK contains Order master data.

Regards,

former_member184495 — Fri, 30 Mar 2007 15:51:10 GMT

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 Table Join from DataSource.

Click OK.

Click Icon InserTable.

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.