topic Re: Adding fields to table EBAN in Application Development and Automation Discussions

Adding fields to table EBAN

Former Member — Mon, 09 Jul 2012 06:40:35 GMT

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 — Mon, 09 Jul 2012 06:51:31 GMT

Hi,

Try using the below given query.

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

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

Cheers

~Niranjan

Former Member — Mon, 09 Jul 2012 06:53:34 GMT

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 — Mon, 09 Jul 2012 07:16:21 GMT

Hi Ami ,

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

Former Member — Mon, 09 Jul 2012 08:03:37 GMT

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

that fux the problem

thanks