SAP SAP Certified Associate C_ABAPD_2309 Questions & Answers

• Question 1:

  What are some features of a unique secondary key? Note: There are 2 correct answers to this question.

  A. It is created when a table is filled.

  B. It is updated when the modified table is read again.

  C. It is created with the first read access of a table.

  D. It is updated when the table is modified.

  Correct Answer: CD

  A unique secondary key is a type of secondary key that ensures that the key combination of all the rows in a table is unique. A unique secondary key has two purposes: firstly, to speed up access to the table, and secondly, to enforce data

  integrity1. It is created with the first read access of a table: This is true. A unique secondary key is created when an internal table is filled for the first time using the statement READ TABLE or a similar statement. The system assigns a name

  and an index to each row of the table based on the key fields23.

  It is updated when the modified table is read again: This is false. A unique secondary key does not need to be updated when the internal table content changes, because it already ensures data uniqueness. The system uses a lazy update

  strategy for non-unique secondary keys, which means that it delays updating them until they are actually accessed23.

  You cannot do any of the following:

  It is created when a table is filled: This is false. As explained above, a unique secondary key is created only with the first read access of a table23. It is updated when the modified table is read again: This is false. As explained above, a unique

  secondary key does not need to be updated when the internal table content changes23.

  References: 1: Improving Internal Table Performance Using Secondary Keys - SAP Learning 2: [Secondary Key - ABAP Keyword Documentation - SAP Online Help] 3:

  [Secondary Table Key - ABAP Keyword Documentation - SAP Online Help]

• Question 2:

  In this nested join below in which way is the join evaluated?

  

  A. From the left to the right in the order of the tables:

  1.

  a is joined with b

  2.

  b is joined with c

  B. From the right to the left in the order of the tables:

  1.

  b is joined with c.

  2.

  b is joined with a.

  C. From the top to the bottom in the order of the on conditions 1. b is joined with c

  2.

  a is joined with b

  D. From the bottom to the top in the order of the on conditions:

  1.

  a is joined with b

  2.

  b is joined with c

  Correct Answer: C

  The nested join is evaluated from the top to the bottom in the order of the ON conditions. This means that the join expression is formed by assigning each ON condition to the directly preceding JOIN from left to right. The join expression can be parenthesized implicitly or explicitly to show the order of evaluation. In this case, the implicit parentheses are as follows: SELECT * FROM (a INNER JOIN (b INNER JOIN c ON b~c = c~c) ON a~b = b~b) This means that the first join expression is b INNER JOIN c ON b~c = c~c, which joins the columns of tables b and c based on the condition that b~c equals c~c. The second join expression is a INNER JOIN (b INNER JOIN c ON b~c = c~c) ON a~b = b~b, which joins the columns of table a and the result of the first join expression based on the condition that a~b equals b~b. The final result set contains all combinations of rows from tables a, b, and c that satisfy both join conditions. References: 1: SELECT, FROM JOIN - ABAP Keyword Documentation - SAP Online Help

• Question 3:

  In class ZCL_CLASS_A, you use the statement DATA var TYPE ***

  What may stand in place of ***? Note: There are 2 correct answers to this question.

  A. The name of a type defined privately in class ZCL_CLASS_A

  B. The name of a data element from the ABAP Dictionary

  C. The name of a type defined privately in another class

  D. The name of a domain from the ABAP Dictionary

  Correct Answer: BD

  In class ZCL_CLASS_A, you use the statement DATA var TYPE *** to declare a data object named var with a data type specified by ***. The data type can be any of the following1:

  A predefined ABAP type, such as i, f, c, string, xstring, and so on. A data element from the ABAP Dictionary, such as matnr, carrid, bukrs, and so on. A data element defines the semantic and technical attributes of a data field, such as the

  domain, the length, the data type, the description, and the value range2.

  A domain from the ABAP Dictionary, such as matnr_d, carrid_d, bukrs_d, and so on. A domain defines the technical attributes of a data field, such as the data type, the length, the output length, the number of decimal places, and the value

  range3. A type defined globally in a class, an interface, or a type pool, such as zcl_class_b=>type_a, zif_interface_c=>type_b, ztype_pool_d=>type_c, and so on. A global type is a type that is defined in a global repository object and can be

  used in any program or class4.

  A type defined locally in the current class, such as type_a, type_b, type_c, and so on. A local type is a type that is defined in the declaration part of a class and can only be used within the class5.

  Therefore, the possible values for *** are B. the name of a data element from the ABAP Dictionary and D. the name of a domain from the ABAP Dictionary. The other options are not valid because:

  A. The name of a type defined privately in class ZCL_CLASS_A is a local type and cannot be used with the DATA statement. A local type can only be used with the TYPES statement5.

  C. The name of a type defined privately in another class is a private type and cannot be accessed from outside the class. A private type can only be used within the class that defines it.

  References: 1: DATA - ABAP Keyword Documentation 2: Data Elements - ABAP Dictionary - SAP Online Help 3: Domains - ABAP Dictionary - SAP Online Help 4: Global Types - ABAP Keyword Documentation 5: Local Types - ABAP

  Keyword Documentation :

  Private Types - ABAP Keyword Documentation

