topic Re: select query in Application Development and Automation Discussions

select query

Former Member — Mon, 07 Jan 2008 09:15:47 GMT

pl explain the following query:

SELECT * APPENDING CORRESPONDING FIELDS OF TABLE

bomtable FROM mara

INNER JOIN makt ON makt_{matnr = mara}matnr

WHERE mara~matkl = GROUP.

Re: select query

Former Member — Mon, 07 Jan 2008 09:20:44 GMT

good

i hope this join statement is use to join the table mara and makt with the key field matnr and putting all the data into an internal table bomtable.

thanks

mrutyun^

Re: select query

Former Member — Mon, 07 Jan 2008 09:23:36 GMT

hi ,

What is there to explain u r selecting the data from 2tables and sending the values to bomtable if u have not used appending also u will get the same result.

Re: select query

Former Member — Mon, 07 Jan 2008 09:25:21 GMT

u r retrieving the information from mara and makt and

u r appending the records to the table bomtable

based on the where condition.

Madhavi

Re: select query

Former Member — Mon, 07 Jan 2008 09:26:09 GMT

Jani,

1. Here using table joins MARA. MAKT,

2.APPENDING is denoting that : When ever this select

statemnt executes it will add the records to internal

table "bomtable" instead of over writing.

3. CORRESPONDING : is using because internal table is having the columns other than the columns in MARA, MAKT tables.

Don't forget to reward if useful

Re: select query

Former Member — Mon, 07 Jan 2008 10:10:25 GMT

Hi Jani,

1.APPENDING denotes that it will add records to the internal table rather than overwriting.

U can fetch the same result without this only for few fields.

2. CORRESPONDING denotes that the internal table u used will have the columns other than the main tables u used.This CORRESPONDING matches the fields by itself.Otherwise there will be a mismatch in the fields.

3.Here join is used to join 2 tables MARA and MAKT and will retrieve the fields based on the where condition.

Reward if helpful.

Thanks and Regards

Deepthi K.