topic Re: Table problem in Application Development and Automation Discussions

Table problem

Former Member — Wed, 09 Jan 2008 05:17:25 GMT

Hi all,

i meet with this strange problem....

first i had create a database. later i go into se16 to create new record. Everything work fine. Strange thing happen when i add in new field to the table.

Later i realised i had miss some of the field....

step i do:

1) i remove all the record in the database table.

2) i go into se11 to add my new field

3) i check and activated my table. Save successful from the prompt

4) i go into se16 again. fill the tablename and press execute.

5) the the program stuck.

What is the cause of this? This happen when i add in new field to the table. Any help?

Re: Table problem

Former Member — Wed, 09 Jan 2008 05:18:52 GMT

You can logout and log in again..

Re: Table problem

Former Member — Wed, 09 Jan 2008 05:20:10 GMT

Hi,

After adding ur New field in the table , table should be adjusted thru SE14 tcode.

Go to SE14,

Give ur table name.

And ACTIVATE ADDJUST.

Now it wil work fine.

Revrt back if any issues,

regards,

Naveen

Re: Table problem

former_member156446 — Wed, 09 Jan 2008 05:21:38 GMT

when ever you make any change to the table (Ztable) after the changes are made and activated and saved, you need to run the database unities and say Adjust and execute it.

check the option in se11 > database unities > select ADJUST and execute

Re: Table problem

Former Member — Wed, 09 Jan 2008 05:21:50 GMT

Hi Gary,

Go to se14, enter table name and click on button "Activate and adjust database"

Regards,

Mohaiyuddin

Re: Table problem

Former Member — Wed, 09 Jan 2008 05:23:35 GMT

i try to logout and log in again. i still cant access my table in se16. It hang in se16 when i fill the tablename and press execute.

When i re-create the whole database table again.... i can access the table.

The program gt hang when i add new field to the existing database table. How to resolve it?

Re: Table problem

Former Member — Wed, 09 Jan 2008 05:25:54 GMT

Make sure, ur table is active..

if it is partially active or inactive, then use t-code se14 and adjust table

Re: Table problem

uwe_schieferstein — Wed, 09 Jan 2008 05:25:56 GMT

Hello Gary

You have added a new field when the DB table contained already records. In this case the following might happen:

When you add the field definition (in SE11) you may or may not mark the flag "initial" value. However, (most likely) the problem is that for the existing records the values in the newly added field is not initial but NULL.

I once had this problem and got a strange selection behaviour of the corresponding maintenance view (because NULL is not initial). I solved this problem by writing a little report which initialized the values in the new field for all records, e.g.:


TABLES: z_mytable.  " new field FLAG added

DATA:  ls_record     TYPE z_mytable,
  

  SELECT * FROM z_mytable INTO ls_record.
     ls_record-flag = space.     " selected record may contain NULL value -> initialize

     MODIFY z_mytable FROM ls_record.
  ENDSELECT.
  COMMIT WORK.

Regards,

Uwe

Re: Table problem

Former Member — Wed, 09 Jan 2008 05:27:19 GMT

Hi,

After addition of new field you got error in activating a table.

so you have to adjust the table with existing field with a new field.

regards,

swami

Re: Table problem

Former Member — Wed, 09 Jan 2008 05:35:12 GMT

i will try later after my basis done wid the configuration.

Re: Table problem

Former Member — Wed, 09 Jan 2008 06:00:18 GMT

I try the se14 and activate the adjust. It still the same.

Gt hang in se16 when i view the table.

i check the status is active and save.

what wrong?

Re: Table problem

Former Member — Wed, 09 Jan 2008 06:07:29 GMT

THANK U SOLVE MY PROBLEM.

Is working after some waiting time.