SAP Questions and Answers for Certification
SAP Questions and Answers for Certification
The reference and definitive learning guide for SAP ABAP consultants Questions, answers, and explanations about the SAP ABAP interview! It is clear that SAP ABAP is one of the most important areas in SAP. Mastering the technical details is difficult. SAP ABAP Interview questions, answers, and explanations will guide you through your learning process. From helping you assess your ABAP skills to assessing job applicants, SAP ABAP certification and interview book can help you understand what you really need to know. This book is organized into eight areas of SAP ABAP: databases, lists, tables, dialog boxes, ABAP objects, bases, and others. Each question contains everything you need to know to master the interview or correctly evaluate the candidate. Rather than relaunching SAP sales documentation and presentations, each question is based on the knowledge of the project and the experience gained with successful SAP implementations. Updated for key certification and interview topics, database and standard updates, list processing, internal tables, and ALV grid control, dialog programming, ABAP objects, data transfer, basic administration, ABAP 2006 development reference! The ABAP resource is all you need to know before the interview.
SAP ABAP Questions and Answers for Certification
These are the most important and useful SAP ABAP real-time interview questions and answers helpful for SAP ABAP freshers and experienced SAP technical consultants. Real-Time Interview Questions of all ABAP programming Objects(Applications) :
Question
In your ABAP program, you want to display a dialog box that asks the user to confirm a chosen action. Which function module can you use to do this? Please choose the correct answer Popup_To_Confirm
Dialog_To_Confirm
User_Confirm
There Is No Such Function Module.
Question
What is true about the result set of a left outer join at the database level?
(More than one answer is correct) contains all entries from the left table
contains only entries that match in the on clause
fields from unmatched rows in the right table are null filled
fields from unmatched rows in the left table are null filled
contains all entries from the right table
Question
Identify the item that are not considered Data Dictionary technical settings when creating a
dictionary table
(More than one answer is correct) Buffering
Data Class
Field Name
Size Category
Status
Question
In what can lists be saved?
(More than one answer is correct) Local File to the application server
SAPOFFICE
HTML Format on local PC
ABAP Editor
Report Tree
Question
What appears in the standard header of the list?
(More than one answer is correct) Page Number
User
Program title
Date
Underline
Question
Mark the code that will display the selection screen of the called program ZIST
(More than one answer is correct) SUBMIT ZTST USING SELECTION-SET ‘VAR1’
SUBMIT ZTST VIA SELECTION-SCREEN
SUBMIT ZTST AND RETURN
SUBMIT ZTST VIA SELECTION-SCREEN USING
SELECTION-SET ‘VAR1’
Question
What is needed to ensure a check field is verified against the referred key field of the check table? same data type only is required for check field and referenced field
all key fields MUST have domain equality between check table and foreign key table
same domain is required for check field and referenced field
same data element is required for check field and referenced field
Question
What is not a valid functional type? Program
Joined tables
Sequential Data Set
LDB
Search Help
Question
When does a table get physically created in the underlying database? When you activate a transparent table in the ABAP Workbench
When you create a transparent table
When Basis creates the tablespace at the OS layer
When you activate a transparent table in the Dictionary
Question
What methods can be used to set the values for printing an online list.
(More than one answer is correct) NEW-PAGE PRINT ON
Function SET_PRINT_PARAMETERS
Function GET_PRINT_PARAMETERS
Include SET_PRINT_PARAMTERS
Question
What makes a text table? The type of foreign key field defined must be “No Key /Candidates”
The key of the text table consists of the key of the check table plus an additional language key
Cardinality must be defined as 1:1
Question
What is the recommended method to modify a standard search help to include customer defined
search paths? Add an elementary search help to the standard search help
Add a collective search help to the standard search help
Perform a modification to the standard search help
Enhance the standard search help with an append search help
Question
Given the logical database F1S, identify the database program that is created? Your user defined Program Name
SAPMZF1S
SAPDBF1S
DBF1SSEL
Question
You want to create a selection screen for your ABAP executable program. Which statements can you use to do this? There is more than one correct answer to this question. Parameters
Select-Options
Field-Symbols
Tables
Range Of
Question
Where does the system store the data after a Read Line has been performed on a list? In Memory
In an Internal table
SY-LISTI
SY-LISEL
Question
The cardinality of a foreign key relationship is defined as 1:N
What does this imply? One record of the check table is assigned to many records of the foreign key table
Many records of the check table are assigned to one record of the foreign key table
One record of the foreign key table is assigned to one record in the check table
Question
Programs that extend beyond transaction limits and want to pass data should use: SAP Memory
tables
ABAP/4 memory
Question
What requirement exists if a field is defined in the dictionary of type CURR? Decimals must be defined in the domain
The field must be numeric
The field must be linked to another field of type CUKY
No other requirement exists
Question
Identify the clause that is used to suppress standard headers? No Standard Heading
No Standard Page Heading
Suppress Standard
System>List>Save
Question
What is the effect of the hide statement? The variable appears on the current line as indicated by sy-linno
The system stores the field name and values for each field hidden
The fields are invisible and cannot be written to the list
Question
What is true about the result set of an inner join at the database level? contains all entries from both tables
contains all entries from the left table
contains only entries that match
contains all entries from the right table
Question
Which of the following dictionary objects gets stored as a runtime object? tables
All of the answers are correct
Structures
Data Elements
table Types
Question
Which statement prevents duplicate internal table entries? Insert
Append
Delete Duplicates
Collect
Question
You are an ABAP consultant and your customer asks you to list the benefits of moving from a Non-Unicode to a Unicode system. There is more than one correct answer to this question. A Unicode System Can Support Users Of Different Cultures.
A Unicode system automatically translates between different cultures
A Unicode system needs less database storage space.
Transfer Of Character Data Between Two Unicode Systems From Different Cultures Is Easier Than Between Non-Unicode Systems.
In Unicode systems, characters are always stored using UTF-8 encoding.
Question
Which is not a valid option of write a statement? Input
NO-GAP
No-Zero
As Radio Box
Centered
Under
Question
Identify the different type categories in the ABAP dictionary
(More than one answer is correct) table Types
Data Models
Structures
Data definitions
Data Elements
Question
Identify the dictionary type of field catlog used for the ALV control? Fieldcat
Catalog
alv_calog
cv_t_fcat
Question
What is true about the end-of-page Event?
(More than one answer is correct) Used to create Footers
Occurs when the page break has been triggered by the New-Page statement
Automatically creates a footer on the last page of a list
Works only if you reserve space in the Report
A statement using the line-count statement
Question
You want to generate page headers for a secondary list in an ABAP executable program. Which event block do you use to do this? Please choose the correct answer. At Line-Selection
Top-Of-Page
Top-Of-Page during Line-Selection
New-Page – end-Of-Page
Question
What is true about extract database?
(More than one answer is correct) An extract dataset may consist of records with different structures
More than one Extract Dataset is allowed per program
The Header Must be defined as one of the field groups
The field group HEADER is part of each extract record
Definition of a field group immediately reserves storage space for the fields
Question
What is true about SAP query? Users can access only the fields which are assigned to a functional group
user master record is generated when the query is defined
SAP user can be assigned to only one user groups
Functional Area can be a special view of a logical database
Question
For called program component that is of type transaction or report, what is true about the roll
area (assuming processing will resume in the calling program). Share the same roll area
They run in their own roll area
They run in the roll area of the caller
Question
What are valid methods for including text elements in your program?
(More than one answer is correct) Write: ‘Hello'(001)
Write: TEXT-001
Write: 001(Hello)
Write: TEXT-001’Hello’
Question
What is the authorization object is required to maintain queries? S_Query
S_Program
S_Query_All
S_Maintain
Question
What happens when a 1 to many relationships is encountered with an inner Join redundant da is not returned to the result set
redundant da from the outer ble is included
run time error
redundant da from the inner ble is included
Question
Default page headings are created on which type of list? All lists
Basic
Secondary
Question
Define logical database. A Reporting Tool
A method to update data
Definition of a Relational Data Model
An ABAP/4 Reading Program used to read and process data
Question
During interactive reporting, at what point does sy-Isind get incremented by the system? When you programmatically increment it
At the end of an interactive processing block
At the beginning of an interactive processing block
Question
What does a LDB provide? Consistent and flexible user interface
method to access the data in a random manner
Centrally defined authorization checks
Central performance improvements for update accesses
Question
What will cause the AT USER-COMMAND to fire? Type S Function Codes
Type T Functions Codes
Normal Function Codes
Function Codes that Start with P
Question
What is conined in the system variable sy-Linsz? row count of the current line
height of the current line
width of the current line
size of vertical bars in your list
Question
What happens when an EXIT statement is executed in the AT event? The program ends.
The remainder of the current processing block is executed
The output list is displayed
The system leaves the processing block and branches to the processing block of the next event.
Question
When is Top-Of-Page event triggered? When the Top-Of-Page event is encountered in sequence
After Number of lines per page, as specified in the REPORT, have been written to the list buffer
When the report starts
When the first write statement is encountered
Question
What is the READ LINE statement used for?
(More than one answer is correct) Reading Secondary Lists
Reading the Basic List
Reading Database tables
Reading Internal tables
Question
What is the effect of the collect statement if any entry with the same key already exists? Appends a new line
adds the numeric fields to an existing entry
Creates a new entry
Question
What is true of the new-page statement?
(More than one answer is correct) It is an event
Requires at least one write statement before it can be executed
Increments the page counter
Used to generate a blank page
Question
When does system reset the formatting values on a write statement? When explicitly changed using the Format statement
All answers are correct
At any New Event
Using the Reset option of the Format statement
Question
What is true about sorting an extract (intermediate) database? You can sort an extract dataset even without a header
The extract dataset is typically sorted in the Srtof- Selection processing block
The sequence of the control breaks in the Loop does not have to correspond to the extract dataset sort sequence
The extract dataset must be sorted for processing to begin
Question
You have written a module pool that manages flight connections. How can the end-user start a screen in your module pool? Please choose the correct answer. The user uses transaction SA38 to start a screen in the module pool.
The user uses transaction SE38 to start a screen in the module pool.
The User Uses A Dialog Transaction That You Have Created To Start A Screen In The Module Pool.
The administrator assigns a screen in the module pool to the profile of the user. The user then can start this screen from his user menu.
Question
Mark the valid usage of Read statement
(More than one answer is correct) DO. Read Line SY-INDEX. ENDDO
Read Line 3 of Current Page
Read Line 3 of Next Page
Read Current Line of table ITAB
Question
Identify the valid attributes of domain?
(More than one answer is correct) Header
Label
Length
Fixed Values
Type
Question
Table ZMYTABLE is created in the dictionary. When does the table get created in the underlying database? When the database administrator physically creates the table
At the end of the table creation after it is saved
When the table is activated
At the beginning of the table creation
It does not correspond to an object in the underlying database and does not get created
Question
You design a Dynpro with number 100 for an ABAP program. Dynpro 100 contains input fields that reference the data dictionary structure SDYN_BOOK. What do you have to do so that your ABAP program can access the data entered by the user during PAI processing? Please choose the correct answer. Use the statement GET FIELD sdyn_book in the PAI logic of the Dynpro.
Use the DATA statement to declare a structure of type SDYN_BOOK in the Top-Include of the program.
Use The Statement Tables Sdyn_Book To Declare A Structure With The Name And Type Sdyn_Book In The Top-Include Of The Program.
Use the statement GET FIELD sdyn_book in the PAI module user_command_100.
Question
You have written a Dynpro with number 100 in a module pool containing a button labeled Save. You have assigned the function code ‘SAV’ to this button. In the PAI module user_command_100 you want to check whether the user has clicked this save button. How can you achieve this? Please choose the correct answer. Check If The Field Sy-Okcode Contains The Value ‘Sav’.
Check If The Field Ok_Code Contains The Value ‘Sav’.
Check If The Field With The Ok Attribute In The Screen 100 Contains The Value ‘Sav’.
Check If The Field Sy-Ucomm Contains The Value ‘Sav’.
Question
What internal table Fields are generated using a select-option?
(More than one answer is correct) Low
Between
Option
High
Sign
Operator
Question
Select the methods used to access data on the database
(More than one answer is correct) Read table
Get node
Native SQL
ABAP/4 Open SQL
LDB
Question
Tables with indices, result in reduced performance in what Kind of OPEN SQL operation Data Base Modify
All database access
Data Base Retrieval
Data Base Updates
Question
What is the default screen that is generated for a selection screen? 100
1000
1001
1100
Question
What is the purpose of nodes statement in an ABAP program? Points to cluster tables
Indicates the nodes from the logical database
Specifies the logical database
Sets up an address pointer to the nodes in the shared memory buffers
Question
When you EXPORT an internal table that has a header line to ABAP/4 memory, what is the result? The header line and contents of the internal table are stored
. You cannot EXPORT an internal table with a header line.
Only the header line is stored
Only the contents of the internal table is stored
Question
Mark the valid logical nodes
(More than one answer is correct) table
Structure
Node
File
Complex Data Object
Question
You Want To Write A Subprogram Named Check_Booking That Receives A Parameter Of Type Sbook. You Want To Change Fields Of The Actual Parameter Within Your Subprogram, But Only If Your Subprogram Executes Without Any Error. How Do You Declare The Subprogram?Please Choose The Correct Answer. FORM Check_Booking USING P_Book TYPE Sbook
FORM Check_Booking USING VALUE(P_Book= TYPE Sbook
FORM Check_Booking CHANGING P_Book TYPE Sbook
FORM CHECK_BOOKING CHANGING VALUE (P_BOOK) TYPE SBOOK
FORM Check_Booking CHANGING P_Book TYPE Sbook ON RETURN
Question
Identify the object that cannot have a search help attached to it? table
table field
type
check table
data element
Question
Assuming a Detail list exists, what takes place when sy-island is set to zero.
(More than one answer is correct) All secondary lists are deleted
The basic and secondary lists are deleted
The basic list is overwritten with the current secondary list
The original basic list is re-displayed
Question
Which program do we used the refine the values returned by a search help? administration data
Export
restrict value range
Import
Question
An ABAP program has a selection screen. The ABAP is to be included as a step in the
Background job. What other field must be filled in when creating the job step? Print Specifications
Variant
Language
Mandatory Fields
Question
When writing a list, what command would allow you to overwrite a line? Back
Overtype
Reserve
Write:/ 1
Question
You analyze an executable ABAP program. In the event block AT SELECTION-SCREEN you see this line of code: MESSAGE w003 (ZMAT). What is the effect of this line? Please choose the correct answer. On the selection screen, the user sees a warning. The user must change the input parameters on the selection screen to continue with the program.
On The Selection Screen, The User Sees A Warning. The User May Change The Input Parameters Or Press Enter To Continue With The Program.
On the list, the user sees a warning. By pressing ENTER, the user is taken back to the selection screen and can change the input parameters.
On the selection screen, the user sees a dialog box with a warning. The user may change the input parameters or press ENTER to continue with the program.
On the selection screen, the user sees a dialog box with warning. The user must change the input parameters to continue with the program.
Question
You review an ABAP program that needs to be migrated to a Unicode system. The program opens a data set to read a text file into an internal table. How do you need to modify the OPEN DATASET statement so that your program will run on a Unicode system? Please choose the correct answer. Add The Extension In Binary Mode
Add The Extension In Text Mode.
Add The Extension In Unicdoe Mode.
Use Opent Textfile Instead Of Open Dataset
Use Open Unicode Instead Of Open Dataset.
Question
You want to display a dialog box window in your ABAP dialog program. Which statement can you use to do this? Please choose the correct answer. GO TO SCREEN 200.
CALL SCREEN 200.
SET SCREEN 200.
CALL SCREEN 200 STARTING AT 5 5.
WINDOW 200 STARTING AT 5 5.
Question
Which object would you integrate to determine the length of a field on a screen? Repository
Data Element
Value table
Dictionary
Domain
Question
Which modulation unit do not use ABAP/4 to pass data? Remove this record
function modules
Parameter Ids
transactions
reports called with SUBMIT and Return
Question
Select example of organizational data? Sales Order
Country Keys
Cost Centres
Vendors
Question
Select the valid customer defined Message Stement: MESSAGE Y123.
MESSAGE E123 (9999).
MESSAGE ID ‘AT’ TYPE ‘S’ NUMBER 100
MESSAGE E123 by Fielda Fieldb
Question
What is true about functional areas and User groups in ABAP Query?
(More than one answer is correct) The queries of a user group belong only to the person that created the query
The user can access only designated queries in a given user group
Users belonging to the same authorization group have the same query privilege
A Functional area can be assigned to several user groups
Several Functional areas can be assigned to one user group
Question
What can be assigned directly to a data element?
(More than one answer is correct) domain
built-in type
table type
check table
table field
Question
What determines if a table is a client specific versus client independent? The first field is mandt with a external data type
CLNT and specified as a key field
Depends how Basis has configured the client
The option ‘Client Specified’ is added to the Select stement The first field is mandt with a domain CLNT but not specified as a key field
Question
Which report statement option determines the width of a list? Line-Width
Line-Count
Report Size
Line-Size
Question
You create a function group ZATP that contains a couple of function modules to manage material master data. What is the name of the corresponding program? Please choose the correct answer. ZATP
SAPMZATP
SAPFZATP
SAPLZATP
SAPTZATP
Question
You want to write an ABAP executable program that displays a list of flights. When the user double-clicks on a line displaying a flight, you want to display a secondary list that displays all bookings for this flight. Which is the correct usage of the HIDE technique to provide information about the selected line on the base list to the event block that builds the secondary list? Please choose the correct answer. Select * From Sflight Into Wa. Write:/ Wa-Carrid, Wa-Connid, Wa-Fldate. Hide:/ Wa-Carrid, Wa-Connid, Wa-Fldate. Clear: Wa. Endselect.
Select * From Sflight Into Wa. Write:/ Wa-Carrid, Wa-Connid, Wa-Fldate. Hide: Wa-Carrid, Wa-Connid, Wa-Fldate. Endselect. Clear: Wa.
Select * From Sflight Into Wa. Hide: Wa-Carrid, Wa-Connid, Wa-Fldate. Write:/ Wa-Carrid, Wa-Connid, Wa-Fldate. Clear: Wa. Endselect
All the answers are wrong.
Thanks for your wonderful content. This makes me clear about Microsoft SQL Certification
ReplyDelete