inconsistency when appending a table

[Former Member]

hi

i did an append in a standard table because of some requirement

lets say i append with field name XXXX

but when i go the se11 and input xxxx NE space (this should return me all field where xxxx is empty) i get 30 record

and when i go the SE11 and select same thing without putting any condition in xxxx (this should again return me all field where xxxx ie empty ) i get 100 record

what i discover is that in SE14 and do a check in the database the field XXXX not null and default value has not been assign anything .

This i get inconsistencies when selecting record . anyone encounter this problem before please advise

[JozsefSzikszai]

hi,

did you carry out the 'Activate and adjust DB' functionality in SE14?

ec

[Former Member]

i tried but i got the message

"No authorization for action: CNV with object:"

and the action got cancel. may be i don't have enough rights to do so. is there any other way

[Former Member]

by the way when you click on activate and adjust database after that when do you do ?

[JozsefSzikszai]

no other way. this is a must to do.

you can do two things:

1. someone else (who has proper auth.) does this for you

2. you auth will be fixed and you do on your own

[Former Member]

ok may be i found a user who had more authorization

after i click on adjust a pop-up appear with "request:"Adjust""

i click on yes what is suppose to happen?

[JozsefSzikszai]

the table will be adjusted with the new filed (I guess you inserted the new field not at the end), when it is ready, try to display the data again.