Skip to Content
0
Feb 24, 2009 at 09:12 AM

Strange problem with search in custom table

1340 Views

Hi experts,

please someone help me with this problem.

I have created a Z table. This table contain a field called MFRNR which has LIFNR domain. LIFNR has ALPHA conversion routine.

Beside this field there is another field - MFRPN - and other fields.

The problem is when i want to search after MFRPN and MFRNR it's not working even if the entry exist in table. But if i'm looking only after MFRPN it's OK - the result is displayed.

I have notice that if i uncheck "Check conversion routine" from SE16-Settings->User parameters field MFRNR does not contain zeros. If i do this in DEV system the result contain zeros.

I can't figure out what's the problem.

Is there any database utiltiy where i can check if this table contain bugs/errors/warnings?

This problem came from conversion routine?

Any help/clue/hint would be apreciated.

Thank you.

Edited by: Julius Bussche on Feb 24, 2009 10:49 AM

Please use meaningfull subject titles