Happy Hour

In what order are objects created to generate a RESTful Application Programming application?. Service Binding → Service Definition → Projection View → Data Model View → Database Table. Data Model View → Service Binding → Database Table → Service Definition → Projection View. Projection View → Database Table → Service Binding → Data Model View → Service Definition. Database Table → Data Model View → Projection View → Service Definition → Service Binding.

Given the following Core Data Service view entity data definition: @AccessControl.authorizationCheck: #NOT_REQUIRED DEFINE VIEW ENTITY demo_cds_param_view_entity WITH PARAMETERS p_date : abap.dats AS SELECT FROM sflight { key carrid, key connid, key fldate, price, seatsmax, seatsocc } WHERE fldate >= $parameters.p_date; Which of the following ABAP SQL snippets are syntactically correct ways to provide a value for the parameter on line #4? Note: There are 2 correct answers to this question. SELECT * FROM demo_cds_param_view_entity( p_date = '20230101' ) ... SELECT * FROM demo_cds_param_view_entity( p_date = @( cl_abap_context_info=>get_system_date( ) ) ) ... SELECT * FROM demo_cds_param_view_entity( p_date = `20230101` ) ... SELECT * FROM demo_cds_param_view_entity( p_date = :$session.system_date ) ...

You want to join two database tables, T_CARRIER and T_CONNECTIONS, to retrieve all carriers, whether they have corresponding connections or not. Which statements would achieve this? Note: There are 2 correct answers to this question. SELECT FROM t_carrier INNER JOIN t_connections ON ... SELECT FROM t_carrier LEFT OUTER JOIN t_connections ON ... SELECT FROM t_carrier LEFT INNER JOIN t_connections ON ... SELECT FROM t_connections RIGHT OUTER JOIN t_carrier ON ...

Which function call returns 0?. find( val = 'FIND Found found' sub = 'F' occ = -2 CASE = abap_true ). find( val = 'find FOUND Found' sub = 'F' occ = -2 CASE = abap_false ). find( val = 'FIND FOUND FOUND' sub = 'F' ). find( val = 'find Found FOUND' sub = 'F' occ = -2 ).

When you work with a test class, you can set up some prerequisites before the actual testing. In which sequence will the following fixtures be called by the test environment?. class_setup() → setup() → teardown() → class_teardown(). setup() → teardown() → class_setup() → class_teardown(). class_teardown() → setup() → teardown() → class_setup(). teardown() → class_setup() → setup() → class_teardown().

Given the following code excerpt that defines an SAP HANA database table: DEFINE TABLE demo_table { KEY field1 : REFERENCE TO abap.clnt(3); KEY field2 : abap.char(1332); @Semantics.quantity.unitOfMeasure : 'demo_table.field4' field3 : abap.quan(2); field4 : abap.unit(2); } Which field is defined incorrectly?. field2. field3. field4. field1.

Given the following ABAP SQL statement excerpt from an ABAP program: SELECT SINGLE * FROM spfli WHERE carrid = 'LH' AND connid = '0400' INTO @DATA(wa). You are given the following information: The data source spfli on line #2 is an SAP HANA database table. spfli will be a large table with over one million rows. This program is the only one in the system that accesses the table. This program will run rarely. Based on this information, which of the following general settings should you set for the spfli database table? Note: There are 2 correct answers to this question. ''Storage Type'' to ''Row Store''. ''Storage Type'' to ''Column Store''. ''Load Unit'' to ''Column Loadable''. ''Load Unit'' to ''Page Loadable''.

In a booking record, how can you calculate the difference in days between the order date (type D) and the flight date (type D) of a flight?. data(gv_diff_days) = conv d( gs_booking-flight_date - gs_booking-order_date ). data(gv_diff_days) = gs_booking-flight_date - gs_booking-order_date. data(gv_diff_days) = gs_booking-order_date - gs_booking-flight_date. data(gv_diff_days) = conv d( gs_booking-order_date - gs_booking-flight_date ).

Which of the following rules apply for dividing with ABAP SQL? Note: There are 3 correct answers to this question. The division operator ''/'' accepts decimal input. Numeric function division( numerator, denominator, decimal places ) accepts decimal input. Numeric function div( numerator, denominator ) expects only integer input. The division operator ''/'' accepts floating point input. Numeric function division( numerator, denominator, decimal places ) accepts floating point input.

