topic Doubt in select statement in Application Development and Automation Discussions

Doubt in select statement

Former Member — Wed, 20 Jun 2007 16:54:35 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: Doubt in select statement

Former Member — Wed, 20 Jun 2007 17:17:18 GMT

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

Greetings,

Blag.

Re: Doubt in select statement

Former Member — Wed, 20 Jun 2007 19:29:59 GMT

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

thx

Re: Doubt in select statement

Former Member — Wed, 20 Jun 2007 20:29:15 GMT

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