• Question 4:

  Which extensibility type does SAP recommend you use to enhance the existing UI for an SAP Fiori app?

  A. Key user

  B. Classic

  C. Side-by-side

  D. Developer

  Correct Answer: D

  Explanation: According to the SAP clean core extensibility and ABAP cloud topic, SAP recommends using developer extensibility to enhance the existing UI for an SAP Fiori app. Developer extensibility allows you to use the UI adaptation editor in SAP Web IDE to modify the UI layout, add or remove fields, and bind them to the data model. You can also use the SAPUI5 framework to create custom controls, views, and controllers. Developer extensibility is based on the in-app extensibility concept, which means that the extensions are part of the same application and are deployed together with the app. Developer extensibility requires developer skills and access to the source code of the app. References: SAP Learning Hub, SAP S/4HANA Cloud Extensibility - In-App Extensibility, SAP Fiori: Extensibility

• Question 5:

  As a consultant you are posed the following question from a client who is using SAP S/4HANA Cloud, public edition and also SAP BTP, ABAP environment.

  "We are currently using an SAP Fiori app based on SAP Fiori elements that analyzes open orders. We have determined that it should be extended via a new button on the UI which will perform an on-the-fly calculation and display the result in a quick popup for the enduser. We have been informed by SAP that all underlying stack layers for the SAP Fiori app have been extensibility enabled."

  Based on this which of the following extension types would you recommend to the customer to add the new button?

  A. RAP BO Behavior Extension

  B. SAP HANA database table extension

  C. RAP BO Node Extension

  D. Business Service Extension

  Correct Answer: C

