Mysterious custom table

[Former Member]

Experts,

I have a custom table with date field. When I give date not equal to blank in SE16 screen and press execute icon, i see records in output.

Mystery: For above records there is no data that i can see on screen in date field meaning that ideally these records should not be picked.

I wrote a code snippet to select one of the above records from custom table & wrote the string length of date field using WRITE statement. I see that STRLEN is ZERO.

I am not able to understand why a blank date field record gets displayed in SE16 output when search is made for DATE NOT EQUAL TO BLANK.

Please share your valuable inputs.

BR,

Aspire

[Former Member]

Experts,

I have a custom table with date field. When I give date not equal to blank in SE16 screen and press execute icon, i see records in output.

Mystery: For above records there is no data that i can see on screen in date field meaning that ideally these records should not be picked.

I wrote a code snippet to select one of the above records from custom table & wrote the string length of date field using WRITE statement. I see that STRLEN is ZERO.

I am not able to understand why a blank date field record gets displayed in SE16 output when search is made for DATE NOT EQUAL TO BLANK.

Please share your valuable inputs.

BR,

Aspire

[Former Member]

Experts,

I noticed 1 more thing. There is 1 more field in this table which is mysterious as well.

No of records which have this field as blank 167

No of records which have this field as NOT blank 13

Total no of records in this table 1267

Ideally 167 + 13 should be the total no of recs in the table which is NOT TRUE. 

I am clueless about what value can be in the rest of records other than 167 + 13

BR,

Aspire

[former_member197622]

Hi Aspire

when you use the SE16 please consider the initial value and conversion exits of the field

in this case you are searching NOT BLANK in SE16 but when it executes it will search for date value NOT '00000000'

create a sample program and select the table in a internal table and check these values

also i assume you are using the alv grid to display the result, you can the change the view of SE16 setting SE16 Standard List to see the values in Setting ->User Parameters...

about the other field... what type is ?

Regards

MC

[Former Member]

Marco,

Thanks a lot for your reply.

I can see your reply as a possible explanation for date field. Will check it one more time closely.

Other field is CHAR 3.

BR,

Aspire.

[Former Member]

Experts,

I tried Activate & adjust table option (SE14 Tcode) but with no luck. I believe this can be because there is no changes made to table fields & this adjustment will not impact the existing records in table.

BR,

Aspire

[former_member201275]

Please post a snapshot of your table here so i can see how it is declared i.e. the fields. Also a snap of the "Delivery and maintenance" tab from SE11 as well.

[former_member183073]

1. Check if there is any conversion exit in your fields.

2. just check the check conversion exit check box in se16 by going to settings->userparameters->check conversion exit.

3. might some problem in se16 screen, just regenerate the screen by changing the selection fields in the setting and the screen will regenerated.

[rosenberg_eitan]

Hi.

Symptoms of null fields.

Please check the history of this table did any one add a new fields at some point without using the "initial values" flag .

Also please check the on line help in se11 for "initial values" .

Regards.

[Former Member]

Hi,

Initial value for date field is '00000000' and not SPACE.

[RaymondGiuseppi]

A blank displayed field could actually been initial (date : 00000000) or even null.

So you could try

SELECT COUNT(*) FROM zmystery WHERE fieldate EQ space.
SELECT COUNT(*) FROM zmystery WHERE fieldate EQ '00000000'.
SELECT COUNT(*) FROM zmystery WHERE fieldate IS NULL.

SELECT COUNT(*) FROM zmystery.

Regards,

Raymond