Given the following code which defines an SAP HANA database table in SAP S/4HANA Cloud, public edition: @EndUserText.label : 'Draft table for entity /DMO/R_AGENCY' @AbapCatalog.tableCategory : #TRANSPARENT @AbapCatalog.deliveryClass : #A @AbapCatalog.dataMaintenance : #RESTRICTED define table /dmo/agency_d { key mandt : mandt not null; key agencyid : /dmo/agency_id not null; key draftuuid : sdraft_uuid not null; name : /dmo/agency_name; street : /dmo/street; postalcode : /dmo/postal_code; city : /dmo/city; } You are a consultant and the client wants you to extend this SAP database table with a new field called zz_countrycode on line #14. Which of the following is the correct response?. The database table can be extended whether extensibility enabled or not if it is assigned to a software component of type ''Standard ABAP''. The database table cannot be extended since it has not been extensibility enabled by SAP. The database table can be extended once it has extensibility been enabled by the customer. The database table can be extended whether extensibility enabled or not if it is assigned to a software component of type ''ABAP Cloud''.

You want to extract date information of a flight date (f_info) and format it like yyyy-dd-mm using the following code: SELECT FROM TABLE dbtab1 FIELDS f1, extract_year( f_info ) && '-' && extract_month( f_info ) && '-' && extract_day( f_info ) ... For the extract_* functions to work, what can be the data dictionary types of f_info? Note: There are 3 correct answers to this question. TIMS. UTCLONG. TIMESTAMP. DATS. TIMN.

Which of the following are reasons that SAP recommends developing Core Data Services view entities as opposed to classic Core Data Services DDIC-based views? Note: There are 2 correct answers to this question. Automated client handling. Simplified syntax check. Simpler and stricter syntax. Elimination of the need for a database view.

What RESTful Application Programming feature is used to ensure the uniqueness of a semantic key?. Action. Validation. Determination. None of the above.

What describes multi-column internal tables?. They use one incomplete data type. They are based on a structured row type. They must contain nested components. They use one complete data type.

In RESTful Application Programming, a business object contains which parts? Note: There are 2 correct answers to this question. Process definition. Behavior definition. CDS view. Authentication rules.

When you join two database tables, which of the following rules applies to the database fields you use in the join?. They must be at the same position in their table, for example left_table-col1 = right_table-col1. They must always have an alias name. They must have the same name, e.g. col1 = col1. They must be compared with an ON condition.

What are some features of ABAP SQL? Note: There are 2 correct answers to this question. It is first processed by the Database Interface. It is integrated in the ABAP programming language. It is directly executed on the HANA database. It is only valid on the HANA database.

In a subclass sub1, you want to redefine a component of a superclass super1. How do you achieve this? Note: There are 2 correct answers to this question. You add the clause REDEFINITION to the component in sub1. You implement the redefined component for a second time in super1. You add the clause REDEFINITION to the component in super1. You implement the redefined component in sub1.

Which of the following types of Core Data Services Views can be used at the consumption layer? Note: There are 3 correct answers to this question. Table Function. Transactional Interface. Transactional Query. Analytical Query. Hierarchy.

Which statement can you use to change the contents of a row of data in an internal table?. INSERT. APPEND. UPDATE. MODIFY.

What is the purpose of a foreign key relationship between two tables in the ABAP Dictionary?. To create a corresponding foreign key relationship in the database. To ensure the integrity of data in the corresponding database tables. To document the relationship between the two tables. None of the above.

Which RAP object can be used to organize the display of fields in an app?. Metadata extension. Data model view. Projection view. Service definition.

To give authorization to users, in which order are the artifacts used?. 1) The IAM app uses the Authorization Object. 2) The Business Catalog uses the IAM app. 3) The Business Role uses the Business Catalog. 4) The Business User uses the Business Role. 1) The IAM app uses the Business Role. 2) The Business Role uses the Authorization Object. 3) The Authorization Object uses the Business Catalog. 4) The Business User uses the Authorization Object. 1) The IAM app uses the Business User. 2) The Business User uses the Business Catalog. 3) The Business Catalog uses the Business Role. 4) The Business Role uses the Authorization Object. 1) The IAM app uses the Business Catalog. 2) The Business Catalog uses the Business Role. 3) The Business Role uses the Business User. 4) The Business User uses the Authorization Object.

