Interview Questions.

Question 1. What Is Erp?

Answer :

ERP is a package deal with the techniques and ideas for the included control of commercial enterprise as a whole, for effective use of management resources, to enhance the performance of an business enterprise. Initially, ERP was focused for production industry in particular for making plans and handling core commercial enterprise like manufacturing and economic marketplace.

As the increase and merits of ERP bundle ERP software program is designed for simple method of a organisation from production to small stores with a target of integrating statistics across the business enterprise.

Question 2. Different Types Of Erp?

Answer :

SAP, BAAN, JD Edwards, Oracle Financials, Siebel, PeopleSoft. Among all the ERP’s most of the groups applied or looking to put into effect SAP due to quantity of benefits over different ERP programs.

SAP CRM Interview Questions
Question 3. What Is Sap?

Answer :

SAP is the name of the business enterprise founded in 1972 underneath the German call (Systems, Applications, and Products in Data Processing) is the main ERP (Enterprise Resource Planning) software package.

Question four. Explain The Concept Of “enterprise Content” In Sap Business Information Warehouse?

Answer :

Business Content is a pre-configured set of position and undertaking-relevant records fashions based on consistent Metadata within the SAP Business Information Warehouse. Business Content offers selected roles within a enterprise with the data they want to carry out their tasks.

These statistics models essentially comprise roles, workbooks, queries, InfoSources, InfoCubes, key figures, traits, update policies and extractors for SAP R/3, mySAP.Com Business Applications and different decided on packages.

SAP CRM Tutorial
Question 5. Why Do You Usually Choose To Implement Sap?

Answer :

There are number of technical motives numbers of companies are planning to put in force SAP. It’s incredibly configurable, rather comfortable records dealing with, min records redundancy, max information consistency, you can capitalize on economics of sales like buying, tight integration-pass feature.

SAP MM Interview Questions
Question 6. Can Bw Run Without A Sap R/three Implementation?

Answer :

Certainly. You can run BW without R/3 implementation. You can use pre-described commercial enterprise content material in BW the use of your non-SAP records. Here you without a doubt want to map the switch systems related to BW statistics sources (InfoCubes, ODS tables) to the inbound records files or use 3rd element tool to attach your flat documents and different records sources and cargo statistics in BW. Several third birthday celebration ETL products which include Acta, Infomatica, DataStage and others will had been certified to load facts in BW.

Question 7. What Is Ides?

Answer :

International Demonstration and Education System. A sample software supplied for quicker mastering and implementation.

SAP MM Tutorial SAP HR Interview Questions
Question eight. What Is Wf And Its Importance?

Answer :

Business Work Flow: Tool for computerized manipulate and execution of pass-application strategies. This entails coordinating the persons concerned, the paintings steps required, the statistics, which desires to be processed (business gadgets). The main benefit is reduction in throughput times and the fees concerned in dealing with business techniques. Transparency and first-class are more desirable by way of its use.

Question nine. What Is Sap R/3?

Answer :

A 0.33 generation set of enormously included software program modules that plays commonplace enterprise characteristic based totally on multinational leading exercise. Takes care of any employer however diverse in operation, unfold over the world. In R/three machine all the 3 servers like presentation; utility server and database server are placed at exceptional device.

SAP BASIS Interview Questions
Question 10. What Are Presentation, Application And Database Servers In Sap R/three?

Answer :

The utility layer of an R/three System is made from the utility servers and the message server. Application applications in an R/three System are run on software servers. The utility servers talk with the presentation additives, the database, and also with each other, the use of the message server. All the information are saved in a centralized server. This server is known as database server.

SAP HR Tutorial
Question eleven. What Should Be The Approach For Writing A Bdc Program?

Answer :

Convert the legacy device information to a flat record and convert flat report into inner desk. Transfer the flat document into sap system called “sap information transfer”. Call transaction (Write the program explicitly) or create classes (classes are created and processed, if success statistics will transfer).

SAP ABAP Interview Questions
Question 12. Explain Open Sql Vs Native Sql?

Answer :

ABAP Native SQL permits you to consist of database-specific SQL statements in an ABAP program. Most ABAP applications containing database-particular SQL statements do no longer run with exclusive databases. If distinct databases are worried, use Open SQL. To execute ABAP Native SQL in an ABAP software, use the assertion EXEC. Open SQL (Subset of standard SQL statements), allows you to get admission to all database tables available within the R/3 System, irrespective of the manufacturer.

