Is the select statement correct?

[Former Member]

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

[ThomasZloch]

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

Cheers

Thomas

[Former Member]

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.

[Former Member]

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.

[Former Member]

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