Removing MATCHCODE OBJECT From TOP Include

[sumeyye_1634]

Hi experts,

[raymond_giuseppi]

Check the domain of your field, does it have an ALPHA conversion exit?

If so, then the data in your table does not respect this conversion exit, and this is the root cause of your problem. When the user enters any selection criteria, they are implicitly converted (adding leading zeros when only numeric characters are entered) and therefore the wrong data in the table is not selected.

Consider building a report to remove the invalid data and reinsert it corrected using the FM CONVERSION_EXIT_ALPHA_INPUT into your table, and remove the dirty code.

(Also correct the programs that created the inconsistent data)

[Sandra_Rossi]

sumeyye_1634 If you want to "rearrange" your question then you'd better edit your question then instead of commenting on Raymond's answer (unless you prefer continuing with just Raymond of course).

[raymond_giuseppi]

Look at your report code (I forgot my crystal ball at home this morning) there should be some JOIN option when selecting data to display, use a left outer join syntax.

[raymond_giuseppi]

As already written, replace INNER JOIN with a LEFT OUTER JOIN