topic Re: Select statement in Application Development and Automation Discussions

Select statement

Former Member — Tue, 14 Aug 2007 11:30:49 GMT

hi,

what are the various select statements.??any ppt's or documents on select statement would be helpful..

thanx..

Re: Select statement

Former Member — Tue, 14 Aug 2007 11:32:14 GMT

http://www.planetsap.com/ABAP_SQL_SELECT_syntax.htm

Re: Select statement

former_member189059 — Tue, 14 Aug 2007 11:32:33 GMT

type select in the se38 editor and press F1

you will get all the options

Select .. end select --> For Fetching Multiple records..

Its Runs in loop

i.eNo. of Database Hits = Length of loop .

so it should avoided for performance issues and use

select ..... into table...

select single --> Used for fetching single record.

Re: Select statement

Former Member — Tue, 14 Aug 2007 11:33:02 GMT

Hi,

The select command is the most fundamental function of writing ABAP programs allowing the retrieval of data from SAP database tables. Below are a few examples of the various ways of selecting data.

*Code to demonstrate select command

*Code to demonstrate select into internal table command

TYPES: BEGIN OF t_bkpf,

include structure bkpf.

bukrs LIKE bkpf-bukrs,

belnr LIKE bkpf-belnr,

gjahr LIKE bkpf-gjahr,

bldat LIKE bkpf-bldat,

monat LIKE bkpf-monat,

budat LIKE bkpf-budat,

xblnr LIKE bkpf-xblnr,

awtyp LIKE bkpf-awtyp,

awkey LIKE bkpf-awkey,

END OF t_bkpf.

DATA: it_bkpf TYPE STANDARD TABLE OF t_bkpf INITIAL SIZE 0,

wa_bkpf TYPE t_bkpf.

TYPES: BEGIN OF t_bseg,

*include structure bseg.

bukrs LIKE bseg-bukrs,

belnr LIKE bseg-belnr,

gjahr LIKE bseg-gjahr,

buzei LIKE bseg-buzei,

mwskz LIKE bseg-mwskz, "Tax code

umsks LIKE bseg-umsks, "Special G/L transaction type

prctr LIKE bseg-prctr, "Profit Centre

hkont LIKE bseg-hkont, "G/L account

xauto LIKE bseg-xauto,

koart LIKE bseg-koart,

dmbtr LIKE bseg-dmbtr,

mwart LIKE bseg-mwart,

hwbas LIKE bseg-hwbas,

aufnr LIKE bseg-aufnr,

projk LIKE bseg-projk,

shkzg LIKE bseg-shkzg,

kokrs LIKE bseg-kokrs,

END OF t_bseg.

DATA: it_bseg TYPE STANDARD TABLE OF t_bseg INITIAL SIZE 0,

wa_bseg TYPE t_bseg.

*Select directly into an internal table

SELECT bukrs belnr gjahr buzei mwskz umsks prctr hkont xauto koart

dmbtr mwart hwbas aufnr projk shkzg kokrs

FROM bseg

INTO TABLE it_bseg.

Select directly into an internal table where fields are in a
different order or not all fields are specified

SELECT bukrs belnr gjahr buzei mwskz umsks prctr hkont xauto koart

dmbtr mwart hwbas aufnr projk shkzg kokrs

FROM bseg

INTO CORRESPONDING FIELDS OF TABLE it_bseg.

*Select... endselect command

SELECT bukrs belnr gjahr buzei mwskz umsks prctr hkont xauto koart

dmbtr mwart hwbas aufnr projk shkzg kokrs

FROM bseg

INTO wa_bseg.

APPEND wa_bseg TO it_bseg.

ENDSELECT.

*Select FOR ALL ENTRIES command

SELECT bukrs belnr gjahr bldat monat budat xblnr awtyp awkey

UP TO 100 ROWS

FROM bkpf

INTO TABLE it_bkpf.

IF sy-subrc EQ 0.

