topic Re: Removing MATCHCODE OBJECT From TOP Include in Application Development and Automation Discussions

Removing MATCHCODE OBJECT From TOP Include

sumeyye_1634 — Mon, 11 Apr 2022 10:49:45 GMT

Hi experts,

Re: Removing MATCHCODE OBJECT From TOP Include

RaymondGiuseppi — Tue, 12 Apr 2022 14:28:21 GMT

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)

Re: Removing MATCHCODE OBJECT From TOP Include

Sandra_Rossi — Wed, 13 Apr 2022 07:17:31 GMT

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).

Re: Removing MATCHCODE OBJECT From TOP Include

RaymondGiuseppi — Wed, 13 Apr 2022 14:35:45 GMT

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.

Re: Removing MATCHCODE OBJECT From TOP Include

RaymondGiuseppi — Thu, 14 Apr 2022 12:11:50 GMT

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