Monday, October 29, 2012

SAP ABAP Interview Question (SAP Labs, Accenture, IBM , Deloitte , TCS , Infosys)


After Observing many interviews. Finally i come up with the following questions which are mostly asked in all the Big companies including SAP Labs, Accenture, IBM , Deloitte , TCS , Infosys etc…
1. Can we write the code both call transaction and session method in single program?
Ans. Yes it is possible to write call transaction and session in one program.
2. Which BDC you prefer?
Ans. If we want to transfer large amount of data and when we need to use more than one transaction code we prefer session method. For small or less amount of data and for single transaction use call transaction.
(This is more genric answer but you can add more on to this if you have worked on  BDC)
3. When u prefer LSMW?
Ans. When we need to update medium amount of data we use LSMW. LSMW is also used when the person like functional consultant has less programming language.
5. Difference between .include and  .append?
Ans.
Include structure allows to add one or more structure into structure or table.Also placed positioning anywhere. Upto 6 include structure can be used in a table.
Append structure can be placed only at the end of a structure or table which also stops further insertion of fields.Only one append structure can be used
6. Preformance techniques
Ans.
1. The sequence of fields must be same as per database table
2. During writing select query write all fields in sequence as per database table.
3. Never write select statements inside loop….endloop.
4. Use st05 SQL trace, se30 run time analysis, code inspector, slin,etc.
5. Use select single * statement instead of select *
6. Always use primary key
7. Use binary search but before using binary search sort that table.
7. How to debug sapscripts ?
Ans.
Two ways to debug sapscript . first way is goto SE 71 and from menu bar select Utilities->activate debugger .then goto SE38 execute the print program ,it automatically goes to debugging mode …..the other way is , run the program RSTXDBUG in se 38 . execute it . a message will show that debugger is activated .now open the print program in se 38 …u vll notice that the print prgm is automatically diverted to debugging mode.
8. What is partner selection?
Ans. This concept is mainly used in IDOC where u select the partner profile using Tcode We20 .with  Tcode SM59 you create RFC(remote function call) to create communication link to a remote system.
10. What is occurs in internal table?
Ans. Occurs addition to the Declaration will give initial size to that table.occur statement allocates 8kb of memory to the internal table.
11. What is page window?
Ans : page window is nothing but a container of a page ,which uniquely identifies a set of data …for example while creating invoice …we create logo window , billing document header window , customer window , terms and condition window etc …
12. What is the difference between scrolling a table horizontally and vertically..??
Ans: In table control when you scroll a table vertically presentation server needs to call application server to fetch the next record and display in the table while in case of horizontal scroll there is no need to call application server.
13. What are Field Groups?
Ans: A group that combines several fields fewer than one name, at runtime, the INSERT command is used to define which data fields are assigned to which field group are called Field Groups. It should always be a HEADER field group that defines how the extracted data will be sorted; the fields grouped under the HEADER field group sort the data.
14. List the events in ABAP/4 Language?
Ans: The events in ABAP/4 are load of program ,Initialization, Selection Screen, Start of Selection, End of Selection, Top of page, Line selection, User command, End, First.
15.How the values will be passed to RFC Function module PassbyValue or Passbyreference?
Ans: always Pass by Value.
RFC is Remote Function call so it can’t access the values with Pass by reference.
16. Buffering concept usage?
Ans: There are three type of buffer
1 single record
2 generic buffer
3 full buffer
Buffering is use for improve performance. it improves performance  10 to 100 times more
17. Select up to 1 row and select single difference ?
Ans:  Select single fetches first matching record. If more than one matching records are there then only the first matching record will be considered other records will not be taken into account. Where as select up to 1 rows will fetch all the matching records from the database.(Again it will assign only One Record to the internal table/Work area)
18. What are the different buffering methods?
There are two different buffering methods
The system ensures that data transfer between the R/3 System and the database system is as efficient as possible. To do this, it uses the following techniques:
Table buffering: The program accesses data from the buffer of the application server.
Database request buffering: Individual database entries are not read or passed to the database until required by an OPEN SQL statement.
19. Different types of locks?
v  Read lock (shared lock)
Protects read access to an object. The read lock allows other transactions read access but not write access to the locked area of the table.
v  o Write lock (exclusive lock)
Protects write access to an object. The write lock allows other transactions neither read nor write access to the locked area of the table.
v  o Enhanced write lock (exclusive lock without cumulation)
Works like a write lock except that the enhanced write lock also protects from further accesses from the same transaction.
20. CHAIN END CHAIN?
Ans: Chain and end chain are used for multiple field validation in Module pool programming .It is written inside the screen flow logic.
21.How to Debug RFC Function module?
Ans:
SE38 –> Utilities –> Settings –> ABAP Editor –> Debugging
Activate the external debugging and choose the New Debugger option in ABAP debugger.
Go to the particular place in the code and put break point, pop will appear then choose the HTTP break point.
If you are triggering the RFC from SAP portal make sure that both the user ID should be same
If the users are different then provide the XI/Portal User ID in the users field.
22.Why sapscripts are client dependent and smartforms are client independent.?
Ans-: Smartforms create its own function module so it doesn’t need to transport the request through SCC1.As all the Development Object are stored in client independent tables. Whereas Script doesn’t generate  any function module while executing so we need to transport the request number through SCC1.Sap script is stroed in side the client depended table as a TEXT.so sapscripts are client dependent and smartforms are client independent.
23. Difference between user exit and BADIs?
Ans: User exit is for single implementation and it is procedural approach while BADIs are for multiple implementation and object oriented approach.
Multiple implementation means Reusability… because we use OOps Concepts for BADI.
24. Control break events in ABAP:-
1. AT-FIRST: This is used when we want to execute the statements before records are processed.
2. AT-LAST: This event is used when we want to execute the statements after all records are processed.
3. AT-NEW: This event is used when we want to execute the statement before group of records are processed.
4. AT-END: This event is used when we want to execute the statements after processing of group of records.
25.I am uploading 100 records out of which say 59th record has error so what will happen if i am using synchronous or asynchronous method of BDC? Can we update the database using local update mode how?
26. Suppose i am writing following code then what will be output?
LOAD-OF-PROGRAM.
WRITE:/”HELLO”.
Ans:  HELLO
(Explain the importance of LOAD-OF-PROGRAM Event.If you dont know Tell the interviewer as this event is used in such cases when you want to clear sum buffers or something Before calling that Program)
27. What is TMG?
Ans. TMG stands for Table Maintenance generator. It is a tool available in abap by which we can add or delete multiple records at a time and it is executed or triggered by the transaction code SM30.
28. Difference between select option and ranges ?
Ans. The main difference between select option and ranges is that ranges implicitly or automatically creates internal table with fields like OPTION,LOW,HIGH,SIGN,etc . Where as in case of select option we have to explicitly create internal table.
When u declares a select options it will implicitly declare an internal table (ranges) for you.
While using RANGES syntax u can declare internal table explicitly.
The only need of declaring ranges is when you r not taking input from the user but you want make limit based selection at that time it will be use full e.g. SELECT ** from ** where MATNR in val_range.
here u can use select-option or ranges : val_range.
29. is it possible to bring select option in module pool screens?
Ans.Create a SELECT-OPTIONS in module pool screen using two methods as shown.
Method 1:—-
a) Create a subscreen area in your screen layout where you want to create the select options.
b) In the top include of your module pool program declare a selection screen as a subscreen e.g.
SELECTION-SCREEN BEGIN OF SCREEN 100 AS SUBSCREEN.
select-options s_matnr for mara-matnr.
SELECTION-SCREEN END OF SCREEN.
c) In the PBO and PAI of the main screen where the select options needs to be created do a call subscreen of the above screen (100).
CALL SUBCREEN sub_area INCLUDING <program> <screen>
This CALL SUBSCREEN statement is necessary for transport of values between screen and program.
Note: All validations of the selection screen fields e.g. the s_matnr field created above should be done in selection screen events like AT SELECTION-SCREEN etc and not in PAI. These selection screen validations etc should be done in the top include only.
Method 2:——-
a) Create 2 separate fields in your screen layout – one for the low value and one for the high value. Insert an icon beside the high value which will call the multiple selections popup screen on user command. Use function module COMPLEX_SELECTIONS_DIALOG to achieve this.
continued ……
struc_tab_and_field-fieldname = con_cust. ” ‘KUNNR’
struc_tab_and_field-tablename = con_kna1. ” ‘KNA1′.
CALL FUNCTION ‘COMPLEX_SELECTIONS_DIALOG’ EXPORTING*
TITLE = ‘ ‘
text = g_titl1 ” ‘Customers’
tab_and_field = struc_tab_and_field
TABLES RANGE = rng_kunnr
EXCEPTIONS
NO_RANGE_TAB = 1
CANCELLED = 2
INTERNAL_ERROR = 3
INVALID_FIELDNAME = 4
OTHERS = 5.
IF NOT rng_kunnr[] IS INITIAL.
* Read the very first entry of the range table and pass it to
* dynpro screen field
*READ TABLE rng_kunnr INDEX 1.
IF sy-subrc = 0.
g_cust = rng_kunnr-low.
ENDIF.
ENDIF.
You can use the return table rng_kunnr to populate your own internal range table with the values entered by the user. Basically here you are just simulating the work of a select-options parameter by module pool screen elements.
30.how we can retrive data using secondary index.explain with simple example
Ans:  First create secondary indexes on required fields of a particular database table.
We can create one primary index and 15 secondary indexes.Once the respective secondary indexes are created write select queries and within select queries specify secondary indexes field name with where clause.
31.How can we handle table control in BDC?
Ans.We can handle table control using line index
Line index indicates which line of Table control is to be use for BDC transaction
Ex -
perform bdc_field using ‘RC29K-AUSKZ(01)’
Indicates 1st line of table control is going to be used for transaction which is Line index of Table Control
32. If i want to execute a BDC program only in background not in foreground is there any option for this?
Ans.The sm37 transaction can be used for running a program in the background. Also in the session method while processing the session you can specify the processing type as background or foreground.
33.How Can We upload a text file having Delimiters in to Legacy System
Ans.For up loading text file we use the pre-defined FM gui_upload. in that FM we have the parameter has_field_seperator for that we assign the default delimiter ‘x’.
HAS_FIELD_SEPERATOR ‘X’
‘X’ can provide the Whatever delimiter we used in flat file for separation.
34. What is the land scape in sap.
Ans. In every organisation sap landscape involves three servers viz, Development server, Quality server and Production server. Whatever new development we do as per clients requirement is done in development server. Later to test the developed object we move it to quality server for testing and finally once everything goes clear then the object is moved to production server ,production server data is ready for final business use.
35. Workbench request are client dependent or client independent
Ans. Workbench request are client independent.
(Common Man Workbench request holds the Program , FM etc…. How it can be Client Dependent!!!!)
36. Tell me about workbench request and customization requests.
Ans.Workbench (ABAP Dev) request is client independent when you import it into one system it reflact it in all client in same system, but customized request has to import in that client perticular client where it is created, actually it is client dependent.
Other  Interview questions…
SAP SCRIPTS & FORMS
1. Can we write the code/program inside sap script?
2. How will u create sapscripts & smartforms in multiple language?
3.How to execute sap script & smart forms in Background?
4.How to do total & subtotal in scripts & forms?
=================================================
DATA DICTIONARY
1.Apart from .include & .append how will u do table enhancement?
2.what r the events of table maintainence generator?
3.what will happen if i use projection view and maintainence view together?
4. I created ZEMP table now i want to add more data but prev. data should not disturb how can i do this?
=====================================================
REPORTS
1.How will u print footers in alv report?
2.How will u edit fields from output list of alv?
====================================================
BDC
1.what r the fields u took during recording for mmo1,me21n?
2.If u want to do bdc for xd01 explain me how will be the flow?
=================================================
user exits
1.what r enhancement points?
2.How to write customer exits?
3.what is routine? how it is different from user exits?