The FOR ALL ENTRIES comand only retrieves data which matches
entries within a particular internal table.

SELECT bukrs belnr gjahr buzei mwskz umsks prctr hkont xauto koart

dmbtr mwart hwbas aufnr projk shkzg kokrs

FROM bseg

INTO TABLE it_bseg

FOR ALL ENTRIES IN it_bkpf

WHERE bukrs EQ it_bkpf-bukrs AND

belnr EQ it_bkpf-belnr AND

gjahr EQ it_bkpf-gjahr.

ENDIF.

Regards

Sudheer

Re: Select statement

Former Member — Tue, 14 Aug 2007 11:33:54 GMT

SAP's OPEN SQL, syntax of the SELECT statement

Basic form:

SELECT result FROM source [INTO target] [WHERE condition] [GROUP BY fields] [ORDER BY order].

SELECT clause

Variants:

1. SELECT [SINGLE [FOR UPDATE] DISTINCT] *

2. SELECT [SINGLE [FOR UPDATE] DISTINCT] s1 ... sn

3. SELECT [SINGLE [FOR UPDATE] DISTINCT] (itab)

FROM clause

Variants:

1. ... FROM dbtab

Additions:

1. ... CLIENT SPECIFIED

2. ... BYPASSING BUFFER

3. ... UP TO n ROWS

2. ... FROM (dbtabname)

Additions:

1. ... CLIENT SPECIFIED

2. ... BYPASSING BUFFER

3. ... UP TO n ROWS

INTO target

(This form of the FROM clause works only in conjunction with the INTO clause.)

INTO clause

Variants:

1. ... INTO wa

2. ... INTO CORRESPONDING FIELDS OF wa

3. ... INTO (f1, ..., fn)

4. ... INTO TABLE itab

5. ... INTO CORRESPONDING FIELDS OF TABLE itab

6. ... APPENDING TABLE itab

7. ... APPENDING CORRESPONDING FIELDS OF TABLE itab

WHERE clause

Variants:

1. ... WHERE f op g

2. ... WHERE f [NOT] BETWEEN g1 AND g2

3. ... WHERE f [NOT] LIKE g

4. ... WHERE f [NOT] IN (g1, ..., gn)

5. ... WHERE f [NOT] IN itab

6. ... WHERE f IS [NOT] NULL

7. ... WHERE NOT cond

8. ... WHERE cond1 AND cond2

9. ... WHERE cond1 OR cond2

10. ... WHERE (itab)

11. ... WHERE cond AND (itab)

12. ... FOR ALL ENTRIES IN itab WHERE cond

Operator Meaning

EQ or = equal to

NE or < > not equal to

LT or < less than

LE or < = less than or equal to

GT or > greater than

GE or >= greater than or equal to

GROUP-BY clause

Variants:

1. ... GROUP BY f1 ... fn

2. ... GROUP BY (itab)

ORDER-BY clause

Variants:

1. ... ORDER BY PRIMARY KEY

2. ... ORDER BY f1 ... fn

3. ... ORDER BY (itab)

http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/abapindx.htm

http://www.erpgenie.com/abap/example_code.htm

Re: Select statement

varma_narayana — Tue, 14 Aug 2007 11:36:22 GMT

Hi..

There are basically 3 types of SELECT statements :

1. To Read multiple rows from DB table into Work area (Row by row in a loop)

SELECT <FIELDS> FROM <DB TABLE> INTO <WA>.

ENDSELECT.

2. To read a single row from dB table into work area(Based on Primary key)

SELECT SINGLE <FIELDS> FROM <DBTABLE> into <WA> where <cond>.

3. To read a group of rows from DB table into Internal Table (Array fetch)

SELECT <fields> from <DBTABLE> into TABLE <ITAB>.

Both 2 and 3 are efficient performance wise.

<b>Reward if Helpful.</b>

Re: Select statement

Former Member — Tue, 14 Aug 2007 11:40:11 GMT

hi,

thanx for the reply..do u have any ppts for select statement