The objective of this instructional exercise isn't to show you SQL or data set ideas yet to acquaint you with the SQL variety in ABAPIn ABAP/4 programming language, two kinds of SQL are being utilized.Open SQL permits you to get to the data set tables announced in the ABAP word reference no matter what the data set stage that the R/3 framework is utilizing.Local SQL permits you to involve data set explicit SQL proclamations in an ABAP/4 program. This implies that you can utilize data set tables that are not directed by ABAP word reference, and consequently incorporate information that isn't essential for the R/3 framework.Open SQL comprises of a bunch of ABAP proclamations that perform procedure on the focal data set in the R/3 framework. The aftereffects of the activities and any blunder messages are autonomous of the data set framework being used. Open SQL in this manner gives a uniform punctuation and semantics for all of the data set frameworks upheld by SAP. ABAP programs that main utilize Open SQL articulations will work in any R/3 framework, no matter what the data set framework being used. Open SQL proclamations can work with data set tables that have been made in the ABAP word reference.
Fundamental Open SQL Commands
OPEN CURSOR, FETCH, CLOSE CURSOROpen SQL Return Codes
All Open SQL explanations fill the accompanying two framework fields with bring codes back.After each Open SQL proclamation, the framework field SY-SUBRC contains the worth 0 on the off chance that the activity was fruitful, a worth other than 0 if not.SY-DBCNTAfter an Open SQL explanation, the framework field SY-DBCNT contains the quantity of data set lines handled.Local SQ.As currently referenced, Native SQL permits you to involve data set explicit SQL articulations in an ABAP program.To utilize Native SQL explanation, you should go before it with the EXEC SQL articulation, and follow it with the ENDEXEC proclamation.