Table problem

[Former Member]

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?

[Former Member]

You can logout and log in again..

[Former Member]

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?

[Former Member]

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

[Former Member]

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

[Former Member]

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?

[Former Member]

THANK U SOLVE MY PROBLEM.

Is working after some waiting time.

[former_member156446]

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

[Former Member]

Hi Gary,

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

Regards,

Mohaiyuddin

[Former Member]

Make sure, ur table is active..

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

[uwe_schieferstein]

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

[Former Member]

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