eina

[Former Member]

Hi,i wnt infnr,matnr,lifnr,urzdt from eina and urzdt is with reference to plant.

i am retrieving matnr,plant from mara, marc using inner join into t_mara.

refering this t_mara, within this fields matnr can be refered to eina-matnr and werks for eine which is having plant.

need query

urgent pls help

regards,

kb

[Former Member]

Ask the same question twice for someone to write the code for you.

GOOD LUCK!!!!!!!!!!!!!!

But I am sure some fool will do it.

[Former Member]

when u cant just dont reply.

u have no right to say like this.

[Former Member]

Use EINA and EINE (which contains plant)

[Former Member]

HI

Check this INNER JOIN on EINA and EINE

IF NOT ITAB[] IS INITIAL.

SELECT a_{infnr a}lifnr a~matnr

b_{ekgrp b}ekorg b_{peinh b}bprme

INTO TABLE g_t_purinfo1

FROM eina AS a

INNER JOIN

eine AS b

ON a_{infnr = b}infnr

FOR ALL ENTRIES IN g_t_editpos1

WHERE a~infnr = ITAB-infnr

AND b~ekgrp IN so_ekgrp

AND b~ekorg IN so_ekorg

AND a~lifnr IN so_lifnr

AND a~matnr IN so_matnr.

ENDIF.

Hope this Helps.

Thanks Praveen

[Former Member]

thanks