Skip to Content
0
Former Member
Dec 20, 2011 at 08:40 AM

How to get functional location with wildcard %

315 Views

Hello,

I want to get all functional locations with a wildcard search.

In most cases it works but if there is a conversion exit to a other key

for example :

With conversion exit in iflo | real database content in iflo

UT-KON-RCK10-PI-8300-UU | UT-KON-RCK10-PI-8300-UU

UT-KON-RCK10-WS-8300-UU | UT-KON-RCK10-WS-8300-UU

UT-KON-RCK10-PI-8300HHS0100 | ?0100000000000008902

Result search %8300%

UT-KON-RCK10-PI-8300-UU

UT-KON-RCK10-WS-8300-UU

not

UT-KON-RCK10-PI-8300-UU

UT-KON-RCK10-WS-8300-UU

UT-KON-RCK10-PI-8300HHS0100

this is my code

TABLES : iflo.
SELECT-OPTIONS: so_tplnr  FOR lty_ilom_strno NO INTERVALS.
so_tplnr-sign   = 'i'.        
so_tplnr-option = 'CP'.
so_tplnr-low    = '*-8300*'.
select tplnr into table gt_iflo from iflo where tplnr = so_tplnr.