select query

[Former Member]

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.

[Former Member]

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.

[Former Member]

hi

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^

[Former Member]

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.

[Former Member]

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

[Former Member]

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

[Former Member]

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.