topic Re: Select Query in Application Development and Automation Discussions

Select Query

rahul2000 — Tue, 29 Jul 2008 09:04:22 GMT

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?

Re: Select Query

Former Member — Tue, 29 Jul 2008 09:06:19 GMT

Hi,

if u have the MWSKZ field in the IT_BSEG

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

Re: Select Query

Former Member — Tue, 29 Jul 2008 09:07:03 GMT

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

Re: Select Query

Former Member — Tue, 29 Jul 2008 09:09:29 GMT

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

Re: Select Query

Former Member — Tue, 29 Jul 2008 09:09:55 GMT

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

Re: Select Query

rahul2000 — Tue, 29 Jul 2008 09:10:10 GMT

HI CHANDRIKA..

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

Re: Select Query

rahul2000 — Tue, 29 Jul 2008 09:10:46 GMT

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

Re: Select Query

Former Member — Tue, 29 Jul 2008 09:12:32 GMT

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

Re: Select Query

Former Member — Tue, 29 Jul 2008 09:12:48 GMT

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

Re: Select Query

former_member787646 — Tue, 29 Jul 2008 09:13:31 GMT

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

Re: Select Query

Former Member — Tue, 29 Jul 2008 09:14:28 GMT

Rahul,

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

Amit.

Re: Select Query

Former Member — Tue, 29 Jul 2008 09:16:52 GMT

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