Adding fields to table EBAN

[Former Member]

hi

i am adding new field to table EBAN  in structure CI_EBANDE.

The field is called z_flag and it's data element in type FLAG (char 1).

when i am writing the next select

data:  gt_eban type table of EBAN.

select * from EBAN into table gt_eban

where z_flag = ' '.

and i get no records (sy-dbcnt = 0) when in the database i have 1328 records with this field when it has null value.

thanks

Ami.

[Former Member]

Hi,

Try using the below given query.

select * from EBAN into table gt_eban where z_flag = ' '. (use a space between single quotes)

or

select * from EBAN into table gt_eban where z_flag = space. (SPACE is SAP keyword)

Cheers

~Niranjan

[Former Member]

use below query.

select * from EBAN into table gt_eban where z_flag is null.

When you add a field, the field always has a null value unless you have ticked on INITIAL VALUES checkbox.

Read Clemens reply in below thread.

[Former Member]

Hi Ami ,

                  Put the break point over the select query and check weather the data is featching from DB or not .....

[Former Member]

i found that when i add new field to table i use se14 extra -> force conversion

that fux the problem

thanks