topic Re: eina in Application Development and Automation Discussions

eina

Former Member — Tue, 22 Jan 2008 15:05:19 GMT

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,

Former Member — Tue, 22 Jan 2008 15:07:46 GMT

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 — Tue, 22 Jan 2008 15:07:53 GMT

Use EINA and EINE (which contains plant)

Former Member — Wed, 23 Jan 2008 06:32:29 GMT

when u cant just dont reply.

u have no right to say like this.

Former Member — Wed, 23 Jan 2008 08:14:32 GMT

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 — Wed, 14 Jan 2009 22:13:21 GMT

thanks