Problem with domain and blank value

[Former Member]

Hi,

I have a problem with my domain.

I created a structure append to LFA1 and add in this append a custom data element ZREG_TVA associated to a domain ZREG_TVA.

This domain contain only 3 values : blank, D and E

all objects have been activated.

Now the problem is when i would like to select all the blank values in this new LFA1 field, i obtain 0 results.

my selection is :

SELECT * FROM LFA1 INTO TABLE T_LFA1

WHERE ZREG_TVA = ''

But when i modify this data in the vendor modification transaction (FK02) (i set D, save and set blank), now when redo my selection i only have 1 entry

I tried SE14 to update LFA1 entries but it do nothing.

The only selection who works is

SELECT * FROM LFA1 INTO TABLE T_LFA1

WHERE ZREG_TVA = NULL

but i can't use this statement in my program because null is not the awating value.

Is anyone knows about this problem ?

Many thanks in advance

[Former Member]

Hi,

I have a problem with my domain.

I created a structure append to LFA1 and add in this append a custom data element ZREG_TVA associated to a domain ZREG_TVA.

This domain contain only 3 values : blank, D and E

all objects have been activated.

Now the problem is when i would like to select all the blank values in this new LFA1 field, i obtain 0 results.

my selection is :

SELECT * FROM LFA1 INTO TABLE T_LFA1

WHERE ZREG_TVA = ''

But when i modify this data in the vendor modification transaction (FK02) (i set D, save and set blank), now when redo my selection i only have 1 entry

I tried SE14 to update LFA1 entries but it do nothing.

The only selection who works is

SELECT * FROM LFA1 INTO TABLE T_LFA1

WHERE ZREG_TVA = NULL

but i can't use this statement in my program because null is not the awating value.

Is anyone knows about this problem ?

Many thanks in advance

[Clemenss]

Hi Olivier,

when you create an append for a table, you must check the INITIAL checkbox for the appended field or include in the table definition in SE11/SE12. If you append a new field, the database will then fill it for all existing records with initial value. Then you have no problem with selections.

Regards,

Clemens

[Former Member]

Many thanks for your answer.

The problem is that i added my fields directly to the structure append, without an include so i can't check the initial value box.

thanks anyway