<a href="http://www.widgeo.net">widgeo.net</a> widgeo.net

Wednesday, August 29, 2012

Sap Abap Interview Questions and Answers-VII


How data is stored in cluster table? 
A cluster table conatins data from mulitple DDIC tables.
It stores data as a name value pair ( varkey, vardata)
Have you used performance tuning? What major steps will you use for these? 
First of all tunning can be done
In three ways: disk i/o ,sql tunning , memory tunning,
Before tunning u have to get the status of your database using
Oracle utility called statpack , tkprof, then you should go for tunning
How to create client independent tables? 
client independent tables:
the table in which the first field is not mandt is the client independent tables
*mandt is the field with mandt as the data element
*automatically client which we login is populated to mandt
What type of user exits have you written? 
there are four types
1.function exit
2.menu ixit
3.screen exit.
4.field exit.
these are the user exits
How can you debug a script form? 
SE71 -> give the form name -> utilities -> activate debugger 
How do we debug sapscript? 
First we need to put Break point in Print program where ever you want to stop the execution.
After in SE71 give your form name and go to Utilities-->Active De-bugger.
Then go to your transcation like VF03(for Invoice or Credit memo) etc to see the print preview or print the form execute it.
When you execute it the the form Debugging will get activated and you can see your Form execution step by step.
What are the different types of data dictionary objects?
Answer1
Data Dictionary Objects

* Tables
* Views
* Domain
* Data Element
* Type Groups
* Search Helps/Matchcode Objects
* Lock objects
* Structures
* Table Types

Answer2
the dictionary objects are:
domain
dataelements
tables
views
structures
typegroups
search helps
lock objects etc which are data base related objects in sap
What is the step by step process to create a table in data dictionary? 
Answer1
steps to create database tables
1.go to se11
2.give name the database table
3.give short description for the table
4.Give delivery class name as A and data browser / table view maint as Display/maintenence allowed
5.select fields tab
6.give field name data type(user defined element type/built-in-type),short text
7.select technical settings tab ,give data class as appl0 and size category as 0
8.save it
9.go utillities menu click table contents select create and enter the field values then select display in table contents and u can view the table values with field lables

Answer2
bottom to top approach:
_________________________
step 1:
creating a domain:
*se11,select the object type as domain ,name it ,create,description,enter the datatype and length(size),save ,activate
step2:
creating a dataelement;
se11,select the object type as :date element,name it ,create,desc,assign it with a domain what we created now,save,activate it.
step3:
creating a table;
se11,select the object type as table,name it, create,
enter the field name and assign it with the data element instead of assigning a datatype to it,
like this create req fields:
on behalf of this:
table maintainence:
assign the type of the table ie.,A C G L S
NEXT
maintaince:
allowed,not allowed ,allowed with restricions
______________________________________________
fields of a table:(as descripted above)
___________________________________________
techical settings:
A0
OR
A1
AND
BUFFERED OR NON-BUFFERED

No comments:

Post a Comment