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 44 People out of 46 think this lesson helpful


    Lesson Navigation

    Batch Data Communication← Previous Lesson
    Next Chapter →