01-22-2008 3:05 PM
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
01-22-2008 3:07 PM
Ask the same question twice for someone to write the code for you.
GOOD LUCK!!!!!!!!!!!!!!
But I am sure some fool will do it.
01-23-2008 6:32 AM
01-22-2008 3:07 PM
01-23-2008 8:14 AM
HI
Check this INNER JOIN on EINA and EINE
IF NOT ITAB[] IS INITIAL.
SELECT ainfnr alifnr a~matnr
bekgrp bekorg bpeinh bbprme
INTO TABLE g_t_purinfo1
FROM eina AS a
INNER JOIN
eine AS b
ON ainfnr = binfnr
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
01-14-2009 10:13 PM