If you're looking for SAP BI ABAP Interview Questions & Answers for Experienced & Freshers, you are at the right place. There are a lot of opportunities from many reputed companies in the world. According to research SAP, BI ABAP has a market share of about 5.3%. So, You still have the opportunity to move ahead in your career in SAP BI ABAP. Mindmajix offers advanced SAP BI ABAP Interview Questions 2019 that helps you in cracking your interview & acquire a dream career as a SAP BI ABAP Developer.
SAP BI ABAP Basic Interview Questions and Answers
Q1) Compare SAP ABAP and BI/BW?
|1||It is more efficient||Its efficiency is less as compared to the ABAP|
|2||It can handle high data and can be trusted for large volumes of the same||It is ideal to be used for smaller data needs|
|3||It has both relational and multi-dimensional structure||It has only a relational structure|
Q2) What do you know about the Star routines in the SAP BI ABAP?
Ans They are generally considered for all the data packages and are useful in the proper execution of all the rules that decides execution. All the computations that are very complex for a key figure can easily be considered. Generally, there are no return values in them. All the preliminary calculations can be executed in the one go when it comes to storing them in the third-party structures.
Q3) Name the option which you can consider for the purpose of transforming the Open Hub data?
Ans This can be done with the BADI option in the SAP DI ABAP
Q4) What exactly do you mean by the term Info Cube?
Ans It is basically a star schema approach that is useful when the useful tables need to be accessed but have issued with them due to DIM tables covering. It is possible to put the aggregated data in the cubes and without making a lot of efforts. The users can easily keep up the pace without investing a lot of time on this approach.
Q5) What exactly a dimensional table is according to you?
Ans It is actually a group of attributes defining the descriptive characteristics.
Q6) How can you say that an Info object be an Info provider?
Ans It is possible that an Information Object can be an Information Provider. Whenever there is a need to report on the useful data or on the characters, there is a default option that can be selected in the SAP BI ABAP and the same offer information on various aspects of the object. Thus, it can easily be said that the Info objects can be utilized for deriving a lot of useful information.
Q7) What do Intelligence matters a lot in the modern day businesses?
Ans Intelligence matters a lot due to a very large number of reasons. It simply makes sure that useful data can be driven and the same can be utilized for the purpose of taking decisions and neglecting or adopting the things. In addition to this, the users are free to make sure that the things can go beyond their actual scope with this approach. All the users are free to simply keep up the pace with the Intelligence as it simply eliminates a lot of errors.
Q8) How can you say that SAP BI ABAP is a good tool to be considered for Intelligence in the business?
Ans There are certain factors that make it simply the best and there are users all over the world who are considering it because of no other reason than this. It is possible to access multiple sources at the same time easily. It is possible to convert the data in reports and the same can be utilized further for the purpose of analyzing tasks. The easy to use GUI simply makes sure that no compatibility and other issues declare their presence. The multidimensional data sources can easily be considered and the best part is SAP BI ABAP is a highly scalable Business Intelligence Platform. The users can also make sure of an excellent query performance and simple integration with all the other domains.
Q9) What exactly do you mean by the term modeling and how it is essential in the Advanced business Application Programming?
Ans It is basically an approach that simply enables business owners to make sure of coming with a superb database. Actually, the design of the same depends largely on the schema adopted by the organization and there are various restrictions which are generally imposed due to lackness of schema in the same. SAP BI ABAP makes sure that the barriers can easily be eliminated. It also enables businesses in assuring the proper representation of all the tables and how they are related to each other.
Q10) What exactly do you mean by the term ODS?
Ans It is actually an option that can be considered in the SAP BI for the purpose of storing the data in a detailed manner. It stands for Operational Data Source and it is possible for the users to overwrite the data in the ODS as many times as possible. There are generally transparent tables which are deployed for this task.
SAP BI ABAP Interview Questions and Answers for Freshers
Q11) Tell something about the Business Statistics and where exactly they can be used?
Ans Basically, they are regarded as an array of Info cubes responsible for the development of the Business Content defining some important guidelines. It is possible for the users to deploy them for the purpose of measuring the performance of Load Monitoring, as well as Query handling. Clear information on the exact usage of aggregates can also be shown.
Q12) Can users load data from a flat file, what are the options available for this?
Subscribe to our youtube channel to get new updates..!
Ans Yes, it is possible for the users. Generally, there are three important options that can be trusted for this. These can be Full Upload, Additive Delta, New Status for the records changed.
Q13) Name a few important extractors types used in the Sap BI Advanced Business Application Programming?
Ans Content FI related to Business Warehouse
2. DB View
Q14) Compare ODS, Multi-provider and CUBE?
- ODS is responsible for providing the users all the granular data they need while performing some essential tasks or while handling major operations in the Advanced Business Application Programming. The data present in ODS always remain ideal for the drill down.
- MultiProvider approach doesn’t have the presence of any physical data in it. It allows the users to access the data from the Info Providers that are not same in nature and location. For complex reporting, many users consider it.
- CUBE simply depends on the star schema and in fact, it is based on the same. The users are free to consider it also for the primary reporting
Q15) Tell something you know about the Star Schema?
Ans There are generally dimensional tables which are responsible for surrounding the Dimensional and other tables. The size of the fact tables is not always small to be considering directly in the domain. They can have a very large number of records with them. However, the dimensional tables are small in size in the Star Schema Approach. The transactional Data remains present in the Fact table whereas the Dimensional Table generally consists of master data.
Q16) What are the problems which you have faced while working on SAP BI ABAP?
Ans Sometimes, depending on the volume of data, there can be issues such as master data redundancy. This usually happens when the same record remains present in the different dimensional tables. The extended star schema can solve this issue if adopted wisely.
Q17) Name the Routines which are defined at the Info Object Level?
Ans They are Update Routines and are very much similar to that of Star Routine. Generally, the data source has no concern with them. All the Global Check and the Global Data can easily be defined through them.
Q18) When it comes to accessing the Info Package, which routines can be considered and why?
Ans Star Routines are the ones that can be considered. This is because they are generally free from all sorts of calculation issues and are always good at updating the data targets. The same is one of the highly essential tasks of the SAP BI Advanced Business application Programming management.
Q19) How Native SQL and Open SQL can be put separate from one another?
Ans It is possible for the users to simply access the entire database tables with which the SAP system is already introduced to and this can be done through the Open SQL. The database manufacturer has no concern with this. The same cannot be provided by the Native SQL. In fact, it works perfectly on the database system which is independent. Both have a few commands in common but it takes different time to perform similar tasks on the both.
[ Related Article:- Modules of SAP ]
Q20) Does Dimensions change with respect to time?
Ans Yes, they often have an impact of time on them.
SAP BI ABAP Interview Questions and Answers For Experienced
Q21) In the Advanced Business Applications Programming, is it possible for the users to optimize the dimensions? If so, how this can be done?
Ans Yes, it is possible. It is actually a simple task and you have no reasons to worry about anything. Dimensions can easily be created without any limit. The only thing which users have to make sure is the dimensions don’t cross more than 20% of the table size allotted for the task.
Q22) Tell something you know about the conversion routines for the units?
Ans There is always a need to write the Advanced Business Application Programming codes in this environment. It can be done simply by using this option. The users can simply make sure of converting the units into other simply by making a few clicks only.
Q23) What do you know about the Open Hub Service?
Ans This is actually an option that is considered when it comes to sharing the data in the BW systems as well as in the other application within a short span of time. The involvement of multiple systems simply makes sure of controlled distribution of data. The users can easily define both the source, as well as the destination for the data. A central monitoring policy simply makes sure of preferred and desired outcomes.
Q24) Can you name the data types used for the characteristic Info Object?
Ans These are DATS, HAR, TIMS, NUMC
Q25) What do you know about a buffer and its type in the SAP BI?
Ans There is often a need to store the data temporarily while working in the SAP BI ABAP. The same is done through the buffers. The users can access the two important buffers anytime and they are Roll Buffers and the Page Buffers.
Q26) What do you know about a primary index?
Ans It is basically an index that contains the important fields or the key fields. There is also a pointer to the non-key fields which remain present in the table. The good thing is, this index get created automatically in the SAP environment. The users are free to define the references and the best thing is upon creation of the table, it gets created in the system default memory. By defining or mentioning the references, it is possible for the users to use the primary index as the secondary one.
Q27) In SAB BI, what exactly is Pooled Table?
Ans A table in which the data has multiple relations with the database is generally said to be a pooled database. Each table in the database can have different sections in the dictionary. It is generally stored at the database level and the users can simply make sure of a large number of pooled files.
Q28) What is table maintenance generator?
Ans It is nothing but an approach with the help of which a table is made ready for adding the records or performing the reverse action and i.e. deleting the same. This simply makes sure of the availability of them whenever a user need to access them for performing tasks related to records.
Q29) What are Lock Objects and how they are useful in SAP?
Ans These are the objects which are useful for data holding for a specific time period. They are generally deployed for holding the same for a particular field.
Q30) In the selection screen, it is possible to create a selection button?
Ans Yes, it is possible and for this task, the parameters can be deployed easily.
SAP BI ABAP Advanced Interview Questions and Answers
Q31) Define the table partition in SAP BI ABAP?
Ans SAP is using fact table partitioning inorder to improvise the performance. you can partition only on 0CALMONTH or 0FISCPER
Q32) Info Cube means?
Ans Info cube - A structured star schema (extended) or multidimensional dataset, where an fact table is surrounded by multiple dimension tables. Also used for analysing the BEx queries.
Q33) Name the data types for the characteristic an infoobject ?
Q34) What is the role of ST05 in performance tuning?
Ans SQL trace
Q35) How you’ll write the date in BW?
Q36) What do you mean by "slowly changing dimension"?
Ans The Dimensions which changes along with time are defined as slowly changing dimension.
Q37) What is a dimension table?
Ans Dimension table is a collection of logically related descriptive attributes that means characteristics.
Q38What is the model of the info cube?
Ans Info cube model is extended star schema.