topic Re: Regarding Select query in Application Development and Automation Discussions

Regarding Select query

Former Member — Thu, 24 Apr 2008 11:38:34 GMT

Hi all,

Please give me the select query

I have to fetch MATNR EBELP WERKS LGORT BEDNR from EKPO table where EBELN is the Value in the selection screen and BUKRS should be 2001 or 2002 or 2003 or 9999.

Regards

Ajay

Re: Regarding Select query

Former Member — Thu, 24 Apr 2008 11:44:37 GMT

Here is a simple version


TABLES: ekpo.


SELECT matnr ebelp werks lgort bednr FROM ekpo
  WHERE ebeln IN s_ebeln
    AND ( bukrs = '2001' OR
          bukrs = '2002' OR
          bukrs = '2003' OR
          bukrs = '9999' ).

* your process
ENDSELECT.

Re: Regarding Select query

S0025444845 — Thu, 24 Apr 2008 11:44:38 GMT

Hi,

do like this.

tables:ekpo.

types: begin of ty_ekpo,

matnr type ekpo-matnr,

ebeln type ekpo-ebeln,

ebelp type ekpo-ebelp,

werks type ekpo-werks,

lgort type ekpo-lgort,

bednr type ekpo-bednr,

end of ty_ekpo.

data: it_ekpo type standard table of ty_ekpo.

select-options: s_ebeln for ekpo-ebeln.

select matnr ebeln ebelp werks lgort bednr into table it_ekpo from ekpo where ebeln in s_ebeln and

(bukrs = '2001' OR

bukrs = '2002' OR

bukrs = '2003 ' OR

bukrs = '9999' ).

regards,

sudha

Edited by: sudha yadav on Apr 24, 2008 1:45 PM

Edited by: sudha yadav on Apr 24, 2008 1:46 PM

Edited by: sudha yadav on Apr 24, 2008 1:47 PM

Re: Regarding Select query

abapdeveloper20 — Thu, 24 Apr 2008 11:45:25 GMT

DELCARE one internal table with all fields u mentioned...

and select options as

P_EBELN LIKE EKPO-EBELN.

now

SELECT SINGLE 
 MATNR 
 EBELP 
 WERKS 
 LGORT 
 BEDNR 
 INTO CORRESPONDING FIELDS OF TABLE ITAB 
 FROM EKPO
WHERE EBELN IN P_EBELN AND
             BUKRS IN ( '2001', '2002' ,'2003' , '9999').

Reward if useful

Re: Regarding Select query

Former Member — Thu, 24 Apr 2008 11:46:17 GMT

This should be u r select query :

SELECT matnr ebelp werks lgort bednr FROM ekpo
  WHERE ebeln IN s_ebeln
    AND ( bukrs = '2001' OR
          bukrs = '2002' OR
          bukrs = '2003  ' OR
          bukrs = '9999' ).

Re: Regarding Select query

Former Member — Thu, 24 Apr 2008 11:46:58 GMT

Hi,

select MATNR

EBELP

WERKS

LGORT

BEDNR

from EKPO

into table itab

where EBELN = (selection screen value)

and (BUKRS = 2001

or BUKRS = 2002

or BUKRS = 2003

or BUKRS = 9999).

reward if helpful

raam

Re: Regarding Select query

Former Member — Thu, 24 Apr 2008 11:53:16 GMT

Hi,

For selecting the data in selection screen which type of data type you are using

I mean Select-options or Paramters.

if you are using select-options for Ebeln and Bukrs use IN operator where codition

if you are using Parameters for ebeln and bukrs use EQ operator.

see below eg:

here ebeln is using select-options so I have given in operator and bukrs hard coded.

select ebelp

matnr

werks

lgort

bendr from ekpo

into table <itab>

where ebeln in s_ebeln

and bukrs = '2001' or

bukrs = '2002' or

bukrs = '2003' or

bukrs = '9999'.

Actually what is your requirement bukrs value it should be one in that above values or is it a range. I mean is it select-options or parameters 1st let me clear.

Thaks

Ganesh

Re: Regarding Select query

Former Member — Thu, 24 Apr 2008 11:55:30 GMT

Try like this.

Select MATNR

EBELP

WERKS

LGORT

BEDNR

from ekpo

into table i_ekpo

where ebeln in s_ebeln

and bukrs in ('2001', '2002', '2003', '9999').

Regards

Haritha.