topic Re: select in Application Development and Automation Discussions

select

Former Member — Wed, 23 May 2007 06:56:35 GMT

Hi,

this statement is not working,

please anybody let me know how to compare offset values in where clause

this statement is showing an error,

Select rebel rebel from lesser into table get_purchase

for all entries in get_ship

Where verdant in s_date

and TX+0(10) = get_ship-tokenism.

please give me an idea how to rectify it..

regards,

Adair

Re: select

Former Member — Wed, 23 May 2007 07:01:09 GMT

You can't compare the offset values in where clause

better compare it in the loop of a internal table and ignore them.

Select rebel from lesser into table get_purchase

for all entries in get_ship

Where verdant in s_date.

loop at get_purchase.

read table get_ship with key.....

if get_purchase-TX+0(10) <> get_ship-tokenism.

delete get_purchase index sy-tabix.

endif.

endloop.

Reward points if useful

Regards

Anji

Re: select

Former Member — Wed, 23 May 2007 07:02:26 GMT

Hi Madhavi,

why u are select the same field(REBEL) two times .

Thanks & Regards

Bhaskar Rao.M

Re: select

Former Member — Wed, 23 May 2007 07:03:25 GMT

Hi,

We can't give offset values in WHERE clause of a SELECT stmt. After retriving the data only we can do it in the internal table.

Cheers,

Bujji

Re: select

dev_parbutteea — Wed, 23 May 2007 07:04:47 GMT

Hi,

try

Select rebel from lesser into table get_purchase

for all entries in get_ship

Where verdant in s_date

and TX(10) = get_ship-tokenism.

Re: select

Former Member — Wed, 23 May 2007 07:04:57 GMT

Hi,

its not possible to use offset operator in where condition.

try for some other alternative.

rgds,

bharat.

Re: select

Former Member — Wed, 23 May 2007 07:05:27 GMT

you cannot use offsets to the right hand fields in select

try this

if not get_ship[] is initial.

Select rebel rebel from lesser <b>TX</b> into table get_purchase

for all entries in get_ship

Where verdant in s_date.

endif.

loop at get_pucharse.

v_tabix = sy-tabix.

read table getship with key tokenism eq get_pucharse-TX+0(10).

if sy-subrc ne 0.

delete get_purchase index v_tabix.

endif.

endloop.

Message was edited by:

Chandrasekhar Jagarlamudi

Re: select

Former Member — Wed, 23 May 2007 07:06:10 GMT

Hi.

"" TX+0(10) = get_ship-tokenism"" This checking is not possible in the where clause.It will Consider this whole word as a field and that is the reason u r getting an error..After the selection write an "IF" condition seperately to for Checking... Then why u r selecting rebel field twice..Correct that also..there is no other mistakes.....

Reward All the helpfull Answers..

Re: select

former_member196280 — Wed, 23 May 2007 07:16:35 GMT

Hi Madhavi,

You cannot use offset value on table field in where clause while retreving.

Read value TX into internal table , Ex: get_purchase. and then compare it using offset by looping internal table. Ex. get_purchase-TX+0(2).

Reward points to all useful answers.

Regards,

SaiRam