topic Re: Is the select statement correct? in Application Development and Automation Discussions

Is the select statement correct?

Former Member — Fri, 23 May 2008 13:58:23 GMT

Hi all,

Is the below select statement correct?

If not how to modify it.

SELECT * INTO CORRESPONDING FIELDS OF TABLE it_vbap

FROM vbup AS k

INNER JOIN vbap AS p ON p_{vbeln = k}vbeln

WHERE k~gbsta <> 'C'

AND p~vbeln IN p_vbeln

AND k~vbtyp NOT IN ('A','B','J','M','N','O','P','S')

AND p~matnr IN p_matnr

AND p~werks IN p_werks

AND p~pstyv IN p_pstyv

AND p~mvgr2 IN p_mvgr2

AND p~abgru = ''.

Thanks,

Balaji

Re: Is the select statement correct?

ThomasZloch — Fri, 23 May 2008 14:03:06 GMT

you probably want to include POSNR when joining VBUP and VBAP.

Cheers

Thomas

Re: Is the select statement correct?

Former Member — Fri, 23 May 2008 14:07:04 GMT

Hi,

the following line will work fine.

AND k~vbtyp NOT IN ('A','B','J','M','N','O','P','S')

no need to change the query.

Re: Is the select statement correct?

Former Member — Fri, 23 May 2008 14:20:37 GMT

SELECT *

INTO CORRESPONDING FIELDS OF TABLE it_vbap

FROM vbup AS k

INNER JOIN vbap AS p

ON p_{vbeln = k}vbeln

AND p_{posnr = k}posnr

WHERE k~gbsta = 'C'

AND p~vbeln IN p_vbeln

AND k~vbtyp NOT IN ('A','B','J','M','N','O','P','S')

AND p~matnr IN p_matnr

AND p~werks IN p_werks

AND p~pstyv IN p_pstyv

AND p~mvgr2 IN p_mvgr2

AND p~abgru = ''.

You should use all the key fields to get the right data.

Adithya M.

Re: Is the select statement correct?

Former Member — Fri, 23 May 2008 14:39:09 GMT

Hi all,

Thanks for the reply.

VBUP table has 4220449 records.

VBAP table has 1730584 records.

The select statement fetches around 3000000 records which takes around 15 mins.

I need to optmize the code. Any inputs?

Thanks,

Balaji