Interview Questions.

Q1. Can You Create A Table With Fields Not Referring To Data Elements?

 Yes.

Q2. What Are The Different Types Of Data Dictionary Objects?

Data Dictionary Objects:

Tables

Views

Domain

Data Element

Type Groups

Search Helps/Matchcode Objects

Lock gadgets

Structures

Table Types.

Q3. What Is Is A Match Code?

A Match code is a tool tip to assist us to look for the information records within the system. Match codes are an green and consumer friendly seek in which key of a document is unknown.

Q4. How To Eliminate Duplicate Entries In Internal Tables?

SORT itab.

DELETE ADJACENT DUPLICATES FROM itab COMPARING ALL FIELDS.

Q5. Difference Between Call By Value And Call By Reference?

Call By Value:creates a brand new reminiscence location for use in the subroutine. The memory is freed once it leaves the subroutine, changes made to the variable are not affected out of doors the subroutine.

Call through Reference : passes a pointer to the memory vicinity. Changes to the variable within the subroutine impacts the variable outside the subroutine.

Q6. What Are The Control Break Events In Abap?

AT-FIRST: This is used while we need to execute the statements before facts are processed.

AT-LAST: This event is used while we want to execute the statements in any case statistics are processed.

AT-NEW: This event is used while we need to execute the announcement before organization of statistics are processed.

AT-END: This event is used whilst we need to execute the statements after processing of group of data.

Q7. What Are The Different Types Of Locks?

Read lock (shared lock):

 Protects examine get right of entry to to an object. The study lock permits different transactions study access however not write get entry to to the locked place of the table.

Write lock (unique lock):

Protects write get right of entry to to an item. The write lock permits different transactions neither read nor write get admission to to the locked location of the desk.

Enhanced write lock (specific lock without cumulation):

 Works like a write lock except that the enhanced write lock additionally protects from similarly accesses from the same transaction.

Q8. Open Sql Vs. Native Sql?

A database interface interprets SAP’s Open SQL statements into SQL commands unique to the database in use.

Native SQL statements get right of entry to the database without delay.

Q9. What Is Lock Object ?

LockObjects used to synchornize get right of entry to of several users using same facts.

Q10. What Is The Basic Difference Internal Tables And Database Tables?

The basic difference is database tables are stored in DB serverand the internal tables are virtual tables these are created run time best

Internal tables are created dynamically, the reminiscence of internal tables isn't permant reminiscence, for internal tables the reminiscence may be created in the software server and it is outside memory and terminates after the program termination.

Q11. When Is The Top-of-page Event Triggered?

After executing first write statement in begin-of-selection event.

Q12. How Many Types Of Buffering?

There are 3 form of buffer:

unmarried record->it buffers handiest statistics based on pick question declaration.

Regularly occurring buffer->it buffers all of the statistics which in shape to number one key and general key

full buffer :Buffering is locate for enhance performance.

Q13. Which Transaction Code Is Used Executing A Report (type 1 Program)?

SE38

Q14. Which Database Object Is Used For Storing The System Variables?

SYST table.

Q15. How To Creat Transactions?

We can use TC SE93 for growing our very own transaction code.

Q16. What Is Table Attribute?

The Table attributes decide who's answerable for preserving a desk and which forms of access are allowed for the desk.

The maximum critical table attributes are:

Delivery magnificence

Table Maintenance allowed 

Activation type.

Q17. What Is Value Table?

Value table is maintained at Domain level in SAP. During domain advent, cost variety of the area i described with the aid of specifying cost table.

Q18. How Many Ways You Can Create Table?

 User can create a Database desk in  ways:

 Top-to-backside technique: In this technique, first fields are defined and later area and statistics detail are described.

 Bottom-to-pinnacle method: In this technique, first domain and records detail are defined and later fields are defined.

Q19. How Many Types Of Data Classes Are There In Sap Abap?

APPL0(Master Data) for the records frequently accessed but not often up to date/changed.

APPL1(Transactional Data) for the information that is often modified.

APPL2(organizational Data) for customizing data this is described/ entered at some point of machine set up and infrequently changed.

Q20. What Is Delivery Class?

You use the delivery elegance to control the shipping of table data for an installation, upgrade, or client replica and transports among customer systems. The shipping magnificence is likewise used within the prolonged table maintenance.

There are the following improvement instructions:

A- Application table (grasp and transaction facts).

C- Customer table, records is handiest maintained by means of the client.

L- Table for storing temporary facts.

G- Customer table, SAP can insert new information data but cannot overwrite or delete current ones. The patron namespace should be defined in table TRESC. To define the patron namespace use document RDDKOR5@You can start it immediately from the table preservation by choosing Maintain Customer Namespace on the Delivery and Maintenance tab.

E- System table with its personal namespace for customer entries. The purchaser namespace must be described in desk TRESC. To outline the purchaser namespace use file RDDKOR5@You can start it directly from the desk preservation by deciding on Maintain Customer Namespace at the Delivery and Maintenance tab.

S- System table, information modifications have the reputation of software changes.

W- System table (as an example desk of the development environment) whose records is transported with its very own shipping gadgets (which include R3TR PROG, R3TR TABL and so on).

Q21. What Is Sql Trace?

SQL Tracer is a tool used to degree the overall performance of ABAP software.

Tcode :st05

Q22. What Is Meant By Hot Spots?

A Hot spot is a listing region wherein the mouse pointer seems as an upright hand image. When a person factors to that region, a unmarried click on does the equal element as a double click. Hot spots are supported from R/three launch three.0.