Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

NUMC value saved in Database without leading 0

Former Member

‎2017 Feb 13 3:22 PM

1,531

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.

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.

Reply
1 REPLY 1
Read only

retired_member
Product and Topic Expert
Product and Topic Expert

‎2017 Feb 13 3:47 PM

1,043

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