Which of the following integration frameworks have been released for ABAP Cloud development? (Select 3). CDS Views. Business events. OData services. Business Add-ins (BAdIs).

How do you make class sub1 a subclass of class super1?. In super1 use clause 'sub1 REDEFINITION' in the DEFINITION part. In sub1 use clause 'INHERITING FROM super1' in the IMPLEMENTATION part. In sub1 use clause 'INHERITING FROM super1' in the DEFINITION part. In super1 use clause 'sub1 REDEFINITION' in the IMPLEMENTATION part.

What is a class defined as part of an ABAP program called?. Local variable. Global variable. Global class. Local class.

How can you execute test classes? (Select 3). As a mass test when executing an ABAP Test Cockpit (ATC) check variant. As a mass test when releasing a transport request with the ABAP Transport Organizer. Interactively by calling function ''Run as a unit test'' from within the tested object. Interactively by calling function ''Run as a unit test'' from within the test class. Interactively during the release of transport request.

You have two database tables - ZDEPARTMENTS and ZEMPLOYEES. They are linked by a foreign key relationship: ZEMPLOYEES is the foreign key table and ZDEPARTMENTS is the check table. A department may have any number of employees (including none at all). What is the correct cardinality of the foreign key relationship?. [0..,1]. (0..1,1). (1..1,1). (1..,1).

Which of the following are reasons to use the side-by-side extensibility pattern? (3 correct). An extension is managed independently from SAP S/4HANA. An extension uses its own data model with occasional consumption of data in SAP S/4HANA. An extension implements reactive (event-based) process extensions. An extension runs in the same logical unit of work (LUW) as an SAP S/4HANA application. An extension enhances an existing SAP Fiori UI.

What can you do in SAP S/4HANA Cloud, public edition? (2 correct). Use SAP-released extension points. Use ABAP Development Tools in Eclipse (ADT). Modify SAP objects. Use Web Dynpros.

Given the following Core Data Services (CDS) View Entity data definition: DEFINE VIEW ENTITY demo_cds_view_entity AS SELECT FROM spfli { cityfrom, cityto, carrid, connid } When you attempt to activate the definition, what will be the response?. Activation error due to no key defined. Activation error due to missing annotation ''@AbapCatalog.sqlViewName''. Activation will be successful. Activation error due to missing annotation ''@AccessControl.authorizationCheck''.

What are some features of the current ABAP programming language? (Select 2). A data object's type can change at runtime. Keywords are case-sensitive. The code is expression-based. It has built-in database access.

You want to check the behavior of an ordinary class ZCL_ORDINARY with class LTCL_TEST. How do you specify LTCL_TEST as a test class?. Use the addition FOR TESTING in the class declaration of LTCL_TEST. Create a parameter in the SETUP method of LTCL_TEST and set its value to ''Test''. Use the addition FOR TESTING: LTCL_TEST in the class declaration of ZCL_ORDINARY. Create LTCL_TEST in a special package that is reserved for test classes.

Which models must you use to develop artifacts that expose ABAP-based backend services based on semantic data models? (Select 2). ABAP RESTful Application Programming Model. ABAP Cloud Development Model. Cloud Application Programming Model. ABAP Programming Model for SAP Fiori.

What are some necessary parts of the singleton pattern? (Select 3). Class creation is set to CREATE PRIVATE. Constructor visibility is set to private. Class method to create the singleton instance is set to private. Static attribute to store address of the singleton instance must exist. Class method to create the singleton instance must exist.

Which of the following actions cause an indirect change to a database table requiring a table conversion? (Select 2). Deleting a field from a structure that is included in the table definition. Changing the field labels of a data element that is used in the table definition. Shortening the length of a domain used in a data element that is used in the table definition. Renaming a field in a structure that is included in the table definition.

Which of the following are valid ABAP SQL type conversions? (Select 3 correct answers). CAST( 'field_f1' AS CHAR( 8 ) ) AS f_char8. CAST( field_f2 AS N( 8 ) ) AS f_n8. CAST( 29 AS INT8 ) AS f_int8. CAST( field_f5 AS DEC( 15, 2 ) ) AS f_dec_15_2. CAST( 34 AS I ) AS f_i34.

