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

tables

Former Member
0 Likes
530

Hi all,

How to change the field size of a field if the table has a reference with the other table..

1 ACCEPTED SOLUTION
Read only

Former Member
0 Likes
505

Hi

U should delete the reference, change the data element for the field and insert the reference again.

Anyway if you change the size of the field, probably you'll have to use the database utility to adjust the database too.

Max

4 REPLIES 4
Read only

Former Member
0 Likes
505

Hi all,

How to change the type of the field if the table has a reference table

Read only

Former Member
0 Likes
506

Hi

U should delete the reference, change the data element for the field and insert the reference again.

Anyway if you change the size of the field, probably you'll have to use the database utility to adjust the database too.

Max

Read only

0 Likes
505

What are database utilities

Read only

0 Likes
505

Hi

It's the tool to adjust the database image of the table.

The SE11 corrects only the dictionary structure and then when it actives the table the system should be create the correct image of the table in the database, but this action sometimes fails when the format of an old field is changed, so It has to force this action by database utility:

From SE11:

Utilities->Database Utility

or trx SE14

Anyway after activing the table the system should advise you if you have or don't have to use the database utility.

Max