topic Re: VBAK Performance in Application Development and Automation Discussions

VBAK Performance

sergio_cifuentes — Wed, 07 Mar 2007 21:34:05 GMT

i got a performance issue with the following select:

SELECT SINGLE vbeln netwr knumv

FROM VBAK

INTO (v_vbeln, v_netwr, v_knumv)

WHERE auart = p_tipo

AND bstnk = pti_zcmtt_envase-ref.

how do i complete a key when i don't have it i mean is there a way to make something to complete the index fields even when you don't know the exactly values, thanks.

Re: VBAK Performance

Former Member — Wed, 07 Mar 2007 21:37:32 GMT

Hi,

Perhaps you can create secondary index for table VBAK with MANDT, AUART and BSTNK fields or database view (SE11).

Regards,

Ferry Lianto

Re: VBAK Performance

Former Member — Wed, 07 Mar 2007 21:40:18 GMT

Hi,

I believe there is an index on the customer purchase order number BSTNK..

Try this..

SELECT VBELN NETWR KNUMV

UP TO 1 ROWS

FROM VBAK

WHERE bstnk = pti_zcmtt_envase-ref

AND auart = p_tipo

ENDSELECT.

Thanks

Naren

Re: VBAK Performance

sergio_cifuentes — Wed, 07 Mar 2007 21:40:46 GMT

but without creating a secondary index, is there a way to complete the index key with a condition that always be true, i mean something like audat GT 19900101??? how this affects my performance is it a good practice or no?

Re: VBAK Performance

Former Member — Wed, 07 Mar 2007 21:47:59 GMT

Hi,

You can try to add field AUDAT in your select statement since there is secondary index AUD for field AUDAT. It should improve the performance.

Regards,

Ferry Lianto

Re: VBAK Performance

sergio_cifuentes — Wed, 07 Mar 2007 21:53:53 GMT

exactly that's what i want but how do i add the 'audat' field if don't know it?? or i use it in a condition that always be true??