|In the context of a logical database, which is not a valid ABAP keyword event End-Of-Selection Get Initialization Put At Selection-Screen.
Identify the case where table buffering should be set off? For Small Static non volatile tables For Global Master Data When the most current data is not required When the most current data is required.
Mark the valid usage of Read statement
(More than one answer is correct) Read Line 3 of Next Page DO. Read Line SY-INDEX. ENDDO Read Line 3 of Current Page Read Current Line of table ITAB.
What is the effect of the collect statement if any entry with the same key already exists? Appends a new line Creates a new entry adds the numeric fields to an existing entry.
What must be assigned to help parameters? domain data element values nothing.
You want to write an ABAP executable program that displays a list of airline carriers. When the user double-clicks on a line displaying a carrier, you want to display a secondary list that displays the flight plan of this carrier. You build your base list using this code: SELECT * from scar INTO wa. WRITE:/ wa-carrid, wa-name, wa-url. HIDE: wa-carrid. ENDSELECT. CLEAR wa. Which is the correct coding for the secondary list?Please choose the correct answer. AT LINE-SELECTION. CHECK wa-carrid IS NOT INITIAL. SELECT * FROM spfli INTO wa_spfli WHERE carrid = wa-carrid. WRITE:/ wa_spfli-carrid, wa_spfli-connid, wa_spfli-cityfrom, wa_spfli-cityto. ENDSELECT. CLEAR wa. AT LINE-SELECTION. CHECK sy-subrc IS NOT INITIAL. SELECT * FROM spfli INTO wa_spfli WHERE carrid = wa-carrid. WRITE:/ wa_spfli-carrid, wa_spfli-connid, wa_spfli-cityfrom, wa_spfli-cityto. ENDSELECT. CLEAR wa. All the answers are correct AT LINE-SELECTION. CHECK wa-carrid IS NOT INITIAL. SELECT * FROM spfli INTO wa_spfli. WRITE:/ wa_spfli-carrid, wa_spfli-connid, wa_spfli-cityfrom, wa_spfli-cityto. ENDSELECT. CLEAR wa.
When is Top-Of-Page event triggered? When the report starts 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 first write statement is encountered.
Which is not a valid option of write statement? NO-GAP As Radio Box No-Zero Under Input Centered.
Mark the valid logical nodes
(More than one answer is correct) Node table File Structure Complex Data Object.
Identify the clause that is used in suppress standard headers? No Standard Page Heading No Standard Heading System>List>Save Suppress Standard.
During interactive reporting, at what point does sy-Isind get incremented by the system? At the end of an interactive processing block At the beginning of an interactive processing block When you programmatically increment it.
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 dialog box with warning. The user must change the input parameters 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 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 a warning. The user may change the input parameters or press ENTER to continue with the program.
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.
Which program do we used the refine the values returned by a search help? administration data restrict value range Import Export.
What appears in the standard header of list?
(More than one answer is correct) Page Number Program title User Underline Date.
What internal table Fields are generated using a select-option?
(More than one answer is correct) Low Between Option High Operator Sign.
What is true about the result set of an inner join at the database level? contains all entries from the left table contains all entries from the right table contains all entries from both tables contains only entries that match.
Identify the different type categories in the ABAP dictionary
(More than one answer is correct) Data definitions Structures table Types Data Models Data Elements.
You need to create an ABAP program that displays a list of invoices from a supplier. What types of programs can you create to achieve this goal? There is more than one correct answer to this question. Abap Executable Program Abap Webdynpro Application Abap Subroutine Pool Abap Module Pool Abap Include Program.
Assuming a Detail list exists, what takes place when sy-island is set to zero.
(More than one answer is correct) The basic and secondary lists are deleted All secondary lists are deleted The basic list is overwritten with the current secondary list The original basic list is re-displayed.
Which statement would be used to create a box with a frame title on a selection screen? Begin of Selection, End of Selection Begin of Frame, End of Frame Begin of Box, End of Box Begin of Block, End of Block.
What happens when a 1 to many relationship is encountered with an inner Join redundant data is not returned to the resulnt set redundant data from the outer block is included run time error redundant da from the inner bloc is included.
What is authorization object is required to maintain queries? S_Query_All S_Query S_Program S_Maintain.
Which modulation unit do not use ABAP to pass data? Remove this record function modules Parameter Ids transactions reports called with SUBMIT and Return.
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.
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 SE38 to start a screen in the module pool. The user uses transaction SA38 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. The User Uses A Dialog Transaction That You Have Created To Start A Screen In The Module Pool.
READ CURRENT LINE makes use of what system variables ….
(More than one answer is correct) SY-CUROW SY-INDEX SY-PAGNO SY-CPAGE.
The user default for the date format is set to YYYY.MM.DD. Assume that today’s date is January
15, 1999 the displayed output of the date field in the following code 01/15/1999 1999.01.15 19990115 1999/01/15.
Define logical database. A Reporting Tool Definition of a Relational Data Model An ABAP/4 Reading Program used to read and process data A method to update data.
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? Mandatory Fields Print Specifications Language Variant.
What methods can be used to set the values for printing an online list.
(More than one answer is correct) Function GET_PRINT_PARAMETERS Include SET_PRINT_PARAMTERS NEW-PAGE PRINT ON Function SET_PRINT_PARAMETERS.
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 Text Mode. Use Opent Textfile Instead Of Open Dataset Add The Extension In Unicdoe Mode. Add The Extension In Binary Mode Use Open Unicode Instead Of Open Dataset.
What options can be assigned directly to a data element?
(More than one answer is correct) table field table type domain built-in type check table.
What is the default screen that is generated for a selection screen? 100 1000 1001 1100.
Identify the valid attributes of domain?
(More than one answer is correct) Label Header Length Fixed Values Type.
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 Range Of Tables Select-Options Field-Symbols.
What happens when an EXIT statement is executed in the AT event? The program ends. The output list is displayed The remainder of the current processing block is executed The system leaves the processing block and branches to the processing block of the next event.
Given the logical database F1S, identify the database program that is created? Your user defined Program Name SAPDBF1S SAPMZF1S DBF1SSEL.
Why is subquery usually more efficient? data is filtered in the sap gui data is filtered at the application server data is filtered on the network data is filtered in the database.
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.
Programs that extends beyond transaction limits and want to pass data should use: ABAP/4 memory SAP Memory tables.
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. SAPMZATP ZATP SAPFZATP SAPLZATP SAPTZATP.
When is it better to buffer the table? When a table is read infrequently When a table is linked to check tables When a table is read frequently and the data is always changing When a table is read frequently and the data seldom changes.
What are valid methods for including text elements in your program?
(More than one answer is correct) Write: TEXT-001 Write: 001(Hello) Write: 'Hello'(001) Write: TEXT-001'Hello'.
After a READ LINE on a List, what happens to the HIDE data? The hide data is restored to shared memory Nothing, the data remains in the hidden area It is transferred back to the fields defined in the program The Hide data is not available to the program.
What requirement exists if a field is defined in the dictionary of type CURR? The field must be linked to another field of type CUKY No other requirement exists Decimals must be defined in the domain The field must be numeric.
At what point does a parameter ID get reset? Free Memory User sign off Program Execution Ends When you Flush the SPA/GPA memory.
When does a processing block for a Get statement end? When all da has been retrieved for the Get When the next keyword event is encountered When the END GET statement is encountered After each PUT in the LDB.
Where does information comes from when you press F1 on a screen fileld? Domain Help values Domain short text Search help Data element documention.
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.
Identify the object that cannot have a search help attached to it? data element check table table type table field.
What is the effect of the hide statement? The system stores the field name and values for each field hidden The variable appears on the current line as indicated by sy-linno The fields are invisible and cannot be written to the list.
What are the main functions of the data dictionary?
(More than one answer is correct To connect to the operating system To insulate the ABAP/4 developer from the database To provide data security at the application level To support the creation and management of meta data.
How are buffers used by inner and outer joins? buffers are always bypassed the choice can be made to use or bypass buffers buffers are always used.
What is true about the result set of an 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 left table are null filled fields from unmatched rows in the right table are null filled contains all entries from the right table.
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.
What does a LDB provide? Consistent and flexible user interface Centrally defined authorization checks method to access the data in a random manner Central performance improvements for update accesses.
What is true of the new-page statement?
(More than one answer is correct) Increments the page counter Requires at least one write statement before it can be executed It is an event Used to generate a blank page.
What is the option on the “Parameters” statement in a report program to include a SPA/GPA
Parameter ID? Parameter ID Default Parameter ID Memory ID Value.
What is true about SAP query? Functional Area can be a special view of a logical dabase user master record is generated when the query is defined Users can access only the fields which are assigned to a functional group SAP user can be assigned to only one user groups.
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. Hide: Wa-Carrid, Wa-Connid, Wa-Fldate. Write:/ 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. Write:/ Wa-Carrid, Wa-Connid, Wa-Fldate. Hide:/ Wa-Carrid, Wa-Connid, Wa-Fldate. Clear: Wa. Endselect. All the answers are wrong.
What happens to memory when the Export is executed without specifying ID? SAP Memory is overwritten The ABAP memory is completely overwritten ABAP memory sets up a new default area.
What happens if message E046 is raised? Field Sales is open for input and all other fields are not available for input The program ends All fields are open for input and cursor is positioned on field sales The initialization event is fired again.
Select example of organizational data? Sales Order Country Keys Vendors Vendors.
What makes a text table? 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 The type of foreign key field defined must be "No Key /Candidates".
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 With The Ok Attribute In The Screen 100 Contains The Value 'Sav'. Check If The Field Sy-Okcode Contains The Value 'Sav'. Check If The Field Ok_Code Contains The Value 'Sav'. Check If The Field Sy-Ucomm Contains The Value 'Sav'.
Identify the valid methods for setting the value of a select-option selection field…
(More than one answer is correct) Initialization. ZFLIGHTS-CARRID = 'AA'. Start-of-Selection. ZFLIGHTS-CARRID = 'AA'. SELECT-OPTIONS AIRLINE FOR ZFLIGHTSCARRID MEMORY ID CAR. SELECT-OPTIONS AIRLINE FOR ZFLIGHTSCARRID DEFAULT 'AA'.
You Review An ABAP Program That Needs To Be Migrated To A Unicode System. Within The Program, The Two Data Objects City And Member Are Declared In The Following Way:
DATA City (20) TYPE C.
DATA: BEGIN OF Member,
First name (20) TYPE C,
Age TYPE I,
City (20) TYPE C,
END OF Member.
The Program Contains the Following Line: City = Member+54(20). Why Does This Line Not Work As Expected? Please Choose The Correct Answer. Because the syntax is incorrect. Because the fragment view of member contains non-character data. Because an integer has 8 bytes Because You Can Not Read Beyond Non-Character Data Within A Structure Using The Offset Notation.
You have written an ABAP executable program that displays the flight connections between two cities for your customer. You hand over your program to your customer for maintenance and need to explain to your customer’s programmer the properties of event blocks. There is more than one correct answer to this question Event Blocks Start With An Event Key Word And End With The Start Of Any Other Modularization Block, For Example, Another Event Block Or Module Or Subroutine Event blocks start with an event key word and end with the keyword END OF EVENT Event blocks can be nested, for example, you can have event blocks within event blocks. Event blocks are executed in the sequence they occur in the program. The Abap Runtime Decides In Which Sequence To Execute Event Blocks.
You have made change to an existing table that contains data. What takes place when the Dabtaase
Conversion utility is executed?
(More than one answer is correct) Data in the table is automatically deleted and must be reloaded The revised table in the ABAP/4 Dictionary is activated The table in the database is renamed and eventually deleted The indexes for the table needs to manually be reconstructed in the ABAP Dictionary The table in the database is recreated.
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. CALL SCREEN 200 STARTING AT 5 5. CALL SCREEN 200. GO TO SCREEN 200. WINDOW 200 STARTING AT 5 5. SET SCREEN 200.
When does a table get physically created in the underlying database? When you activate a transparent table in the Dictionary When you create a transparent table When you activate a transparent table in the ABAP Workbench When Basis creates the tablespace at the OS layer.
What techniques would you use to fix the 10 leftmost columns on a list when scrolling to the right? Set Left Scroll-Boundary Column 10 Scroll List PS+<10> Scroll List Left Set Right Scroll-Boundary Column 10.
Mark the code that will display the selection screen of the called program ZtST
(More than one answer is correct) SUBMIT ZTST VIA SELECTION-SCREEN SUBMIT ZTST AND RETURN SUBMIT ZTST USING SELECTION-SET 'VAR1' SUBMIT ZTST VIA SELECTION-SCREEN USING SELECTION-SET 'VAR1'.
Which object would you integrate to determine the length of a field on a screen? Value table Repository Data Element Domain Dictionary.
The cardinality of a foreign key relationship is defined as 1:N
What does this imply? Many records of the check table are assigned to one record of the foreign key table One record of the check table is assigned to many records of the foreign key table One record of the foreign key table is assigned to one record in the check table.
Select the methods used to access data on the database
(More than one answer is correct) ABAP/4 Open SQL Read table Native SQL Get node LDB.
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. New-Page - end-Of-Page Top-Of-Page Top-Of-Page during Line-Selection At Line-Selection.
What is the purpose of nodes statement in an ABAP program? Indicates the nodes from the logical database Specifies the logical database Points to cluster table Sets up an address pointer to the nodes in the shared memory buffers.
What is the READ LINE statement used for?
(More than one answer is correct) Reading the Basic List Reading Database tables Reading Internal tables Reading Secondary Lists.