22 September, 2020
Are you planning to attend an interview for the SAP BI ABAP Developer role but confused on how to crack that interview and also what would be the most probable SAP BI ABAP Interview Questions that the interviewer may ask? Well, you have reached the right place. Tekslate has collected the most frequently asked SAP BI ABAP Interview Questions which are often asked in multiple interviews.
Ans: It is an art of designing the database. The design of DB depends on the schema and the schema is defined as a representation of tables and their relationships.
Ans: Info cube is structured as star schema (extended) where a fact table is surrounded by a different dim table that is linked with DIM-ids. And the data-wise, you will have aggregated data in the cubes.
Ans: 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.
Ans: Using this option we can write ABAP code for Units / Currencies conversion. If we enable this flag then the unit of Key Figure appears in the ABAP code as an additional parameter. For example, we can convert units in Pounds to Kilos.
Ans: 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 CUSTOMER as an Info Provider and report on it.
Ans: 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.
Ans: Using BADI we can transform Open Hub Data according to the destination requirement.
Ans: Operational Data Source is used for the detailed storage of data. We can overwrite data in the ODS. The data is stored in transparent tables.
Ans: They are a 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.
Inclined to build a profession as SAP ABAP Developer? Then here is the blog post on, explore SAP ABAP Training
Q11) What are the delta options available when you load from a flat-file?
Ans: The 3 options for Delta Management with Flat Files:
Ans: The steps are:
Q14) How to create a connection with LIS Info Structures?
Ans: LBW0 Connecting LIS Info Structures to BW
Q15) What is the difference between ODS and Info Cube and Multi Provider?
Inclined to build a profession as SAP BI Developer? Then here is the blog post on, explore SAP BI Training
Ans: Start Routines: The start routine is run for each Data Package after the data has been written to the PSA and before the transfer rules have been executed. It allows complex computations for a key figure or a characteristic. It has no return value. Its purpose is to execute preliminary calculations and to store them in global Data Structures. This structure or table can be accessed in the other routines. The entire Data Package in the transfer structure format is used as a parameter for the routine.
Transfer / Update Routines: They are defined at the Info Object level. It is like the Start Routine. It is independent of the Data Source. We can use this to define Global Data and Global Checks.
Q17) What is the difference between start routine and update routine, when, how, and why are they called?
Ans: Start routine can be used to access Info Package while update routines are used while updating the Data Targets.
Ans: In the Star Schema model, the Fact table is surrounded by dimensional tables. The fact table is usually very large, which means it contains millions to billions of records. On the other hand, dimensional tables are very small. Hence they contain a few thousand to a few million records. In practice, the Fact table holds transactional data and the dimensional table holds master data.
The dimensional tables are specific to a fact table. This means that dimensional tables are not shared across other fact tables. When other fact tables such as a product need the same product dimension data another dimension table that is specific to a new fact table is needed.
This situation creates data management problems such as master data redundancy because the very same product is duplicated in several dimensional tables instead of sharing from one single master data table. This problem can be solved in an extended star schema.
Ans: Dimensions those changes with time are called slowly changing dimensions.
Ans: The fact table is the collection of facts and relations that means foreign keys with the dimension. Actually fact table holds transactional data.
Ans: The dimension table is a collection of logically related descriptive attributes that means characteristics.
Ans: Actually info cube contains two tables. E table and F (fact) table.
Ans: 16(3 are sap defines and 13 are customer-defined)
Ans: 4(3 Sap defined and 1 customer-defined).
Ans: The 3 SAP defined dimensions are:
Ans: The info cube model is an extended star schema.
Ans: There are 4 data types:
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.
Ans: Primary index: the primary index contains key fields 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 the database and moreover you can further define a reference to the primary index which are known as the Secondary index.
Ans: The data class specifies in which tablespace the table is created in the database.
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. 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.
Ans: A transparent table has a one to one relationship 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).
Ans: 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 on previous pages. Data areas of used programs are created in roll areas for each internal session.
Ans: Table maintenance generator is nothing but making a table available for adding records and deleting records. The transaction code used is SM30.
Ans: Lock objects are nothing but which holds data for particular field value until you remove a lock.
Ans: Start-of-selection is called simplicity even it is not used in the program. start-of-selection is triggered after the standard selection screen has been displayed.
Ans: End-of-page: is the footer of the page. End-of-selection: is triggered At the end of the processing block.
Ans: Using parameters
Ans: Yes through Submit and return
Ans: Yes Using Call transaction and leave to.
Ans: These reports are used to find subtotals and totals in a report. If you want I'll give you an example program
Ans: Silas type pool is a global definition of pool types of catalog structure, table, and layout which we use in ALV reports
Ans: Top-of-page is a header on the primary list. Top-of-page during line-selection is a header on secondary lists
Ans: Standard, Hashed, Sorted tables
Ans: The sorted internal table works on Binary Search and Hashed internal tables work on hashed algorithm through indexes.
Ans: Sorted table improve the performance in case of a huge table which has no: of records
Ans: If we don't want to use any explicit work area then it's better to go for an internal table with header line.
Ans: Batch Input method.
Ans: Exec SQL [Performing [Native SQL statements] indexes. The above is the syntax for the native SQL statements.
The syntax check is not done to statements written inside the EXEC SQL statements.
Ans: 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.
Ans: Through functions.
Ans: Use select field statements (not select *) Use views rather than tables Don't use nested Select.
Ans: SQL trace Use select fields statements (not select *) Use views rather than tables Don't use nested Select.
Ans: SQL trace
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .