SAP BW Interview Questions - Part A

1. What are the extractor types?
• Application Specific
o BW Content FI, HR, CO, SAP CRM, LO Cockpit
o Customer-Generated Extractors
• Cross Application (Generic Extractors)
o DB View, InfoSet, Function Module

2. What are the steps involved in LO Extraction?
• The steps are:
o RSA5 Select the DataSources
o LBWE Maintain DataSources and Activate Extract Structures
o LBWG Delete Setup Tables
o 0LI*BW Setup tables
o RSA3 Check extraction and the data in Setup tables
o LBWQ Check the extraction queue
o LBWF Log for LO Extract Structures
o RSA7 BW Delta Queue Monitor

3. How to create a connection with LIS InfoStructures?
• LBW0 Connecting LIS InfoStructures to BW

4. What is the difference between ODS and InfoCube and MultiProvider?
• ODS: Provides granular data, allows overwrite and data is in transparent tables, ideal for drilldown and RRI.
• CUBE: Follows the star schema, we can only append data, ideal for primary reporting.
• MultiProvider: Does not have physical data. It allows to access data from different InfoProviders (Cube, ODS, InfoObject). It is also preferred for reporting.

5. What are Start routines, Transfer routines and Update routines?
• Start Routines: The start routine is run for each DataPackage after the data has been written to the PSA and before the transfer rules have been executed. It allows complex computations for a key figure or a characteristic. It has no return value. Its purpose is to execute preliminary calculations and to store them in global DataStructures. This structure or table can be accessed in the other routines. The entire DataPackage in the transfer structure format is used as a parameter for the routine.
• Transfer / Update Routines: They are defined at the InfoObject level. It is like the Start Routine. It is independent of the DataSource. We can use this to define Global Data and Global Checks.

6. What is the difference between start routine and update routine, when, how and why are they called?
• Start routine can be used to access InfoPackage while update routines are used while updating the Data Targets.

7. What is the table that is used in start routines?
• Always the table structure will be the structure of an ODS or InfoCube. For example if it is an ODS then active table structure will be the table.

8. Explain how you used Start routines in your project?
• Start routines are used for mass processing of records. In start routine all the records of DataPackage is available for processing. So we can process all these records together in start routine. In one of scenario, we wanted to apply size % to the forecast data. For example if material M1 is forecasted to say 100 in May. Then after applying size %(Small 20%, Medium 40%, Large 20%, Extra Large 20%), we wanted to have 4 records against one single record that is coming in the info package. This is achieved in start routine.

9. What are Return Tables?
• When we want to return multiple records, instead of single value, we use the return table in the Update Routine. Example: If we have total telephone expense for a CostCenter, using a return table we can get expense per employee.

10. How do start routine and return table synchronize with each other?
• Return table is used to return the Value following the execution of start routine

Related Links

Comments (52)

Burgula Raj
Said this on 5-16-2007 At 07:33 am
This site has good information & very useful to everyone.
If this site will be keep on update basing on persons experiences that would be great.
Said this on 6-4-2007 At 11:57 am
I found it very helpful for my preparation
Said this on 10-23-2007 At 10:57 am
Tanoy Roy
Said this on 9-11-2011 At 01:58 pm

Hi SAP BW Experts,

Hi, I am Tanoy.

What is the Support Project roles and responsibilities ? Can u please explain in detail ?

I would be sitting for the interview of SAP BI for support role very soon. Can u please tell me what a SAP BI Support guy need to do on a daily basis in detail ? 

Can you please tell me that what are the chapters should I mainly concentrate for SAP BI Support Interview ?

Can you please forward me some functional specs of SAP BI Support ??

Can you send me some real time scenarios and issues with solution ??

Can you send me a common list of errors that happens in production with solution ??

Please reply me asap.

Said this on 11-10-2007 At 06:07 pm
Hi SAP BW experts,
Really very good preparation and presentation. Thanks for this hearty helps.

Thanks & regards
Said this on 2-24-2011 At 04:09 pm

where do u work