To keep away from conflicts between database tables and to keep ABAP packages impartial from the database system used, SAP has generated its very own set of SQL statements called Open SQL.

SAP CRM Interview Questions
Question thirteen. What Are Datasets?

Answer :

The sequential documents (processed on application server) are referred to as datasets. They are used for record handling in SAP.

SAP BASIS Tutorial
Question 14. What Are Internal Tables Check Table, Value Table, And Transparent Table?

Answer :

Internal desk: It is a wellknown facts kind item, which exists only at some point of the runtime of this system.

Check desk: Check desk might be at field degree checking.

Value desk: Value desk may be at area stage checking

ex: scarr table is take a look at desk for carrid.

Transparent desk: – Exists with the same shape each in dictionary as well as in database exactly with the same information and fields.

Question 15. What Are The Major Benefits Of Reporting With Bw Over R/3? Would It Be Sufficient Just To Web-permit R/three Reports?

Answer :

Performance Heavy reporting in conjunction with ordinary OLTP transactions can produce a variety of load both at the R/three and the database (cpu, memory, disks, and many others). Just test the load put on your gadget for the duration of a month give up, quarter give up, or year-quit — now believe that occurring even greater regularly.

Data analysis — BW uses a Data Warehouse and OLAP standards for storing and analyzing data, in which R/3 was designed for transaction processing. With plenty of paintings you may get the identical evaluation out of R/three however maximum probable could be easier from a BW.

SAP Crystal Reports Interview Questions
Question sixteen. How Can An Erp Such As Sap Help A Business Owner Learn More About How Business Operates?

Answer :

In order to use an ERP system, a commercial enterprise man or woman ought to understand the commercial enterprise techniques and the way they paintings collectively from one purposeful area to the alternative.

This know-how offers the pupil a much deeper expertise of ways a enterprise operates. Using SAP as a tool to learn about ERP structures would require that the humans apprehend the business methods and how they integrate.

SAP ABAP Tutorial
Question 17. What Is The Difference Between Olap And Data Mining?

Answer :

OLAP – On line Analytical processing is a reporting tool configured to recognize your database schema, composition facts and dimensions. By simple factor-n-clicking, a user can run any number of canned or person-designed reports while not having to recognize some thing of SQL or the schema.

Because of that previous configuration, the OLAP engine “builds” and executes the suitable SQL. Mining is to construct the software to particularly take a look at specific analyses, often algorithmic; even extra regularly misappropriate referred to as “reporting.

Share Point Administration Interview Questions
Question 18. What Is “extended Star Schema” And How Did It Emerge?

Answer :

The Star Schema consists of the Dimension Tables and the Fact Table. The Master Data associated tables are saved in separate tables, which has connection with the traits in the size desk(s). These separate tables for grasp records is named because the Extended Star Schema.

SAP MM Interview Questions
Question 19. Define Meta Data, Master Data And Transaction Data?

Answer :

Meta Data: Data that describes the structure of records or MetaObjects is called Metadata. In other phrases statistics about data is known as Meta Data.

Master Data: Master records is statistics that remains unchanged over a protracted time frame. It carries facts that is continually wanted in the equal manner. Characteristics can bear master information in BW. With grasp statistics you're dealing with attributes, texts or hierarchies.

Transaction records: Data referring to the daily transactions is the Transaction statistics.

SAP Crystal Reports Tutorial
Question 20. Name Some Drawbacks Of Sap?

Answer :

Interfaces are massive hassle, Determine in which grasp facts is living, Expensive, very complicated, needs especially trained team of workers, lengthy implementation time.

SAP SCM Interview Questions
Question 21. What Is Bex?

Answer :

Bex stands for Business Explorer. Bex permit give up person to locate reviews, view reports, examine facts and may execute queries. The queries in workbook can be saved to their respective roles in the Bex browser. Bex has the following components: Bex Browser, Bex analyzer, Bex Map, Bex Web.

Question 22. What Are Variables?

Answer :

Variables are parameters of a question which might be set inside the parameter query definition and are not packed with values till the queries are inserted into workbooks.

