1)What are the different types of data dictionary objects?
Data Dictionary Objects
1 Tables
2 Views
3 Domain
4 Data Element
5 Type Groups
6 Search Helps/Matchcode Objects
7 Lock objects
8 Structures
9 Table Types
2)What is lock object ?
LockObjects used to synchornize access of several users using same data.
3)How to eliminate duplicate entries in internal tables?
SORT itab.
DELETE ADJACENT DUPLICATES FROM itab COMPARING ALL FIELDS.
4)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 only
Internal tables are created dynamically, the memory of internal tables is not permant memory, for internal tables the memory will be created in the application server and it is external memory and terminates after the program termination.
5)How many ways you can create Table?
User can create a Database table in two ways.
1.Top-to-bottom approach: In this approach, first fields are defined and later domain and data element are defined.
2.Bottom-to-top approach: In this approach, first domain and data element are defined and later fields are defined.
6)What is SQL Trace?
SQL Tracer is a tool used to measure the performance of ABAP program.
Tcode :st05
7)how to creat transactions?
We can use TC SE93 for creating our own transaction code.
8)Open SQL vs. Native SQL
A database interface translates SAP’s Open SQL statements into SQL commands specific to the database in use.
Native SQL statements access the database directly.
9)Which statement is used to get the number of lines in an internal table?
DESCRIBE table .
sy-tfill.
10)Can you create a table with fields not referring to data elements?
Yes
11)Which database object is used for storing the system variables?
SYST table
12)Which transaction code is used executing a report (type 1 program)?
SE38
13)When is the TOP-OF-PAGE event triggered?
After executing first write statement in start-of-selection event.
14)Which transaction code is used for deleting the user lock on tables?
sm12
15)how many types of buffering?
Ans: There are three type of buffer
1 single record->it buffers only records based on select query statement.
2 generic buffer->it buffers all the records which match to primary key and generic key
3 full buffer
Buffering is use for improve performance.
16)Select up to 1 row and select single difference ?
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)
17)19. Different types of locks?
1. 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.
2. 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.
3.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.
18) 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.
No comments:
Post a Comment