topic Re: problem with select query in Application Development and Automation Discussions

problem with select query

Former Member — Mon, 30 Apr 2007 11:24:11 GMT

hi,

I have to restrict the line items retrieved from BSIS for document type (AB, JV, XX, YY).

My Code is as below :

SELECT bukrs hkont augdt augbl zuonr gjahr belnr buzei monat budat

blart FROM bsis INTO TABLE gt_bsis

WHERE bukrs = '1000'

AND hkont IN so_hkont

AND gjahr = sp_gjahr

AND ( blart NE 'AB' OR

blart NE 'JV' OR

blart NE 'XX' OR

blart NE 'YY' )

AND budat IN gr_budat

AND waers IN so_waers.

With above statement it is not restricting the document types to specified.

PLease let me know how to restrict the selection of all these doc types.

Re: problem with select query

Former Member — Mon, 30 Apr 2007 11:26:39 GMT

SELECT bukrs hkont augdt augbl zuonr gjahr belnr buzei monat budat

blart FROM bsis INTO TABLE gt_bsis

WHERE bukrs = '1000'

AND hkont IN so_hkont

AND gjahr = sp_gjahr

AND ( blart NE 'AB' AND

blart NE 'JV' AND

blart NE 'XX' AND

blart NE 'YY' )

AND budat IN gr_budat

AND waers IN so_waers.

Re: problem with select query

Former Member — Mon, 30 Apr 2007 11:27:26 GMT

hi dear..

instead of all ORs u need to put AND...

cheers

Re: problem with select query

kostas_tsioubris — Mon, 30 Apr 2007 11:27:29 GMT

Hi,

you should replace 'OR' with 'AND'.

SELECT bukrs hkont augdt augbl zuonr gjahr belnr buzei monat budat
blart FROM bsis INTO TABLE gt_bsis
WHERE bukrs = '1000'
AND hkont IN so_hkont
AND gjahr = sp_gjahr
AND ( blart NE 'AB' and
blart NE 'JV' and
blart NE 'XX' and
blart NE 'YY' )
AND budat IN gr_budat
AND waers IN so_waers.

Kostas

Re: problem with select query

alex_m — Mon, 30 Apr 2007 11:27:29 GMT

SELECT bukrs hkont augdt augbl zuonr gjahr belnr buzei monat budat

blart FROM bsis INTO TABLE gt_bsis

WHERE bukrs = '1000'

AND hkont IN so_hkont

AND gjahr = sp_gjahr

AND ( blart NE 'AB' AND

blart NE 'JV' AND

blart NE 'XX' AND

blart NE 'YY' )

AND budat IN gr_budat

AND waers IN so_waers.

Message was edited by:

Alexander

Re: problem with select query

Former Member — Mon, 30 Apr 2007 11:28:57 GMT

If you don't want to select the document type (AB, JV, XX, YY), then please try the select query with 'AND' not with 'OR'.

Re: problem with select query

Former Member — Mon, 30 Apr 2007 11:29:54 GMT

HI,

you got the answers above/...

you can just check wiht some values whether the internal table is fetching data correctly in DEBUG mode..

regards,

nazeer..

Message was edited by:

nazeer shaik

Re: problem with select query

Former Member — Mon, 30 Apr 2007 11:29:59 GMT

Data R_BLART type range of BSIS-BLART.

Data W_BLART type line of R_BLART.

R_BLART-SIGN = 'I'.

R_BLART-OPTION = 'NE'.

R_BLART-LOW = 'AB'.

Append W_BLART to R_BLART.

....

use this in your select statement

santhosh

Re: problem with select query

Former Member — Mon, 30 Apr 2007 11:30:45 GMT

Hi,

declare a Range for

r_blart for bsis-blart.

r_blart-low = 'AB'.

r_blart-sign = 'I'.

r_blart-option = 'EQ'.

append r_blart.

r_blart-low = 'YY'.

r_blart-sign = 'I'.

r_blart-option = 'EQ'.

append r_blart.

r_blart-low = 'JV'.

r_blart-sign = 'I'.

r_blart-option = 'EQ'.

append r_blart.

r_blart-low = 'XX'.

r_blart-sign = 'I'.

r_blart-option = 'EQ'.

append r_blart.

SELECT bukrs hkont augdt augbl zuonr gjahr belnr buzei monat budat

blart FROM bsis INTO TABLE gt_bsis

WHERE bukrs = '1000'

AND hkont IN so_hkont

AND gjahr = sp_gjahr

AND budat IN gr_budat

AND waers IN so_waers.

delete gt_bsis where not blart in r_blart.

reward points if useful

regards

Anji

Re: problem with select query

Former Member — Mon, 30 Apr 2007 11:31:04 GMT

build a range table for doc types

ranges : it_blart for bsis-blart.

it_blart-sign = 'E'.

it_blart-option = 'BT'.

it_blart-low = 'AB'.

append it_blart.

it_blart-sign = 'E'.

it_blart-option = 'BT'.

it_blart-low = 'JV'.

append it_blart.

it_blart-sign = 'E'.

it_blart-option = 'BT'.

it_blart-low = 'XX'.

append it_blart.

it_blart-sign = 'E'.

it_blart-option = 'BT'.

it_blart-low = 'YY'.

append it_blart.

SELECT bukrs hkont augdt augbl zuonr gjahr belnr buzei monat budat

blart FROM bsis INTO TABLE gt_bsis

WHERE bukrs = '1000'

AND hkont IN so_hkont

AND gjahr = sp_gjahr

AND blart in it_blart

AND budat IN gr_budat

AND waers IN so_waers.