Which of the following do you use as a separator between a table and a field name in Open SQL? Pointer (->) Tilde (~) Minus (-) Period (.).
You want to create a new CDS view VIEW1 that reads from CDS view VIEW2. VIEW2 has 2 input parameters, par1 and par2, with data type abap.char(10).
Which of the following is the correct way to supply the input parameters? select from VIEW2( par1: IText1I par2: IText2I )
select from VIEW2( par1 = IText1I, par2 = IText2I ) select from VIEW2( par1: IText1I, par2: IText2I ) select from VIEW2( par1= IText1I par2= IText2I ).
Where do you distinguish between OData V2 or OData V4? Service Binding
Behavior Projection
Service Definition Projection View.
You develop an OData V2 service in SAP Gateway. What is listed in the service document? Entity Types Entity Sets Association Sets Associations.
You develop a transactional application with the ABAP RESTful Application Programming Model (RAP).Not all field names in the data model view are identical to the field names in the database table.
Where do you define the field name mapping? In the Behavior Projection In the field mapping view In the Behavior Definition
In the Behavior Implementation You want to replace statements in a program with expressions.
You maintain a transactional app that is built with the ABAP Programming model for SAP Fiori. The BOPF Business Object consists of a single node. You want to enable the CREATE button for new instances.
In which of the following CDS objects do you have to add annotation @ObjectModel.createEnabled? The data definition of the transactional view The data definition of the consumption view
The data definition of the interface view
The metadata extension of the consumption view.
You want to analyze SQL performance. You use the SQL Monitor in the production system (PRD) to collect the data. How can you create a snapshot in the development system (DEV)? Use transaction SRTCM in DEV to retrieve a snapshot from PRD by RFC. Use transaction SWLT in PRD to export a file and transaction SWLT in DEV to import this file.
Use transaction SQLM in PRD to export a file and transaction SWLT in DEV to import this file. Use transaction SWLT in DEV to retrieve a snapshot from PRD by RFC.
For performance optimization, you want to combine the results of ABAP Test Cockpit and the SQL Monitor runtime data. Which tool do you use for this? SQL Performance Tuning Worklist (SWLT)
Runtime Check Monitor: Data Display (SRTCMD)
SQL Monitor: Display Data (SQLMD) Runtime Check Monitor (SRTCM).
You want to use the UNION between 2 SELECT statements in aCDS view. What must both statements have in common? Identical data types for elements in the same position Identical name or alias for elements in the same position Same number of key elements Same number of elements.
You create a project in the Custom Code Migration app to analyze the readiness of custom code for SAP S/4HANA. How does the app supply the check results?
It reads a check result from a remote system.
It executes a check run in a remote system It reads the check result from the local system.
It executes a check run in the local system.
You want to define an ABAP Managed Database Procedure (AMDP) . Which are requirements in the definition part of the class? The AMDP method has at least one exporting parameter. The AMDP method is defined as a a static method. All parameters of the AMDP method are passed by value. The class implements interface if_amdp_marker_hdb.
You use remote client proxy in ABAP. You create an Exception Class for errors related to proxy consumption. Which of the following do you use as a superclass? CX_RAP_QUERY_PROVIDER CX_UUID_ERROR
CX_WEB_MESSAGE_ERROR
CX_HTTP_DEST_PROVIDER_ERROR.
Which of the following are benefits of draft-enabling an application? Support for device switching Early feedback fromvalidations
Re-use of existing business logic
Support for continuous work Implicit authorization checks.
You implement an ABAP Managed Database Procedure (AMDP). You want to access some other objects from within your script code. Which of the following objects must you list after the USING addition?
Database Views
Stored Procedures
AMDP Functions Calculation Views.
You want to establish an automatic check during the release of change requests. If the check returns any errors, the system should prevent the request from being released.
Which analysis tool can you configure for this? Extended Check (SLIN) ABAP Test Cockpit (ATC) Performance Tuning Worklist (SWLT) Code Inspector (SCI).
You develop an ABAP application and you want to directly access an Internet-facing API. Which of the following methods of the CL_HTTP_DESTINATION_PROVIDE class can you use to obtain the destination object? CREATE_BY_DESTINATION
CREATE_BY_HTTP_DESTINATION CREATE_BY_CLOUD_DESTINATION
CREATE_BY_URL.
When creating CDS-based BOPF Business Objects, the system generates several additional repository objects. Among those objects are objects in the ABAP Dictionary.
Which types of ABAP Dictionary objects are generated?
Database Views Data Elements Table Types Structures.
You implement the behavior of a CDS-based BOPF Business Object. For which of the following tasks can you reuse the implementation from the BOPF public library?
Check for valid dates in input fields Auto-fill semantic key fields
Check for existing foreign keys
Auto-fill a Last Changed By field.
You want to search for custom code that needs to be adjusted. Which of the following tools can you use? ABAP Call Monitor (SCMON)
Usage Data (SUSG)
SQL Monitor (SQLM) Code Inspector (SCI).
How could you replace the statement CONCATENATE a b INTO c.? c = a && b. c = a& b. c = |a&&b|. c = |{ a }{ b }|.
You want to write a SELECT statement using the Open SQL syntax of release 7.50.Which of the following sequences of clauses are valid?
INTO can precede the UNION clause
WHERE clause can precede the INTO clause FROM clause can precede the column list
UP TO ... ROWS can precede the INTO clause.
You are defining a variant in the ABAP Trace tool (SAT). Which of the following trace restrictions can you set?
Restrict trace to specific program parts
Restrict trace to specific transactions
Restrict trace to specific users
Restrict trace to specific statements.
You edit a behavior implementation class of a draft-enabled BOPF Business Object. You need to distinguish between a new draft instance and an edit draft instance.
Which property of the node instance do you evaluate? DraftEntityOperationCode HasActiveEntity ActiveUUID IsActiveEntity.
You are writing an ABAP Managed Database Procedure that contains a SELECT statement. How does client handling work?
Use sy-mandt Use session_context( ICLIENTI ) Client handling is automatic Use $session.client.
Which of the following make up the behavior of a BOPF Business Object?
Authorizations
Actions
Validations
Associations Determinations.
Which of the following are extensibility apps from the Extensibility Business Catalog?
Data Source Extensions Custom Database Fields
Custom CDS Views
Configure Software Packages CustomFields and Logic.
Which of the following expressions will lead to an exception? DATA var TYPE c LENGTH 3. var = EXACT #( IA123I ). DATA var TYPE c LENGTH 5. var = EXACT #( IA123I ).
DATA var TYPE p LENGTH 3 DECIMALS 2. var = EXACT #(1 / 8 ). DATA var TYPE n LENGTH 4. var = EXACT #( IA123I ). DATA var TYPE p LENGTH 3 DECIMALS 2. var = EXACT #(1 / 4 ).
You plan to migrate an SAP ERP system to SAP S/4HANA. Which of the following tasks are recommended but NOT mandatory?
SAP S/4HANA checks
Functional adaption Custom code evaluation Performance tuning.
Which of the following rules apply to the naming of CDS Views? The data definition and the SQL view must have the same name.
The SQL view name can be up to 30 characters long.
The data definition name can be up to 30 characters long.
The CDS view and the SQL view must have different names.
Which expression can you use in Open SQL release 7.50? NEW CONV COND CASE.
Which of the following are dimensions of the SAP Fiori definition? Process Design Technology Concept Business.
In your ABAP program, you have a loop over internal table T1. Inside the loop, you use the contents of T1 to fill another internal table T2: LOOP AT t1 INTO wa1. MOVE-CORRESPONDING wa1 TO wa2. APPEND wa2 TO T2. ENDLOOP.
Which expressions could you use to replace the loop?
REF REDUCE VALUE
CONF.
In your system landscape, you create a Custom Business Object in the SAP S/4HANA On-Premise edition. Which steps are necessary to use the Custom Business Object as the basis for an SAP Fiori app? Activate the Service Generation checkbox in the Custom BusinessObjects app Create a project in the SAP Gateway Service Builder (SEGW)and reference your Custom Business Object as data source
Register the OData service based on your Custom Business Object in SAP Gateway Activate the UI Generation checkbox in the Custom Business Objects app.
Which CDS annotation do you use to add a section to an ObjectPage?
@UI.area
@UI.range
@UI.segment
@UI.facet.
In SAP S/4HANA, a replacement object is assigned to transparent table ANEA. Which uses of table ANEA do you have to correct when migrating an SAP ERP system to SAP S/4HANA? As the data source of a database view in the ABAP Dictionary
In the FROM clause of a SELECT statement In the FROM clause of a DELETE statement As the line type of a table type in the ABAP Dictionary.
The Entity Manipulation Language (EML) is an extension of which of the following? The ABAP Programming Language The Service Definition Language The Behavior Definition Language
The Structured Query Language.
Where does the SAP system organize the SAP Gateway services? Internet Communication Framework (ICF)
Internet Communication Manager (ICM)
Internet Graphics Service (IGS) Internet Transaction Server (ITS).
You are creating an enhancement implementation using key user extensibility. Which of the following can you do in the web-based ABAP editor?
Assign your implementation to a transport request.
Test your custom logic. Directly access SAP database tables. Create filter conditions. Modularize your code using custom libraries.
Which of the following tasks are typically done in a Projection view of the ABAP RESTful Application Programming Model (RAP)? Enable full-text search in the application Define a value help for an input field Define the Business Object composition Define the components of the service.
You want to use the extensibility app, Custom Fields and Logic, to define custom fields for an SAP Fiori app. Which of the following conditions is a prerequisite for this activity? You must release the SAP Fiori app for extensibility using the Enable Fields for Use transaction in the Custom Fields and Logic (SCFD_EUI) app. There is no specific requirement. Custom fields can basically be created for any SAP Fiori app. Custom fields can only be created for SAP Fiori apps that have been enabled by SAP for this type of extension. You must release the SAP Fiori app for extensibility via transaction Setup Adaptation Transport Organizer for Key User Tools (S_ATO_SETUP).
You develop an SAP Fiori app in a specific solution area. Where do you define tiles and target mappings for the app?
In a Business Catalog Group
In a Business Catalog In a Business Role In a Technical Catalog.
Which of the following new features are supported by the CDS Views but not by the ABAP Dictionary Views? Enhancement with custom fields
Nested views (View-on-View) Combining queries as inner join Aggregations and grouping Expressions in the field list.
You create a destination in SAP BTP cockpit. Which of the following destination types can you set in the Connectivity Service? HTTP RFC OData SMTP.
What can you define in an SAP Fiori catalog?
Links Tiles Groups Target Mappings.
You implement the Behavior of a CDS-based BOPF Business Object. You call method update( ) of the BOPF data modifier to update instance data of node ZMY_NODE.
How do you type the actual parameter of import parameter IS_DATA? TYPE REF TO zs_my_node TYPE REF to zt_my_node
TYPE zs_my_node TYPE zt_my_node.
In a central hub deployment, which protocol is used to communicate between front-end and back-end server? InA OData RFC HTTP.
You implement a SELECT statement in ABAP. When do you use the key word FIELDS? When the position of the fields list is after the GROUP BY clause. When the position of the fields list is after the ORDER BY clause.
When the position of the fields list is after the UNION clause.
When the position of the fields list is after the FROM clause.
Which OData option do you use to access the data model of the service? $format $metadata $select $expand.
You have a field currcode in a CDS view definition. You want to annotate the field with a label. Which of the following are syntactically correct?
@EndUserText.label: 'Currency Code'
currcode, @<EndUserText.label: 'Currency Code'
currcode, currcode @<EndUserText.label: 'Currency Code' , currcode, @>EndUserText.label: 'Currency Code'.
Which of the following CDS view definitions is syntactically correct?
@AbapCatalog.sqlViewName: IS4D430_CARRIERI . DEFINE VIEW S4D430_Carrier AS SELECT. carrid, carrname, currcode, url. FROM scarr
@AbapCatalog.sqlViewName: IS4D430_CARRI. DEFINE VIEW S4D430_Carrier AS SELECT. FROM scar. FIELDS carrid, carrname, currcode, url
@AbapCatalog.sqlViewName: IS4D430_CARRI. DEFINE VIEW S4D430_Carrier AS SELECT. FROM scarr. { carrid carrname currcode url } @AbapCatalog.sqlViewName: IS4D430_CARRI. DEFINE VIEW S4D430_Carrier AS SELECT . FROM scar. {carrid, carrname, currcode, url}.
Which of the following information do you get using the ABAP Call Monitor? Business transactions that called ABAP objects The ABAP objects that have been called The ID of the calling user The number of calls The protocol type used for the call.
What can you use as data source for an SAP Fiori App Launcher - Dynamic? OData service Target mapping SAPUI5 service Source mapping.
Which of the following repository objects offer a preview function? Service Binding Behavior Definition Service Definition Data Definition.
Which of the following do you use as a separator between a table and a field name in a CDS view definition? Minus (-) Period (.) Pointer (->) Tilde (~).
You want to create ABAP applications to consume an on-premise RFC. You use the jco.client.ashost property to create a corresponding destination.
Which other properties must you add to the destination definition? jco.client.group = < Group of application servers > jco.client.client = < SAP Client > jco.client.mshost = < Message server host > jco.client.sysnr = < SAP System Instance >.
Which building blocks of the ABAP RESTful Programming Model(RAP) are part of the Core Data Services(CDS)?
Projection View
Behavior Implementation
Service Definition Behavior Definition.
You want to use Data Source Extensions. Which of the following restrictions and options apply? You can only create one Data Source Extension per data source. You can use Data Source Extensions to extend SAP data sources with customer-specific fields. You can only read fields of a Data Source Extension. You can only create Data Source Extensions for SAP applications that have been enabled by SAP for key user extensibility.
The class CL_CLASS contains a public static method DO_SOMETHING with an importing parameter PARAM TYPE i. Your program contains the following data declaration: DATA var TYPE string.
Which of the following method calls is syntactically correct? cl_class=>do_something( param = CONV #( var ) ). cl_class=>do_something( param = EXACT #( var ) ). cl_class=>do_something( param = CAST #( var ) ).
cl_class=>do_something( param = var ).
Which of the following floor plans does SAP Fiori elements offer? Initial Page
List Report Worklist Master Detail Page
Overview Page.
There are many syntax differences between SAP HANA SQLScript and Open SQL. Which of the following rules are common ground between the two languages? Host variables are escaped with an at symbol (@) Key words can be upper-case or lower-case Statements are ended with a period (.) Comments can be marked by an asterisk (*) at position 1.
Which of the following features are part of the new syntax for OpenSQL? ABAP variables escaped with @ ABAP variables escaped with : Comma-separated column list Blank-separated column list.
The root-node of a CDS-based business object is based on CDS View ZMY_VIEW. The persistent data is stored in the database table ZMY_TABLE. At least one key field of ZMY_TABLE has a different name in CDS View ZMY_VIEW.
Which kind of repository object is needed to map the fields of ZMY_VIEW to the fields of ZMY_TABLE? Database View SQL View Structure Type Global Class.
You maintain a transactional app for sales orders that is built with the ABAP Programming model for SAP Fiori. For which of the following tasks would you implement a determination of the BOPF Business Object? Check the creation date Assign the sales order ID
Save the sales order data Calculate the sales order sum Dynamically allow or disallow editing.
Which of the following are features of the ABAP Test Cockpit?
Request and approve exemptions
Measure the consumption of database time
Check how often code is executed
Schedule global check runs.
You have written a program that uses inline declarations and assigns values using expressions. The global data declarations contain the following statement: DATA o TYPE REF TO cl_class.
Which of the following are valid statements? o =NEW cl_class( ). o = NEW string( ). DATA(p) =NEW( ). DATA(p) = NEW cl_class( ). o = NEW( ).
You use the UNION in the Open SQL statement in release 7.50.Which of the following must you use? JOIN clauses Explicit field list INTO clause at the end DISTINCT clause.
You implement the behavior of a CDS-based BOPF-Object and want to issue a message. Which is the correct sequence of the necessary implementation steps? Make sure parameter eo_message is not empty. Call a static method of class /bobf/cl_frw_message_factory. Add a message to the message container. Call a static method of class /bobf/cl_frw_message_factory. Add a message to the message container. Make sure parameter eo_message is not empty. Add a message to the message container. Make sure parameter eo_message is not empty. Call a static method of class /bobf/cl_frw_message_factory Make sure parameter eo_message is not empty. Add a message to the message container. Call a static method of class /bobf/cl_frw_message_factory.
You define an SAPUI5 application as the target in a target mapping. Which of the following are mandatory? Component ID
ICF path
Application type
OData service Application ID.
You want to adjust validations of a RAP Business Object. You open the related Behavior Pool. On which tab do you find the method implementations?
Test Classes Class-relevant Local Types
Local Types
Global Class.
Which of the following are valid ways to insert a comment in a Data Definition (DDL source)? * comment -- comment /* comment */ // comment.
You want to create custom fields using the Custom Fields and Logic extensibility app. Which of the following statements do you need to consider?
You must assign the fields to a business context.
You can only use String-like data types for the fields. You must define the fields as read-only fields. You can translate the fields into different languages.
You use the Code Inspector to Search for Potential Functional Issue. Which of the following checks are presets in FUNCTIONAL_DB variant of the Code Inspector?
Search problematic statements for result of SELECT or OPEN CURSOR without ORDER BY
Search DB Operations in Pool or Cluster Tables Unsecure use of FOR ALL ENTRIES Complex WHERE conditions in SELECT statements.
Which of the following new repository object types were introduced with ABAP CDS?
Business Object Data Definition Metadata Extension External View Access Control.
You have written the following code: START-OF-SELECTION. LOOP AT itab INTO DATA(line). * ENDLOOP. The system creates a variable called Line. When is it created and when can you address it? It is created at the beginning of the program. You can access it only within the loop.
It is created when the LOOP statement is processed. You can access it any time after the declaration.
It is created when the LOOP statement is processed. You can access it only within the loop. It is created at the beginning of the program. You can access it any time after the declaration.
What can you do with the SQL Trace Tool (ST05)? Detect redundant statements Display record of all database access Locate database-related performance issues
Locate database-related functional issues
Detect all deleted database records.
You maintain a transactional application for flight travels that was developed with the ABAP RESTful Application Model (RAP Model). You want to offer an additional button for cancelling a travel.
Which of the following building blocks need to be edited?
Behavior Projection Data Model Data Model Projection Service Definition Behavior Definition.
Which of the following Open SQL statements are syntactically correct in release 7.50?
SELECT carrid connid loccuram loccurkey . FROM sbook . WHERE customid = lv_customer. INTOTABLE lt_booking.
SELECT carrid, connid, loccuram, loccurkey . FROM sbook .INTO TABLE @lt_booking . WHERE customid = @lv_customer.
SELECT carrid connid loccuram loccurkey. FROM sbook. INTOTABLE lt_booking . WHERE customid = lv_customer.
SELECT FROM sbook . FIELDS carrid, connid, loccuram, loccurkey . INTO TABLE @lt_booking . WHERE customid = @lv_customer.
SELECT FROM sbook. FIELDS carrid, connid, loccuram, loccurkey . WHERE customid =@lv_customer. INTOTABLE @lt_booking.
SAP enabled key user extensibility for a SAP Fiori application. The application accesses a database table that you extended with an append structure in the customer namespace. You want to use key user extensibility to create input fields on the SAP Fiori UI that correspond to the custom database fields.
Which of the following steps are mandatory? Enable the custom database fields for usage in SAP Fiori apps using the transaction Enable Fields for Use in the Custom Fields and Logic (SCFD_EUI) app. Enable the usage of the custom database fields in the Custom Fields and Logic app. Append the custom database fields to the extension include structure provided by SAP. Redefine the OData service used by the SAP Fiori app in transaction SAP Gateway Service Builder(SEGW)to add the custom database fields. Activate the custom database fields using the transaction Extensibility Registry (SCFD_REGISTRY).
Which of the following features are available in Open SQL release7.50?
FULL OUTER JOIN
ASSOCIATION BETWEEN in ON conditions RIGHT OUTER JOIN Up to 50 tables in JOINs.
In your system landscape, there is a development system DEV and a central check system CHK. Which of the following describes the developer scenario of remote checks with ABAP Test Cockpit (ATC)? A developer logs on to system CHK and invokes a check in system DEV. A developer logs on to system DEV and invokes a check in system CHK. A developer logs on to system DEV and checks objects from system CHK.
A developer logs on to system CHK and checks objects from system DEV.
|
