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

Data type changed in Custom table after its activation

Former Member

‎2014 May 19 7:07 AM

0 Likes
1,359

HI,

    I have created a Z-table, and i have changed one field( A ) data type from NUM10 to NUM13 after few days. Now the table is capable of storing from 10 digits to 13 digits in the changed field (A).

  My problem is when i am reading table by passing 11 digits or 12 digits value of the field (A).it is showing not availabe message even though the record exixts in the table. and if im reading with 10 digits or 13 digit values of the field(A) it is showing fine...

What might be the problem with the Z-table field (A). I have already adjusted the database in SE14 for the ztable. PLease sujjest me in overcoming it

                                  

Regards,

Lokesh.

HI,

    I have created a Z-table, and i have changed one field( A ) data type from NUM10 to NUM13 after few days. Now the table is capable of storing from 10 digits to 13 digits in the changed field (A).

  My problem is when i am reading table by passing 11 digits or 12 digits value of the field (A).it is showing not availabe message even though the record exixts in the table. and if im reading with 10 digits or 13 digit values of the field(A) it is showing fine...

What might be the problem with the Z-table field (A). I have already adjusted the database in SE14 for the ztable. PLease sujjest me in overcoming it

                                  

Regards,

Lokesh.

Reply
7 REPLIES 7
Read only

Former Member

‎2014 May 19 7:15 AM

0 Likes
1,311

Hi lokesh,

once try to active it again in se14 after still will showing same then go to se14 clik on force active under edit option from menu.

Read only

Former Member
In response to Former Member

‎2014 May 19 7:24 AM

0 Likes
1,311

HI Balaji,

            I did not see any option Force activate on menu, Weather force activate may impact any thing on the table....

Read only

bernat_loscos
Explorer

‎2014 May 19 12:42 PM

0 Likes
1,311

Hi Lokesh,

You can try to delete this table and create it again. I know it's not an appropriate solution but It may work.

Regards.

Read only

sreeramkumar_madisetty
Active Contributor

‎2014 May 19 12:45 PM

0 Likes
1,311

Hi

After adjusting the table using Database Utility (SE14),delete the existed table maintanance generator and created it now freshly,hope it will all set.

Thanks,

Sreeram

Read only

Former Member

‎2014 May 20 5:44 AM

0 Likes
1,311

hello EXPERTS,

                      Please sujjest what else can be done to over come this issue......

REgards,

lokesh

Read only

Former Member
In response to Former Member

‎2014 May 20 5:53 AM

0 Likes
1,311

hi lokesh ,

Are you reading the table via program or manual.if it is program declare the variable(internal table-field).as 13 character one.so that this problem can b avoided.if it is manual u can assign the value range in the domain.

hope it helps....

Read only

Former Member
In response to Former Member

‎2014 May 20 5:56 AM

0 Likes
1,311

Use leading zeroes for values less than 13 digits.

You can use use FM 'CONVERSION_EXIT_ALPHA_INPUT'.

Pass your variable in exporting and importing parameters and it will add leading zeroes to it.

Regards,

Ashish