How to join

[Former Member]

Hi all,

I have three tables LFM1,ADRC,ADR6,but there is no common field to join with LFM1,any one help me how to join these tables.

Thanks&regds,

Sree.

[Former Member]

Hi all,

I have three tables LFM1,ADRC,ADR6,but there is no common field to join with LFM1,any one help me how to join these tables.

Thanks&regds,

Sree.

[Former Member]

hi,

Use table LFA1 table to join with LFM1 by using primary key

LIFNR....

then use LFA1-ADRNR field to join with table ADRC...

Regards ,

Brijesh