Interview Questions.

Q1. What Are Formula Variables?

These are variables utilized in calculations inside the question; for example take a client cut price file wherein each customer is given a one of a kind percentage discount; you create a formula variable for the bargain percent and use it inside the calculated key parent.

Q2. I Am Currently Using A Standard Task Ts 00008314 (bus2038) To Launch Work Flow When Notification Is Created. Given This, How Can I Define Notification Type (only M1)? Subsequently, How I Can Launch A

You can create a start situation (transaction: SWB_COND) and set it to begin if the notification kind is M@Just make sure to file this due to the fact months from now you may not recall why it starts offevolved selectively for a few and now not others. For the second question - if you are trying to inform the agent that they have a undertaking, then strive placing this general mission right into a custom 2 step workflow template. The first step of the template need to send an specific mail then the following step must mechanically ship the project.

Q3. What Is The Difference Between Ods And Infocube And Multiprovider?

• ODS: Provides granular records, permits overwrite and records is in obvious tables, perfect for drilldown and RRI.

• CUBE: Follows the celebrity schema, we are able to best append facts, best for primary reporting.

• MultiProvider: Does no longer have bodily facts. It permits to get admission to statistics from one of a kind InfoProviders (Cube, ODS, InfoObject). It is also desired for reporting.

Q4. How Do You Create A Value Set?

Use the AWB -> Reporting agent and pick the cost set icon on the left.

Q5. What Is The Difference Between Sending A Mail To A Recipient List Compared To Sending Individual Mails Via A Dynamic Loop?

Performance. Sending 1 mail to twenty recipients will value appreciably much less overall performance than sending 20 individual mails. If the mail is sent as a SAP Office mail (as opposed to electronic mail, fax...) disk space will also be a thing due to the fact the SAP workplace mail will only exist once within the database, with references being created for each of the recipients.

The best time you need to cons ider character mails with a dynamic loop is when the text of the mail varies from one recipient to every other.

Q6. What Are The Special Conversions For Time In Update Rules?

Time dimensions are automatically converted; for instance if the cube carries calendar month and your transfer structure contains date, the date to calendar month is transformed automatically.

Q7. What Is An Exception?

Exception is not a filter (like circumstance) however used to focus on reviews with exclusive colorings for unusual key figures; as an instance you could want to reveal purple for all accounts receivables which might be older than ninety days and yellow for older than 60 days.

Q8. What Is An Event Chain?

This is a set of occasions which complete independently of one another; use this to check the successful popularity of a couple of occasions; for example you may cause a chain occasion if all hundreds are a success.

Q9. What Are Transfer Rules?

The transformation rules for information from source gadget to data supply/verbal exchange shape.

Q10. What Are The Important Aggregation Usage Indicators?

A. Number of records. 

B. Summarization ration (compression) .

C. Last used date — do not forget if you don’t see any current interest then this combination isn't used.

Q11. What Are The Destination Target Options?

CSV record or database table.

Q12. What Is The Ods Object Settings?

Defines range of parallel processors in activation, mm range of data facts and wait time.

Q13. What Is A Star Schema?

A fact desk on the middle and surrounded (connected) by using size tables.

Q14. What Are The Advantages Of Using Ods In A Infoset For Reporting?

A. Access thru OLAP engine.

B. Infosets can join flat BW gadgets like master data attributes, etc.

Q15. What Is A Characteristic In Co-pa?

These are described as degrees wherein information is maintained; example customer companies, divisions, etc.

Q16. Why If One Request Fails, All The Subsequent Requests Are Turned To "pink"?

This is to avoid inconsistency and ensure that handiest proven information is entered into the system.

Q17. How To Create Condition And Exceptions In Bi.7.Zero? But I Know In Bw3.Five Version.?

From a query name or description, you would no longer be able to choose whether or not the question is having any exception.There are  methods of locating exception against a question:@Execute queries separately, the only that's having background colour as exception reporting are with exceptions.@Open queries in the BEX Query Designer. If you are locating exception tab at the right facet of clear out and rows/column tab, the question is having exception.

Q18. When We Use Condition The Totals Do Not Match Why?

By default the report suggests typical effects general and not the results overall simplest for the filtered outcomes; to show the proper totals you ought to use “Summation” inside the key figure houses instead of “Nothing described”.

Q19. Can You Make An Info Object As Info Provider And Why?

Yes, When you need to document on characterstics or master records, you may make them as information company. Ex: you may make 0CUSTMER as info company and do Bex reporting on zero CUSTOMER;right click on the data area and pick Insert characterstic as records goal.

Q20. What Are The Steps To Create Classes?

A. Define the homes

b. Create class kinds; this controls the instructions assigned to them; as an example elegance type can be material

c. Create classes and assign to a category kind; as an instance magnificence can be virtual cameras

d. Assign gadgets

e. Now searches may be completed on lessons; as an example get all of the cameras with 3.Zero mega pixels.

F. These values are transferred to BW as Omaterial attributes

Q21. What Are The Two Fact Tables?

There are  reality tables for every information cube; it's far the E table and the F table;

Q22. How Do You Set Up The Permitted Characters?

Using transaction RSKC.

Q23. What Is Ods?

Operations information Source you may overwrite the existing records in ODS.

Q24. What Are Non Cumulative Key Figures?

These varieties of key figures are not summarized (unlike income, and many others); examples are head be counted, inventory quantity; these are always in relation to some extent in time; for instance we are able to ask what number of employees we had as of closing sector. We don’t add up the head rely.

Q25. What Are The Control Parameters For Data Transfer?

This defines the most size of packet, max no of statistics per packet, the wide variety of parallel strategies, and so on.