• Question 6:

  What would be the correct expression to change a given string value 'mr joe doe' into 'JOE' in an ABAP SQL field list?

  A. SELECT FROM TABLE dbtabl FIELDS Of1, upper(left( 'mr joe doe', 6)) AS f2_up_left, f3,

  B. SELECT FROM TABLE dbtabl FIELDS Of1, left(lower(substring( 'mr joe doe', 4, 3)), 3) AS f2_left_lo_sub, f3,

  C. SELECT FROM TABLE dbtabl FIELDS Of1, substring(upper('mr joe doe'), 4, 3) AS f2_sub_up, f3,...

  D. SELECT FROM TABLE dbtabl FIELDS Of1, substring(lower(upper( 'mr joe doe' ) ), 4, 3) AS f2_sub_lo_up, f3,

  Correct Answer: C

  The correct expression to change a given string value `mr joe doe' into `JOE' in an ABAP SQL field list is C. SELECT FROM TABLE dbtabl FIELDS Of1, substring(upper(`mr joe doe'), 4, 3) AS f2_sub_up, f3,... This expression uses the

  following SQL functions for strings12:

  upper: This function converts all lowercase characters in a string to uppercase. For example, upper(`mr joe doe') returns `MR JOE DOE'. substring: This function returns a substring of a given string starting from a specified position and with a

  specified length. For example, substring(`MR JOE DOE', 4, 3) returns `JOE'.

  AS: This keyword assigns an alias or a temporary name to a field or an expression in the field list. For example, AS f2_sub_up assigns the name f2_sub_up to the expression substring(upper(`mr joe doe'), 4, 3).

  You cannot do any of the following:

  A. SELECT FROM TABLE dbtabl FIELDS Of1, upper(left( `mr joe doe', 6)) AS f2_up_left, f3,...: This expression uses the wrong SQL function for strings to get the desired result. The left function returns the leftmost characters of a string with a specified length, ignoring the trailing blanks. For example, left( `mr joe doe', 6) returns `mr joe'. Applying the upper function to this result returns `MR JOE', which is not the same as `JOE'.

  B. SELECT FROM TABLE dbtabl FIELDS Of1, left(lower(substring( `mr joe doe', 4, 3)), 3) AS f2_left_lo_sub, f3,...: This expression uses unnecessary and incorrect SQL functions for strings to get the desired result. The lower function converts all uppercase characters in a string to lowercase. For example, lower(substring ( `mr joe doe', 4, 3)) returns `joe'. Applying the left function to this result with the same length returns `joe' again, which is not the same as `JOE'. D. SELECT FROM TABLE dbtabl FIELDS Of1, substring(lower(upper( `mr joe doe' ) ), 4, 3) AS f2_sub_lo_up, f3,...: This expression uses unnecessary and incorrect SQL functions for strings to get the desired result. The lower function converts all uppercase characters in a string to lowercase, and the upper function converts all lowercase characters in a string to uppercase. Applying both functions to the same string cancels out the effect of each other and returns the original string. For example, lower(upper( `mr joe doe' ) ) returns `mr joe doe'. Applying the substring function to this result returns `joe', which is not the same as `JOE'. References: 1: SQL Functions for Strings - ABAP Keyword Documentation - SAP Online Help 2: sql_func - String Functions - ABAP Keyword Documentation - SAP Online Help

• Question 7:

  When does SAP recommend to use a sorted or a hashed table respectively? Note: There are 2 correct answers to this question.

  A. A hashed table, when you read a single record and specify the complete key.

  B. A hashed table, when you read a subset in a loop and specify a part of the key from the left without gaps.

  C. A sorted table, when you read a subset in a loop and specify a part of the key from the left ^ without gaps.

  D. A sorted table, when you read a single record and specify non key fields.

  Correct Answer: AB

• Question 8:

  Which RESTful Application Programming object can be used to organize the display of fields in an app?

  A. Data model view

  B. Metadata extension

  C. Service definition

  D. Projection view

  Correct Answer: B

  A metadata extension is a RESTful Application Programming object that can be used to organize the display of fields in an app. A metadata extension is a CDS view that annotates another CDS view with UI annotations, such as labels, icons, or facets. These annotations define how the data should be presented in the app, such as which fields should be shown on the object page, which fields should be editable, or which fields should be used for filtering or sorting. A metadata extension can also be used to add custom actions or validations to the app12. References: 1: Refine the Object Page with Annotations | SAP Tutorials 2: ABAP RAP : Enabling custom actions with a dialog for additional input fields | SAP Blogs

• Question 9:

  Which function call returns 0?

  A. Count_any_of ( val - `ABAP ABAP abap' sub "AB" )

  B. Count (val - 'ABAP ABAP abap' sub - 'AB' )

  C. find_any_of (val = "ABAP ABAP abap' sub = "AB")

  D. find_any_not_of( val 'ABAP ABAP abap' sub = 'AB')

  Correct Answer: D

  Explanation: The function find_any_not_of returns the position of the first character in the string val that is not contained in the string sub. If no such character is found, the function returns 0. In this case, the string val contains only the characters A, B, and a, which are all contained in the string sub, so the function returns 0. The other functions return positive values, as follows: Count_any_of returns the number of occurrences of any character in the string sub within the string val. In this case, it returns 8, since there are 8 A's and B's in val. Count returns the number of occurrences of the string sub within the string val. In this case, it returns 2, since there are 2 AB's in val. find_any_of returns the position of the first character in the string val that is contained in the string sub. In this case, it returns 1, since the first character A is in sub. References: String Functions - ABAP Keyword Documentation, Examples of String Functions - ABAP Keyword Documentation

• Question 10:

  You have two internal tables itab1 and itab2.What is true for using the expression itab1 = corresponding #( itab2 )? Note: There are 2 correct answers to this question.

  A. Fields with the same name but with different types may be copied from itab2 to itab1.

  B. itab1 and itab2 must have at least one field name in common.

  C. Fields with the same name and the same type will be copied from itab2 to itab1.

  D. itab1 and itab2 must have the same data type.

  Correct Answer: BC

  The expression itab1 = corresponding #( itab2 ) is a constructor expression with the component operator CORRESPONDING that assigns the contents of the internal table itab2 to the internal table itab1. The following statements are true for using this expression:

  B: itab1 and itab2 must have at least one field name in common. This is because the component operator CORRESPONDING assigns the identically named columns of itab2 to the identically named columns of itab1 by default, according to the rules of MOVE-CORRESPONDING for internal tables. If itab1 and itab2 do not have any field name in common, the expression will not assign any value to itab1 and it will remain initial or unchanged1

  C: Fields with the same name and the same type will be copied from itab2 to itab1. This is because the component operator CORRESPONDING assigns the identically named columns of itab2 to the identically named columns of itab1 by default, according to the rules of MOVE-CORRESPONDING for internal tables. If the columns have the same name but different types, the assignment will try to perform a conversion between the types, which may result in a loss of precision, a truncation, or a runtime error, depending on the types involved1 The following statements are false for using this expression:

  A: Fields with the same name but with different types may be copied from itab2 to itab1. This is not true, as explained in statement C. The assignment will try to perform a conversion between the types, which may result in a loss of precision, a truncation, or a runtime error, depending on the types involved1

  D: itab1 and itab2 must have the same data type. This is not true, as the component operator CORRESPONDING can assign the contents of an internal table of one type to another internal table of a different type, as long as theyhave at least one field name in common. The target type of the expression is determined by the left-hand side of the assignment, which is itab1 in this case. The expression will create an internal table of the same type as itab1 and assign it to itab11 References: CORRESPONDING - Component Operator - ABAP Keyword Documentation