SAP ERP ABAP Training course in Pakistan

What is ABAP? 

ABAP(Advanced Business Application Programming) is a general programming language made by SAP that causes huge enterprises to redo the SAP ERP. ABAP can help redo work processes for monetary book keeping, materials the executives, resource the board and any remaining modules of SAP.

Open SQL and Native SQL in SAP ABAP 

The objective of this instructional exercise isn't to show you SQL or information base ideas however to acquaint you with the SQL variety in ABAP.

In ABAP/4 programming language, there are two sorts of SQL being utilized. 

• NATIVE SQL 
• OPEN SQL.

Open SQL permits you to get to the information base tables announced in the ABAP word reference paying little heed to the data set stage that the R/3 framework is utilizing.

Native SQL permits you to utilize information base explicit SQL articulations in an ABAP/4 program. This implies that you can utilize data set tables that are not managed by ABAP word reference, and thusly coordinate information that isn't important for the R/3 framework.

Basic Open SQL Commands

• SELECT
• MODIFY
• DELETE
• INSERT
• UPDATE

Open SQL Return Codes 

All Open SQL articulations fill the accompanying two framework fields with bring codes back. 

SY-SUBRC 

After each Open SQL explanation, the framework field SY-SUBRC contains the worth 0 if the activity was fruitful, a worth other than 0 if not. 

SY-DBCNT 

After an Open SQL proclamation, the framework field SY-DBCNT contains the quantity of information base lines prepared.

Native SQL 

As of now referenced, Native SQL permits you to utilize data set explicit SQL proclamations in an ABAP program. To utilize Native SQL explanation, you should go before it with the EXEC SQL proclamation, and follow it with the ENDEXEC articulation.

Open SQL - Performance Rules 

To improve the exhibition of the SQL and thusly of the ABAP program, one should deal with the accompanying standards 

Keep the Result Set Small 

• Utilizing the where statement 
• In the event that just one record is needed from the data set, utilize SELECT SINGLE at whatever point conceivable . 

Limit the Amount of Data Transferred 

• Confine the quantity of lines 
• On the off chance that lone certain fields are needed from a table, utilize the SELECT <field1> <field2> INTO … proclamation 
• Limit no of sections 
• Utilize total capacities

Limit the Search Overhead 

• Use file fields in the where condition 

• While getting to information bases, consistently guarantee that the right record is being utilized . 

Lessen the Database Load 

• Buffering 
• Legitimate information bases 
• Stay away from rehashed information base access

 Internal Table 

Internal table are utilized to acquire information from a fixed construction for dynamic use in ABAP. Each line in the inward table has a similar field structure. The principle use for inward tables is for putting away and designing information from a data set table inside a program.

Work Area

Work Area are single lines of information. They ought to have similar arrangement as any of the interior tables. It is utilized to handle the information in an inner table each line in turn.

Sorts of Internal Tables 

There are two kinds of inside tables. 

• Inside tables with HEADER line 
• Inside tables without HEADER line. 

Interior Tables with Header Line 

• Here the framework naturally makes the work region. 
• The work region has a similar information type as inner table. 
• This work zone is known as the HEADER line. 
• It is here that every one of the progressions or any of the activity on the substance of the table are finished. Subsequently, records can be straightforwardly embedded into the table or gotten to from the interior table straightforwardly.

Interior Tables without Header Line : 

• Here there is no work region related with the table. 
• Work region is to be unequivocally determined when we need to access such tables. 
• Consequently these tables can't be gotten to straightforwardly.

SAP ABAP Table Control

Table controls and step circles are objects for screen table showcase that you add to a screen in the Screen Painter. From a programming viewpoint, table controls and step circles are by and large something very similar. Table controls are essentially improved advance circles that show information with the look and feel related with tables in work area applications.

With table controls, the client can: 

• Look through the table vertically and on a level plane 
• Re-size the width of a section 
• Look inside a field (when field substance are more extensive than the field) 
• Select table lines or segments 
• Re-request the grouping of segments 
• Save the current presentation settings for sometime later

ABAP Report Programming

SAP-ABAP upholds two sorts of Programs - Report Programs and Dialog Programs. Report Programs are utilized when a lot of information should be shown.

Why we use Report Programs

• They are utilized when information from various tables must be chosen and prepared prior to introducing 
• Utilized when reports request an extraordinary arrangement 
• Utilized when the report must be downloaded from SAP to an Excel sheet to be circulated across. 
• Utilized when the report must be sent to a specific individual

Call Subscreen in SAP ABAP

• A sub screen is an autonomous screen that is shown in a zone of another ("primary") screen. 

• Sub screens permit you to insert one screen inside another at runtime. You can remember different sub-evaluates for principle screen. 

• The term sub screen applies both to the screen that you insert, and the territory on the principle screen in which you place it. This instructional exercise is about sub screen zones. The genuine screens made through SE51 exchange, are called sub screen screens whenever characterized in screen credits. 

• At the point when you utilize a sub screen, the stream rationale of the implanted screen is additionally inserted in the stream rationale of the primary screen .Hence, Using sub screens on screens resembles utilizing remembers for ABAP programs.

To utilize a sub screen, you should follow three straightforward advances 

• Characterize the sub screen area(s) on a screen 

• Characterize reasonable sub screen screens 

• Incorporate the sub screen screen in the sub screen zone.

Process on Help-Request (POH) : F1 Help 

• At whatever point F1 is squeezed the POH occasion for the predetermined information component is executed. 

• On the off chance that the PROCESS ON HELP-REQUEST occasion doesn't exist in the process rationale of a screen, the documentation of the field in the ABAP Dictionary is taken as a premise and showed. Regardless of whether that doesn't leave no assistance is shown. 

• To show field help documentation, you should code the accompanying screen stream rationale in the POH occasion: 

Interaction ON HELP-REQUEST 

FIELD &lt;f&gt; [MODULE &lt;mod&gt;] WITH &lt;num&gt; 

• On the off chance that there is screen-explicit information component documentation for the field <f>, you can show it by determining its number <num>. 

• The number <num> can be a strict or a variable. The variable should be proclaimed and filled in the comparing ABAP program.

Process on Value (POV): F4 

• At the point when the client picks the capacity Possible passages (F4), the framework shows the conceivable info esteems for a field (values, check table, matchcode), if they were put away by the engineer. 

• The occasion PROCESS ON VALUE-REQUEST is constantly prepared if the client has called "Potential passages". 

• To characterize Possible qualities for a field on screen, you need to characterized continuing in POV occasion of screen stream rationale: 

Interaction ON VALUE-REQUEST 

Field name module name 

• For Possible qualities, inside module characterized above, you should utilize the overall capacity module HELP_VALUES_GET_WITH_TABLE to get potential qualities from ABAP Dictionary.

You can visit for more details. Regarding SAP ERP ABAP Training in Pakistan.

Try to visit the best SAP ERP Training Institute in Lahore Pakistan.