Skip to Content
0

NUMC value saved in Database without leading 0

Feb 13, 2017 at 03:22 PM

136

avatar image

Hello to all,

I've encountered a weird case in which a database field defined as NUMC of length 14 has values stored without the appropiate leading zeroes.

How could this happen? The field is, and has always been, defined as NUMC.

I'm really shocked. Any ideas on how come did this happen?

Thanks in advance,

Best regards.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Horst Keller
Feb 13, 2017 at 03:47 PM
1

Welcome to reality ;-)

NUMC is a semantical dictionary type. On the database it's simply characters. No problem getting "illegal" values in there. Even in ABAP you can easily fill type n fields with alphas and then, when you save those ...

Same for DATS and TIMS. No guarantee for valid values.

In the ABAP world it's mainly the classical Dynpros that care for valid values. That's why batch input was/is so important.

http://help.sap.com/abapdocu_751/en/index.htm?file=abenddic_special_character_types.htm

Share
10 |10000 characters needed characters left characters exceeded