Problem with KNMT table custom field

[santosh_kumarm]

Dear All,

There is a custom field ZZSKU in the table KNMT table.   in se16 if i enter correct value in ZZSKU field.  it does not return any rows.

Request you to kindly help .

Thanks & Regards

Santosh

[santosh_kumarm]

Can you share some evidence?

e.g. a screenshot from SE16 where the field is visible with value 

then a screenshot from your entry in the selection screen.

Is it a num- field or a char- field?

[JL23]

Can you share some evidence?

e.g. a screenshot from SE16 where the field is visible with value 

then a screenshot from your entry in the selection screen.

Is it a num- field or a char- field?

[santosh_kumarm]

Hi Jurgen

the value 1234567 exists in the KNMT table

Now without value for the ZZSKU field.

Hope this might be useful.

Thanks & Regards

Santosh

[JL23]

go again into SE16

select from menu Settings > user parameter

remove the flag in the box " Check conversion exits"

then do your steps again and see how this 12345 is shown in that ZZSKU field

[santosh_kumarm]

Thank you for the useful information.  it was helpful.

[RaymondGiuseppi]

How was this field filled in database, does it carry a conversion-exit, and did the loader program respect this conversion-exit.

Often some (young, distracted or in a hurry) programmers forget to convert data to internal format and use some open-sql statement to update the database, genrating some wrong data which cannot be selected. For example the field is a CHAR field of length 10 and the program put value '1234     ' (trailing spaces) in the field, correct programs (like SE16/SE16N) will convert a selection of 1234 to '0000001234' (leading zeroes) so '1234      ' will not be selected...

Regards,

Raymond