Data dictionary related <Urgent>

[Former Member]

Dear experts,

I have created a z table with 4 fields and entered 4 records.

after this I have modified z table and added a new field zdel(for deletion flag)

and entered 2 more records.

problem is: when I mention zdel in query to fetch data, it does not consider old data.

select * from ztable into corresponding fields of table it_ztable where zdel NE 'X'.

it display only 2 records, while it should be display all the 6 records.

due to I have not marked deletion flag for any record.

Waiting for reply.;

With warm regards

Rajiv singh.

[Former Member]

Did you run the db Utility (Tcode SE14) for your Z Table after changing its structutre?

Arya

[Former Member]

Thanks Aryani,

Using force conversion option of se14, Problem has been solved.

Thank you very much.

[Former Member]

hi,

you should adjust the table through the transaction se14 and se16

....

thanks,

reward points if helpful...

[Former Member]

adjusted using se14, but on selection using my query

select * from ztable where zdel ne 'X'.

it display only last 2 entry, while in se16 it display all records.

[Former Member]

check your table in se16, probably your old records got deleted when appending a field to your table and activating it.

[Former Member]

Hi Rajiv,

After any change you make to a database you have to

adjust the database..

For this you use tcode SE14, enter your table name,

select Tables, press on Edit

After you enter, press on the push button Activate and adjust database

with 'Save data' selected...

Happyy coding ..

Regards,

SJ

[Former Member]

when ever u alter the table u need activate and and ajust the data base which will be uneder the menu:utilities>database utility->activate and adjust databse.

Once you do this u wil not have this trouble.If this helps you then please give me marks