Which of the following are rules that extensions in SAP S/4HANA Cloud, public edition must adhere to? (Select 3 correct answers). Modify SAP objects in exceptional cases only. Use tier 2 wrappers to enable access to non-released SAP APIs. Use released remote or local SAP APIs. Use cloud-enabled and released technologies. Extend SAP objects through predefined extension points.

What is the syntax to access component carrier_name of structure connection?. connection>carrier_name. connection/carrier_name. connection-carrier_name. connection=>carrier_name.

Given this code, DATA(structure_variable) = REDUCE structure_type( INIT h_structure_variable TYPE structure_type FOR row IN source_itab NEXT h_structure_variable-f1 += row-f1 h_structure_variable-f2 += row-f2 ). Which of the following statements are correct? (Select 2 correct answers). row is a predefined name and cannot be changed. This REDUCE expression may produce a result of multiple rows. Components of h_structure_variable will be copied to same-named components of structure_variable. The REDUCE expression creates a loop over source_itab.

You have attached a system field to an input parameter of a CDS view entity as follows: define view entity Z_ENTITY with parameters @Environment.systemField: #SYSTEM_LANGUAGE language : spras What are the effects of this annotation? (Select 2 correct answers). The value of sy-langu will be passed to the CDS view automatically both when you use the CDS view in ABAP and in another CDS view entity (view on view). You can still override the default value with a value of your own. The value of sy-langu will be passed to the CDS view automatically when you use the CDS view in ABAP but not when you use it in another view entity. It is no longer possible to pass your own value to the parameter.

When you create an exception class, what does SAP recommend you do? (Select 3 correct answers). Define corresponding public attributes, if you want to pass context-specific values to placeholders of a message. Inherit from cx_static_check, if you want a warning at design time that the exception can never be raised. Inherit from cx_static_check, if you want a warning at design time that the exception will not be caught. Inherit from cx_no_check, if you want to reuse messages from a system exception class. Implement interface if_t100_message, if you want to reuse messages from a message class.

While debugging an ABAP program, you want the program to stop whenever the value of a variable changes. Which of the following do you use?. Exception breakpoint. Watchpoint. Conditional breakpoint.

Which of the following ABAP SQL aggregate functions accept an ABAP SQL expression (e.g., f1 + f2) as input? (Select 2 correct answers). avg(). max(). count(*). sum().

In a CDS view, where can a value help be defined?. In the SQL console. In an annotation. In an association. In a view definition.

Which function call produces the string 'LORE_IPSUM_FACTUM'?. from_mixed( val = 'LorelpsumFactum' sep = '_' ). condense( to_upper( 'LorelpsumFactum' ) ). to_upper( condense( 'LorelpsumFactum' ) ). to_mixed( val = 'LorelpsumFactum' sep = '_' ).

What can be translated? (Select 3 correct answers). Content of a string variable. Data element texts. Text literal. Message class. Text symbol.

Setting a field to read-only in which object would make the field read-only in all applications of the RAP model?. Projection view. Behavior definition. Metadata extension. Service definition.

Which of the following pre-defined ABAP data types is a complete data type?. p. d. c. n.

You select a field flight_date with type DATS in the field list of a CDS view. Which of the following expressions returns the 2-digit month from the field? (Select 2 correct answers). substring( flight_date, 5, 2 ). right( left( flight_date, 6 ), 2 ). left( right( flight_date, 6 ), 2 ). substring( flight_date, 4, 2 ).

Which statement creates a reference variable for class CL_VEHICLE?. TYPES lo_vehicle TYPE cl_vehicle. DATA lo_vehicle TYPE REF OF cl_vehicle. DATA lo_vehicle LIKE REF cl_vehicle. DATA lo_vehicle TYPE REF TO cl_vehicle.

In a RAP business object, where is the validation implementation code contained?. Local class. Function. Global class. Subroutine.

To which of the following rules must extensions in SAP S/4HANA, public cloud edition adhere? (Select 2 correct answers). Build at the UX layer. Use predefined extension points. Use CI / CD pipelines. Use released APIs.

