topic Selection criteria in Application Development and Automation Discussions

Selection criteria

Former Member — Mon, 11 Sep 2006 22:51:01 GMT

Hello friends i have to select data from a DB table to Internal table based on a condition.

I am having problems with the where condition for the field zuonr in BSID table,

Below is the code.

SELECT vbeln

kunnr

belnr

budat

dmbtr

xblnr

INTO TABLE it_bsid

FROM bsid

WHERE bldat IN s_bldat

ND zuonr EQ '5410 64 *' *'.

However when i replace '5410 64 *' by a specific number like '5410 64 125' then i get the data into my internal table.

But i want all the data starting with 5410 64

Any advice,

Shejal

Re: Selection criteria

Former Member — Mon, 11 Sep 2006 22:52:20 GMT

I had some problems in pasting the code previously,

code

SELECT vbeln

kunnr

belnr

budat

dmbtr

xblnr

INTO TABLE it_bsid

FROM bsid

WHERE bldat IN s_bldat

AND blart NE 'RV'

AND zuonr EQ '5410 64 *'.

Shejal...

Re: Selection criteria

Former Member — Mon, 11 Sep 2006 22:58:31 GMT

Hi,

Fetch the data using the select statement

SELECT vbeln

kunnr

belnr

budat

dmbtr

xblnr

INTO TABLE it_bsid

FROM bsid

WHERE bldat IN s_bldat

AND blart NE 'RV'.

loop the internal table.

and remove the records which does not starts with 5410 64

Regards,

Azaz

Message was edited by: Azaz Ali

Re: Selection criteria

Former Member — Mon, 11 Sep 2006 23:00:55 GMT

Thanks AZAZ,

CAn you explain in Brief as how would i select the data from the IT which would not start from 5410 64.

Thanks agan,

Shejal.

Re: Selection criteria

former_member186741 — Mon, 11 Sep 2006 23:02:07 GMT

use 'like' and '%' instead of '*',eg

SELECT vbeln

kunnr

belnr

budat

dmbtr

xblnr

INTO TABLE it_bsid

FROM bsid

WHERE bldat IN s_bldat

AND blart NE 'RV'

AND zuonr <b> not like '5410 64 %'</b>.

Re: Selection criteria

Former Member — Mon, 11 Sep 2006 23:26:53 GMT

Hi,

go through the code,

tables: bsid.

data : begin of it_bsid occurs 0,

vbeln like bsid-vbeln,

kunnr like bsid-kunnr,

belnr like bsid-belnr,

budat like bsid-budat,

dmbtr like bsid-dmbtr,

xblnr like bsid-xblnr,

ZUONR like bsid-ZUONR,

end of it_bsid.

select-options : s_bldat for bsid-bldat.

SELECT vbeln

kunnr

belnr

budat

dmbtr

xblnr

ZUONR

INTO TABLE it_bsid

FROM bsid

WHERE bldat IN s_bldat

AND blart NE 'RV'.

loop at it_bsid where ZUONR+0(6) ne '541064'.

delete it_bsid.

endloop.

Regards,

Azaz Ali.

Message was edited by: Azaz Ali