When defining aggregates what are the options available?
Ans:
The groups are according to the characteristics:
H – Hierarchy
F – Fixed Value
B – None
32
What are transfer rules?
Ans:
The transformation rules are for the data from source system to info source or communication structure.
33
What is the procedure to debug errors with SAP GUI like Active X error?
Ans:
Run Bex analyzer>Business Explorer menu item > Installation check, this shows an excel sheet with a start button; click on it; this verifies the GUI installation; if u find any errors either reinstall or fix it.
34
What is the global transfer rule?
Ans:
Global Transfer rule is a transfer routine (ABAP) defined at the info object level; which is common for all source systems.
35
What is the first step performed when user exit for variables are written?
Ans:
When the user exit for variables is written it would be used in ABAP code as a conditional check
36
What are the options available in the transfer rule Assign info object, assign a constant, ABAP routine or a Formula?
Ans:
The following are the options available in the transfer rule are:
Assign Info Object – Direct Transfer, no Transformation.
Assign a Constant – For example while loading data from a specified country in a flat file, it can make the country as constant and assign the value.
ABAP Routine – For Example to do some complex string manipulation, assume that they are getting a flag file from legacy data and the cost center is in a field and it contains message the data to get it, in this case ABAP code is used.
Formula – For example for simple calculations use formula, to convert all lower case characters to upper case use the To Upper Formula.
37
What is the procedure to replace a query result from a master query to a child query?
Ans:
If a characteristic value is selected with replacement path then it uses the results from previous query for example assume that we have query Q1 which display the top 10 customers, we have query Q2 which gets the top 10 customers for info object 0CUSTOMER with as a variable with replacement path and display detailed report on the customers list passed from Q1.
38
Give some available formulas?
Ans:
Some available formulas are Concatenate, sub string, condense, left/right characters, 1_trim, r_trim, replace, date routines like DATECONV, date-week, add to date, date different, logical functions.
39
How do you define exception reporting in the background?
Ans:
By using the reporting agent, from the AWB click on the exception icon on the left; give a name and description. Select the exception from query for reporting (drag and drop).
40
What are the important variables generally used and when do the ABAP code for transfer rule?
Ans:
The important variables generally used by the ABAP code for transfer rule are:
Result – This gets the result of the ABAP code.
Return Code – It set this to 0 if everything is OK, else this record is skipped.
Abort – Set this to a value not 0, to abort the entire package.