topic Re: NUMC type with ZEROS in Application Development and Automation Discussions

NUMC type with ZEROS

Former Member — Wed, 09 May 2007 17:35:13 GMT

Hi, everybody

I've got a question.

It is very simple. I have a database table with a numc4 type field.

I want the field to store data with zeros, so if a go to SM30 and type: 1 for that field,

the stored value should be 0001, not 1.

Is there any way???

Thanks

RichHeilman — Wed, 09 May 2007 17:48:03 GMT

That is what will happen if the field is defined as a NUMC data type. It will always be zero filled left.

Regards,

Rich Heilman

Former Member — Wed, 09 May 2007 18:06:54 GMT

Hi,

Try this..

In the attributes of that input field...Set the flag "Leading zeroes"

Activate..

Thanks,

Naren

Former Member — Wed, 09 May 2007 19:57:27 GMT

Yes, but i meant, in sm30 transaction, if i enter 1 the value is not set to 0001.

Why?

RichHeilman — Wed, 09 May 2007 20:00:07 GMT

It should be in the database, but it will appear as 1 in the SM30. Check in the db using SE16, you will see it with leading zeros.

Regards,

RIch Heilman

Former Member — Wed, 09 May 2007 20:05:15 GMT

Hi,

If it is custom table..

Then go to SE51

Give the program name -> SAPL + "Function group used to generate the screen".

Give the screen number..

Press change..

Go to the layout..

In the input field attributes for that NUMC field...Set the flag "LEADING ZEROES".

Activate the screen..

Then go to SM30..

Give 1 in the numc field and then press enter..You will see 0001

Thanks,

Naren