SAP BI ABAP Interview Questions
SAP BI ABAP Interview Question And Answers:
Q.What is table partition ?
SAP is using fact table partitioning to improve the performance. you can partition only on 0CALMONTH or 0FISCPER
Q.How would you convert a info package group into a process chain ?
Double Click on the info package grp, click on the ‘Process Chain Maint’ button and type in the name and description; the individual info packages are inserted automatically.
Q.How do you replace a query result from a master query to a child query ?
If you select characteristic value with replacement path then it used the results from previous query; for ex: let us assume that u have query Q1 which displays the top 10 customers, we have query Q2 which gets the top 10 customers for info object 0customer with as a variable with replacement path and display detailed report on the customers list passed from Q1.
Q.What is modeling ?
It is an art of designing the data base. The design of DB depends on the schema and the schema is defined as representation of tables and their relationships.
Q.What is an info cube ?
Info cube is structured as star schema (extended) where a fact table is surrounded by different dim table that are linked with DIM-ids. And the data wise, you will have aggregated data in the cubes.
Q.What is extended star schema ?
- In Extended Star Schema, under the BW star schema model, the dimension table does not contain master data. But it is stored externally in the master data tables (texts, attributes, hierarchies).
- The characteristic in the dimensional table points to the relevant master data by the use of SID table. The SID table points to characteristics attribute texts and hierarchies.
- This multistep navigational task adds extra overhead when executing a query. However the benefit of this model is that all fact tables (info cubes) share common master data tables between several info cubes.
- Moreover the SID table concept allows users to implement multi languages and multi hierarchy OLAP environments. And also it supports slowly changing dimension.
- delete a BEx query that is in Production system through request.
- A) Using the RSZDELETE transaction
Q.How would you optimize the dimensions ?
We should define as many dimensions as possible and we have to take care that no single dimension crosses more than 20% of the fact table size.
Q.What are Conversion Routines for units and currencies in the update rule ?
Using this option we can write ABAP code for Units / Currencies conversion. If we enable this flag then unit of Key Figure appears in the ABAP code as an additional parameter. For example, we can convert units in Pounds to Kilos.
Q.Can an Info Object be an Info Provider, how and why ?
Yes, when we want to report on Characteristics or Master Data. We have to right click on the Info Area and select ‘Insert characteristic as data target’. For example, we can make 0CUSTOMER as an Info Provider and report on it.
Q.What is Open Hub Service ?
The Open Hub Service enables us to distribute data from an SAP BW system into external Data Marts, analytical applications, and other applications. We can ensure controlled distribution using several systems. The central object for exporting data is the Info Spoke. We can define the source and the target object for the data. BW becomes a hub of an enterprise data warehouse. The distribution of data becomes clear through central monitoring from the distribution status in the BW system.
Q.How do you transform Open Hub Data ?
Using BADI we can transform Open Hub Data according to the destination requirement.
Q.What is ODS ?
Operational Data Source is used for detailed storage of data. We can overwrite data in the ODS. The data is stored in transparent tables.
Q.What are BW Statistics and what is its use ?
They are group of Business Content Info Cubes which are used to measure performance for Query and Load Monitoring. It also shows the usage of aggregates, OLAP and Warehouse management.
Q.How to create a connection with LIS Info Structures ?
LBW0 Connecting LIS Info Structures to BW
Q.What is the difference between start routine and update routine, when, how and why are they called ?
Start routine can be used to access Info Package while update routines are used while updating the Data Targets.
Q.What is slowly changing dimension ?
Dimensions those changes with time are called slowly changing dimension.
Q.What is fact table ?
Fact table is the collection if facts and relations that means foreign keys with the dimension. Actually fact table holds transactional data.
Q.What is dimension table ?
Dimension table is a collection of logically related descriptive attributes that means characteristics.
Q.What is the model of the info cube ?
Info cube model is extended star schema.
Q.What are the data types for the characteristic info object ?
There are 4types:
Q.How you’ll write date in BW ?
Q.What is data class ?
The data class specifies in which table space the table is created in database.
Q.What is pooled table in sap ?
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. The 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 database table with a special strut that enables the data of many R3 tables to be stored in it. It can hold only pooled tables.
Q.What is transparent table ?
A transparent table has a one to one relation ship 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 table has application data (Master and Transaction).
Q.What is a buffer and how many types ?
- Buffer is nothing 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 ?
Table maintenance 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 ?
- Appended structures 2. Customizing tables
Q.What are lock objects ?
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 ?
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 ?
End-of-page : is footer of the page. End-of-selection: is triggered At the end of the processing block.
Q.How to create a button in selection screen ?
Q.Can you call a bdc program from a report ? how ?
Yes through Submit and return
Q.Can you call a transaction from a report ? how ?
Yes Using Call transaction and leave to.
Q.What are ALV reports? how they are different from normal reports ?
These reports are used to find subtotals and totals in a report. If you want i’ll give you an example program
Q.What is the use of SLIS type pool in alv reports ?
Slis type pool is a global defination of pool types 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 ?
Top-of-page is a header on primary list. Top-of-page during line-selection is a header on secondary lists
Q.How many type of internal tables are there ?
Standard, Hashed, Sorted tables
Q.What is the difference between hashed & sorted internal tables ?
Sorted internal table works on Binary Search and Hashed internal tables works on hashed algorithm through indexes.
Q.What is the difference between standard and sorted internal tables ? (in performance wise)
Sorted table improve the performance in case of a huge table which has no: of records
Q.When do you need to create an internal table with header line? and with out a header line ? line ?
If we don’t want to use any explicit work area then its better to go for an internal table with header line.
Q.Which of these methods can be best used in background process ?
Batch Input method.
Q.What is direct input method?What does an EXEC SQL stmt do in ABAP ? What is the disadvantage of using it ?
- Exec Sql [Performing
- [Native sql statements]
- The above is the syntax for the native sql statements.
- Syntax check is not done to statements written inside the EXEC SQL statements.
Q.What are selection texts ?
In the selection screen you can change the name of the field,title etc using selection texts. go to text-> text elements-> selection texts in the menu bar to set selection texts.
Q.What is the role of ST05 in performance tuning ?