Important ABAP FAQ's related to Data Dictionary.
Q. What are dml statements in SAP?
Ans: Insert, Update, Delete.
Q. What is the difference between open sql & native sql?
Ans: Open SQL allows you to access all database tables known to the SAP system, regardless of the database manufacturer. Sometimes, however, we may want to use database-specific SQL statements called Native SQL in your ABAP/4 program.
To avoid incompatibilities between different database tables and also to make ABAP/4 programs independent of the database system in use, SAP has created a set of separate SQL statements called Open SQL. Open SQL contains a subset of standard SQL statements as well as some enhancements which are specific to SAP.
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
Q. What is Primary key, foreign key ? what is primary index? secondary index?
Ans: Primary index: the primary index contains key fiels of a table and a pointer to non-key fields of the table. The primary index is created automatically when a table is created in database and moreover you can further define reference to the primary index which are known as Secondary index.
Q. How many indexes can be created for a table?
Q. What is data class?
Ans: The data class specifies in which table space the table is created in database.
Q. Give few names of cluster tables in sap?
Ans: Names of Cluster Tables in sap
BSET Tax Data Document Segment
BSEG Accounting Document Segment
BSED Bill of Exchange Fields Document Segment
BSEC One-Time Account Data Document Segment
BSES Document Control Data
CDPOS Change document items
Q. Give few names of pooled tables in sap?
Ans: A pool table has many to one relation with the table in the database. For one table in the database there are many tables in the dictionary. Tha table in the database has a diff name than in the table in the data dict, it has diff no of fields and field names are different. A pooled table is stored in the pool at the database level. A table pool is a databse table with a special struct that enables the data of many R3 tables to be stored in it. It can hold only pooled tables.
Names of Pooled Tables in sap
A012 Additional Selling Plant/Material Group
A015 Not Used in Standard
A016 Contract Item
A017 Material Info Record (Plant-Specific)
A018 Material Info Record
A019 Contract Header
Q. Give few names of Transparent Tables?
Ans: A transparent table has a one to one relataionship in the database. The table in the dictionary has the same name, same no of fields, and the fields have the same name as in the R3 table defn. A transparent tabel has application data (Master and Transaction).
Name of Transparent Tables
T000ATP Basic Settings for Availability Check
T000CM Client-specific FI-AR-CR settings
T000F Cross-Client FI Settings
T000G Cross-Client FI-SL Postings
T000GL Flexible general ledger: Customizing check
T000MD MRP at MRP Area Level
Q. What is a buffer and how many types?
Ans: Buffer is othing but which stores data temporarily. there are two types of buffers. they are Roll and Page areas.
Pages : it stores the application data.
Roll area: it stores the data of previous pages.Data areas of used programs are created in roll areas for each internal session.
Q. What is table maintenance generator and how to create that? What is the transaction code?
Ans: Table maintanence generator is nothing but making a table available for adding records and deleting records.
The transaction code used is SM30.
Q. How to add new fields to a standard sap table?
Ans: 1. Appended structures 2. Customizing tables
Q. What are lock objects?
Ans: Lock objects are nothing but which holds a data for particular field value until you remove a lock..
Q. What is the use of start-of-selection event?
Ans: Start-of-selection is called implicity even it is not used in the program. start-of-selection is triggered after the standard selection screen has been displayed.
Q. What is the difference between end-of-page and end-of-selection?
Ans: End-of-page : is footer of the page. End-of-selection: is triggered At the end of the processing block.
Q. If you write a write statement after end-of-selection, will that be triggered?
Q. How to create a button in selection screen?
Ans: Using parametres
Q. How to add a gui status in a selection screen?
Ans: If you are trying to set a gui status in selection screen then you can use FM RS_SET_SELSCREEN_STATUS at event AT SELECTION-SCREEN OUTPUT.
Q. How to create a check box/option button in a list?
Ans: Regarding Runtime creation of Check Boxes
Q. Can you call a bdc program from a report? how?
Ans: Yes through Submit and return
Q. Can you call a transaction from a report? how?
Ans: Yes Using Call transaction and leave to.
Q. What are ALV reports? how they are different from normal reports?
Ans: these reports are used to find subtotals and totals in a report. If you want i'll give you an example program
Q. What are the main events that are used in an ALV report?
Ans: The main events that are used in an ALV report.
Q. What is the use of SLIS type pool in alv reports?
Ans: Slis type pool is a global defination of pooltypes of catalog structure, table and layout which we use in ALV reports
Q. Difference between top-of-page and top-of-page during at-line- selection?
Ans: Top-of-page is a header on primary list. Top-of-page during line-selection is a header on secondary lists
In an interactive report, after going to 5th list, can you come back to 2nd list? how?
Q. How many type of internal tables are there?
Ans: Standard, Hashed, Sorted tables
Q. What is the difference between hashed & sorted internal tables?
Ans: Sorted internal table works on Binary Search and Hashed internal tables works on hashed alogorthim through indexes.
Q.What is the difference between standard and sorted internal tables? (in performance wise)
Ans: Sorted table improve the performance in case of a huge table which has no: of records
Q. What is the use of at new statement?
Ans: It is a control statement in table loop. In a loop, whenever there is new entry for the field, AT NEW is trigerred and process the block..
it trigers for the record having defferent value comparing to the previoues record. so before using at new you have to sort the table using all the fields before the column used in at new statement......
Q. When do you need to create an internal table with header line? and with out a header line? line?
Ans: If we don't want to use any explicit work area then its better to go for an internal table with header line.
Q. What does it mean occurs 0 while creating an internal table?
Ans: Occurs 0 is used to assign some memory for the internal table which will increse at run time depending upon the data records. Occurs 0 statement assigns 8 kb memory and everytime that memory is used it assigns again 8 kb. If you won't give occurs 0 in the declaration It will become a structure .
Q. Which of these methods can be best used in background process?
Ans : Batch Input method.
Q. What is direct input method?
Ans: Direct Input Method is the data transfer method provided by SAP through which we can tranfer data between two SAP systems.For e.g T.Code
BAUP is used for transfer bank master records. Direct Input Method is used to upload or download data into or from SAP system.
Q. What does an EXEC SQL stmt do in ABAP? What is the disadvantage of using it?
Ans: Exec Sql[Performing SE11