APPENDING TABLE

1. The following code indicates:

SELECT fld1 fld2 FROM tab1 APPENDING TABLE itab

WHERE fld1 IN sfld1.

A: Add rows to the existing rows of itab.

B: Add rows to itab after first deleting any existing rows of itab.

C: Select rows from tab1 for matching itab entries.

D: Nothing, this is a syntax error.

Syntax

... FROM { {dbtab [AS tabalias]}
| join
| {(dbtab_syntax) [AS tabalias]} }
[UP TO n ROWS]
[CLIENT SPECIFIED]
[BYPASSING BUFFER]
[CONNECTION {con|(con_syntax)}] ... .

Alternatives:

1.... dbtab [AS tabalias]

2.... join
2.... (dbtab_syntax) [AS tabalias]

Extras:

1.... UP TO n ROWS

2.... CLIENT SPECIFIED

3.... BYPASSING BUFFER

4.... CONNECTION {con|(con_syntax)}

Effect

Entries in source specify whether a database table or a view, or if many database tables or views are accessed by a join expression. Optional additions execute theclient handling, specify whether the SAP buffering is avoided, and determine the maximum number of rows to be read.

Confused? Feel free to ask

Your feedback is always appreciated.I will try to reply Ur queries as soon as time allows.
Regards,
SAPhelpdesk