can we restrict our char with values ending with certain pattern.

36 Views

Hi Experts,

I have tried searching but wasn't able to,

My requirement is that I have to create a query wherein I want to show data for those storage locations which are ending with 1

i.e. 1100, 1101, 1102, 1191, 1142,1141

out of these My values should come for 1101,1191,1141

I tried using customer exit for it with code

WHEN 'STOR_LOC'.
IF I_STEP = 1.
DATA: ITAB1 TYPE STANDARD TABLE OF /BI0/SSTOR_LOC WITH HEADER LINE.

SELECT * FROM /BI0/SSTOR_LOC INTO TABLE ITAB1 WHERE STOR_LOC LIKE '%1'.

CLEAR: L_S_RANGE.
L_S_RANGE-SIGN = 'I'.
L_S_RANGE-OPT = 'EQ'.
LOOP AT ITAB1.
L_S_RANGE-LOW = ITAB1-STOR_LOC.
APPEND L_S_RANGE TO E_T_RANGE.
ENDLOOP.
CLEAR L_S_RANGE.
ENDIF.

but my exit is also causing issues ( error), kindly help.

Is there any way I can get only those storage locations whose key ends with 1 without using exit?