topic Re: Data Type change. in Application Development and Automation Discussions

Data Type change.

Former Member — Mon, 07 Apr 2014 11:29:18 GMT

Hi Expert.

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

APPROVED_STATUS

CHAR

Source

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

APPROVED_STATUS

CHAR

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.

Re: Data Type change.

Former Member — Mon, 07 Apr 2014 11:33:32 GMT

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

Re: Data Type change.

Former Member — Mon, 07 Apr 2014 11:33:38 GMT

Hi,

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

Kind regards, Rob Dielemans

Re: Data Type change.

Former Member — Mon, 07 Apr 2014 11:40:58 GMT

Hi Sachin Dandekar.

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

but result none.

Thanks.

Pradip Patel.

Re: Data Type change.

Former Member — Mon, 07 Apr 2014 11:41:04 GMT

Hi,

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

Re: Data Type change.

Former Member — Mon, 07 Apr 2014 11:43:29 GMT

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

Result None.

Regards.

Pradip Patel.

Re: Data Type change.

Former Member — Mon, 07 Apr 2014 11:50:50 GMT

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

Re: Data Type change.

former_member206650 — Mon, 07 Apr 2014 11:52:00 GMT

Hi,

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

hope it helps

Re: Data Type change.

Former Member — Mon, 07 Apr 2014 12:38:26 GMT

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