01-07-2008 9:15 AM
pl explain the following query:
SELECT * APPENDING CORRESPONDING FIELDS OF TABLE
bomtable FROM mara
INNER JOIN makt ON maktmatnr = maramatnr
WHERE mara~matkl = GROUP.
01-07-2008 10:10 AM
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.
01-07-2008 9:20 AM
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^
01-07-2008 9:23 AM
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.
01-07-2008 9:25 AM
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
01-07-2008 9:26 AM
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
01-07-2008 10:10 AM
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.