44 comments:

Sara Jones21 said...

Thanks a ton for the answers, helped me at right time. http://www.a2zonlinetraining.com/sap-online-training/sap-bo-online-training-hyderabad-india.php

Anonymous said...

Genuinely when someone doesn't be aware of after that its up to other viewers that they will help, so here it occurs.

Also visit my webpage; Download Autoclicker Adfly

Anonymous said...

Hey I know this is off topic but I was wondering if you knew of any widgets I could add to my blog that automatically
tweet my newest twitter updates. I've been looking for a plug-in like this for quite some time and was hoping maybe you would have some experience with something like this. Please let me know if you run into anything. I truly enjoy reading your blog and I look forward to your new updates.

Visit my weblog; $20 PSN Card

Anonymous said...

I will immediately grasp your rss as I can not in finding your email
subscription link or newsletter service.
Do you've any? Please let me understand so that I may subscribe. Thanks.

my weblog; http://greencoffeecleanse.net

Anonymous said...

Hello colleagues, its wonderful article about teachingand
fully explained, keep it up all the time.

Review my homepage; Fail Compilation 2013

Anonymous said...

Magnificent goods from you, man. I've understand your stuff previous to and you're just too great.
I really like what you have acquired here, certainly like
what you're stating and the way in which you say it. You make it enjoyable and you still care for to keep it sensible. I can not wait to read much more from you. This is actually a wonderful web site.

