1. How to handle table control in BDC?

Ans-Normally all the screns with table controls will have buttons to add(Insert) a Row,
Delete a Row etc..
After adding data to 1st Row (it will have index 1)... press that insert button so a new
Row is inserted again at 1st row..so this will have index 1.
So in this way you can hard code the index to one.
The advantage is that if there are many rows then you will not have to keep a track of
how many rows are inserted and when to press the page down button.

2. i have to fetch the data based on non primary key field from a pooled
or clustered table, but for pooled and clustered tables we can't create
secondary index then to achieve the performance what to do?
Ans-You should avoid selection from cluster data base table. The better way to do this is
to use base tables. For example if you want to select data from BSEG table you should
use "lower level" tables like BSAK BSIK BSAD BSAK etc

3.We go in debugging but i m in 5th line of debugging and i want to go

again in 4th line of it then how to do that

Ans-Once u enter in the debugging screen put the courser on particular line from menu
debugging select go to statement.

4. Can we modify data in data base table using view?

Ans-Yes, we can. In data base view, we have got the option of read and read &
change. By selecting read & change we can make changes to data base table.

5. at which situation we create the secondary index?

Ans-When situation arise where in multiple reports the data being fetched via select
query and we don't have strong Primary key

6. can we use sub routines in a function module?

Ans-Yes we can.
7. What is kernal badi? What is the difference between classic badi and kernal badi ?
What is the advantages of kernal badi?

Ans-1)Framework completely different from Classic BADI.

A classic BAdI can be called only once and the call positions are registered
 centrally.
With new BAdIs, multiple calls are possible and the call positions are not
registered centrally.

2)Kernel BADI you can from your program by using commands GET BADI.

3)We can able to make more complex filter conditions.

8. Suppose I am working on userexit if someone wants to work on same is it possible to

work?

Ans-NO, because user exit is Locked by the user,

possible to to create another include.

9. what is index and types in indexes?

Ans-index is to avoid duplicate data and for good performance while extracting data from
dbtab, these are of 2 types
1> primary: it is created by system by considering all key fields
2> secondary: this are created by abap consultants using key or non key fields up to 9
indexes can be maintained

10. I have 1 basic list and 9 secondary list in interactive report. If i am in 5th list, how can i come
directly to the basic list?

Ans-MAX we can go for 20 SECONDARY LIST AND ONE BASIC LIST TOTAL 21

sy-lisel : contains data of the selected line.

sy-lsind : contains the level of report (from 0 to 21)

if sy-lsind = '5'.
sy-lsind = 1.
endif.

11. how to create view in bdc..??

Ans-

12. how to sort internal table?with out sort statement?

Ans-By taking the type of the table as sorted.
Example. " xyz type sorted table of spfli "
13. as a developer how u will decided which internal table we will use for requirement?

Ans-Most of the time we go for standard internal table. However, where main operation is
key access, Hashed internal table is most appropriate. Hashed internal tables are useful if
you want to construct and use an internal table which resembles a database table or for
processing large amount of table. If you are not sure about it, then go for standard internal
table.

14. what is 'X' parameter in BAPI?

Ans-to make a changes in BAPI Parameter we will be using staemt 'X".

15. in which situation we use user-exits and badi's?? with example

Ans-User exit allows to add only one extra functionality in standard SAP program but BADI
allows multiple functionality through implementations and methods.

16. IF I SAVE A TRANSACTIONAL DATA TABLE IN APPL0 INSTEAD OF APPL1 DURING

TECHNICAL SETTINGS OF A NEW TABLE WHTHER IT WILL CREATE ANY PROBLEM OR IT
WILL WORK SMOOTHLY???

Ans-Yes, APPL0 is the technical settings for Master Table which

changes seldom whereas APPL1 is for Transaction Table
which changes frequently. We should save the data of the
database table on its appropriate disk space otherwise will
create disk space problem, fatal disk problem etc.

17. How can we create Search Help, without using table field?
for example I have two fields in one table and I required
one more field in search help how?
Ans-create first a view of the two table in SE11 transaction.
Then create the search help based on that view.

18. What are dynamic modifications of a screen?

Ans-Change Screen based on user actions....this can be done by using AT SELECTION-
SCREEN OUT PUT event....

19. WHICH LANGUAGE IS USED TO WRITE ABAP CODING PART?

Ans-ABAP inturn uses COBOL structure

