select statement

[Former Member]

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

[Former Member]

I solved the query...

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

FROM aufk AS a

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 E~GETRI IN s_date.

AND a~erdat IN s_date.

SELECT SINGLE ismnw INTO v_ismnw FROM afru

WHERE aufnr = v_aufnr.

it_tab-ismnw = v_ismnw.

SELECT SINGLE a~arbei INTO v_arbei FROM afvv AS a

INNER JOIN caufv AS b ON

a_{aufpl = b}aufpl

WHERE b~aufnr = v_aufnr.

it_tab-arbei = v_arbei.