Select Query

[rahul2000]

Dear All,

I have fired a select query as follows

SELECT BUKRS BELNR GJAHR BUZEI MWSKZ HKONT

TXGRP HWBAS HWSTE KTOSL KBETR

FROM BSET

INTO TABLE IT_BSET FOR ALL ENTRIES IN IT_BSEG

WHERE BELNR = IT_BSEG-BELNR

AND KTOSL IN ('JP4','JP5') .

In the same query i also want documents with MWSKZ EQ 00. it is not necessary that JP4 and JP5 will have MWSKZ eq 00. So how is the query to be fired?

[Former Member]

Hi,

if u have the MWSKZ field in the IT_BSEG

table then you can add the condition in this where only.

[rahul2000]

HI CHANDRIKA..

apart from the existing documents i want 00 documents as well..

[Former Member]

SELECT BUKRS BELNR GJAHR BUZEI MWSKZ HKONT 
TXGRP HWBAS HWSTE KTOSL KBETR 
FROM BSET
INTO TABLE IT_BSET FOR ALL ENTRIES IN IT_BSEG
WHERE BELNR = IT_BSEG-BELNR
AND KTOSL IN ('JP4','JP5')  and
MWSKZ = '00'.

[rahul2000]

hi amit...and condition cannot be used...as that will mean all 3 will have to be satisfied at a time

[Former Member]

Rahul,

first select all document as per your select query than delete unwanted by comparing kostl or mwskz .

Amit.

[Former Member]

hi do like this ...

SELECT BUKRS BELNR GJAHR BUZEI MWSKZ HKONT

TXGRP HWBAS HWSTE KTOSL KBETR

FROM BSET

INTO TABLE IT_BSET FOR ALL ENTRIES IN IT_BSEG

WHERE BELNR = IT_BSEG-BELNR

AND KTOSL IN ('JP4','JP5') .

AND MWSKZ = '00'.

[Former Member]

SELECT BUKRS BELNR GJAHR BUZEI MWSKZ HKONT

TXGRP HWBAS HWSTE KTOSL KBETR

FROM BSET

INTO TABLE IT_BSET FOR ALL ENTRIES IN IT_BSEG

WHERE BELNR = IT_BSEG-BELNR AND

KTOSL IN ('JP4','JP5') .

Delete it_bset where KTOSL NE 00.

Regards

rajesh

[Former Member]

This will select documents with KTOSL JP4 or JP5 and among those with MWSKZ '00'

SELECT BUKRS BELNR GJAHR BUZEI MWSKZ HKONT 
TXGRP HWBAS HWSTE KTOSL KBETR 
FROM BSET
INTO TABLE IT_BSET FOR ALL ENTRIES IN IT_BSEG
WHERE BELNR = IT_BSEG-BELNR
AND KTOSL IN ('JP4','JP5') 
and mwskz = '00'.

If you want to select documents with KTOSL 'JP4' or 'JP5' and or mwskz 00. Do this :

SELECT BUKRS BELNR GJAHR BUZEI MWSKZ HKONT 
TXGRP HWBAS HWSTE KTOSL KBETR 
FROM BSET
INTO TABLE IT_BSET FOR ALL ENTRIES IN IT_BSEG
WHERE BELNR = IT_BSEG-BELNR
AND ( KTOSL IN ('JP4','JP5')  OR mwskz = '00' ).

regards,

Advait

[Former Member]

Put an OR condition .. If U want both conditions to be satisfied..

SELECT BUKRS BELNR GJAHR BUZEI MWSKZ HKONT

TXGRP HWBAS HWSTE KTOSL KBETR

FROM BSET

INTO TABLE IT_BSET FOR ALL ENTRIES IN IT_BSEG

WHERE BELNR = IT_BSEG-BELNR

AND ( KTOSL IN ('JP4','JP5') OR

MWSKZ EQ 00 ) .

[former_member787646]

Hi

Try the following SQL..

SELECT BUKRS BELNR GJAHR BUZEI MWSKZ HKONT TXGRP HWBAS HWSTE KTOSL KBETR FROM BSET

INTO TABLE IT_BSET FOR ALL ENTRIES IN IT_BSEG

WHERE BELNR = IT_BSEG-BELNR AND ( KTOSL IN ('JP4','JP5') OR MWSKZ EQ 00 ) .

Hope it helps.

Murthy

[Former Member]

hiii

first right a query like

SELECT BUKRS BELNR GJAHR BUZEI MWSKZ HKONT

TXGRP HWBAS HWSTE KTOSL KBETR

FROM BSET

INTO TABLE IT_BSET FOR ALL ENTRIES IN IT_BSEG

WHERE BELNR = IT_BSEG-BELNR

AND KTOSL IN ('JP4','JP5') AND

MWSKZ EQ '00'.

here it will fetch data for JP4 and JP5 with MWSKZ field value as 00..

or just fetch data by using

SELECT BUKRS BELNR GJAHR BUZEI MWSKZ HKONT

TXGRP HWBAS HWSTE KTOSL KBETR

FROM BSET

INTO TABLE IT_BSET FOR ALL ENTRIES IN IT_BSEG

WHERE BELNR = IT_BSEG-BELNR

AND KTOSL IN ('JP4','JP5').

then by using LOOP with where condition for MWSKZ EQ '00' you can get that record for JP4 or JP5.

regards

twinkal