topic Re: Reg: Select Query in Application Development and Automation Discussions

Reg: Select Query

Former Member — Wed, 26 May 2010 04:58:41 GMT

Hi All,

the Custom Table consist of fields Company Code, Material, Vendor, date, Status, deletion falg

of which Comapany Code, Material and Vendor are key fields, Now the requirement is i need to select the records without deletion flag for this i have written a select quiry as

select bukrs matnr lifnr stuff datma loekz from <databasetabe> into <internal table>

where bukrs in s_bukrs and

matnr in s_matnr and

lifnr in s_lifnr and

loekz = ' '.

but it is fetching along with deletion flag as 'X' Please correct my code if there is any mistake Actually i need records without deletion flag.

Regards,

Kumar

Re: Reg: Select Query

former_member233090 — Wed, 26 May 2010 05:03:25 GMT


select bukrs matnr lifnr stuff datma loekz from <databasetabe>INTO CORRESPONDING FIELDS OF <internal table>
where bukrs in s_bukrs and
matnr in s_matnr and
lifnr in s_lifnr and
loekz = ' '
 and flag ne 'X'.

bhavana

Edited by: Bhavana Amar on May 26, 2010 7:04 AM

Re: Reg: Select Query

Former Member — Wed, 26 May 2010 05:03:48 GMT

Hi,

Try to use "INTO CORRESPONDING FIELDS OF".

select bukrs matnr lifnr stuff datma loekz from <databasetabe> into CORRESPONDING FIELDS OF TABLE <internal table>

where bukrs in s_bukrs and

matnr in s_matnr and

lifnr in s_lifnr and

loekz EQ ' '.

Regards

Shruti

Re: Reg: Select Query

former_member776318 — Wed, 26 May 2010 05:03:51 GMT

HI,

Try using

1. LOEKZ = ' '. (a blank space in between inverted commas)

2. LOEKZ NE 'X'.

Let me know if that works.

Regards,

Saurabh

Edited by: SaurabhBuksh on May 26, 2010 7:04 AM

Re: Reg: Select Query

Former Member — Wed, 26 May 2010 05:04:20 GMT

Hi,

Use

AND LOEKZ EQ ''.

Regards

Vinod

Re: Reg: Select Query

Former Member — Wed, 26 May 2010 05:06:47 GMT

Hi,

Just try with the below code.

select bukrs matnr lifnr stuff datma loekz from <databasetabe> into <internal table>

where loekz = space and bukrs in s_bukrs and

matnr in s_matnr and

lifnr in s_lifnr .

For Eg.

TABLES : EKKO.

DATA : ITAB TYPE TABLE OF EKKO,

WA TYPE EKKO.

SELECT * FROM EKKO INTO TABLE ITAB WHERE LOEKZ EQ SPACE.

IF SY-SUBRC EQ 0.

LOOP AT ITAB INTO WA.

WRITE : / WA-EBELN.

ENDLOOP.

ENDIF.

With Regards,

Sumodh.P

Re: Reg: Select Query

Former Member — Wed, 26 May 2010 05:19:54 GMT

Use like

select bukrs matnr lifnr stuff datma loekz from ztable into it_tab

where bukrs in s_bukrs and

matnr in s_matnr and

lifnr in s_lifnr.

DELETE it_tab where loekz EQ 'X'.

Re: Reg: Select Query

Former Member — Wed, 26 May 2010 06:30:15 GMT

Hi Kumar,

You can either:

1) FLAG NE 'X'.

2) DELETE ENTRIES where FLAG = 'X'.

Edited by: Ajoy Chakraborty on May 26, 2010 12:01 PM