SAP DB Interview Questions and Answers
Question - 11 : - What are the different types of ERP?
Answer - 11 : -
- SAP
- Baan
- JD Edwards (now acquired by Oracle)
- Siebel
- Peoplesoft (now acquired by Oracle)
- Microsoft Dynamics
Question - 12 : - What are the different SAP products?
Answer - 12 : -
SAP R/3 – It succeeds SAP R/2 and is a market leader in ERP. R/3 stands for three-tier architecture, i.e., Presentation, Logic, and Data tier. It has many modules like SD, FI, HR, etc. which encompass almost all enterprise departments.
mySAP – It is a suite of SAP products which apart from SAP R/3 also includes SRM, PLM, CRM, SCM
Question - 13 : - What is NetWeaver?
Answer - 13 : -
NetWeaver is an integrated technology platform such that all the products in the mySAP suite can run on a single instance of NetWeaver, known as SAP Web Application Server (SAP WEBAs).
The advantage of using NetWeaver is that you can access SAP data using the web (HTTP protocol) or even mobile. Thus, you can save on costs involved in training users on SAP Client-side GUI.
Question - 14 : - List the Different Modules in SAP.
Answer - 14 : -
- FI (Financial Accounting)
- CO(Controlling)
- EC (Enterprise Controlling)
- TR(Treasury)
- IM (Investment Management)
- HR (Human Resource)
- SD (Sales and Distribution)
- MM (Materials Management)
- PM (Plant Maintenance)
- PP (Production Planning)
- QM – Quality Management
- BW (Business Warehousing)
There are many industry-specific solutions that SAP provides apart from the list of modules above, which is ever-growing.
Answer - 15 : -
Meta Data: Meta Data is data about Data. It tells you about the structure of data or MetaObjects.
Master Data: This Data is key business information like Customer information, Employee, Materials, etc. This is more like a reference data for Ex. If a customer orders 10 units of your product instead of asking the customer for his shipping address 10 times, the same can be referenced from the Customer Master Data.
Transaction Data: This is data related to day to day transactions.
Question - 16 : - Is SAP A Database?
Answer - 16 : -
NO. SAP is not a database, but it’s an application that makes use of databases provided by other vendors like Oracle, SQL Server, etc.
Question - 17 : - How many SAP Sessions can you work on at a given time?
Answer - 17 : -
At any given time for a particular client, you can work on 6 sessions at max.
Question - 18 : - What is a transaction in SAP terminology?
Answer - 18 : -
In SAP terminology, a transaction is a series of logically connected dialog steps.
Question - 19 : - Mention what is the process to create a table in the data dictionary?
Answer - 19 : -
To create a table in the data dictionary, you have to follow this step.
- Creating domains (data type, field length, range)
- Creating data elements (properties and type for a table field)
- Creating tables (SE 11)
Question - 20 : - Mention what are the different layers in the R/3 system?
Answer - 20 : -
Different layers in the R/3 system includes
- Presentation Layer
- Database layer
- Application layer