Application Development 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
Showing results for 
Search instead for 
Did you mean: 

Regarding storing 3 digit value in two tables.

former_member508729
Active Participant
0 Kudos

Hi All,

I have two z tables created in which i am using same field named 'Version'. which is NUMC 3. Problem is when In one table i save the data for this field as 1 then it get stored in database as 001. but in another table it is saved as 1 only. although the data element is same for both the fields named 'Version'.

I used conversion routine 'CONVERSION_EXIT_ALPHA_INPUT' in PAI for that table but then also it get saved as 1 I mean one digit number if i input 1.

Can u just help me out in this problme. so that the data get saved as three digit number always no matter what user enters.

e.g if user enters 1 ---> should be stored as 001

if 10---> 010. etc

Thanks in advance.

Regards

Ashutosh.

4 REPLIES 4

former_member181962
Active Contributor
0 Kudos

Hi Ashutosh,

Try declaring them as CHAR03 type.

Regards,

Ravi

rahulkavuri
Active Contributor
0 Kudos

<b>check the thread above and award points if found helpful</b>

Former Member
0 Kudos

define the domain for both of them as numc3. So irrespective of your input it will be in your required format

0 Kudos

Thanks ,

But i am using same domain with numc 3 for these two fields. infact both the fields are same. But in one table value with 3 digit number and in other not.