Skip to Content
0
Former Member
Jun 20, 2007 at 03:38 PM

select statement

15 Views

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 aaufnr aauart b~arbei INTO CORRESPONDING FIELDS OF TABLE it_tab

FROM aufk AS a

INNER JOIN plpo AS b ON awerks = bwerks

INNER JOIN iloa AS d ON abukrs = dbukrs

*06/18

INNER JOIN afko AS e ON aaufnr = eaufnr

*

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