How to get functional location with wildcard %

[Former Member]

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.

[Former Member]

There is a similar problem with MATNR in MARA. Internal the length is 18 and external the length is 40. In order to have a correct result when selecting with wildcards, i use table MATERIALID whcih holds both the internal as the external material number.

I guess there's also one for functional locations so i suggest you make your selection first on that table instead of IFLOT. Afterwards, you continue your selection on IFLOT (or IFLO) with the result.

[Former Member]

Thanks,

Indeed there is translation table IFLOS

  SELECT tplnr INTO TABLE gt_iflo FROM iflos WHERE strno in so_tplnr.