Doubt in 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]

Please....Do not duplicate posts....

Greetings,

Blag.

[Former Member]

Dude, the question is important thats why i asked twice , hoping atleast one reply from experts.

thx

[Former Member]

Everybody's question is important.

All you have to do is edit your original question and it will pop to the top.

If you ask the same question twice, somebody may spend a lot of time trying to answer your question only to find that someone else answered it a long time before.

Rob