SELECT with no records

[former_member184029]

Hi

It's first time that happen, I have a 'Z' table where I have control number, I have a FM which extract these number and is called from a LOOP, first record of this loop is processed and the control number are fine, but next record when the FM is called,the "SELECT" of the 'Z' table put in blank fields, I've just update this table if a check is ' '.

This is "SELECT"

SELECT * INTO TABLE ti_nroctrlfact FROM zfictrlfact WHERE zcodctrl eq 'FC'.

thanks in advance.

[former_member156446]

SELECT * INTO TABLE ti_nroctrlfact FROM zfictrlfact WHERE zcodctrl eq 'FC'.

make sure zcodctrl is two character element... if it more padd FC will zeros.. say zcodctrl is 4 characters then '00FC'.

or try

SELECT *  FROM zfictrlfact 
INTO TABLE ti_nroctrlfact
WHERE zcodctrl eq 'FC'.

[former_member184029]

Thanks J@y

I've cheched zcodctrl is 2 characters and put code lines sugested but still values in blank on "SELECT" command.

Regards

[former_member156446]

Check the dicleration of ti_nroctrlfact it need to be the same type of ztable you are getting data...

last option is data issue.. make sure there are no convertion routines where u send FC it get converts to GC or BC...

query the same input in se11 or se16 and make sure data is present...with the criteria you are using in select.

[former_member184029]

J@y thanks for answering

Check the dicleration of ti_nroctrlfact it need to be the same type of ztable you are getting data...

same declaration

last option is data issue.. make sure there are no convertion routines where u send FC it get converts to GC or BC...

VZCODCTRL = 'FC'.
*    SELECT * INTO TABLE ti_nroctrlfact FROM zfictrlfact WHERE zcodctrl eq 'FC'. " CR#ECDK903965
    SELECT *  FROM zfictrlfact INTO TABLE ti_nroctrlfact WHERE zcodctrl EQ VZCODCTRL.

query the same input in se11 or se16 and make sure data is present...with the criteria you are using in select.

data present when I check se11 and se16 data values

Regards

[former_member156446]

>

> query the same input in se11 or se16 and make sure data is present...with the criteria you are using in select.
> data present when I check se11 and se16 data values
> Regards

data is present is every thing is the same case (upper case)

check the domain of zcodctrl, if lower case check box is selected / or sign check box is selected

[former_member184029]

check the domain of zcodctrl, if lower case check box is selected / or sign check box is selected

Domain of zcodctrl the lower case check box is selected.

What does it mean?

Regards

[former_member156446]

>

> Domain of zcodctrl the lower case check box is selected.
> What does it mean?

then use this way

WHERE zcodctrl eq 'fc'.

or un-check the lower case check box

[former_member184029]

I've made change and test, but still getting blank fields.

[Former Member]

Hi,

Can you tell how you declared the internal table.

Did you do it as t_notcntrl type standard table of ztable.?

Generally such errors occur because of improper declaration.

Regards,

Subhashini

[former_member184029]

Thank you for answering to all.

I solved it, It was a code line used in a BTE.