SAP DB Interview Questions and Answers
Question - 41 : - Mention what are internal tables, check tables, value tables, and transparent table?
Answer - 41 : -
It is the standard data type object; it exists only during the runtime of the program.
Check the table will be at field level checking.
Value table will be at domain level checking
The transparent table will exist with the same structure both in the dictionary as well as in the database exactly with the same data and fields
Question - 42 : - Mention what is an application, presentation, and database servers in SAP R/3?
Answer - 42 : -
The application layer of a R/3 system is made up of the application server and the message server. Application programs in an R/3 system run on application servers. Using the message server, the application servers communicate with presentation components, the database, and also with each other. All the data are stored in a centralized server, which is known as a database server.
Question - 43 : - Explain what is a company in SAP?
Answer - 43 : -
Company in SAP is the highest organizational unit for which financial statements like profit and loss statements, balance sheets can be drawn according to the requirement of organizations. A single company contains one or many company codes. All the company codes in SAP must use the same COA (chart of accounts) and fiscal year.
Question - 44 : - Mention what is the difference between SAP BASIS and SAP ABAP?
Answer - 44 : -
SAP ABAP is the programming language used within SAP to customize, generate forms, generate reports, etc. While SAP basis is, the administration module of SAP used to control code changes, upgrades, database admin, network setup, etc.
Question - 45 : - List out the different types of source systems in SAP?
Answer - 45 : -
The different types of the source system in SAP includes
- SAP R/3 source system
- SAP BW
- Flat files
- External Systems
Question - 46 : - Explain what is Extractor?
Answer - 46 : -
In the SAP source system, extractors are a data retrieval mechanism. It can fill the extract structure of a data source with the data from the SAP source system datasets.
Question - 47 : - Explain what is extended star schema?
Answer - 47 : -
The star schema consists of the fact tables and the dimension tables. The master data related tables are kept in separate tables, which has reference to the characteristics in the dimension tables. These separate tables for master data are termed as the Extended Star Schema.
Question - 48 : - Explain what should be the approach for writing a BDC program?
Answer - 48 : -
The approach to writing BDC program is to
Create recording
Convert the legacy system data to a flat file into the internal table referred as “Conversion.”
Transfer the Flat file into the SAP system called “SAP Data Transfer.”
Depending upon the BDC type CALL TRANSACTION or CREATE SESSIONS
Question - 49 : - Mention what are the major benefits of reporting with BW over R/3?
Answer - 49 : -
Business Warehouse uses a data warehouse and OLAP concepts for analyzing and storing data While the R/3 was intended for transaction processing. You can get the same analysis out of R/3, but it would be easier from a BW.
Question - 50 : - Mention the two types of services that are used to deal with communication?
Answer - 50 : -
To deal with communication, you can use two types of services.
Message Service: In order to exchange short internal messages, this service is used by the application servers
Gateway Service: This service allows communication between R/3 and external applications using CPI-C protocol.