topic Re: Table not showing data after refresh in Application Development and Automation Discussions

Table not showing data after refresh

AnjaneyaBhardwaj — Fri, 22 Jul 2011 13:53:20 GMT

Hi gurus ,

A unique problem We have added a field in the custom table . once moved to quality system it is not showing up the data whwn when we do a select query on that table in se16 . say total entries are ten thousand four of them are checked and when display not checked i.e eq space we get just 100 entries on number of entries ..i asked to regenerate the table in quality system but it did not help .The Quality system was refresh 1 month ago and we see it not working after it ..please suggest the correct steps we need to perform to recover the data . Adjust database with keep data has already been done ...

Re: Table not showing data after refresh

Sandra_Rossi — Fri, 22 Jul 2011 19:43:20 GMT

Hi Anjaneya Bhardwaj,

If I understand well, your issue is that you have a SELECT in your program, saying newfield is your newfield, something like:


SELECT ... FROM ztable INTO ... WHERE newfield = space.

and it doesn't return the records that existed in quality before newfield was added.

It it because, by default, when you add a field to an existing database table, with records already present, they are assigned the NULL value, which is different from space.

They can be retrieved using WHERE newfield IS NULL.

Usually, to avoid this issue, when we add a new field, we tick the "no null value" checkbox for this new field, in SE11 transaction. That will initialize the field of existing records, to the initial value (space for characters, 0 for numeric fields, etc.) Note: maybe it can be counter performant for big tables...

Solution for your issue, run this code once:

UPDATE ztable SET newfield = space WHERE newfield IS NULL.

Sandra

Re: Table not showing data after refresh

madhu_vadlamani — Sun, 24 Jul 2011 04:57:01 GMT

Hi Bharadwaj,

You can do as Sandra told. It will work.

Regards,

Madhu.

Re: Table not showing data after refresh

AnjaneyaBhardwaj — Mon, 25 Jul 2011 04:41:14 GMT

Hi instead my query is ...

select something from ZTABLE into table where newfield ne 'X' .

new field should give me all record which are not equal to 'X'

and in this case NULL and SPACE are similar ar'nt they ?

please suggest .

Re: Table not showing data after refresh

lijisusan_mathews — Mon, 25 Jul 2011 04:45:33 GMT

Are you getting all the data if you try retrieving it from SE16/SE11 directly. IE. if you give new field NE 'X' condition in SE16 , do you get all the records? If so its a problem with select. Otherwise it is a problem with the table transport.l

Re: Table not showing data after refresh

AnjaneyaBhardwaj — Mon, 25 Jul 2011 04:52:37 GMT

Hi,

Se16 is inconsistent and transports have been imported properly ....

i do not get all record ne 'x' when i click on the number of entries and that was my question ?

request all to read the original problem ........

Thanks

Re: Table not showing data after refresh

lijisusan_mathews — Mon, 25 Jul 2011 05:18:02 GMT

ok. If your se16 table is inconsistent, it should show your the reasons too. Are any warnings or errors or anything being displayed along with the inconsistency message?

Re: Table not showing data after refresh

AnjaneyaBhardwaj — Mon, 25 Jul 2011 05:23:18 GMT

When i say inconsistent it mean data it shows is inconsistent ...not the table itself ...there are no warning logs or error messages ....Domain being used is XFELD for this field . the whole inconsistency is with regards to this new field ...

Thank you .

Re: Table not showing data after refresh

Former Member — Mon, 25 Jul 2011 05:57:44 GMT

Hi,

write your select like this .

select <field1>

from <ztable> into table <itab>

where <newfield> = Space.

it will fetch you all the record which are not checked.

Hope this will helps you.

Regards,

Kiran

Re: Table not showing data after refresh

lijisusan_mathews — Mon, 25 Jul 2011 06:18:34 GMT

Did u try transporting your table a second time.??

And in QAS did u try checking the number of entries in the table when no conditions are given ?

Re: Table not showing data after refresh

Former Member — Mon, 25 Jul 2011 06:37:59 GMT

Hi Anjaneya,

I understand, you mean that select is giving you much more data (which is correct) than se16 tcode.

Strange problem indeed. Try reimporting the table in QA and re-adjust using SE14.

I believe if there was any problem with respect to table stats gathering, then select and se16 both must have given same output at least, but you can still try re-gathering table statistics with help of basis team.

Re: Table not showing data after refresh

Sandra_Rossi — Mon, 25 Jul 2011 08:37:55 GMT

Hi,


Hi instead my query is ...
> 
> select something from ZTABLE into table where newfield ne 'X' .
> 
> new field should give me all record which are not equal to 'X'
> and in this case NULL and SPACE are similar ar'nt they ?
> please suggest .

No, NULL value is special. The record won't be returned if you don't use explicitly IS NULL. The right select would be:

SELECT ... WHERE newfield ne 'X' OR newfield IS NULL.

So, I think the only and best solution in your case is to UPDATE the records (and using the database utility is useless, or with extra efforts). You'll have to do it for transport on next systems too. Next time, remember that it's better to tick the "initial value" checkbox of the new fields in the SE11 table definition.

Sandra

Re: Table not showing data after refresh

nabheetscn — Mon, 25 Jul 2011 08:43:27 GMT

Hi,

We face the same problem and the solution is for the field check the initial checkbox and activate it will replace all the null valuewith a blank and it works.

Thanks

Re: Table not showing data after refresh

Sandra_Rossi — Mon, 25 Jul 2011 08:56:10 GMT

Hi nabheetmadan09,

I thought the late ticking of that checkbox would not perform a table conversion, but I just tested and you're right (so, no need to program the UPDATE ourselves, it will be automatically done by the transport of the corrected database table)

Thanks!

Sandra

Re: Table not showing data after refresh

madhu_vadlamani — Mon, 25 Jul 2011 09:08:41 GMT

Hi Sandra,

It is a good discussion . I got a good point.

Regards,

Madhu.

Re: Table not showing data after refresh

Sandra_Rossi — Mon, 25 Jul 2011 12:16:00 GMT

Just a remark on the erroneous terms I used in my last post:


> I thought the late ticking of that checkbox would not perform a table conversion, but I just tested and you're right

Ticking that checkbox won't run a "SAP table conversion", but will simply lead to an "ALTER TABLE" SQL operation that does an update of existing records.

Sandra

Re: Table not showing data after refresh

AnjaneyaBhardwaj — Mon, 25 Jul 2011 18:04:20 GMT

Thank you all ...I have my problem solved ...it introduced another issue ...That is the table was earlier sorted based on two keys fields ...now it is not ................is has altered the sorting did i do anything wrong .......i simply made the check fthe initial checkbox ...and retransported it ................

Edited by: Anjaneya Bhardwaj on Jul 25, 2011 8:04 PM

Re: Table not showing data after refresh

AnjaneyaBhardwaj — Thu, 28 Jul 2011 05:32:16 GMT

The question has been answered and i am closing the thread ...the very basic but important point to rember understand the value of checkbox having heading initial ....

Thank you all ..