There are one of a kind kinds of variables which are utilized in specific utility:

Characteristics variables, Hierarchies and hierarchy node, Texts, Formulas, Processing sorts, User access/Default kind, Replacment Path.

SAP SCM Tutorial
Question 23. What Is Awb?. What Is Its Purpose?

Answer :

AWB stands for Administrator WorkBench. AWB is a tool for controlling, tracking and maintaining all the strategies related with information staging and processing in the commercial enterprise data whearhousing.

SAP Smart Forms Interview Questions
Question 24. What Is The Significance Of Ods In Biw?

Answer :

An ODS Object serves to shop consolidated and debugged transaction facts on a file level (atomic stage). It describes a consolidated dataset from one or greater InfoSources. This dataset can be analyzed with a BEx Query or InfoSet Query.

The facts of an ODS Object can be updated with a delta replace into InfoCubes and/or different ODS Objects inside the same device or across systems. In contrast to multi-dimensional information storage with InfoCubes, the data in ODS Objects is saved in obvious, flat database tables.

SAP HR Interview Questions
Question 25. What Are The Different Types Of Source System?

Answer :

SAP R/three Source Systems, SAP BW, Flat Files and External Systems.

SAP Smart Forms Tutorial
Question 26. What Is Extractor?

Answer :

Extractors is a facts retrieval mechanisms in the SAP supply gadget. Which can fill the extract shape of a statistics source with the data from the SAP supply system datasets. The extractor can be capable of deliver data to extra fields than exist inside the extract shape.

SAP R/three Interview Questions
Question 27. Why Implement An Erp System?

Answer :

ERP software integrates all departments and features across a organization onto a unmarried laptop system which can serve all the ones different departments’ particular wishes. ERP combines finance, HR, production and distribution all together right into a single, included software program application that runs off a single database in order that the numerous departments can greater without problems share statistics and speak with every other. This incorporated method could have a tremendous payback supplied the software program is hooked up and used correctly.

SAP BASIS Interview Questions
Question 28. How Much Does It Cost To Go For Erp?

Answer :

The value of ERP challenge could vary extensively from one instance to other. The real price relies upon on the nature of the enterprise, the scale of the company, the geographical distribution of the organizational units such as workplaces, plant life, warehouses and distribution points, the number of consumer licenses and the volume of ERP implementation (the quantity of purposeful modules carried out). A normal mid-length Indian company with about Rs one hundred- three hundred crores of annual commercial enterprise will must invest about 5 to twenty crores of rupees in the ERP assignment. This consists of ERP software program licenses, server price, conversation network fee and the price of specialists who could do the implementation.

Large companies with Rs 1000+ crores of annual business may invest Rs a hundred+ crores in ERP project. A variety of small corporations have controlled to put in force ERP in approximately Rs 1 crore. It may be referred to here that in a typical set up the value of ERP software program debts for handiest about 20% of the general price. A most important component in ERP assignment is the value of the implementation representative (each inner and external).

SAP Dashboards Tutorial
Question 29. What Is An Erp Project Team?

Answer :

ERP undertaking group might be charged with the duty of enforcing the ERP for the specific organisation. A champion, who's professional in verbal exchange and is familiar with the organisation nicely must head the ERP crew. The leader ought to be properly commonplace through the maximum personnel of the business enterprise.

The chief additionally need to be someone who can hold the inducement level of the implementation crew at pretty excessive degrees for the duration of the numerous months of implementation. The implementation group could consist of dozens of humans. There might be a number of teams for every of the functional vicinity with every team along with key customers and IT personnel to offer era assist.

Sap Mm Cin Interview Questions
Question 30. Is There A Benchmarking Tool To Fine Tune Erp Performance?

Answer :

Every ERP vendor affords overall performance pointers that can be used by gadget administrators to satisfactory music overall performance. Some of them are very complete and deal with nice-tuning on the utility, database, running machine, processor or even the community degree.

Other ERP providers offer equipment which can leverage the main facet database tuning, working system tuning and community performance tuning gear.

Question 31. Erp Being Integrated Software Does One Benefit By Implementing Only Specific Modules?

Answer :