Check out my web blog psn

Anonymous said...

Hey there, You've done a great job. I'll definitely digg it and personally recommend
to my friends. I am confident they will be benefited
from this website.

Review my site - Free PSN Codes

Anonymous said...

Thank you for sharing your info. I really appreciate your efforts and I will be waiting for your further post thanks once again.


My blog post minecraft 1.0

Anonymous said...

For newest information you have to pay a visit web and on the web I found this website as a most excellent website for most up-to-date updates.


Also visit my webpage :: Funny Video

Anonymous said...

I read this article fully on the topic of the comparison of most up-to-date
and earlier technologies, it's amazing article.

Feel free to visit my web-site; Fail Compilation 2012

Anonymous said...

Great post. I used to be checking continuously this blog and I am impressed!
Very helpful information specially the closing section :) I maintain such information
a lot. I used to be seeking this certain info for a very lengthy time.
Thanks and good luck.

Also visit my site; funny animals videos

Anonymous said...

I like the helpful info you provide in your articles.
I will bookmark your blog and check again here frequently.

I'm quite certain I will learn many new stuff right here! Best of luck for the next!

my blog post ... twitter account

Anonymous said...

I could not refrain from commenting. Very
well written!

Also visit my blog post :: Minecraft Premium Hacks

Anonymous said...