Which of the following are features of Core Data Services (CDS)? (Select 3 correct answers). Associations. Delegation. Structured Query Language (SQL). Inheritance. Annotations.

Given the following code: DATA gv_text1 TYPE string. '#EC_NEEDED DATA gv_text2 TYPE string ##NEEDED. What are valid statements? (Select 2 correct answers). The pseudo-comment is checked by the syntax checker. The pragma is not checked by the syntax checker. ##NEEDED is checked by the syntax checker. #EC_NEEDED is not checked by the syntax checker.

What RAP object contains only the fields required for a particular app?. Projection view. Metadata extension. Database view. Data model view.

Which statements apply to the TRY-ENDTRY construct? (Select 3 correct answers). A CATCH clause can be used as a handler for several exception classes. A CLEANUP clause catches remaining exceptions. All matching CATCH clauses are always executed. A superclass in a CATCH clause catches exceptions of itself and of its subclasses. CATCH clauses should be organized ascending from most specific to most general.

Given the following Core Data Service View Entity Data Definition: @AccessControl.authorizationCheck: #NOT_REQUIRED DEFINE VIEW ENTITY demo_flight_info_union AS SELECT FROM scustom { KEY id, KEY 'Customer' AS partner, name, city, country } UNION SELECT FROM stravelag { KEY agencynum AS id, 'Agency' AS partner, name, city, country } When you attempt to activate the definition, what will be the response?. Activation error because the field types of the union do not match. Activation error because the key fields of the union do not match. Activation successful. Activation error because the field names of the union do not match.

You have the following CDS definition (aliases shown): define view entity Z_ENTITY as select from Z_SOURCE1 as _Source1 association to Z_SOURCE2 as Source2 on ??? { key carrier_id as Carrier, key connection_id as Connection, cityfrom as DepartureCity, cityto as ArrivalCity, Source2 } (The data sources are joined by the field carrier_id. The corresponding field in Z_SOURCE2 is also carrier_id.) Which ON condition must you insert?. ON Z_SOURCE1.carrier_id = Z_SOURCE2.carrier_id. ON $projection.carrier_id = Z_SOURCE2.carrier_id. ON $projection.Carrier = _Source2.carrier_id. ON _Source1.carrier_id = Source2.carrier_id.

Which of the following results in faster access to internal tables? (Select 3 correct answers). In a sorted internal table, specifying the primary key completely. In a standard internal table, specifying the primary key partially from the left without gaps. In a sorted internal table, specifying the primary key partially from the left without gaps. In a hashed internal table, specifying the primary key partially from the left without gaps. In a hashed internal table, specifying the primary key completely.

Given this code, INTERFACE if1. METHODS m1. ENDINTERFACE. CLASS cl1 DEFINITION. PUBLIC SECTION. INTERFACES if1. METHODS m2. ENDCLASS. ' in a method of another class DATA go_if1 TYPE REF TO if1. DATA go_cl1 TYPE REF TO cl1. go_cl1 = NEW #( ... ). go_if1 = go_cl1. What are valid statements? (Select 3 correct answers). Instead of go_cl1 = NEW #( ... ) you could use go_if1 = NEW cl1( ... ). Instead of go_cl1 = NEW #( ... ) you could use go_if1 = NEW #( ... ). go_if1 may call method m2 with go_if1->m2( ... ). go_if1 may call method m1 with go_if1->m1( ... ). go_cl1 may call method m1 with go_cl1->if1~m1( ... ).

You want to document a global class with ABAP Doc. What do you need to consider? (Select 3 correct answers). The documentation may contain tags like <strong> </strong>. The documentation has to be positioned directly after the declarative statement. The documentation can contain links to other repository object's documentation. The documentation can be translated. The documentation starts with !.

Which language is used to add or change data of a business object in RAP?. Data manipulation language. Entity manipulation language. Data modification language. RAP editing language.

Which of the following are personas under the SAP S/4HANA Cloud Extensibility Framework? (Select 2 correct answers). Report Writer. Business Expert. Workflow Administrator. Citizen Developer.

Which of the following enforce ABAP Cloud rules? (Select 2 correct answers). ABAP release contracts. ABAP platform reuse services. ABAP compiler. ABAP runtime checks.

