Skip to Content
0
Former Member
Feb 20, 2009 at 04:20 AM

how we replace '0000%'

35 Views

Hi , how to replaece LIKE '0005%' to improve the performance of quarry.

SELECT BELNR WRBTR ZUONR HKONT SHKZG BUZEI

INTO TABLE I_BSEG

FROM BSEG

FOR ALL ENTRIES IN I_BKPF

WHERE BUKRS = P_BUKRS

AND BELNR = I_BKPF-BELNR

AND GJAHR IN S_GJAHR

AND HKONT LIKE '00005%'.