It's perfect time to make some plans for the future and it is time to be happy. I have read this post and if I could I desire to suggest you few interesting things or advice. Perhaps you can write next articles referring to this article. I wish to read even more things about it!

My web site: new car Town promo codes

Anonymous said...

What's up to all, for the reason that I am really eager of reading this webpage's post to be updated regularly.
It contains good material.

my site; how do you get money fast

Anonymous said...

I rarely leave a response, however after browsing a great deal of remarks on this page
"SAP ABAP Interview Question (SAP Labs, Accenture, IBM , Deloitte , TCS , Infosys)".
I actually do have a few questions for you if
you do not mind. Is it just me or does it appear like a few of
these comments appear as if they are left by brain dead folks?

:-P And, if you are posting on other online sites, I would like to
keep up with anything fresh you have to post.
Could you make a list of all of all your public sites like your Facebook page, twitter feed, or
linkedin profile?

Take a look at my page :: how to hack a twitter account

Anonymous said...

Hello! This is kind of off topic but I need some guidance from an established blog.
Is it hard to set up your own blog? I'm not very techincal but I can figure things out pretty quick. I'm thinking about creating my own but
I'm not sure where to start. Do you have any ideas or suggestions? With thanks

my webpage :: Dubstep Videos

Anonymous said...

Howdy excellent website! Does running a blog like this take a lot of work?
I have virtually no knowledge of coding but I was hoping to start
my own blog in the near future. Anyway, should you have any ideas or techniques for
new blog owners please share. I understand this is off topic nevertheless I just had to ask.

Thanks!

Here is my web-site: Green coffee review

Anonymous said...

Heya i am for the first time here. I came across this board and
I find It truly useful & it helped me out a lot. I hope to give something back and help
others like you helped me.

Look into my homepage - sharecash auto

Anonymous said...

I simply couldn't go away your web site prior to suggesting that I actually loved the usual info a person supply for your guests? Is gonna be again steadily to inspect new posts

Here is my web page ... minecraft beta

Anonymous said...

Hello, I think your blog might be having browser compatibility issues.

When I look at your blog in Chrome, it looks fine but when opening in Internet Explorer,
it has some overlapping. I just wanted to give you a quick
heads up! Other then that, excellent blog!

Look at my weblog; PSN Code Generator

Anonymous said...

Pretty! This was an extremely wonderful article. Thanks
for supplying these details.

Also visit my site: dragonvale gems for free

Anonymous said...

magnificent issues altogether, you simply won a new
reader. What would you suggest about your put up that you simply made some days ago?
Any positive?