20. which commands are allowed if you are working with an internal table of type sorted?
Ans- whenever u r working with a sorted internal table u cant use
APPEND stmt..rest of the operations u can do...

21. 1.what are the events in TMG..?

2.if i do not write any thing in a REPORT program except TOP
OF PAGE and END OF PAGE ,then what will be the output?
Ans-As START-OF-SELECTION is an default event,if u don't write it,it will automatically
triggered. so with out start-of-selection and end-of-selection ,u can get the output .

22. In SAP R/3 architecture, how many databases can exist?

Ans-In Sap R/3 system,there can be only one database existing
in the system.

23. There is a delivery that is being created through the ABAP code and in the middle it says
delivery created but someone is modifying , how would you rectify this issue?
Ans-We can restrict other users from editing our programs/FMs with the help of "editor lock"
Concept.
The editor lock prevents other users from making changes to the program. This includes
attributes, documentation and text elements, as well as the functions "Rename" and
"Delete".
This will be helpful for the crucial reports.

24. How will you add search help in a program?

Ans-first create search help in se11
and then write below code in report
parameters: p_bukrs type bukrs matchcode <search help name>

25. How can we call, call transaction and session method in the same program?
Ans-You can call both methods by using the standard include
BDCRECX1.

26. what is the difference between

data: begin of ty_emp,

eno type i,
ename type string,
dno type i,
end of ty_emp.
and
types: begin of ty_emp,
eno type i,
ename type string,
dno type i,
end of ty_emp.
Ans-First is the structure and the second one is structure data type
27. User ‘A’ put the Exclusive Lock for one table and User ‘B’ want to put the Shared Lock for the
same table. Is it Possible?
Ans-No it's not possible. Because Once Exclusive Lock is
activated for one table it's not allowed another lock like
Shared or Exclusive lock.
While in case of Shared Lock it is possible.

28. Can we store Data in Cluster table?

Ans-no , table cluster should be used exclusively for storing internal control information.

29. In Pooled and Cluster Tables, which table we can convert into Transparent Table?
Ans-pooled tables , You can easily convert pooled tables to transparent table with the
transparent flag of the technical settings. You can use this option to access a pooled table
from outside the R/3 System.

30. Among pooled and Cluster tables, in which table data used to store in Row Format?
Ans-pooled table is stored entries with out row separator .
and coming to the cluster the entries are stored with row
separator

31. What is Transaction to view the Workflow status ? a) SWDD b) SWI2_FREQ c) SBWP d) SPRO
Ans-its swi2_freq.

it shows the status of all the workflows..

SWDD is the development tool

32. Function Module to upload the Excel sheet into SAP Internal
Tables. *
a) GUI_UPLOAD
b) CL_GUI_FRONTEND_SERVICES=>GET_UPLOAD_DOWNLOAD_PATH
c) CL_GUI_FRONTEND_SERVICES=>GUI_UPLOAD
d) All the above
ans- no i think these fm doesn't work with excel files. the above fm are used to upload the
txt files means note pad filessivas
in order to upload the xl file usually we use the fm

alsm_text_convert_to_xls_format : to download internal table data to xl file

sap_convert_xls_to_internal_table : to upload the xl file data to internal table

33. I have 2 inputs in Module pool prgm, if i click on the input i need to get drop down list..How to get
it..?
Ans-There are two methods to do so
1st: Assign fixed values in domain level of data element
and in MMP give that field as droup-down.

2nd : Use FM 'VRM_SET_VALUES'

34. In Interactive report, how to go back to 3rd list directly,

from 9th list?
Ans-Use system variable sy-lsind = 3 when sy-lsind = 9 .

35. What is the effect on Customer Exits and User Exits maintained
in a system on Up-gradation .
ans-Customer Exits are enhancements hence protected against up-gradation however, User
Exits are considered as modifications to ABAP program and are not protected against the
up-gradation and hence are overwritten during up-gradation.

36. Which method is faster among 4 methods used in LSMW.?

Ans-DirectInput

37. what is the difference between a table and template in

Smartforms?
Ans-Table is of variable length i.e. that flows all through
main windows in the form .
Template is of fixed length.
Both have multiple rows/entries.

38. what are the layers of data description in r/3?

Ans-presntation layer-for user gui

application layer-where all data processing is done

database layer-stored in databse

39. what is the use of field symbol?

Ans-Field symbols is like pointer in 'C'.
By the use of field symbol u can modify the internal table,
work area, user command etc without using modify keyword.
U can also modify internal table of standard program by
field symbols.
field-symbol <fs> type any