You have a superclass super1 and a subclass sub1 of super1. Each class has an instance constructor and a static constructor. The first statement of your program creates an instance of sub1. In which sequence will the constructors be executed?. Class constructor of sub1 Instance constructor of super1 Instance constructor of sub1 Class constructor of super1. Class constructor of super1 Class constructor of sub1 Instance constructor of super1 Instance constructor of sub1. Instance constructor of super1 Class constructor of super1 Class constructor of sub1 Instance constructor of sub1. Instance constructor of sub1 Instance constructor of super1 Class constructor of super1 Class constructor of sub1.

Which of the following Core Data Services built-in functions returns a result of type INT4? (Select 2 correct answers). dats_add_months. dats_is_valid. dats_add_days. dats_days_between.

Constructors have which of the following properties? (Select 2 correct answers). The constructor is automatically called during instantiation. The constructor can have importing parameters. The constructor must be the first method called by the client. The constructor can have returning parameters.

Which internal table type allows unique and non-unique keys?. Hashed. Sorted. Standard.

You want to define the following CDS view entity with an input parameter: define view entity Z_CONVERT with parameters i_currency : ??? Which of the following can you use to replace ???? (Select 2 correct answers). A built-in ABAP Dictionary type. A built-in ABAP type. A component of an ABAP Dictionary structure. A data element.

In CDS views, what do joins and associations have in common? (Select 2 correct answers). An alias can be assigned to the data sources and to the fields in the field list. They can expose an entire data source without listing individual fields. The data sources are linked using an ON clause. The field list can include fields of the linked table without specifying the name of the corresponding data source.

Which of the following is a technique for defining access controls?. Inheritance. Redefinition. Singleton. Casting.

How can you control data access of a business user? (Select 3 correct answers). To control the general access implicitly via an Access Control object (define role). To control the 'Create, Update, and Delete access' via explicit check using AUTHORITY-CHECK. To control the 'Create, Update, and Delete access' implicitly via an Access Control object (define role). To control the 'Read access' implicitly via an Access Control object (define role). To control the 'Read access' via explicit check using AUTHORITY-CHECK.

Which of the following custom code use cases falls under Tier 1 extensibility guidelines?. Implement a user or customer exit, for example SAPMV45A. Create a custom field on a DB table or CDS view via a released extension include. Apply an SAP note with manual corrections, for example a DDIC object from SAP Basis. Create a wrapper class around SAP objects that have not been released yet.

Given the following data definitions: DATA: text TYPE string VALUE 'Date 1972-04-01 is in ISO format'. DATA: regex TYPE string VALUE '[0-9]{4}(-[0-9]{2})(2}'. In which of the following functions can you use regular expressions? (Select 3 correct answers). reverse( val = text pcre = regex ). match( val = text pcre = regex ). condense( val = text pcre = regex ). matches( val = text pcre = regex ). find( val = text pcre = regex ).

Given the following ABAP code, which exception will be raised on execution? CONSTANTS c_char TYPE c LENGTH 1 VALUE ' '. TRY. result = 2 / c_char. out->write( |Result: { result }| ). CATCH cx_sy_zerodivide. out->write( |Error: Division by zero is not defined| ). CATCH cx_sy_conversion_no_number. out->write( |Error: { c_char } is not a number!| ). CATCH cx_sy_itab_line_not_found. out->write( |Error: Itab contains less than { 2 / c_char } rows| ). ENDTRY. cx_sy_zerodivide. cx_sy_conversion_no_number. cx_sy_itab_line_not_found.

What are some principles of encapsulation? (Select 2 correct answers). Attributes can be changed through public class methods. Attributes can be changed by the client program directly. Attributes cannot be changed. Attributes can only be changed by the class.

After you created a database table in the RESTful Application Programming model, what do you create next?. A data view. A service definition. A metadata extension. A projection view.

In a class you use the statement DATA var TYPE ... What may stand in place of the type? (Select 2 correct answers). The name of a type defined privately in class ZCL_CLASS_A. The name of a domain from the ABAP Dictionary. The name of a type defined privately in another class. The name of a data element from the ABAP Dictionary.

When defining a METHOD, which parameter type can only have 1 value?. IMPORTING. EXPORTING. CHANGING. RETURNING.