topic Re: problem with table entries in Application Development and Automation Discussions

problem with table entries

SG141 — Mon, 18 Aug 2008 15:26:15 GMT

We are storing EKKO-EBELN field into custom table ZTABLE-ZAUFNR field in user exit. However when we query the ZTABLE with the PO number in the ZAUFNR field..we are getting a message no entries found. If suffix or prefix the PO number with * .... then all the entries are displayed... how to fix this one to display entries when PO number is entered in the ZAUFNR field.

ZAUFRN IS DEFINED WITH REFERNCE TO AUFNR FIELD.

Re: problem with table entries

naimesh_patel — Mon, 18 Aug 2008 15:31:54 GMT

Why do you need to do this because EBELN has 10 characters where as the AUFNR has 12 charcters. So, I think you need to either change the field attribute to EBELN in the ZTABLE or use the * as prefix.

Regards,

Naimesh Patel

Re: problem with table entries

SG141 — Mon, 18 Aug 2008 15:34:58 GMT

Apart from EBELN we are storing AUFNR too in the ZTABLE.

Re: problem with table entries

Former Member — Mon, 18 Aug 2008 15:45:49 GMT

Well, you have to run the field through FM CONVERSION_EXIT_ALPHA_INPUT before updating the database.

Rob

Re: problem with table entries

SG141 — Mon, 18 Aug 2008 15:58:08 GMT

Thanks Rob.