Free SAP C_HCMOD_01 Exam Dumps Questions & Answers

You create a table function to remove historic records, sum the current total weekly working hours for each employee, and update the personnel table with the results. The deployment of the table function fails. Which of the following could be a valid reason?

• A.  You did NOT define a valid table type.
• B.  You did not define at least one input parameter.
• C.  Your function refers to a scalar function.
• D.  Your function includes a TRUNCATE statement.

In a calculation view, why would you implement an SQL expression? Note: There are 3 correct answers to this question.

• A.  To generate a calculated column
• B.  To convert currencies
• C.  To define a filter
• D.  To generate hierarchies
• E.  To generate a restricted column

What is the SQL keyword used to process input parameters defined in a calculation view?

• A.  WHERE
• B.  SET
• C.  PLACEHOLDER
• D.  HINT

You combine two customer master data tables with a union node in a calculation view. Both master data tables include the same customer name. How do you ensure that each customer name appears only once in the results?

• A.  Define a restricted column in a union node.
• B.  Include an aggregation node above the union node.
• C.  Add an intersect node above the union node.
• D.  In the union node, map both source customer name columns to one target column.

What options do you have to handle orphan nodes in your hierarchy? Note: There are 2 correct answers to this question.

• A.  Generate additional root nodes.
• B.  Assign them to a node at the root level.
• C.  Assign them to a level below the root.
• D.  Define an expression to determine a parent.