Q26. What Are The Combined Tests?

A. Master statistics.

B. Transaction information.

C. Hierarchies. 

D. Database .

E. Aggregation.

Q27. What Is Inflow And Outflow?

These are non cumulative adjustments used to get the proper amount.

Q28. What Does A Boolean Operator Returns?

1 or 0.

Q29. What Are The Minimum No Of Dimensions In Info Cube?

Four(three Sap defined and 1 client described).

Q30. What Are The Sap Enhancements To Enhance Fir Data?

HRPTDWO1 - for HR time associated information.

Q31. What Are The Steps To Create Db Connect?

A. First verify that the DB connection works from the server

b. AWB -> Source systems -> create

c. Select Database source system

d. Enter the database consumer name, password and join string; as an example Oracle input the TNS name

e. Generate the statistics source using transaction RSDBC

f. Assign information supply to data supply

g. Maintain and activate communique structure and switch rules

h. Create information package and load records

Q32. What Is Info Object Otctauthh?

This is used in hierarchy authorization.

Q33. What Is Aggregate Realignment Run Maintenance?

Defines the extent of percentage exchange for realignment run will reason a reconstruction of aggregates.

Q34. What Is The New Features Of Ods After Version three.X?

A. You may load and prompt ODS in parallel.

B. NoM table .

C. Secondary indexes are created in ODS gadgets itself .

D. Selective deletion.

Q35. What Does The Variable_screen Url Parameter Do?

An X will pressure the net document to display the variables entry display screen.

Q36. What Are The Parameters Available In User Exit For Enhancing Master Data?

A. I_T_FIELDS - list of switch structure fields

b. I_T_DATA - internal desk containing statistics for the master attributes; remember this incorporates all records

c. LUPDMODE - replace mode

d. I_CHABASNM - simple characteristics

e. I_SOURCE - call of the info supply

Q37. What Are Value Sets?

Using reporting agent you may fill values for a selected characteristic within the history; anticipate that each day you generate a detailed report at the top 10 merchandise; to get the pinnacle 10 merchandise you run another query with situation; so the parent question may be described as a fee set returning values for OMATERIAL.

Q38. What Are The 3sap Defined Dimensions?

The three SAP described dimensions are…..

@Data packet measurement (P)…..It incorporates 3characteristics.A) request Id (b) Record type (c) Change run id

@Time measurement (T)….It incorporates time traits together with 0calmonth, 0calday and many others

@Unit Dimension (U)…it carries basically quantity and quantity associated units.

Q39. How Can I Configure The Workflow So That When The Deadline Is Missed The Workflow Step Is Simply Skipped?

This is difficult to provide an explanation for however easy to put in force as soon as you know how.

Follow these steps (in later releases there may be a wizard which takes you through the stairs):

@In the terminating occasions view of the workflow step prompt the "out of date" occasion and deliver it a name.

@Specify a cut-off date length for the step.

@Specify a call for the event. This adds new department from the step.

@Add a brand new step to the deadline direction. This step have to be of kind "process control".

@Select the manage "Make step out of date" and use the search help to specify the workflow step that has the closing date. Only steps with obsolete paths described could be displayed (see step 1).

Q40. What Is The Use ':' As An Authorization Value?

A. It enables queries that do not include a authorization relevant item that have been checked in data cube.

B. It lets in precis information to be displayed if the consumer does not have get right of entry to to specified information; for instance if you create 2 authorizations for one user one with Sales Org  and customers and 2d with income org a thousand and customers  the user sees all customers for income org 1000 and most effective summarized report for other income org.

Q41. What Are Conversion Routines For Units And Currencies In The Update Rule?

• Using this feature we will write ABAP code for Units / Currencies conversion. If we allow this flag then unit of Key Figure appears inside the ABAP code as an extra parameter. For instance, we can convert gadgets in Pounds to Kilos.

Q42. What Are Intervals?

This is to institution leaves collectively robotically; so when a new cost is added to a traits it's miles delivered to the proper c program languageperiod robotically.

Q43. What Are The Limitations Of Line Item Dimension?

Only one function is permitted in step with line item dimension.

Q44. What Are The Other Variables?

A. 1_VARTYP - variable type 1 — function, 2- hierarchy node , 3-text, 4- system, five-hierarchy.

B. I_IOBJNM - call of the information item.

Q45. What Are The Aggregation Options For Key Figures?

If you're defining charges then you can need to set “no aggregation” or you could outline max, mm, sum; you could also outline exception aggregation like first, final, and many others; that is useful in getting headcount; for instance if you define a monthly inventory count key parent you need the count as of remaining day of the month.

Q46. What Is The Attributes Only Flag?

If the flag is ready, no grasp statistics is stored; this is only used as attribute for other characteristics; for instance comments on a AR file.

Q47. What Is The Sap Enhancement Used For This User Exit?

RSR00001.

Q48. How Do I Send Really Complex Mails From The Workflow?

If you this is not sufficient for you'll in all likelihood want to put in writing your personal ABAP routines for generating the textual content and generating the attachments to go together with the text.

Use the characteristic group SO01 which incorporates features of the shape SO_*_API1 which can be ideal for developing your own state-of-the-art messages. There are masses of benefits of the way these are used in the SAP system.

Q49. How Do You Transform Open Hub Data?

• Using BADI we can remodel Open Hub Data in step with the vacation spot requirement.

Q50. What Are The Delta Options Available When You Load From Flat File (you Set The Delta Mode In The Transfer Structure -update Mode Field)?

A. New repute best; this sends information of modified records; only ODS and dice can't be used.

B. Additive delta — just change in key figures is despatched; can be used in ODS and in dice.