select statement

Former Member — Wed, 20 Jun 2007 15:38:42 GMT

Hi :

How can i join aufnr , arbei , ismnw since there is no common key field between arbei and aufnr , ismnw.

I am able to join aufnr and ismnw based on aufnr, because im trying to pull data based on aufnr , but when i went to se84 and tried to chk tables for arbei...only one table HIKO has all these fields but there is no data in that.

SELECT a_{aufnr a}auart b~arbei INTO CORRESPONDING FIELDS OF TABLE it_tab

FROM aufk AS a

INNER JOIN plpo AS b ON a_{werks = b}werks

INNER JOIN iloa AS d ON a_{bukrs = d}bukrs

*06/18

INNER JOIN afko AS e ON a_{aufnr = e}aufnr

WHERE a~auart IN s_auart

AND a~auart NE 'PM04'

AND a~auart NE 'PM09'

AND a~werks = 'M600'

AND d~tplnr = 'PB-PRO-S01-BY02-MIL'

AND d~abckz IN s_abckz

AND a~erdat IN s_date.

SELECT SINGLE ismnw INTO v_ismnw FROM afru

WHERE aufnr = v_aufnr.

it_tab-ismnw = v_ismnw.

with my first select statment do i get unique values for arbei?

i would appreciate if any one can help me on this.

Thanks.

Raghu

Re: select statement

Former Member — Fri, 22 Jun 2007 02:55:13 GMT

I solved the query...

ELECT a_{aufnr a}auart INTO CORRESPONDING FIELDS OF TABLE it_tab