Skip to Content
0
Former Member
Mar 29, 2006 at 08:48 AM

Problem when accesing a table after modifying it

15 Views

Hi All!

We have a extrange problem in a table acess. On a non standard table we have added a new field (vbeln) and after that we have executed TRX SE14 for activate and adjust the data on this table. Regarding this modification, we have change a program that make an access to this table, we need to retrieve data which have this field (vbeln) initial. If we use condition "vbeln = space" on the select clause, it retrieves only data created after the modification but not data previous to the table modification. On the other hand if we use condition "vbeln IS NULL", data previous to the modification is retrieved but not data created afer it.

Anybody knows the reason for this rare behavior?

Thanks and regards