Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

SQ01 - remove leading zeros at selection screen

Hi,

I have an infoSet with tables AUSP and CABN. When I create a query using this InfoSet, I need to enter leading zeroes in the field I'm using at the selection-screen (AUSP-ATWRT). I'm only after the last 6 digits as this is my material number. If I enter all the leading zeroes, the query works just fine, but for an end-user this is not very convenient.

Does anybody know if this can be done in the query or in the InfoSet, or do I need some programming skills here?

Thanks in advance:)

Br,

Lars

Edited by: Lars Hesleskaug on Apr 14, 2010 11:38 AM

Former Member
replied

Hi Lars,

You have to create your own field in the Infoset converting the real one to numeric value, so the leading zeros will be removed. The search then will be working based on this new field.

Regards,

Eli

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question