List Open SQL Statements in SAP ABAP


List of open SQL statements which are used to modify database table records in SAP ABAP programming


OPEN SQL Statements are those statements which are used to update or modify database table data.

The open SQL statements are.

INSERT

Is used to insert data into a database table, data can be inserted into database table using two ways.

Insert record from internal table

Syntax: INSERT <DB TABLE> FROM TABLE <INTERNAL TABLE>.

Insert record from work area

Syntax: INSERT <DB TABLE> FROM <WA>.

UPDATE

Is used to update data in database table, data can be inserted into database table using two ways.

Update record from internal table

Syntax: UPDATE <DB TABLE> FROM TABLE <INTERNAL TABLE>.

Update record from work area

Syntax: UPDATE <DB TABLE> FROM <WA>.

MODIFY

Is used to modify data in database table, data can be inserted into database table using two ways.

Update record from internal table

Syntax: MODIFY <DB TABLE> FROM TABLE <INTERNAL TABLE>.

Update record from work area

Syntax: MODIFY <DB TABLE> FROM <WA>.

DELETE

Is used to delete data from database table, data can be inserted into database table using two ways.

Update record from internal table

Syntax: DELETE <DB TABLE> FROM TABLE <INTERNAL TABLE>.

Update record from work area

Syntax: DELETE <DB TABLE> FROM <WA>.

Learner Questions

No Questions by learners, be first one to ask ..!!

    Please Sign in to ask a question


    Was this lesson helpful to you? Yes No 48 People out of 50 think this lesson helpful

    Lesson Navigation

    Batch Data Communication← Previous Lesson
    Next Chapter →