topic select query in Application Development and Automation Discussions

select query

Former Member — Wed, 25 Jul 2007 21:54:52 GMT

Hi,

In my selection screen i have work center (ARBPL) and start date.

I want to list work orders (AUFNR) based on technical object (tidnr) .

SELECT a_{gstrp a}gsuzp b_{aufnr c}vornr d_{arbpl b}ktext b~autyp INTO TABLE it_tab

FROM afko AS a

INNER JOIN aufk AS b ON a_{aufnr = b}aufnr

INNER JOIN afru AS c ON a_{aufnr = c}aufnr

INNER JOIN MCAFVGV AS D ON A_{AUFNR = D}AUFNR

WHERE

a~gstrp IN s_date

AND d~arbpl IN S_ARBPL.

The above select statement is displaying Process Orders ( autyp = '40')

but i want to list work orders also ( autyp = '30').

I would appreciate if anyone can drive me on this.

Former Member — Thu, 26 Jul 2007 04:05:20 GMT

First of all avoid using so many inner joins.

SELECT

a_{gstrp a}gsuzp b_{aufnr b}ktext b~autyp

INTO corresponding fields of table it_tab

FROM afko AS a

INNER JOIN aufk AS b ON a_{aufnr = b}aufnr

WHERE a~gstrp IN s_date.

loop at it_tab.

select single vornr from afru into it_tab-vornr where aufnr = it_tab-aufnr.

select single arbpl from MCAFVGV into it_tab-arbpl where aufnr = it_tab-aufnr.

MODIFY itab.

ENDLOOP.

hope this is helpful to u.

anju

Former Member — Thu, 26 Jul 2007 04:32:52 GMT

good

you can give the condition in where statement to display the data for autyp=40.

thanks

mrutyun^