topic Re: Problem with KNMT table custom field in Application Development and Automation Discussions

Problem with KNMT table custom field

santosh_kumarm — Wed, 29 Oct 2014 10:05:43 GMT

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

Re: Problem with KNMT table custom field

JL23 — Wed, 29 Oct 2014 10:17:56 GMT

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?

Re: Problem with KNMT table custom field

RaymondGiuseppi — Wed, 29 Oct 2014 10:25:42 GMT

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

Re: Problem with KNMT table custom field

santosh_kumarm — Wed, 29 Oct 2014 10:33:41 GMT

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

Re: Problem with KNMT table custom field

JL23 — Wed, 29 Oct 2014 10:52:08 GMT

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

Re: Problem with KNMT table custom field

santosh_kumarm — Thu, 20 Nov 2014 05:49:45 GMT

Thank you for the useful information. it was helpful.