Enterprise resource planning (ERP) is business process management software that allows an organization to use a system of integrated applications to manage the business. Here we have listed top interview questions on ERP (Enterprise resource planning) to help you in your job preparation.

Q.1 What is ERP?
ERP is a package with the techniques and concepts for the integrated management of business, for effective use of management resources, to improve the efficiency of an enterprise.
Q.2 What are the different types of ERP?
SAP, BAAN, JD Edwards, Oracle Financials, Siebel, PeopleSoft.
Q.3 What is SAP?
SAP is a company founded in 1972 under the German name, is the leading ERP (Enterprise Resource Planning) software package.
Q.4 Explain the concept of "business Content" in Sap Business Information Warehouse?
Business Content is a pre-configured set of role and task-relevant information models based on consistent Metadata in the SAP Business Information Warehouse. These information models essentially contain roles, workbooks, queries, InfoSources, InfoCubes, key figures, characteristics, update rules and extractors for SAP R/3
Q.5 Why do you usually choose to implement Sap?
It’s highly configurable, highly secure data handling, min data redundancy, max data consistency, you can capitalize on economics of sales like purchasing, tight integration-cross function.
Q.6 Can Bw run without a Sap R/3 implementation?
Yes, you can run BW without R/3 implementation. You can use pre-defined business content in BW using your non-SAP data.
Q.7 What is Ides?
International Demonstration and Education System. A sample application provided for faster learning and implementation.
Q.8 What is Wf?
Tool for automatic control and execution of cross-application processes. This involves coordinating the persons involved, the work steps required, the data, which needs to be processed.
Q.9 What are Presentation, Application and Database Servers in Sap R/3?
The application layer of an R/3 System is made up of the application servers and the message server. Application programs in an R/3 System are run on application servers. The application servers communicate with the presentation components, the database, and also with each other, using the message server. All the data are stored in a centralized server. This server is called database server.
Q.10 Explain Open Sql Vs Native Sql?
ABAP Native SQL allows you to include database-specific SQL statements in an ABAP program. Most ABAP programs containing database-specific SQL statements do not run with different databases. Open SQL, allows you to access all database tables available in the R/3 System, regardless of the manufacturer. To avoid conflicts between database tables and to keep ABAP programs independent from the database system.
Q.11 What are Datasets?
The sequential files are called datasets. They are used for file handling in SAP.
Q.12 What are Internal Tables, Check Table, Value Table, and Transparent Table?
1. Internal table: It is a standard data type object, which exists only during the runtime of the program. 2. Check table: Check table will be at field level checking. 3. Value table: Value table will be at domain level checking ex: scarr table is check table for carried. 4. Transparent table: Exists with the same structure both in dictionary as well as in database exactly with the same data and fields.
Q.13 How can an ERP such as Sap help a Business Owner learn more about how business operates?
In order to use an ERP system, a business person must understand the business processes and how they work together from one functional area to the other. Using SAP as a tool to learn about ERP systems will require that the people understand the business processes and how they integrate.
Q.14 What is the difference between Olap and Data Mining?
Online Analytical processing is a reporting tool configured to understand your database schema, composition facts and dimensions. Whereas, Mining is to build the application to specifically look at detailed analyses, often algorithmic; even more often misappropriate called “reporting".
Q.15 Define Meta data?
Data that describes the structure of data or MetaObjects is called Metadata. In other words data about data is known as Meta Data.
Q.16 Define Master data?
Master data is data that remains unchanged over a long period of time. It contains information that is always needed in the same way. With master data you are dealing with attributes, texts or hierarchies.
Q.17 What is Transaction data?
Data relating to the day-to-day transactions is the Transaction data.
Q.18 Name Some Drawbacks Of Sap?
Interfaces are huge problem, Determine where master data resides, Expensive, very complex, demands highly trained staff, lengthy implementation time.
Q.19 What is Bex?
Bex stands for Business Explorer. Bex enables users to locate reports, view reports, analyze information and can execute queries.
Q.20 What are the components of Bex?
1. Bex Browser, 2. Bex analyzer, 3. Bex Map, 4. Bex Web.
Q.21 What Are Variables?
Variables are parameters of a query that are set in the parameter query definition and are not filled with values until the queries are inserted into workbooks.
Q.22 What are different types of variables?
There are different types of variables which are used in different application: Characteristics variables, Hierarchies and hierarchy node, Texts, Formulas, Processing types, User entry/Default type, Replacement Path.
Q.23 What is Awb? What is its Purpose?
AWB stands for Administrator WorkBench. AWB is a tool for controlling, monitoring and maintaining all the processes connected with data staging and processing in the business information warehousing.
Q.24 What is the significance of Ods in Biw?
The data of an ODS Object can be updated with a delta update into InfoCubes or other ODS Objects in the same system or across systems. In contrast to multi-dimensional data storage with InfoCubes, the data in ODS Objects is stored in transparent, flat database tables.
Q.25 What are the different types of Source System?
1. SAP R/3 Source Systems, 2. SAP BW, 3. Flat Files and External Systems.
Q.26 What is Extractor?
Extractors is a data retrieval mechanisms in the SAP source system. It can fill the extract structure of a data source with the data from the SAP source system datasets.
Q.27 Why implement an ERP System?
ERP software integrates all departments and functions across a company onto a single computer system that can serve all those different departments particular needs. ERP combines finance, HR, manufacturing and distribution all together into a single, integrated software program that runs off a single database so that the various departments can more easily share information and communicate with each other.
Q.28 What are the benefits of an ERP System?
1. A single integrated system. 2. Streamlining processes and workflows. 3. Reduce redundant data entry and processes. 4. Establish uniform processes that are based on recognized best business practices. 5. Information sharing across departments. 6. Improved access to information.
Q.29 Why choose Mosaic 21 Applications for ERP Solution?
1. Software Functionality 2. Technology platform 3. Proven Implementation Control 4. Industry Knowledge and Expertise
Q.30 What is Sap R/3?
A third generation set of highly integrated software modules that performs common business function based on multinational leading practice.
Q.31 What is E-Procurement?
E-Procurement, also known as electronic procurement or supplier exchange, is the purchase and sale of supplies, equipment, works and services through a web interface or other networked system.
Q.32 What are the main functions of e-procurement?
1. Automates manual processes to both free up time and reduce careless, human errors. 2. Simplifies the procurement process through touchless processes, advanced technologies, and compliant steps.
Q.33 What are the types of e-procurement?
1. e-ordering 2. web-based ERP 3. e-sourcing 4. e-tendering 5. e-reverse auctioning 6. e-informing.
Q.34 What is E-Logistics?
E-logistics is defined as the management of all the physical flows of an organisation that sells goods on an online platform.
Q.35 What are the key elements of e-logistics?
Key elements of e-logistics that entrepreneurs should take into consideration include: multi-channel operations, cross-border functionality, warehouse layout and inventory, last mile and reverse logistics, planning and forecasting, and performance measurement.
Q.36 What are the 7 R's of logistics?
The Right product, in the Right quantity, in the Right condition, at the Right place, at the Right time, to the Right customer, at the Right price.
Q.37 What are E-Markets?
An online marketplace is an e-commerce site that connects sellers with buyers. It's often known as an electronic marketplace and all transactions are managed by the website owner.
Q.38 What are the different types of e markets?
1. Product Online Marketplace. 2. Online Service Marketplace. 3. Online Rental Marketplace. 4. Hybrid Model in Ecommerce. 5. Hyperlocal Marketplace.
Q.39 What is business process optimization?
Business process optimization is the practice of increasing organizational efficiency by improving processes. Some examples of optimization include: Eliminating redundancies.
Q.40 What is a business object?
A business object is a representation of a thing active in the business domain, including at least its business name and definition, attributes, behavior, and relationships.
Q.41 What is SCM business?
Supply chain management (SCM) is the central management of the flow of goods and services and includes all processes that transform raw materials into final products.
Q.42 List the examples of SCM?
1. Artificial Intelligence. 2. Automated Material Handling Systems. 3. Bar-coding/ Automatic Identification. 4. Cloud Computing.
Q.43 Define E-commerce?
E-commerce is the activity of electronically buying or selling of products on online services or over the Internet.
Q.44 What are the 3 types of e-commerce?
There are three main types of e-commerce: business-to-business, business-to-consumer, and consumer-to-consumer.
Q.45 What is ERP Finance?
An ERP financial module is a software program that gathers financial data and then generates reports.
Q.46 What is meant by BPR?
Business Process Reengineering involves the radical redesign of core business processes to achieve dramatic improvements in productivity, cycle times and quality.
Q.47 What are BPR tools?
Tools used in Business Process Reengineering include: organizational charts, workflow analysis, benchmarking, job descriptions, business process mapping, and others.
Q.48 Which ERP system module has order entry and purchasing details?
Supply Chain Management ERP system module has order entry and purchasing details.
Q.49 What is the main objective of Executive Information System (EIS)?
An executive information system (EIS) is a decision support system (DSS) used to assist senior executives in the decision-making process.
Q.50 What is the critical benefit of using ERP?
Here are some benefits of using ERP.
1. Help reduce operating costs
2. Facilitate Day-to-Day Management
3. Support Strategic Planning
Q.51 What is meant by Decision Support System (DSS)?
A decision support system (DSS) is a computerized program used to support determinations, judgments, and courses of action in an organization or a business.
Q.52 What is the main benefit of using DSS?
The main benefit of using DSS are
1. Promotes learning or training
2. Express problem solving
3. Increases organizational control
Q.53 What are the benefits of DSS?
1. Improves efficiency and speed of decision-making activities. 2. Increases the control, competitiveness and capability of futuristic decision-making of the organization. 3. Facilitates interpersonal communication. 4. Encourages learning or training.
Q.54 Which ERP vendor started by offering database software
Q.55 Which ERP vendor started with human resource management systems
Q.56 Which ERP systems have you worked with so far?
As an ERP professionals you must have worked with several platforms such as SAP B1, Sage, Unit4, or Infor. In case you have experience in more than one, it suggested to make a list of the accomplishments using those systems. Since this will be among the most likely of ERP interview questions, it is suggested to be ready to have that information ready.
Q.57 Till date, how many full-cycle implementations have you completed?
This question may not be asked at every ERP interview as it will be asked in case you are applying for an ERP consultant position. You should be able to explain a bit about the successes you have had during your implementation and execution.
Q.58 What type of challenges are you looking for in this position?
One of the most important thing to keep in mind is to be motivated by challenges together with the eagerness to learn and try new things. You may share real-time examples of the challenges that you have met previously, if relevant. Your must also illustrate your experiences handling challenges and difficulties.
Q.59 Why should we hire you for this profile?
The interviewer seeks answer as to understand the qualities you are good at and how this will benefit the company. You are required to discuss your strengths, how they are suitable to the position, together with examples of how these strengths can benefit your employer. Concentrate on strengths such as - 1. Technical proficiency 2. Quick Learning 3. Determination to succeed 4. Positive attitude 4. Ability to relate to people to achieve goals You may support your answer with suitable real-time examples to support your answer.
Q.60 How would you improve our ERP system?
It is assumed that you are familiar with the system that the company is using at present – Plan ahead of time by streamlining their ERP operations, as well as understanding from mistakes that you may have learned from that could help them avoid a problem.
Get Govt. Certified Take Test