Take a look at my weblog; Password cracker

Anonymous said...

These are really enormous ideas in regarding
blogging. You have touched some pleasant factors here. Any
way keep up wrinting.

Here is my blog post: Aimbot black op 2

Anonymous said...

Having read this I thought it was very informative.
I appreciate you finding the time and effort to put this informative article
together. I once again find myself personally spending way too much time both reading and
posting comments. But so what, it was still worthwhile!

Also visit my homepage castleville unlimited coins

Anonymous said...

Yes! Finally something about watching shows online for free.


Feel free to visit my web-site where to Download free tv episodes

Anonymous said...

Hi there! This post couldn't be written any better! Looking at this article reminds me of my previous roommate! He constantly kept preaching about this. I'll
forward this information to him. Pretty sure he'll have a great read. Thank you for sharing!

Also visit my weblog google account password retrieval

Anonymous said...

This is very interesting, You are a very professional
blogger. I've joined your feed and look ahead to searching for more of your magnificent post. Additionally, I've
shared your website in my social networks

Look into my web-site - play minecraft free

Anonymous said...

Hey There. I found your blog using msn. This is a very well written
article. I will be sure to bookmark it and come back to read more of your useful info.
Thanks for the post. I will definitely comeback.

my weblog; cheats for dragonvale without jailbreaking

Anonymous said...

Hello, I would like to subscribe for this website to obtain most recent updates, therefore where can i do it please help.


Stop by my weblog :: hack wireless passwords

Anonymous said...

It's very simple to find out any topic on web as compared to textbooks, as I found this piece of writing at this website.

my page - funny clean youtube videos

Anonymous said...

Good day very nice web site!! Man .. Excellent .. Amazing .
. I will bookmark your web site and take the feeds also?
I am happy to seek out a lot of helpful information here within the post,
we need work out more techniques on this regard, thanks for sharing.

. . . . .

Feel free to visit my web-site: dragonvale eggs

Anonymous said...

Thanks for your marvelous posting! I definitely enjoyed reading it, you happen to be a great author.
I will ensure that I bookmark your blog and will come back from
now on. I want to encourage you to definitely continue your great work, have a nice afternoon!


my site: psn $100 $50 $20 working

Anonymous said...

Thanks on your marvelous posting! I actually enjoyed reading it,
you are a great author. I will make certain to bookmark
your blog and will eventually come back later on.

I want to encourage that you continue your great posts, have a
nice day!

Have a look at my weblog; diamond minecraft - -

Anonymous said...

This paragraph offers clear idea in favor of the new viewers of blogging,
that actually how to do blogging.

Also visit my web site ... lost administrator password
windows xp ()

Anonymous said...

Amazing! Its really remarkable post, I have got much clear idea
concerning from this paragraph.

Here is my page; yahoomail password crack

Anonymous said...

Free PSN Code Cards

Here is my webpage ... PSN Code Card 100$

Anonymous said...

If you are going for most excellent contents like
me, simply pay a visit this site daily as it provides quality contents,
thanks

Have a look at my weblog ... castleville games online

Anonymous said...

Because the admin of this web site is working,
no hesitation very soon it will be renowned, due to
its quality contents.

Feel free to surf to my web site: car town cheats 2013

Anonymous said...

Wow, amazing blog layout! How long have you been blogging
for? you make blogging look easy. The overall look of your website is magnificent, let alone the content!


My weblog :: sharecash survey

Anonymous said...

My partner and I stumbled over here different web address and thought I should check things out.
I like what I see so now i am following you. Look forward to looking into your web page repeatedly.


Here is my web page ... Download Autoclicker Adfly

Anonymous said...

It's wonderful that you are getting thoughts from this article as well as from our argument made at this time.

my page: minecraft beta

Anonymous said...

Quality posts is the important to be a focus for the visitors to pay a quick visit the site,
that's what this website is providing.

Feel free to visit my website: minecraft giftcode

Anonymous said...

But was later renamed to Advanced Business Application Programming. ABAP was one of the first languages to include the concept of Logical Databases (LDBs), which provides a high level of abstraction from the basic database level.
The ABAP programming language was originally used by developers to develop the SAP R/3platform. It was also intended to be used by SAP customers to enhance SAP applications – customers can develop custom reports and interfaces with ABAP programming.
SAP ABAP ONLINE TRAINING