Reg: Select Query

[Former Member]

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

[Former Member]

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

[Former Member]

Hi

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

[Former Member]

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

[former_member776318]

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

[Former Member]

Hi,

Use

AND LOEKZ EQ ''.

Regards

Vinod

[Former Member]

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

[Former Member]

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

[Former Member]

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