Yes. The full benefit of ERP might accrue if all of the ERP modules are carried out. However many groups put into effect ERP most effective in those features, which are, considered to be of strategic importance. Some of the modules, though they seem like restrained to particular functions, in fact combine with many different capabilities indirectly.

For example finance module in most cases targets the accounting and finance functions. However the money owed payable module cope with all the material purchases and in flip impacts the entire materials control capabilities. Many extra examples can be quoted to reinforce our point of view. The process orientation of ERP software really contributes to a better control of the agency. Even partial implementation of the ERP therefore leads to vast blessings.

Question 32. What Is The Role Of Process-modeling Tools Erp Implementation?

Answer :

Process Modelling gives a way to map the business enterprise procedures and visualize it in a graphical way. This facilitates in verbal exchange, rationalization and documentation of the “AS IS” and “TO BE” tactics. Process modelling may be used to enhance the crucial subject of ERP, namely, a shift from feature orientation to system orientation.

Sap Business One Interview Questions
Question 33. What Is The Erp Life Cycle?

Answer :

The set of activities via which ERP is carried out in an enterprise constitutes the ERP existence cycle. This may be compared to the nicely developed System Development Life Cycle (SDLC) in the conventional Structured System Analysis and Design (SSAD). Typical ERP challenge consists of the following steps:

Step 1: ERP readiness evaluation

Step 2: Preparing the business enterprise for ERP

Step 3: ERP Feasibility Study

Step 4: Process modelling and documenting the “AS IS” procedures & “TO BE” processes (in conjunction with BPR)

Step 5: Detailed plan for ERP implementation (consists of ERP software program selection, choice of implementation companions, implementation methodology – “Big Bang” or Modular Implementation – and the very last and unique volume of implementation)

Step 6: Detailed implementation together with improvement, first-rate guarantee and manufacturing gadget

Step 7: Preparing to “cross stay” consisting of facts migration

Step eight: Going live

Step 9: Performance evaluation, documentation, schooling (maintains in early stages additionally) and destiny plans.

SAP ABAP Interview Questions
Question 34. What Is Customization In Erp?

Answer :

Customization is the job of becoming the ERP software program to meet the needs of a specific agency. This might imply the mapping of the organizational systems, techniques & surroundings of the business enterprise into the corresponding model of the enterprise this is embedded within the ERP software program. In other words, it's far a mapping of the real global into the model international of the specific ERP software program.

The shape and strategies constitute one a part of customization; the creation of grasp records, enter-output paperwork, validations, reports, queries, formats, authorization, backup / restore methods, facts administration tactics, disaster healing procedures etc., constitute the whole gamut of customization.

Question 35. What Is The Ideal Background For Erp Consultants?

Answer :

An ideal background of ERP Consultants could be several years of domain know-how (HR, Finance, Material and many others) accompanied through considerable software program training and implementation revel in with at least multiple real-international implementations.

Technical knowledge via way of deep IT training helps however now not obligatory. Knowledge of enterprise manner by using way of formal business faculty training, once again is of help but not important. However enterprise know-how by using the manner of enjoy and consulting is a must.

Question 36. Where Do You Get Erp Software Market Information?

Answer :

Once once more Gartner organization and IDC, Data Quest are the prime assets of ERP market related statistics. India particular facts is made available through IDC India.

SAP Crystal Reports Interview Questions
Question 37. Is There A Segmentation Of The Erp Market?

Answer :

There is not any easy manner to segment the ERP market in a precise way that can be conveniently followed via an company as a thumb rule. However SAP R/three, Oracle Applications, BaaN Series, People Soft & Ramco Marshall represent the high-stop of the ERP marketplace. SSA BBCS & JD Edwards represent the medium-cease marketplace. Scala, Intentia Movex & QAD MFG / PRO constitute the low-end of the marketplace.

This division is normally based totally on past set up, pricing and positioning of the products with the aid of the ERP vendors themselves. It does not necessarily suggest that low stop products lack functions or high cease merchandise have all functions. It can be instructive to word that a big agency HLL makes use of QAD MFG/PRO (a low stop ERP) and a small business enterprise Microland makes use of SAP R/3 (a high give up ERP).

Question 38. Who Is The Market Leader In Erp?

Answer :

