Data Type change.

[Former Member]

Hi Expert.

Please help me,   I have create Z table here create one Field like Below.

APPROVED_STATUS

CHAR

1

0

Source

then i was change pre-define data type length CHAR 1 to 10. as below

APPROVED_STATUS

CHAR

10

0

Source

Now When We save data through program 10 char is saved properly.

Problem : When I Use SE16N t-code for changes related field data. At that time only 1 char inserted.

Also Use SE14 for Regenerate Table Structure. but Result is none.

Thanks & Regards.

Pradip Patel.

[Former Member]

hi Pradip,

After changing the lenght of the field, you need to adjust the database. Goto:

Utilities----> Database object -------> Database Utility . Activate and adjust database.

Also make sure that Z tbale is active before doing this.

Thanks,

Sachin

[Former Member]

Hi Sachin Dandekar.

I have already do this and also check Z table is Active.

but result none.

Thanks.

Pradip Patel.

[Former Member]

Hi,

You might have to rebuild the table maintenance generator/view.

Kind regards, Rob Dielemans

[Former Member]

Hi,

Agree with both, adjust the table and recreate the TMG.

[Former Member]

My Z Table have no TMG. and I have already Adjust the Table.

Result None.

Regards.

Pradip Patel.

[Former Member]

hi,

Why do you use se16n and not a view to maintain this table. This should solve the problem if you just generate a table maintenance view and use sm31 for table entries.

Kind regards, Rob Dielemans

[former_member206650]

Hi,

go to domain check if the output length in output characteristic is 10 and then activate it.

hope it helps

[Former Member]

Delete that field and create it again with length 10...only one field right