10-29-2014 10:05 AM
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
10-29-2014 10:17 AM
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?
10-29-2014 10:17 AM
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?
10-29-2014 10:33 AM
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
10-29-2014 10:52 AM
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
11-20-2014 5:49 AM
10-29-2014 10:25 AM
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