problem with table entries

[SG141]

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.

[naimesh_patel]

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

[SG141]

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

[Former Member]

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

Rob

[SG141]

Thanks Rob.