Inner Join Select query

[Former Member]

hello all,

Below is a inner join query

SELECT a_{ebeln a}ebelp a_{packno b}zekkn b~ps_psp_pnr

FROM ( ( ekpo AS a INNER JOIN ekkn AS b

ON a_{ebeln = b}ebeln

AND a_{ebelp = b}ebelp )

INNER JOIN prps AS c

ON b_{ps_psp_pnr = c}pspnr )

INTO TABLE t_wbspo

WHERE a~ebeln IN s_ebeln

AND c~psphi IN s_psphi

AND stufe = c_task.

I want to modify this select and put one more join on ekkn-aufnr

and aufk-afunr .

Now for this i write the below code

SELECT a_{ebeln a}ebelp a_{packno b}zekkn b_{ps_psp_pnr b}aufnr

FROM ( ( ( ekpo AS a INNER JOIN ekkn AS b

ON a_{ebeln = b}ebeln

AND a_{ebelp = b}ebelp )

INNER JOIN prps AS c

ON b_{ps_psp_pnr = c}pspnr )

INNER JOIN aufk AS d

ON b_{aufnr = d}aufnr )

INTO TABLE t_wbspo

WHERE a~ebeln IN s_ebeln

AND c~psphi IN s_psphi

AND d~aufnr IN s_aufnr

AND stufe = c_task.

By the above way does it puts a join on ekkn-aufnr and aufk-aufnr ?

Is the above way the right way to do it ?

Please confirm

regards

[Former Member]

Hey,

You can try your code it is the right way to join the table and it does join on ekkn-aufnr and aufk-aufnr

Regards,

Midhun Abraham

[Former Member]

Hello Bhanu,

Do you face any performance issue? Query looks good now, further you can refer to following threads to know more on JOIN-

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ec77446011d189700000e8322d00/frameset.htm

Thank You,

Nishikant Kumbhar.

[Former Member]

Hello Bhanu,

After your code changes you can check for SQL trace to know which one is giving better result.

Thank You,

Nishikant Kumbhar.