pritam reddy
Said this on 11-27-2007 At 09:59 am
it is very useful
Said this on 12-1-2007 At 11:08 am
it is very help for my preparation.
Said this on 12-19-2007 At 09:54 am
Actually i m fresher in BW. It was very very very helpful to me. Really thanks for this.
Said this on 12-20-2007 At 11:39 pm
Appreciate the efforts for this site, really helpful.. keep it up ... Good work...
Said this on 1-10-2008 At 10:01 am
Excellent site. I was very surprised to see this site with lot of good interview questions even though couldn't able to see this site using Google search.
Said this on 1-10-2008 At 08:19 pm
very usefull information for a new learner
sudhakar sanam
Said this on 1-26-2008 At 09:53 pm
excellent opportunity for the new learners.and also for job seekers for preparing the job interviews
Said this on 3-10-2008 At 09:54 pm
very much greatful to u.people like me somewhere inthe world will benefit from this.hat's off to uar
unselfish work.keep it up friend.
Said this on 3-28-2008 At 09:14 am
excellent material,but missing some answers
Said this on 7-7-2008 At 08:58 am
This is a very nice article for the people who want to know about the sap-bw and also useful for the people who is attending interviews to refresh the subject.
Said this on 7-14-2008 At 09:36 pm
Appreciatable work.... it's really helpful..
krishna kumar
Said this on 8-13-2008 At 08:36 am
good website ,valuable meteriale sharing to all
Said this on 9-16-2008 At 01:19 pm
super, excellent job
Said this on 9-17-2008 At 07:01 am
Gr8 stuff..........keep u the good work......
Said this on 10-1-2008 At 08:29 pm
Its very helpful.
Said this on 12-8-2008 At 08:13 am
Thanks a lot.. very good information.. Real good effort..
Said this on 2-8-2009 At 05:12 pm
very very useful
Said this on 4-1-2009 At 12:57 pm
It is very good site
ranga reddy
Said this on 4-9-2009 At 11:01 pm
this information is very helpful for those who are facing interviews first time
Said this on 5-4-2009 At 01:44 am
its good
Said this on 6-3-2009 At 12:19 pm
Amazing stuff...! Good Work...! Will help lot more guys...!
Said this on 6-18-2009 At 01:25 pm
Many thanks for providing such valuable information on bw interview questions.
Said this on 7-9-2009 At 02:26 pm
Very Informative for Beginers.Thanks alot.Would been excellent posting new questions.
Said this on 7-24-2009 At 11:52 am
thanks a lot for your excellent effort
Said this on 8-5-2009 At 01:50 pm
Really great collection of questions for beginners....
Said this on 8-17-2009 At 10:24 pm
Very Very Helpful Stuff for freshers preparing for an interview.
Said this on 8-22-2009 At 01:23 pm
hi Sunita,

Do u have some more questions on SAP BI.
Said this on 8-29-2009 At 04:35 pm
Its really good to put question from various corner of BW. PL. updated it with time and experience.
Said this on 8-30-2009 At 09:16 am
it is very good useful sap students
Said this on 8-31-2009 At 06:59 pm
i have never found such great site containing lots of useful interview questions.i am very much pleased visiting this site.
Said this on 9-9-2009 At 05:40 pm
Said this on 9-17-2009 At 09:13 pm
very good
Sri Reddy
Said this on 10-26-2009 At 11:30 am

Really worthful good collection of questions for a SAP BW beginner...Good Work....

Said this on 11-18-2009 At 01:51 am


I am very new to SAP world but have core java background and I wanted to learn SAP BI module.

Could any one give me directions/pointers/suggestions on how to approach/start up.

I really appreciate your time and support.

PS: I can provide more details about my background if any one gets back to me.

- Soma

Said this on 11-19-2009 At 05:30 am

Soma please post your question at our answers website IT Answers . We will answer your question.

Said this on 11-8-2011 At 12:44 am

u can join  in qbex at hyd ,that is bw/bi coaching center...

Said this on 6-10-2010 At 01:32 pm

 glorious work..

Said this on 7-4-2010 At 04:56 pm

Said this on 9-1-2010 At 11:27 am

It is excellent site to reveal the subject.It is very helpful to me to express the answers in very understandable terminology.

Said this on 9-1-2010 At 11:41 am

Excellent site to reveal the subject & can able to answer every question in understandable manner.


jagadish raju
Said this on 9-2-2010 At 03:07 pm

these question are nice for new learn bw to known the concept

Said this on 11-14-2010 At 12:19 am


this is very nice and also verymuch useful for peple attending theinterviews a lot.I thank and appreciata all these ones alot.

Said this on 1-14-2011 At 02:40 pm

Thnx... this information is really helpful.

Said this on 4-18-2011 At 03:41 pm

excellent..good work!!!

Post a Comment
* Your Name:
* Your Email:
(not publicly displayed)
Reply Notification:
Approval Notification:
* Security Image:
Security Image Generate new
Copy the numbers and letters from the security image:
* Message:

Email to Friend

Fill in the form below to send this article to a friend:

Email to Friend
* Your Name:
* Your Email:
* Friend's Name:
* Friend's Email:
* Security Image:
Security Image Generate new
Copy the numbers and letters from the security image
* Message: