12-20-2016 1:13 PM
Hello,
We have added the field ZZCT_ITEM_VDATE in the end of the structure CI_EKPODB but the structure is in the middle of the EKPO table Total number of entries in the table are 4733.
But when we place a filter on the field ZZCT_ITEM_VDATE with Not Equal blank, we could get number of entries as 5 which is correct
But when we place filter as Equal to blank it shows number of entries as 336
But it should be total number of entries in the table minus the 5 records for which the field value is not equal to blank.
can any one help on this clarification
12-20-2016 1:29 PM
Look at table definition (EKPO) depending on your database, the value of the field for records existing before the append may be "null" and not "initial".
Regards,
Raymond
12-20-2016 9:36 PM
What other "brief" is needed? You don't know what "null" is?