Selection criteria

[Former Member]

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

[Former Member]

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

[Former Member]

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...

[former_member186741]

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>.

[Former Member]

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

[Former Member]

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.

[Former Member]

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