ABAP (Advanced Business Application Programming) Is The Primary Programming Language Supported On The SAP Netweaver ABAP Application Server Platform And Applications That Run On It, Such As SAP ERP (formerly R/3), S/4 HANA and CRM.
1.What is the table, which contain the details of all the name of the programs and forms? What is an ABAP instance?
When you call a function module, an instance of its function group plus its data, is loaded into the memory area of theinternal session. An ABAP program can load several instances by calling function modules from different function groups.
2.What is the table, which contain the details of all the name of the programs and forms?
Table contains vertical and horizontal lines. We can store the data in table as blocks. We can scroll depends upon your wish.And these all are stored in database (data dictionary).
3.What is SAP R/3?
SAP R/3 refers to Systems Application and Product for data processing Real-time having a 3 tier architecture i.e.Presentation layer, Application layer and Database layer.
4.What are the contents in technical specifications?
There are five contents in Technical Settings: Data Class, Size Category, Buffering Permission, Buffering Type andLogging.
5.What is Function group? Difference between function group and function module?
Function Groups act as containers for Function Modules that logically belong together.Function Groups1) These cannot be defined in a Function Module.2) It cannot be called.3) They are containers for Function Module.Function Modules1) These must be defined in a Function Group.2) It can be called from any program.3) They are not containers for Function Group.
6.Difference between domain and data element? What are aggregate object?
Domain - Specifies the technical attributes of a data element - its data type, length, possible values, and appearance onthe screen. Each data element has an underlying domain. A single domain can be the basis for several data elements.Domains are objects in the ABAP Dictionary.
Data Element - Describes the business function of a table field. Its technical attributes are based on a domain, and itsbusiness function is described by its field labels and documentation.
Aggregate Object – Views, Match Code and Lock objects are called aggregate objects because they are formed fromseveral related table.
7.What is view? Different types of view. Explain?
View - A view is a virtual table containing fields from one or more tables. A virtual table that does not contain anydata, but instead provides an application-oriented view of one or more ABAP Dictionary tables.Different Types of View:1) Maintenance2) Database – It is on more than two tables.3) Projection – It is only on one table.4) Help
8.Can you print decimals in type N? What is difference between float and packed data type?
No, we cannot print decimals in type N because decimal places are not permitted with Ndata type.Float Data Type: It cannot be declared in Parameters.Packed Number: It can be declared in Parameters. For e.g.PARAMETERS : A(4) TYPE P DECIMALS 2,B(4) TYPE P DECIMALS 2.DATA : C(4) TYPE P DECIMALS 2.C = A + B.WRITE : / 'THE SUM IS' , C.
9.What are standard layouts sets in the SAP Script?
There are four standard layouts in the SAP Script:1) Header2) Logo3) Main Window4) FooterAnswer #2main window
10.What is step-loop? Explain all the steps?
A step loop is a repeated series of field-blocks in a screen. Each block can contain one or more fields, and can extend overmore than one line on the screen. Step loops as structures in a screen do not have individual names. The screen can containmore than one step-loop, but if so, you must program the LOOP...ENDLOOPs in the flow logic accordingly. The orderingof the LOOP...ENDLOOPs must exactly parallel the order of the step loops in the screen. The ordering tells the systemwhich loop processing to apply to which loop. Step loops in a screen are ordered primarily by screen row, and secondarilyby screen column. Transaction TZ61 (development class SDWA) implements a step loop version of the table you saw intransaction TZ60. Static and Dynamic Step LoopsStep loops fall into two classes: static and dynamic. Static step loops have a fixed size that cannot be changed at runtime.Dynamic step loops are variable in size. If the user re-sizes the window, the system automatically increases or decreases thenumber of step loop blocks displayed. In any given screen, you can define any number of static step loops, but only a singledynamic one.You specify the class for a step loop in the Screen Painter. Each loop in a screen has the attributes Looptype (fixed=static,variable=dynamic) and Loopcount. If a loop is fixed, the Loopcount tells the number of loop-blocks displayed for the loop.This number can never change. Programming with static and dynamic step loops is essentially the same. You can use boththe LOOP and LOOP AT statements for both types. Looping in a Step Loop When you use LOOP AT <internal-table> witha step loop, the system automatically displays the step loop with vertical scroll bars. The scroll bars, and the updated(scrolled) table display, are managed by the system.Use the following additional parameters if desired:* FROM <line1> and TO <line2>* CURSOR <scroll-var>
11.What are the different functions used in sap script? What are the parameters used in each Function?
There are three different functions used in SAP Script:1) OPEN_FORM2) WRITE_FORM3) CLOSE_FORMParameters in Each Function:1) OPEN_FORM–ExportingFormLanguage2) WRITE_FORM–ExportingElementWindow3) CLOSE_FORM
12.What is sequence of event triggered in report?
There are 6 events in report:1) Initialization2) At Selection-Screen3) Start-of-Selection4) Get5) Get Late6) End-of-Selection7) Top-of-Page8) End-of-Page9) At Line Selection10) At User Command11) At PF (nn)Answer #2a) Load-of-programb) Initializationc) At selection-screen outputd) At selection-screen on fielde) At selection-screen on value requestf) At selection-screen on help requestg) At selection screenh) Start-of-selectioni) End-of-selectionj) Top-of-pagek) End-of-page
13.What are the various types of selection screen event?
SELECTION-SCREEN BEGIN OF BLOCK ABC WITH FRAME TITLE T01.SELECTION-SCREEN BEGIN OF SCREEN 500 AS WINDOW.CALL SELECTION-SCREEN 500 STARTING AT 10 10.
14.What are the system fields? Explain?
The ABAP system fields are active in all ABAP programs. They are filled by the runtime environment, and you can querytheir values in a program to find out particular states of the system. Although they are variables, you should not assign yourown values to them, since this may overwrite information that is important for the normal running of the program. However,there are some isolated cases in which you may need to overwrite a system variable. For example, by assigning a new valueto the field SY-LSIND, you can control navigation within details lists.
15.What is SAP Script? What is the purpose of SAP Script? Difference between SAP Script and Report?
SAP Script – It is the integrated text management system of the SAP R/3 System. Two types – PC Editor & Line Editor.Reports - It is the way to display data fetched from database table onto screen or directly output it to a printer. Two types –Classical and Interactive.
16.Difference between SY-TABIX and SY-INDEX? Where it is used? Can you check SY-SUBRC after perform?
SY-TABIX - Current line of an internal table. SY-TABIX is set by the statements below, but only for index tables. The fieldis either not set or is set to 0 for hashed tables.* APPEND sets SY-TABIX to the index of the last line of the table, that is, it contains the overall number of entries in thetable.* COLLECT sets SY-TABIX to the index of the existing or inserted line in the table. If the table has the type HASHEDTABLE, SY-TABIX is set to 0.* LOOP AT sets SY-TABIX to the index of the current line at the beginning of each loop lass. At the end of the loop,SY-TABIX is reset to the value that it had before entering the loop. It is set to 0 if the table has the type HASHED TABLE.* READ TABLE sets SY-TABIX to the index of the table line read. If you use a binary search, and the system does not finda line, SY-TABIX contains the total number of lines, or one more than the total number of lines. SY-INDEX is undefined ifa linear search fails to return an entry.* SEARCH <itab> FOR sets SY-TABIX to the index of the table line in which the search string is found.SY_INDEX - In a DO or WHILE loop, SY-INDEX contains the number of loop passes including the current pass.
17.Explain What is a Logical Database?
Logical Databases are special ABAP programs that retrieve data and make it available to application programs.Use of LDB – is used to read data from database tables by linking them to executable ABAP programs
18.Explain What are the events used for Logical Database?
Two Events –1) GET - This is the most important event for executable programs that use a logical database. It occurs when the logical databasehas read a line from the node <table> and made it available to the program in the work area declared using the statement NODEStable Tag. The depth to which the logical database is read is determined by the GET statements2) PUT - The PUT statement directs the program flow according to the structure of the logical database.
19.What is the difference between Get and Get Late?
GET - After the logical database has read an entry from the node table Tag.GET LATE - After all of the nodes of the logical database have been processed that are below <table> in the database hierarchy.
20.What are the data types of Internal Tables?
There are three types:1) Line2) Key3) Table
21.What are the events used in ABAP in the order of execution?
I. INITIALIZATION2. AT SELECTION-SCREEN3. AT SELECTION-SCREEN ON <field>4. START-OF-SELECTION5. TOP-OF-PAGE6. TOP-OF-PAGE DURING LINE SELECTION7. END-OF-PAGE8. END-OF-SELECTION9. AT USER-COMMAND10. AT LINE-SELECTION11. AT PF<NN>12. GET13. GET LATE.14. AT User Command
22.Explain What are Interactive Reports?
An output list which displays just the basic details & allow user to interact, so that a new list is populated based onuser-selection. With interactive list, the user can actively control data retrieval and display during the session.
23.What are the commands used for interactive reports?
Top-of-Page during line-selection
24.What are the system fields you have worked with? Explain?
I had worked with the following (30) system fields:1) SY-DBSYS - Central Database2) SY-HOST - Server3) SY-OPSYS - Operating System4) SY-SAPRL - SAP Release5) SY-SYSID - System Name6) SY-LANGU - User Logon Language7) SY-MANDT - Client8) SY-UNAME - Logon User Name9) SY-DATLO - Local Date10) SY-DATUM - Server Date11) SY-TIMLO - Local Time12) SY-UZEIT - Server Time13) SY-DYNNR - Screen Number14) SY-REPID - Current ABAP program15) SY-TCODE - Transaction Code16) SY-ULINE - Horizontal Line17) SY-VLINE - Vertical Line18) SY-INDEX - Number of current loop Pass19) SY-TABIX - Current line of internal table20) SY-DBCNT - Number of table entries processed21) SY-SUBRC - Return Code22) SY-UCOMM - Function Code23) SY-LINCT - Page Length of list24) SY-LINNO - Current Line25) SY-PAGNO - Current Page Number26) SY-LSIND - Index of List27) SY-MSGID - Message Class28) SY-MSGNO - Message Number29) SY-MSGTY - Message Type30) SY-SPONO - Spool number during printing
25.What is the transaction code for Table maintenance?
SM30
26.Explain What is the difference between Primary key and Unique Key?
Primary Key – It can accepts 0 value and cannot be NULL.Unique Key – It can be NULL.
27.If you are using Logical Databases how will you modify the selection-screen elements?
Select-options : dname for deptt-dname
28.Explain What is an RFC?
Answer #1Remote Function CallAnswer #2RFC stand for Remote Function Callit is used to distribute the data between sap to sap and sap to non sap but not possible for VB
29.Explain What are the events in Screen Programming?
There are two events in Screen Programming:1. PBO (Process Before Output) – Before the screen is displayed, the PBO event is processed.2. PAI (Process After Input) – When the user interacts with the screen, the PAI event is processed.3. POH (Process On Help) - are triggered when the user requests field help (F1). You can program the appropriate coding inthe corresponding event blocks. At the end of processing, the system carries on processing the current screen.4. POV (Process On Value) - are triggered when the user requests possible values help (F4). You can program theappropriate coding in the corresponding event blocks. At the end of processing, the system carries on processing the currentscreen.
30.Explain What are the events in Screen Programming?
31.What is the significance of HIDE?
Its stores the click value and display the related record in the secondary list.
32.Where do u code the HIDE statement?
In a LOOP statement
33.Types of BDC s?
There are two types of BDC’s:1) Transaction Method2) Session Method
34.Advantages and Disadvantages of different types of BDC s?
Transaction Method:1) It is faster than session method.2) While executing, it starts from starting.Session Method:1) It is slower than transaction method.2) While executing, it does not start from starting.
35.What are the events used in Interactive Reports?
There are three events of Interactive Reports:I. At PF(nn)II. At line-selectionIII. At user-command
36.Explain What is an RDBMS?
RDBMS – Relational Database Management System. It helps to create relationshipbetween two or more table.
37.What are joins and different types joins?
There are four types of Joins:1) Self Join2) Inner Join3) Outer Join4) Equi Join
38.What will you code in START-OF-SELECTION & END-OF-SELECTON & why?
START-OF-SELECTIONSELECT * FROM DEPTT INTO CORRESPONDING FIELDS OF ITABWHERE DEPTNO IN DEPTNO.APPEND ITAB.ENDSELECT.LOOP AT ITAB.WRITE : / 10 ITAB-DEPTNO.HIDE : ITAB-DEPTNO.ENDLOOP.END-OF-SELECTIONAnswer #2I will code all the required select queries and related logics to get the desired output . between start of selection andend-of-d\\\\selection
39.How do u display a data in a Detail List?
By using two statements:1) Top-of-page during line-selection2) At line-selection
40.What are the types of windows in SAP Script?
Answer #1There are five Standard Layouts in SAP Script:1) Page2) Window3) Page Window4) Paragraph Format5) Character FormatAnswer #21. Main window2. Variable window3. Constant window
41.What are the function modules used in a SAP Script driver program?
There are three functions used in SAP Script:1) OPEN_FORM2) WRITE_FORM3) CLOSE_FORM
42.Explain What are Extracts?
Extracts are dynamic sequential datasets in which different lines can have different structures. We can access theindividual records in an extract dataset using a LOOP.
43.What is LUW?
Logical Unit of Work
44.How do u find out whether a file exits on the presentation server?
eps_get_directory_listing for directory
45.Different types of LUWs. What are they?
Two types of LUW are:
1) DB LUW - A database LUW is the mechanism used by the database to ensure that its data is always consistent. Adatabase LUW is an inseparable sequence of database operations that ends with a database commit. The databaseLUW is either fully executed by the database system or not at all. Once a database LUW has been successfullyexecuted, the database will be in a consistent state. If an error occurs within a database LUW, all of the databasechanges since the beginning of the database LUW are reversed. This leaves the database in the state it had before thetransaction started.
2) SAP LUW - A logical unit consisting of dialog steps, whose changes are written to the database in a singledatabase LUW is called an SAP LUW. Unlike a database LUW, an SAP LUW can span several dialog steps, and beexecuted using a series of different work processes.
46.Systems fields used for Interactive Lists AND Lists
Interactive System Fields: SY-LSIND, SY-CPAGE, SY-LILLI, SY-LISEL, SY-LISTI,SY-LSTAT, SY-STACO, SY-STAROLists: SY-COLNO, SY-LINCT, SY-LINNO, SY-LINSZ, SY-PAGNO,SY-TVAR0…..SY-TVAR9, SY-WTITL
47.Logo in SAP Script?
RSTXLDMC ORSteps for making and inserting Logo in SAP Script:First Procedure:1) Draw the picture2) Save it3) /nSE784) Write name & Choose Color5) Click on Import6) Browse picture7) EnterSecond Procedure1) /nSE712) Insert3) Graphics4) Click on stored on document server5) Execute6) Choose name of BMAP
48.What are the difference between call screen and leave screen?
Call Screen: Calling a single screen is a special case of embedding a screen sequence. If you want to prevent thecalled screen from covering the current screen completely, you can use the CALL SCREEN statement with theSTARTING AT and ENDING ATCALL SCREEN 1000.CALL SCREEN 1000 STARTING AT 10 10 ENDING AT 20 20.LEAVE SCREEN statement ends the current screen and calls the subsequent screen.LEAVE SCREEN.LEAVE TO SCREEN 2000.
49.If internal table used in for all entries in empty then what happens?
Answer #1No, records will be displayed.Answer #2It will fetch all the recordsAnswer #3all the entries will come from the second internal table, irrespective of the where condition.
50.If I forgot some command in SAP Script e.g.: suppress zero display - How to do find it?
Suppressing of entire screens is possible with this command. This command allows us to perform screen processing "in thebackground". Suppressing screens is useful when we are branching to list-mode from a transaction dialog step.
51.How to write a BDC - how do u go about it?
Steps for writing BDC1) /nSE382) Declare Tables, Data (for ITAB) and Data (for BDCITAB)3) Call function 'Upload'.4) Write code for the First Screen, Radio Button, Filename, Change Button, Second Screen, Utilities (Create Entries), ThirdScreen and Save.5) Call transaction 'SE11' using BDCITAB mode 'A'.6) Save, Check Errors, Activate and Execute.
52.How do u move on to the next screen in interactive reporting?
Write code of the following:1) Top-of-Page during line-selection2) At line-selection
53.Create any functions? How to go about it?
Steps for creating the Functions:First Procedure:1) /nSE372) Goto3) Function Group (FG)4) Create Group5) Name of FG (ZREKHA_FG)6) Short Text7) Save8) Local ObjectSecond Procedure1) Environment2) Inactive Object3) Function Group (ZREKHA_FG)4) Activate5) BackThird Procedure1) Name of Function Module (ZREKHA_FM)2) Create3) Write FG Name (ZREKHA_FG)4) Short Text5) SaveFourth Step:Call function 'ZREKHA_FM'.
54.Function modules used in F4 help?
There are two types of function modules used in F4 help:1) F4IF_FIELD_VALUE_REQUEST2) F4IF_INT_TABLE_VALUE_REQUEST
55.Work most on which module: Name a few tables
Sales & Distribution Module1) Sales Document: Item Data – VBAP2) Sales Document: Partner – VBPA3) Sales Document: Header Data – VBAK4) Sales Document Flow – VBFA5) Sales Document: Delivery Item Data - LIPS6) Customer Master – KNA17) Material Data – MARA8) Conditions (Transaction Data) - KONV
56.System Table used in ABAP?
1)Sales Document: Item Data – VBAP2) Sales Document: Partner – VBPA3) Sales Document: Header Data – VBAK4) Sales Document Flow – VBFA5) Sales Document: Delivery Item Data - LIPS6) Customer Master – KNA17) Material Data – MARA8) Conditions (Transaction Data) - KONV
57.What is read line in ABAP?
READ LINE and READ CURRENT LINE – These statements are used to read data from the lines of existing listlevels. These statements are closely connected to the HIDE technique.
58.Can there be more than 1 main window in SAP Script?
Answer #1No, there cannot be more than 1 main window in SAP Script because in WRITE_FORM, it asks for the parameter Windowthat will create the problem.WRITE_FORM–ExportingElementWindowAnswer #2Yes, we can have more than one main window(0 to 99) in sap scripts. but we can not call more than one window at a time,one by one we can call.
59.What are differences between At selection-screen and At selection-screen output?
AT SELECTION-SCREEN event is triggered in the PAI of the selection screen once the ABAP runtime environment haspassed all of the input data from the selection screen to the ABAP program.AT SELECTION-SCREEN OUTPUT - This event block allows you to modify the selection screen directly before it isdisplayed.
60.What are the differences between SAP memory and ABAP memory?
ABAP Memory is a memory area in the internal session (roll area) of an ABAP program. Data within this area is retainedwithin a sequence of program calls, allowing you to pass data between programs that call one another. It is also possible topass data between sessions using SAP Memory.SAP Memory is a memory area to which all sessions within a SAPgui have access. You can use SAP memory either to passdata from one program to another within a session (as with ABAP memory) or to pass data from one session to another.
61.What are the differences between SAP memory and ABAP memory?
62.What is the inside concept in select-options?
Select-options specify are displayed on the selection screen for the user to enter values.Different Properties of Select-options:1) Visible Length2) Matchcode Object3) Memory ID4) Lowercase5) Obligatory6) No Display7) Modify ID
63.What is get cursor field?
GET CURSOR statement transfers the name of the screen element on which the cursor is positioned during a useraction into the variable <f>.GET CURSOR FIELD <f> [OFFSET <off>] [LINE <lin>] [VALUE <val>] LENGTH <len>].
64.What is the difference between Free and Refresh?
Free - You can use FREE to initialize an internal table and release its memory space without first using theREFRESH or CLEAR statement. Like REFRESH, FREE works on the table body, not on the table work area. After aFREE statement, you can address the internal table again. It still occupies the amount of memory required for itsheader (currently 256 bytes). When you refill the table, the system has to allocate new memory space to the lines.Refresh - This always applies to the body of the table. As with the CLEAR statement, the memory used by the tablebefore you initialized it remains allocated. To release the memory space, use the statement
65.65) Can we have more than one selection-screen and how?
Yes, we can have more than one selection screen.Selection-screen begin of block honey with frame title text-101.Select-options : deptno for zrekha_deptt-deptno.Selection-screen end of block honey.Selection-screen begin of block honey1 with frame title text-102.Select-options : dname for zrekha_deptt-dname.Selection-screen end of block honey1.
66.How to declare select-option as a parameter?
Answer #1SELECT-OPTIONS: specify are displayed on the selection screen for the user to enter values.Parameters: dname like dept-dname.Select-options: dname for dept-dname.Answer #2By using no-intervals and no-extension , we can make select-option as a parameter.Select-option :s_kunnr for kna1-kunnr no-intervals no-extension.
67.How can u write pro-grammatically value help to a field without using search help and match codes?
By using two types of function modules to be called in SAP Script:1) HELP_OBJECT_SHOW_FOR_FIELD2) HELP_OBJECT_SHOW
68.What are the differences between SE01, SE09 and SE10?
SE01 - Correction & Transport OrganizerSE09 - Workbench OrganizerSE10 - Customizing Organizer
69.What is the use of Table maintenance allowed?
Mark the Table maintenance allowed flag if users with the corresponding authorization may change the data in thetable using the Data Browser (Transaction SE16). If the data in the table should only be maintained with programs orwith the table view maintenance transaction (Transaction SM30), you should not set the flag.
70.How to define Selection Screen?
Parameters, Select-options & Selection-Screen
71.What are the check tables and value tables?
Check Table: The ABAP Dictionary allows you to define relationships between tables using foreign keys . Adependent table is called a foreign key table, and the referenced table is called the check table. Each key field of thecheck table corresponds to a field in the foreign key table. These fields are called foreign key fields. One of theforeign key fields is designated as the check field for checking the validity of values. The key fields of the check tablecan serve as input help for the check field.Value Table: Prior to Release 4.0, it was possible to use the value table of a domain to provide input help. This is nolonger possible, primarily because unexpected results could occur if the value table had more than one key field. Itwas not possible to restrict the other key fields, which meant that the environment of the field was not considered, asis normal with check tables.In cases where this kind of value help was appropriate, you can reconstruct it by creating a search help for the dataelements that use the domain in question, and using the value table as the selection method.Check table will be at field level checking.Value table will be at domain level checking ex: scarr table is check table for carrid.
72.What is the difference between tables and structures?
Tables:1) Data is permanently stored in tables in the database.2) Database tables are generated from them.Structure:1) It contains data temporarily during program run-time.2) No Database tables are generated from it.
73.Explain What are lock objects?
Reason for Setting Lock: Suppose a travel agent want to book a flight. The customer wants to fly to a particular citywith a certain airline on a certain day. The booking must only be possible if there are still free places on the flight. Toavoid the possibility of overbooking, the database entry corresponding to the flight must be locked against accessfrom other transactions. This ensures that one user can find out the number of free places, make the booking, andchange the number of free places without the data being changed in the meantime by another transaction.
74.What are the events we use in dialog programming and explain them?
There are two events in Dialog Programming i.e. screen:1. PBO (Process Before Output) – Before the screen is displayed, the PBO event is processed.2. PAI (Process After Input) – When the user interacts with the screen, the PAI event is processed.3. POH (Process On Help) - are triggered when the user requests field help (F1). You can program the appropriatecoding in the corresponding event blocks. At the end of processing, the system carries on processing the currentscreen.4. POV (Process On Value) - are triggered when the user requests possible values help (F4). You can program theappropriate coding in the corresponding event blocks. At the end of processing, the system carries on processing thecurrent screen.
75.What are the page windows? How many main windows will be there in a page window?
Page Window: In this window, we define the margins for left, width, upper and height for the layout of Header, Logo,Main, & Footer.
76.How to debug a script in ABAP?
Go to SE71, give layout set name, go to utilities select debugger mode on.
77.What is the difference between OPEN_FORM and CLOSE_FORM?
OPEN_FORM – This module opens layout set printing. This function must be called up before we can work withother layout set function like WRITE_FORM.WRITE_FORM – Output text element in form window. The specified element of the layout set window entered isoutput. The element must be defined in the layout set.CLOSE_FORM – End layout set printing. Form printing started with OPEN_FORM is completed. Possible closingoperations on the form last opened are carried out. Form printing must be completed by this function module. If this isnot carried out, nothing is printed or displayed on the screen.
78.How many maximum sessions can be open in SAPgui?
There are maximum 6 sessions open in SAPgui.
79.What are System Variable in ABAP?
System variables have been predefined by SAP. We can use these variables in formulas or, for example, to pass oncertain pieces of information to a function module. How the function called by the function module behaves dependson the type of information passed on.
80.What is the difference between sum and collect?
Sum: You can only use this statement within a LOOP. If you use SUM in an AT - ENDAT block, the system calculates totals forthe numeric fields of all lines in the current line group and writes them to the corresponding fields in the work area. If you use theSUM statement outside an AT - ENDAT block (single entry processing), the system calculates totals for the numeric fields of alllines of the internal table in each loop pass and writes them to the corresponding fields of the work area. It therefore only makessense to use the SUM statement in AT...ENDAT blocks.If the table contains a nested table, you cannot use the SUM statement. Neither can you use it if you are using a field symbolinstead of a work area in the LOOP statement.
81.What is the typical structure of an ABAP program?
HEADER, BODY, FOOTER.
82.What is the alternative to batch input session?
Call Transaction Method & Call Dialog
83.A situation: An ABAP program creates a batch input session. We need to submit the program and the batch session in background. How to do it?
Go to SM36 and create background job by giving job name, job class and job steps(JOB SCHEDULING)
84.What are field symbols and field groups? Have you used component idx of structure clause with field groups?
Field Symbols – They are placeholder or symbolic names for the other fields. They do not physically reserve space for a field, butpoint to its contents. It can point to any data objects.Field-symbols <fs>Field Groups – Field groups does not reserve storage space but contains pointers to existing fields.An extract dataset consists of a sequence of records. These records may have different structures. All records with the samestructure form a record type. You must define each record type of an extract dataset as a field group, using the FIELD-GROUPSstatement.Field-groups <fg>
85.What is a batch input session?
BATCH INPUT SESSION is an intermediate step between internal table and database table. Data along with the action is stored insession i.e. data for screen fields, to which screen it is passed, program name behind it, and how next screen is processed.Create session – BDC_OPEN_GROUPInsert batch input – BDC_INSERTClose session – BDC_CLOSE_GROUP
86.What is the difference between a pool table and a transparent table and how they are stored at the database level?
Pool Table -1) Many to One Relationship.2) Table in the Dictionary has the different name, different number of fields, and the fields have the different name as in the R3Table definition.3) It can hold only pooled tables.Transparent Table –1) One to One relationship.2) Table in the Dictionary has the same name, same number of fields, and the fields have the same name as in the R3 Tabledefinition.3) It can hold Application data.
87.What are the problems in processing batch input sessions? How is batch input process different from processing on line?
Two Problems: -1) If the user forgets to opt for keep session then the session will be automatically removed from the session queue (log remains).However, if session is processed we may delete it manually.2) If session processing fails, data will not be transferred to SAP database table.
88.Is Session Method, Asynchronous or Synchronous?
Synchronous
89.What are the different types of data dictionary objects?
Different types of data dictionary objects:1) Tables2) Views3) Data elements4) Structure5) Domains6) Search Helps7) Local Objects8) Matchcode
90.Can a transparent table exist in data dictionary but not in the database physically?
No, Transparent table do exist with the same structure both in the dictionary as well as in the database, exactly withthe same data and fields.
91.How many types of tables exist and what are they in data dictionary?
4 Types of Tables:1. Transparent tables - Exists with the same structure both in dictionary as well as in database exactly with the samedata and fields. Both Open SQL and Native SQL can be used.2. Pool tables3. Cluster tables - These are logical tables that are arranged as records of transparent tables. One cannot use NativeSQL on these tables (only Open SQL). They are not manageable directly using database system tools.4. Internal tables
92.What is the step-by-step process to create a table in data dictionary?
Steps to create a table:Step 1: creating domains (data type, field length, Range).Step 2: creating data elements (properties and type for a table field).Step 3: creating tables (SE11).
93.In SAP Scripts, how will u link FORM with the Event Driven?
In PAI, define function code and write code for the same.
94.Can you create a table with fields not referring to data elements?
YES. e.g.:- ITAB LIKE SPFLI.Here we are refering to a data object (SPFLI) not data element.
95.What is the advantage of structures? How do you use them in the ABAP programs?
GLOBAL EXISTANCE (these could be used by any other program without creating it again).
96.What is a collect statement? How is it different from append?
Collect : If an entry with the same key already exists, the COLLECT statement does not append a new line, but addsthe contents of the numeric fields in the work area to the contents of the numeric fields in the existing entry.Append – Duplicate entries occurs
97.What does an extract statement do in the ABAP program?
Once you have declared the possible record types as field groups and defined their structure, you can fill the extractdataset using the following statements:EXTRACT <FG>.When the first EXTRACT statement occurs in a program, the system creates the extract dataset and adds the firstextract record to it. In each subsequent EXTRACT statement, the new extract record is added to the datasetEXTRACT HEADER.When you extract the data, the record is filled with the current values of the corresponding fields.As soon as the system has processed the first EXTRACT statement for a field group <FG>, the structure of thecorresponding extract record in the extract dataset is fixed. You can no longer insert new fields into the field groups<FG> and HEADER. If you try to modify one of the field groups afterwards and use it in another EXTRACTstatement, a runtime error occurs.By processing EXTRACT statements several times using different field groups, you fill the extract dataset withrecords of different length and structure. Since you can modify field groups dynamically up to their first usage in anEXTRACT statement, extract datasets provide the advantage that you need not determine the structure at thebeginning of the program.
98.What is OPEN SQL vs NATIVE SQL?
Open SQL – These statements are a subset of standard SQL. It consists of DML command (Select, Insert, Update, Delete).It can simplify and speed up database access. Buffering is partly stored in the working memory and shared memory. Data inbuffer is not always up-to-date.Native SQL – They are loosely integrated into ABAP. It allows access to all functions containing programming interface.They are not checked and converted. They are sent directly to the database system. Programs that use Native SQL arespecific to the database system for which they were written. For e.g. to create or change table definition in the ABAP.
99.What does an EXEC SQL stmt do in ABAP? What is the disadvantage of using it?
To use a Native SQL statement, you must precede it with the EXEC SQL statement, and follow it with the ENDEXECstatement as follows:EXEC SQL [PERFORMING <form>].<Native SQL statement>ENDEXEC.There is no period after Native SQL statements. Furthermore, using inverted commas (") or an asterisk (*) at the beginningof a line in a native SQL statement does not introduce a comment as it would in normal ABAP syntax. You need to knowwhether table and field names are case-sensitive in your chosen database.
100.What is the meaning of ABAP editor integrated with ABAP data dictionary?
ABAP Editor: Tool in the ABAP Workbench in which you enter the source code of ABAP programs and check theirsyntax. You can also navigate from the ABAP Editor to the other tools in the ABAP Workbench.
101.What are the events in ABAP language?
The events are as follows:1. Initialization2. At selection-screen3. Start-of-selection4. End-of-selection5. Top-of-page6. End-of-page7. At line-selection8. At user-command9. At PF10. Get11. At New12. At LAST13. AT END14. AT FIRST
102.What is an interactive report? What is the obvious difference of such report compared with classical type reports?
An Interactive report is a dynamic drill down report that produces the list on users choice.Difference: -a) The list produced by classical report doesn't allow user to interact with the system where as the list produced byinteractive report allows the user to interact with the system.B) Once a classical report, executed user looses control where as Interactive, user has control.C) In classical report, drilling is not possible where as in interactive, drilling is possible.
103.What is a drill down report?
Its an Interactive report where in the user can get more relevant data by selecting explicitly.
104.How do you write a function module in SAP? Describe?
1. Called program - SE37 - Creating function group, function module by assigning attributes, importing, exporting, tables,and exceptions.2. Calling program - SE38 - In program, click pattern and write function name- provide export, import, tables, exceptionvalues.
105.What are the exceptions in function module?
Exceptions: Our function module needs an exception that it can trigger if there are no entries in table SPFLI that meet theselection criterion. The exception NOT_FOUND serves this function.COMMUNICATION_FAILURE & SYSTEM_FAILURE
106.How are the date and time field values stored in SAP?
DD.MM.YYYY. HH:MM:SS
107.Name a few data dictionary objects?
Different types of data dictionary objects:1) Tables2) Views3) Data elements4) Structure5) Matchcode6) Domains7) Search Helps8) Local Objects
108.What happens when a table is activated in DD?
When the table is activated, a physical table definition is created in the database for the table definition stored in the ABAPdictionary. The table definition is translated from the ABAP dictionary of the particular database. It is available for anyinsertion, modification and updation of records by any user.
109.What are matchcodes? Describe?
It is similar to table index that gives list of possible values for either primary keys or non-primary keys
110.What are ranges? What are number ranges?
Main function of ranges to pass data to the actual selection tables without displaying the selection screen.Min, Max values provided in selection screens.It is often necessary to directly access individual records in a data structure. This is done using unique keys. Number rangesare used to assign numbers to individual database records for a commercial object, to complete the key. Such numbers aree.g. order numbers or material master numbers.
111.Are programs client dependent?
Yes, group of users can access these programs with a client number.
112.What is CTS and what do you know about it?
CTS stands for Correction and Transport System. The CTS provides a range of functions that help you to choose a transportstrategy optimally suited to your requirements. We recommend that you follow the transport strategy while you plan and setup your system landscape.Correction and Transport System (CTS) is a tool that helps you to organize development projects in the ABAP Workbenchand in Customizing, and then transport the changes between the SAP Systems and clients in your system landscape. Thisdocumentation provides you with an overview of how to manage changes with the CTS and essential information on settingup your system and client landscape and deciding on a transport strategy. Read and follow this documentation whenplanning your development project. For practical information on working with the Correction and Transport System, seeCorrection and Transport Organizer and Transport Management System.
113.What is the client concept in SAP? What is the meaning of client independent?
In commercial, organizational and technical terms, the client is a self-contained unit in the R3 system, with separate set ofMaster data and its own set of Tables. When a change is made in one client all other clients are affected in the system - thistype of objects are called Client independent objects.
114.Name a few system global variables you can use in ABAP programs?
SY-SUBRC, SY-DBCNT, SY-LILLI, SY-DATUM, SY-UZEIT, SY-UCOMM,SY-TABIX.....
115.What are internal tables? How do you get the number of lines in an internal table? How to use a specific number occurs statement?
1)It is a standard data type object, which exists only during the runtime of the program. They are used to performtable calculations on subsets of database tables and for re-organizing the contents of database tables according tousers need.2) Using SY-DBCNT.3) The number of memory allocations the system need to allocate for the next record population.
116.How do you take care of performance issues in your ABAP programs?
Performance of ABAP programs can be improved by minimizing the amount of data to be transferred. The data setmust be transferred through the network to the applications, so reducing the amount of time and also reduces thenetwork traffic.Some measures that can be taken are:- Use views defined in the ABAP/4 DDIC (also has the advantage of better reusability).- Use field list (SELECT clause) rather than SELECT *.- Range tables should be avoided (IN operator)- Avoid nested SELECTS.
117.What are datasets in ABAP?
The sequential files (ON APPLICATION SERVER) are called datasets. They are used for file handling in SAP.
118.How to find the return code of an stmt in ABAP programs?
Open SQL has 2 system fields with return codes:1) SY-SUBRC2) SY-DBCNTUsing function modules
119.What are Conversion & Interface programs in SAP?
CONVERSION: Legacy system to flat file.INTERFACE: Flat file to SAP system.
120.What specific statements do you using when writing a drill down report?
AT LINE-SELECTIONAT USER-COMMANDAT PF.
121.Have you used SAP supplied programs to load master data?
SAP supplied BDC programsRM06BBI0 (Purchase Requisitions)RMDATIND (Material Master)RFBIKR00 (Vendor Masters)RFBIDE00 (Customer Master)RVINVB00 (Sales Order)
122.What are the advantages and disadvantages of ABAP query tool?
Advantages: No programming knowledge is required.Disadvantages: Depending on the complexity of the database tables, it may not be easy for the user to select the necessarydata correctly.
123.Is a logical database a requirement/must to write an ABAP query?
No, it is not must to use LDB. Apart from it, we have other options:1) Table join by Basis Table2) Direct Read of table3) Data Retrieval by Program
124.What are the functional areas? User groups? How does ABAP query work in relation to these?
Functional Areas - By creating functional areas, we can initially select this data. This ensures that the data ispresented to the ABAP Query user in a meaningful way to accomplish the task, and that only the data that the usermay use is presented.User Groups – A user group is a collection of users that work with about the same data and carry out similar tasks.The members of a user group can use all programs (queries) created by any user of the group. Changes to such aprogram are at once visible to all users. This ensures that all members of a user group use the same evaluationprograms.ABAP Query: It consists of three components – queries, functional areas and user groups. The functional areasprovide the user with an initial set of data in accordance with the task to be accomplished. All users must be membersof at least one user group. All members of one user group can access the same data as well as the same program(queries) to create lists.
125.What are logical databases? What are the advantages/disadvantages of logical databases?
To read data from a database tables we use logical database.A logical database provides read-only access to a group of related tables to an ABAP/4 program.Advantages: - The programmer need not worry about the primary key for each table. Because Logical database knows how thedifferent tables relate to each other, and can issue the SELECT command with proper where clause to retrieve the data.1) An easy-to-use standard user interface.2) Check functions, which check that user input is complete, correct, and plausible.3) Meaningful data selection.4) Central authorization checks for database accesses.5) Good read access performance while retaining the hierarchical data view determined by the application logic.6) No need of programming for retrieval, meaning for data selectionDisadvantages: -1) If you do not specify a logical database in the program attributes, the GET events never occur.2) There is no ENDGET command, so the code block associated with an event ends with the next event statement (such as anotherGET or an END-OF-SELECTION).3) Fast in case of lesser no. of tables But if the table is in the lowest level of hierarchy, all upper level tables should be read soperformance is slower.
126.What is the structure of a BDC sessions.?
BDCDATA
127.What do you do when the system crashes in the middle of a BDC batch session?
We will look into the error log file (SM35). Check number of records already updated and delete them from input file andrun BDC again.
128.What do you do with errors in BDC batch sessions?
We look into the list of incorrect session and process it again. To correct incorrect session, we analyze the session todetermine which screen and value produced the error. For small errors in data we correct them interactively otherwisemodify batch input program that has generated the session or many times even the data file.
129.How do you set up background jobs in SAP? What are the steps? What are the events driven batch jobs?
Go to SM36 and create background job by giving job name, job class and job steps
130.Does SAP handle multiple currencies? Multiple languages?
Yes.
131.What is SAP Script and layout set?
The tool, which is used to create layout set is called SAP Script. Layout set is a design, appearance and structure ofdocument.
132.What are the ABAP commands that link to a layout set?
Control Commands, System Commands
133.What is the syntax of Packed Number?
Data : NUM type P decimals 2.
134.What are different types of attributes of Function Module?
There are 6 attributes of FM:1. Import2. Export3. Table4. Changing5. Source6. Exception
135.List of Screen elements?
There are 13 screen elements:i. Input / output fieldsii. Text fieldsiii. Checkboxiv. Radio buttonv. Push Buttonvi. Drop down listvii. Subscreenviii. Table controlix. Tabstrip controlx. Custom controlxi. Boxxii. Status iconsxiii. OK_CODE fields
136.How many default Tab Strips are there? How to insert more Tabs in it?
There 2 default Tab strips. Screen painter attributes contain Tab Title, which is used toinsert more tabs in tab strip.
137.What are the properties of Selection Screen?
There are 11 properties of selection screen:1) Default2) Memory ID3) Lowercase4) Visible length5) Obligatory6) Matchcode7) Check8) Checkbox9) Radiobutton Group10) No-display11) Modif ID
138.What are the components of Selection Table?
There are four components of selection table:Low, High, Sign, Options
139.How to display or know if the value entered contains records or not?
SY-SUBRC
140.What are the sequences of event block?
i. Reportsii. Nodesiii. Dataiv. Initializationv. At selection-screenvi. Start-of-selectionvii. Get depttviii. Get empix. Get deptt latex. End-of-selectionxi. Formxii. Endform
141.What are types of Select statements?
SELECT SINGLE <cols> ... WHERE ...SELECT [DISTINCT] <cols> ... WHERE ...SELECT <lines> * ...
142.What are DML commands in ABAP?
Select,Insert,Delete,Modify,Update
143.What is Asynchronous and Synchronous Update?
Asynchronous Update – The program does not wait for the work process to finish the update. Commit Work.Synchronous Update – The program wait for the work process to finish the update.Commit Work and Wait.
144.Write syntax for Message Error (Report)?
AT SELECTION-SCREEN.SELECT * FROM ZREKHA_DEPTT INTO CORRESPONDING FIELDS OF ITABWHERE DEPTNO IN DEPTNO.ENDSELECT.If SY-DBCNT = 0.MESSAGE E000 WITH ‘NO RECORDS FOUND’.ENDIF.
145.What are the function module in BDC?
There are three function module in BDC:1) BDC_OPEN_GROUP2) BDC_INSERT3) BDC_CLOSE_GROUP
146.Write the steps to execute session method?
Steps for execution Session Method:1) System2) Service3) Batch Input4) Session5) Choose Session Name6) Process7) Asks for Mode (Display All Screen, Display Errors & Background)8) Process
147.what are the different types of mode (run code) in Call Transaction method?
There are three modes in Call Transaction:A – Displays All ScreenE – Display ErrorsN – Background Processing
148.What are different types of screen keywords?
There are four types of screen keywords: Module, Loop, Chain and Field.
149.Write special commands of List?
There are four specials commands of lists: Write, Uline, Skip and New-Page
150.How data is stored in cluster table?
Each field of cluster table behaves as tables, which contains the number of entries.
151.What are client dependant objects in ABAP / SAP?
SAP Script layout, text element, and some DDIC objects.
152.On which event we can validate the input fields in module programs?
In PAI (Write field statement on field you want to validate, if you want to validate group of fields put in chain and Endchain statement.)
153.In selection screen, I have three fields, plant material number and material group. If I input plant how do I get the material number and material group based on plant dynamically?
AT SELECTION-SCREEN ON VALUE-REQUEST FOR MATERIAL.CALL FUNCTION 'F4IF_INT_TABLE_VALUE_REQUEST'to get material and material group for the plant.
154.How do you get output from IDOC?
Data in IDOC is stored in segments; the output from IDOC is obtained by reading the data stored in its respective segments.
155.When top of the page event is triggered?
After executing first write statement in start-of-selection event.
156.Can we create field without data element and how?
In SE11, one option is available above the fields strip i.e. Data element / direct type.
157.Which transaction code can I used to analyze the performance of ABAP program?
Transaction Code AL21.
158.How can I copy a standard table to make my own Z_TABLE?
Go to transaction SE11. Then there is one option to copy table. Press that button. Enter the name of the standard table and inthe Target table enter Z_table name and press enter.
159.What is runtime analysis? Have you used this?
It checks program execution time in microseconds. When you go to SE30. If you give desired program name inperformance file. It will take you to below screen. You can get how much fast is your program.
160.Among the Call Transaction and Session Method, which is faster?
Call transaction is faster then session method. But usually we use session method in real time...because we can transferlarge amount of data from internal table to database and if any errors in a session, then process will not complete untilsession get correct.
161.What are the difference between Interactive and Drill Down Reports?
ABAP/4 provides some interactive events on lists such as AT LINE-SELECTION (double click) or ATUSER-COMMAND (pressing a button). You can use these events to move through layers of information aboutindividual items in a list.Drill down report is nothing but interactive report...drilldown means above paragraph only.
162.What is the table, which contain the details of all the name of the programs and forms?
Table contains vertical and horizontal lines. We can store the data in table as blocks. We can scroll depends uponyour wish. And these all are stored in database (data dictionary).