SAP ABAP

Lecture Details

SAP ABAP Training - Modifying Data In A Database Table Using Open SQL Statements - Insert

SAP Training - BEGINNERS GUIDE TO LEARNING SAP ABAP - Create Your First ABAP Program

The Insert Statement

The SELECT statement has already been used, so here it will be skipped for now to focus on the INSERT statement. In this example then, a new record will be inserted into the ZEMPLOYEES table. Firstly, type INSERT, followed by the table name, and then a period

Doing this, one must always type the table name, a variables name cannot be used in-stead. Use the check statement (IF) to include an SY-SUBRC check, telling the system to do if this does not equal 0

This is the simplest form of the INSERT statement, and not necessarily the one which is encouraged. Using this form is no longer standard practice, though one may come across it if working with older ABAP programs...


Videos in the series
Learn SAP ABAP - Video Playlist - httpwww.youtube.complaylist?list=PLyH9U1E43FYqVqAb0wUSpHlP0c3sq6Vwo

Websites and Profiles
SAP Training Courses httpwww.saptraininghq.com
SAP Academy Courses httpacademy.saptraininghq.com
SAP Training on Twitter httpstwitter.competermoxon
SAP Training on Google + httpsplus.google.comu0+PeteMoxon
STHQ on Linked-In httpuk.linkedin.cominpetermoxon
STHQ on YouTube httpwww.youtube.comuserpcmoxon

More SAP Resources
SAP site httpwww.sap.com
SAP community netwrok httpscn.sap.com
About SAP httpen.wikipedia.orgwikiSAP_AG
About ABAP httpen.wikipedia.orgwikiABAP

Various YouTube channels on SAP
SAP InnoJam httpswww.youtube.comchannelUCbkywtePppACE646Kw8wSUg
SAP on YouTube httpswww.youtube.comchannelUCVnIv2xF2wyMMCSKv1qF3pA
SAP TV on YouTube httpswww.youtube.comchannelUCy4kQ_03bhe5PQZVJvCkTKA
SAP SCN on YouTube httpswww.youtube.comchannelUC3We5qK8jkxH8yBc0SugKEQ