IBM abap interview Questions phase - e

How is data passed to a function module? Ans :- Using the EXPORTING clause.

What are exceptions? Ans :- The EXCEPTIONS parameter is a section in the CALL FUNCTION statement where exceptional situations can be processed.

How are they called and handled in the code? CALL FUNCTION ‘function name’ EXPORTING… IMPORTING… EXCEPTIONS NOT_FOUND = 3D1 NOT_VALID = 3D2 OTHERS = 3D3 CASE SY-SUBRC WHEN 1 WHEN 2

How can internal tables be passed to forms and function modules? Ans :- Internal tables are passed by reference in function modules and forms. (For PERFORM –FORM statements use the TABLES parameter.)Valid for old version only.

What is global Vs local data? Ans :- Local data – data relevant only within a subroutine Global data – data relevant within the entire program.

What is ABAP workbench? Ans :- Integrated graphical development environment of the R/3 System. The ABAP Workbench allows you to develop, maintain, and manage client/ server applications written in ABAP. You can use the tools of the ABAP Workbench to: · Write ABAP code · Design screens · Create user interfaces · Test applications for efficiency · Check applications for errors · Use predefined functions · Access development objects · Access database information

What are three the three categories of DATA in the SAP Ans :- · Master Data – changes relatively rarely · Transaction Data – kept for only a limited time in the system together with any associated index tables. · System-specific Data – data, texts, ABAP/4 programs and so on.

What are the table types in SAP? Ans :- Three types :- · Transparent table :- In DDIC has one-to-one relationship with a table in the database. For each TT definition in the dictionary, there is one associated table in database with same no. of fields. · Pooled table :- In R/3 has many-to-one relationship in the database. The table in database has a different name and fields than the tables in DDIC. · Cluster table :- A cluster is similar to table pool. It holds tables within it. Table clusters contain fewer tables than table pools and unlike table pools, the primary key of each table within the table cluster begins with the same field or fields. Cluster table are combined into a single row in the table cluster based on primary key.

What event is executed when START OF SELECTION event exits? Ans :- The statement END-OF-SELECTION is executed. This is different from STOP statement, which terminates report processing all together .

How is the GET LATE command utilized? Ans : - It occurs when all subordinate segments have been processed and before the system requests the next table entry of the same table (hierarchy)

How do you use the STOP command? Ans :- The STOP is specified within the processing block END-OF-SELECTION, report processing is terminated immediately and the list is displayed.

Explain the select-options statement. Ans :- It generates a line on the selection screen, the first part of which contains a text, followed by a range for the input possibilities. Parameter name specified in select options defines as Internal table with same name having structure(seltab) as follows :- Sign,option,low,high. Syntex - SELECT-OPTIONS FOR .

What is the syntax to declare default values? Ans : - SELECT-OPTIONS Variable_name FOR table_ element DEFAULT ‘range’ TO ‘range’

Does SELECT statement perform an authorization check? Ans :- SELECT statement does not carry out any authorization checks.

Why is it important to know this? Ans :- To remind the programmer that he/she should do this checks.

What are the attributes associated with SAPSQL? Ans :- SAP-SQL has the following attributes: 1) SAP-SQL syntax corresponds to that of standard SQL’s 2) SAP-SQL is a subset of standard SQL 3) SAP-SQL contains SAP short forms.

The most important thing to remember about the SELECT SINGLE is? There are several things to remember: 1) It retrieves only one row 2) It does not need an ENDSELECT statement 3) THE FULL KEY OF THE TABLE MUST BE INCLUDED IN THE WHERE CLAUSE OF THE SELECT STATEMENT

How do the BETWEEN, LIKE and IN comparisons work? Ans :- BETWEEN AND is inclusive LIKE - string and character wild characters IN ( , , ……. ,)

Can Meta Characters be used in a where clause? Ans :- Meta characters are wild characters , i.e. ‘%’, and ‘_’ Yes they can be used in where clause