Undoubtedly SAP is the marketplace chief in ERP and has almost one-third the marketplace share. Interestingly SAP has captured  thirds of the marketplace share in India even though ERP commercial enterprise is less than  years antique in India.

2/3rds of marketplace proportion in phrases of sales but now not range of sites/corporations

Question 39. Why Should I Choose Mosaic 21 Applications For My Erp Solution?

Answer :

The four main reasons to select Mosaic 21 Applications are:

Software Functionality: outstanding consumer pleasant capability to meet all your business technique necessities.

Technology platform: guarantees the security and integrity of business enterprise information even as presenting the lowest overall value of possession.

Proven Implementation Control: with the Mosaic Implementation Methodology (MIM) you're ensured an expeditious and a hit implementation.

Industry Knowledge and Expertise: Mosaic’s sources have real world enjoy within the manufacturing and distribution industries.

Question 40. What Are The Sap Upgrade Options Available And What Are The Recommendations To The Present Customers?

Answer :

The wellknown SAP recommendation is to continually upgrade to the present day SAP ERP release in order to use the today's capability SAP gives. SAP ERP 6.0 is the “pass-to release” and the muse for any future innovations.

Use the Product Availability Matrix at http://provider.Sap.Com/pam to discover approximately all SAP improve options. The Product Availability Matrix bundles technical and launch making plans information on SAP additives for short reference. You will discover information on the availability of SAP element releases (product versions), upkeep end dates and upgrade paths, in addition to technical launch facts (DB structures, JSE platforms, working structures, languages, international locations, and so forth).

Share Point Administration Interview Questions
Question forty one. What Is New About Sap Erp 6.Zero?

Answer :

SAP ERP 6.Zero gives more than three hundred purposeful enhancements which could enhance procedure performance. In addition, it integrates the functions of maximum SAP industry solutions in order that these solutions now not want to be set up and installation one after the other. The new software also simplifies each day enterprise tasks via more appealing and included user-interface principles that growth user productiveness and pride – as an instance, with the aid of allowing the use of Duet software program for integrating Microsoft applications. Go to the solution browser device for SAP ERP to find out greater. This device permits you to identify new functions and features and their commercial enterprise blessings in a given release of SAP ERP and enhancement applications.

After you upgrade to SAP ERP 6.0, you could beautify the capability of your software with out performing a similarly improve way to a new deployment generation – the SAP enhancement applications for SAP ERP. The enhancement applications simplify the manner you manipulate and set up new software functions for SAP ERP. They permit you to take benefit of the modern-day software program improvements even as minimizing disruption to ongoing operations.

You can enforce decided on components after which activate decided on commercial enterprise features and enhancements on demand to meet your commercial enterprise requirements. This particular shipping and deployment technique for business enterprise software program, enabled with the aid of the ability of business enterprise provider-orientated structure (business enterprise SOA), helps you to access new ERP features even as maintaining on on your middle features. As a result, you could isolate the impact of software program updates and fast convey new capabilities on line thru shortened testing cycles without impeding middle business strategies.

Question forty two. What Are The Benefits Of An Erp System?

Answer :

The advantages derived from ERP can some distance outweigh the prices of the machine, presenting that the system is chosen cautiously and is suitable on your organization from a feature, price, and era point of view.

Some of the blessings realized are:

* A unmarried included gadget

* Streamlining techniques and workflows

* Reduce redundant statistics access and techniques

* Establish uniform tactics that are based totally on diagnosed exceptional commercial enterprise practices

* Information sharing throughout departments

* Improved access to statistics

* Improved workflow and efficiency

* Improved purchaser pleasure based on advanced on-time transport, increased best, shortened transport times

* Reduced inventory costs attributable to better planning, tracking and forecasting of requirements

* Turn collections faster based totally on better visibility into debts and fewer billing and/or transport errors

* Decrease in supplier pricing by means of taking better benefit of quantity breaks and monitoring vendor performance

* Track actual expenses of sports and perform interest based totally costing

* Provide a consolidated picture of income, inventory and receivables

An ERP gadget affords the strong operational spine manufacturers and vendors need to improve the volume of manufacturing and fulfillment of orders whilst lowering expenses. By optimizing your manufacturing and distribution operations with ERP, you’ll also be capable of recognition on new commercial enterprise possibilities.

SAP SCM Interview Questions