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  FROM TABLE .

Insert record from work area

Syntax: INSERT  FROM .

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  FROM TABLE .

Update record from work area

Syntax: UPDATE  FROM .

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  FROM TABLE .

Update record from work area

Syntax: MODIFY  FROM .

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  FROM TABLE .

Update record from work area

Syntax: DELETE  FROM .

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 32 People out of 34 think this lesson helpful


    Lesson Navigation

    Batch Data Communication← Previous Lesson
    Next Chapter →