SAP Interview Questions and Answers for Freshers and Experienced.
Here are a few SAP Questions provided with their answers, which you may encounter while being interviewed and will help you crack the interview.
- What is SAP and what are the different products of SAP?
- Mention different modules in SAP?
- What are the drawbacks of SAP?
- List the different type of variables?
- Distinguish between OLAP and Data Mining?
- Mention the different types of source systems in SAP?
- What are AWB and Bex?
- What do you mean by “Business Content” and “Extended Star Schema” in SAP?
- Explain the common transport errors?
- Describe the standard stages of SAP Payment run?
- What should be the approach to writing a BDC program?
- What do you mean by Extractor and Pooled Tables?
Q1. What is SAP and what are the different products of SAP?
SAP:The System Application and Products is shortened to SAP in data processing. It stands No.1 in the ERP (Enterprise Resource Planning) market. It has more than 1lac installations worldwide, over 25 industry-specific business solutions and many thousands of customers in 120 countries.
Products of SAP:
- SAP R/3:It is the new ERP market Leader succeeding the SAP R/2. R/3 is a complete three-tier architecture that is Presentation, Logic and Data tier. SD, FI, HR are some of its modules which encompass almost all enterprise departments.
- mySAP: It is a suite of SAP product which includes SRM, PLM, CRM and SCM apart from SAP R/3.
Q2. Mention different modules in SAP?
Modules in SAP:
- Enterprise Controlling (EC)
- Financial Accounting (AC)
- Controlling (CO)
- Human Resource (HR)
- Treasury (TR)
- Sales and Distribution (SD)
- Investment Management (IM)
- Quality Management (QM)
- Production Planning (PP)
- Business Warehousing (BW)
- Material Management (MM)
Q3. What are the drawbacks of SAP?
Though SAP has many industry-specific solutions, it also has some drawbacks like:
- The SAP is expensive.
- It requires highly trained staff.
- It takes a lot of time whiQ3. le implementing.
- Interfaces arise the hassle and complexity.
- It does not specify or cannot determine where the master data is stored.
Q4. List the different type of variables?
Variables are the parameters for the query. The different types of Variables used in Applications are:
- Hierarchy Notes
- Processing type
- Characteristic variables
- User Entry / Default Type
- Replacement Path
Q5. Distinguish between OLAP and Data Mining?
OLAP:Online Analytical Processing is shortened to form OLAP. It is a reporting tool which is configured to understand the database schema, dimensions, and composition facts.
Data Mining:Data Mining is an analytic process which involves three stages: Initial Exploration, Model building and Deployment to explore data in search of consistent patterns or systematic relationship between variables.
Q6. Mention the different types of source systems in SAP?
The different types of source systems in SAP are:
- SAP R/3 source system
- SAP BW
- Flat files
- External system
Q7. What are AWB and Bex?
AWB:AWB is a shortened form of Administrator WorkBench. It is a tool that maintains all the processes like monitoring and controlling, which are connected with the data staging and processing in the business information warehousing.
Bex:Bex stands for Business Explorer. It allows the user end to locate reports, analyze information, view reports and execution of the queries.
The Queries in the workbook can be saved to their respective roles in the Bex Browser. Bex contains the following components: Bex Analyzer, Bex Map, and Bex Web.
Q8. What do you mean by “Business Content” and “Extended Star Schema” in SAP?
Business Content:In SAP, Business Content is a pre-configured and pre-defined model of information contained in the SAP Warehouse which is directly used or with desired modification in the industries.
Extended Star Schema:It consists of fact tables and dimension tables. The tables related to master data are kept in separate tables, which have reference to the characteristics in the dimension table. The separate tables for master data are called Extended Star Schema.
Q9. Explain the common transport errors?
The common transport errors that are encountered include:
- Return code 4: This error code is imported with warnings, generation of programs, columns or rows missing.
- Return code 8: This error code is imported with syntax error, program generation error, dictionary activation error and because of many other errors.
- Return code 12: This error code indicates import canceled because of object missing, object not active and many objects related errors.
- Return code 18: this error code indicates import canceled due to system down while importing, user expired during import and insufficient authorization.
Q10. Describe the standard stages of SAP Payment run?
The Standard stages of SAP Payment Run while execution are:
- Entering of Parameters: This stage includes entering into company codes, vendor accounts, payment methods and other accounts.
- Proposal Scheduling: This stage includes the list of invoices to be paid which is proposed by the system.
- Payment Booking: This stage includes the booking o the actual payments in the ledger.
- Printing of payment forms: This stage includes printing of payment forms.
Q11. What should be the approach to writing a BDC program?
The steps to writing a BDC program are:
- Firstly, a recording has to be created.
- Legacy system data is converted into the internal table as referred as “conversion”.
- The flat file is transferred into the SAP system called “SAP Data Transfer”.
- Depending on the BDC type CALL TRANSACTION or CREATE SESSION.
Q12. What do you mean by Extractor and Pooled Tables?
Extractor:In SAP source system, the extractor is the mechanism of data retrieving. The extract structure of a data source is filled with the data from the SAP source system.
Pooled Tables:These tables are used to store control data. Many pooled tables are united to form a table pool. It is a physical table on the database in which every record of the allocated pooled table is stored or saved.
You can also read this post on https://www.devquora.com/articles/sap-interview-questions