40. Can we create a data element without domain?

Ans-Yes we cam create a dataelement without domain using 'BUILT IN TYPE'
41. Why do we use Process On Value Request(POV) event instead of
data element,search help in module pool.
Ans-hi this is very common question in Mpp , genarally we assign search help for f4 of input
field in mpp, but in case if we created one input field which is needed to upload the file from
either presentation server or appliccation server in that case we espicially declare the
PROCESS_ON_VALUE_REQUEST event and under that we create the module in that
module we write the code for select the file .

42. can u call sub screen with in a sub screen? if so, then
explain the flow of PBO and PAI between 2 sub screens.
Ans-Add the subscreen area in the subscree.
in the PBO of the subscreen, call the second SS using call
sunscreen.....

43. BY WHICH FUNCTION MODULE UPLOAD DATA FROM APPLICATION

SERVER TO DESK TOP AND TO CODE CAN U EXPLAIN
Ans-We use GUI_UPLOAD.

44. What is inheritance and multi-level inheritance? Explain with example ?

Ans-Inheritance is nothing but acquiring the properties of one
class(base class) to another class(child class).

Multi-level Inheritance is nothing but one parent class that

have more than one child class. For Ex, P1 is parent Class
and C1 and C2 are the Child classes, now C1 can acquire the
properties of Parent class P1 and C2 can acquire the
properties of both Child calss C1 and Parent Class P1.

SAP ABAP SUPPORTS MULTI-LEVEL INHERITANCE... SAP ABAP NOT

SUPPORTS MULTIPLE INHERITANCE, ACHIEVES THROUGH INTERFACES
CONCEPT...

45. what is enhancement and modification ? Explain clearly please?

Ans-enhancement is adding additional functionality to standard
sap program without modifying the original object.
modification means changing standard code as per user
requirement.
46. What is Routine in ABAP and Types of routines?
ANS-Routines in Sales & Distribution plays a vital role
.Business Requirements can be met by creating and
configuring in required applications i.e. it can be a Copy
control Routine or any Pricing Requirement Routine or any
Out Put Requirement Routine.

VOFM is the Transaction, where we can create New Routine.

47. how many blocks can create in a ALV BLOCK LIST in ABAP?
ANS-

48. 30000 locks are done,u r having 15 min time .to leave u r
job.how would u resolve it
ANS-SM12 , Select all.....Delete Lock

49. WHAT IS DIFFERENCE BETWEEN USER EXIT AND BADI

ANS-User Exit:
1)it is procedural approach.
2)Program are written in between form endform.
2)it Need access key .

BADI:
1) it is object oriented approach.
2) Reusable because of oops concept .
3) first definition (se18) then implementation (se19)

50. will a break-point statement trigger in background job? say

yes or no. then whats is the reason?
ANS-break-point will not trigger in the background job because it
is a dialogue instance statement.

51. check sy-subrc = 0 and if sy-subrc =0 difference explian

Ans-check sy-subrc = 0.
* This statement checks for the condition and if it is
true, the further code will be executed. If not, the
execution will stop if sy-subrc fails.

if sy-subrc = 0.
endif.
* This statement checks the above condition and even if sy-
subrc fails, the code will be executed further.

52. what is main diffrence b/w refresh ,clear and free?

Ans-Clear: Clear is used to clear the memory of the workarea
and Internal table.
Refresh : It is used to clear only the Internal table
memory.
FREE: It is use to clear the workarea,internal table at the
same time it will return the free memory back to Database.

53. how to find the print/driver prg of smartform.I used FM SSF_FUNCTION_MODULE_NAME in

driver prg
Ans-in three ways we csn do it
1) Check the table TNAPR.
2) go to the Tcode -> NACE

3) Go to the T-code 'SMARTFORMs'

Give your form name
go to the general attributes.
Check the Package name.
then go to T-Code-> SE80
there check the program name for a package wise

54. Can we create a database table through a report?

Ans-As far as I know we can only create database tables in ABAP Dictionary

55. Can you create an internal table dynamically?

Ans-Yes.

56. Name 5 custom objects that dont start with Z or Y ?

Ans-There is only one object we can create without Z or Y.

That is Lock Object, it starts with EZ or EY

57. what is protect and endprotect?

Ans-Avoid page break by using protect and end protect in sap script

58.why you use table control?

Ans-Wehenever you wants to display a multiple records based on a single Header record we use this table control.