05-19-2014 7:07 AM
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.
05-19-2014 7:15 AM
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.
05-19-2014 7:24 AM
HI Balaji,
I did not see any option Force activate on menu, Weather force activate may impact any thing on the table....
05-19-2014 12:42 PM
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.
05-19-2014 12:45 PM
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
05-20-2014 5:44 AM
hello EXPERTS,
Please sujjest what else can be done to over come this issue......
REgards,
lokesh
05-20-2014 5:53 AM
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....
05-20-2014 5:56 AM
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