topic Re: select statements in Application Development and Automation Discussions

select statements

Former Member — Fri, 22 Sep 2006 14:16:09 GMT

Hi exports,

Can any body tell me difference between

select * from db ti itab

select single * from db to itab

select * from db for all entries its

select * from db for corresponding values itab

I read in the document but I am not clear.

please suggest me if any good notes is there.

Thanks

Nithin

Re: select statements

Former Member — Fri, 22 Sep 2006 14:17:54 GMT

Basically all the below are some variations of SELECT statement to fetch data from database tables.

select * from db ti itab

It is the stand way to fetch the data from database table append the same into internal table itab.(Please check the syntax the above is incorrect). U need to make sure that itab has the same field sequence as you are fetching in the SELECT statement.

select single * from db to itab

Here is fetches a single record from database as to the specified key.

select * from db for all entries its

The particular variation is used when you required to fetch data from a table, for all entries in another internal table. It can said to be equivalent to

Loop at itab.

SELECT * from db into jtab

where xyz = itab-xyz.

endloop.

select * from db for corresponding values itab

It is similar to the first statement the difference is that it would update the corresponding fields in table itab so the sequence of fields in itab and SELECt can be different

Message was edited by: Anurag Bankley

Re: select statements

Former Member — Fri, 22 Sep 2006 14:18:44 GMT

Hi nithin,

select * from db ti itab

It should be

select * from db INTO TABLE itab

-- A Normal select statement,

which puts all the records fetched

in itab.

select single * from db to itab

ONLY 1 record

3. select * from db for all entries its

This is used for further filteration

w.r.t some values

in another internal table (and not dbtable where clause)

4. select * from db for corresponding values itab

Fetches all records,

and puts in itab,

ONLY THOSE FIELDS whose NAME Matches,

only those are put, rest are ignored.

regards,

amit m.

Re: select statements

Former Member — Fri, 22 Sep 2006 14:19:03 GMT

hi Nithin,

select * from db ti itab

selects all the records from the db

select single * from db to itab

select only one record from the db

select * from db for all entries its

select all the entries in its from db

select * from db for corresponding values itab

select all the entries from itab without bothering the order in which the fields are there

Regards,

Santosh

Re: select statements

Former Member — Fri, 22 Sep 2006 14:20:24 GMT

select * from db ti itab

Retrives all the records and all fields from the database table to itsb

select single * from db to itab

select the single record and all fields based on the where condition

select * from db for all entries its

for every unique entry in the internal table that you will mention in for all entries statement , it will retrive all the records and all the fields from database table

select * from db for corresponding values itab

if the fieldnames of database table and internal table are same , then u can use corresponding

Re: select statements

Former Member — Fri, 22 Sep 2006 14:21:30 GMT

HI Nithin,

1. Select * from DB into table Itab.

select all records from DB and appends in itab.

2. Select Single * from DB into itab.

Select the first record from DB which matches the condition ( If any) into itab.

3. Select * from DB for all entries in its into itab.

Select records from DB those are in its according to condition and appends it to itab.

4. Select * from DB for corresponding values itab.

Select records from DB and appends the itab where the same fields in DB and itab there. the remaining fields left blank

regards

Re: select statements

Former Member — Fri, 22 Sep 2006 14:22:46 GMT

hi nitin,

1. select * from db ti itab

this reads all the relevant rows from DB that satisfy the WHERE clause.

2. select single * from db to itab this expects a primary key in WHERE clause and gets a single record. if primary keynot given like this, it fetches the first occurence.

3. select * from db for all entries this is used for selecting the relevant rows for all the entries in the internal table <itab>.

4. select * from db for corresponding values itab same as (1) but here u r retrieving few selected fields bcoz itab doesn't have all the components as the DB table

reward if useful...

Re: select statements

Former Member — Fri, 22 Sep 2006 14:24:10 GMT

Hi,

1)select * from db ti itab

select all records from database table. select

2)single * from db to itab

select first row matching where condition

3)select * from db for all entries its

selets data with the entries corresponding to internal table

4)select * from db for corresponding values itab

itab has two fields matnr,werks so only

this two fields are populated in internal table

irrespective of mara having 30 fields.

Regards

Amole

Re: select statements

Former Member — Fri, 22 Sep 2006 14:52:16 GMT

hi,

select * from selects

all the records from the mentioned table.

select single * from selects

selects single record from the table mentioned

select * from db for all entries its

select all records based on the entries selected from the previous table.

select * from db for corresponding values itab.

selects the data and pushes the data into the internal table irrespective of the order defined.