inner join

[Former Member]

SELECT AUFNR OBJNR BUKRS FROM AUFK

INTO CORRESPONDING FIELDS OF TABLE I_AUFK

WHERE BUKRS = P_BUKRS.

SELECT OBJNR STAT FROM JEST

INTO CORRESPONDING FIELDS OF TABLE I_JEST_IN

FOR ALL ENTRIES IN I_AUFK

WHERE OBJNR = I_AUFK-OBJNR

AND STAT EQ R_STAT1

AND STAT NE R_STAT2.

Hi ,

I want to join the above two table ...and then i will

SELECT AUFNR MATNR DWERK FROM AFPO

INTO CORRESPONDING FIELDS OF TABLE I_AFPO

WHERE OBJNP = I_JEST_IN-OBJNR.

I am getting error , Pls solve

Sabya

[anversha_s]

hi,

try like this.

SELECT AUFNR OBJNR BUKRS FROM AUFK
INTO CORRESPONDING FIELDS OF TABLE I_AUFK
WHERE BUKRS = P_BUKRS.

if  I_AUFK[] is not initial. " use this.

SELECT OBJNR STAT FROM JEST
INTO CORRESPONDING FIELDS OF TABLE I_JEST_IN
FOR ALL ENTRIES IN I_AUFK
WHERE OBJNR = I_AUFK-OBJNR
AND STAT EQ R_STAT1
AND STAT NE R_STAT2.

endif.

Rgds

Anver

[Former Member]

Hi,

SELECT a_{AUFNR a}OBJNR a_{BUKRS b}STAT

INTO CORRESPONDING FIELDS OF TABLE I_JOIN_ITAB

FROM AUFK as a join JEST as b

on a_{objnr = b}objnr

WHERE a~BUKRS = P_BUKRS

AND b~STAT EQ R_STAT1

AND b~STAT NE R_STAT2.

reward points if useful

regards,

ANJI

[Former Member]

Try this way...

SELECT a~AUFNR a~OBJNR a~BUKRS b~STAT
INTO CORRESPONDING FIELDS OF TABLE I_JOIN_ITAB
FROM AUFK as a 
join JEST as b
on a~objnr = b~objnr
WHERE a~BUKRS = P_BUKRS
AND b~STAT EQ R_STAT1
AND b~STAT NE R_STAT2

.

[Former Member]

hi

SELECT AUFNR OBJNR STAT

INTO CORRESPONDING FIELDS OF TABLE ITAB

FROM AUFK as A

inner join JEST as B

ON A_{OBJNR = b}OBJNR

WHERE BUKRS = P_BUKRS AND

STAT EQ R_STAT1

AND STAT NE R_STAT2.

u can go for seperate select instead of Joins.

Regards,

madhu

[Former Member]

try this

select aufk_{aufnr aufk}objnr aufk_{bukrs jest}objnr jest_{stat afpo}matnr afpo_{dwerk into table it_detail from aufk inner join jest on aufk}objnr = jest~objnr

inner join afpo on jest_{objnr = afpo}objnp

where aufk~bukrs = p_bukrs

and jest~stat = r_stat1

and jest~stat <> r_stat2.

create a table(it_detail) with all the above fields and use it.

[Former Member]

hI..

hI..

SELECT AUFNR OBJNR BUKRS STAT

FROM <b>AUFK INNER JOIN JEST</b>

INTO TABLE ITAB

ON AUFK_{OBJNR = JEST}OBJNR WHERE

OBJNR = I_AUFK-OBJNR AND

STAT = R_STAT1 AND

STAT <> R_STAT2 AND

BUKRS = P_BUKRS.

<b>***iNNER JOIN ALWAYS BETTER FOR 2 TABLES.

fOR 3 RD TABLE GO WITH FOR ALL ENTRIES.

IF SY-SUBRC EQ 0.</b>

SELECT AUFNR MATNR DWERK FROM AFPO

INTO CORRESPONDING FIELDS OF TABLE I_AFPO

<b>FOR ALL ENTRIES IN ITAB</b>

WHERE OBJNP = ITAB-OBJNR.

ENDIF.