Interview Questions.

Q1. What Are Datasets?

The sequential files (processed on software server) are known as datasets. They are used for file dealing with in SAP.

Q2. What Is New About Sap Erp 6.Zero?

SAP ERP 6.0 affords extra than 300 practical upgrades that may improve technique efficiency. In addition, it integrates the capabilities of maximum SAP industry answers so that those answers not need to be mounted and set up one at a time. The new software program also simplifies day by day commercial enterprise duties via extra appealing and incorporated person-interface standards that boom user productiveness and pride – as an example, through permitting the use of Duet software program for integrating Microsoft programs. Go to the solution browser tool for SAP ERP to discover extra. This device allows you to identify new features and capabilities and their commercial enterprise advantages in a given launch of SAP ERP and enhancement programs.

After you improve to SAP ERP 6.0, you may enhance the capability of your utility with out performing a in addition improve thanks to a new deployment technology – the SAP enhancement applications for SAP ERP. The enhancement packages simplify the way you manipulate and install new software program capabilities for SAP ERP. They allow you to take advantage of the brand new software program innovations at the same time as minimizing disruption to ongoing operations.

You can implement selected additives and then prompt decided on business capabilities and enhancements on demand to satisfy your enterprise requirements. This unique transport and deployment technique for organisation software, enabled with the aid of the power of company carrier-orientated architecture (organization SOA), helps you to get right of entry to new ERP features whilst conserving on on your middle capabilities. As a end result, you can isolate the effect of software program updates and speedy bring new features on line through shortened testing cycles with out impeding core business tactics.

Q3. What Are Presentation, Application And Database Servers In Sap R/three?

The application layer of an R/three System is made up of the utility servers and the message server. Application applications in an R/3 System are run on software servers. The utility servers talk with the presentation components, the database, and also with every different, using the message server. All the statistics are saved in a centralized server. This server is called database server.

Q4. What Are Variables?

Variables are parameters of a question which might be set within the parameter query definition and aren't packed with values until the queries are inserted into workbooks.

There are unique kinds of variables that are utilized in extraordinary utility:

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

Q5. What Is Customization In Erp?

Customization is the process of becoming the ERP software to satisfy the demands of a specific corporation. This could imply the mapping of the organizational systems, approaches & surroundings of the agency into the corresponding version of the employer that is embedded in the ERP software program. In different phrases, it is a mapping of the actual international into the version world of the precise ERP software program.

The structure and processes represent one a part of customization; the advent of master records, input-output forms, validations, reports, queries, formats, authorization, backup / restore tactics, information management methods, catastrophe healing methods and so on., represent the overall gamut of customization.

Q6. What Is Extractor?

Extractors is a data retrieval mechanisms within the SAP supply system. Which can fill the extract shape of a information supply with the records from the SAP source system datasets. The extractor can be able to supply records to more fields than exist within the extract shape.

Q7. What Is The Significance Of Ods In Biw?

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

The records of an ODS Object can be updated with a delta update into InfoCubes and/or other ODS Objects within the equal device or throughout systems. In comparison to multi-dimensional records garage with InfoCubes, the statistics in ODS Objects is stored in obvious, flat database tables.

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

Yes. The complete gain of ERP might accrue if all the ERP modules are applied. However many organizations enforce ERP most effective in the ones functions, which can be, considered to be of strategic significance. Some of the modules, though they appear to be limited to particular functions, in fact integrate with many other functions in a roundabout way.

For instance finance module broadly speaking goals the accounting and finance functions. However the bills payable module address all of the cloth purchases and in turn influences the entire substances management functions. Many extra examples can be quoted to reinforce our standpoint. The manner orientation of ERP software program genuinely contributes to a better control of the company. Even partial implementation of the ERP consequently ends in tremendous blessings.

Q9. Who Is The Market Leader In Erp?

Undoubtedly SAP is the marketplace chief in ERP and has nearly one-1/3 the market share. Interestingly SAP has captured  thirds of the marketplace percentage in India though ERP business is much less than two years antique in India.

2/3rds of market percentage in phrases of revenues however no longer wide variety of web sites/organizations

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

Process Modelling affords a method to map the organisation strategies and visualize it in a graphical manner. This enables in verbal exchange, rationalization and documentation of the “AS IS” and “TO BE” processes. Process modelling may be used to reinforce the crucial subject matter of ERP, namely, a shift from function orientation to system orientation.

Q11. What Is An Erp Project Team?

ERP challenge group could be charged with the responsibility of imposing the ERP for the unique business enterprise. A champion, who is skilled in conversation and understands the company well ought to head the ERP crew. The leader ought to be properly commonplace through the maximum employees of the corporation.

The leader also have to be someone who can keep the motivation stage of the implementation team at pretty high stages all through the numerous months of implementation. The implementation crew would include dozens of human beings. There could be some of teams for every of the purposeful area with every group consisting of key customers and IT employees to provide generation guide.

Q12. What Is Awb?. What Is Its Purpose?

AWB stands for Administrator WorkBench. AWB is a device for controlling, tracking and maintaining all of the techniques linked with records staging and processing inside the business records whearhousing.

Q13. Define Meta Data, Master Data And Transaction Data?

Meta Data: Data that describes the shape of information or MetaObjects is referred to as Metadata. In different phrases statistics about statistics is called Meta Data.

Master Data: Master data is statistics that remains unchanged over a long period of time. It contains statistics that is constantly wanted within the equal manner. Characteristics can endure grasp information in BW. With master statistics you're managing attributes, texts or hierarchies.

Transaction information: Data referring to the everyday transactions is the Transaction information.

Q14. What Are The Different Types Of Source System?

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

Q15. What Is Sap?

SAP is the call of the organisation based in 1972 underneath the German call (Systems, Applications, and Products in Data Processing) is the leading ERP (Enterprise Resource Planning) software bundle.

Q16. What Should Be The Approach For Writing A Bdc Program?

Convert the legacy device information to a flat document and convert flat document into internal table. Transfer the flat document into sap system called “sap records switch”. Call transaction (Write this system explicitly) or create periods (classes are created and processed, if fulfillment information will transfer).

Q17. Name Some Drawbacks Of Sap?

Interfaces are huge hassle, Determine in which grasp statistics is living, Expensive, very complicated, demands notably educated team of workers, prolonged implementation time.

Q18. How Can An Erp Such As Sap Help A Business Owner Learn More About How Business Operates?

In order to use an ERP machine, a enterprise man or woman need to recognize the commercial enterprise tactics and how they paintings collectively from one functional location to the alternative.

This know-how gives the pupil a far deeper know-how of how a business operates. Using SAP as a tool to learn about ERP systems will require that the people understand the enterprise procedures and the way they integrate.

Q19. Why Implement An Erp System?

ERP software integrates all departments and functions throughout a business enterprise onto a unmarried laptop device that may serve all the ones different departments’ precise wishes. ERP combines finance, HR, manufacturing and distribution all collectively into a unmarried, included software program application that runs off a single database so that the diverse departments can extra effortlessly percentage information and communicate with every other. This incorporated technique will have a high-quality payback supplied the software is mounted and used efficiently.

Q20. Explain Open Sql Vs Native Sql?

ABAP Native SQL allows you to include database-particular SQL statements in an ABAP program. Most ABAP packages containing database-precise SQL statements do no longer run with exclusive databases. If one-of-a-kind databases are concerned, use Open SQL. To execute ABAP Native SQL in an ABAP program, use the announcement EXEC. Open SQL (Subset of trendy SQL statements), permits you to get admission to all database tables available within the R/3 System, regardless of the producer.

To keep away from conflicts among database tables and to hold ABAP applications unbiased from the database machine used, SAP has generated its personal set of SQL statements referred to as Open SQL.

Q21. What Is Wf And Its Importance?

Business Work Flow: Tool for computerized control and execution of go-utility tactics. This involves coordinating the individuals worried, the paintings steps required, the records, which wishes to be processed (enterprise gadgets). The primary gain is discount in throughput instances and the charges involved in coping with commercial enterprise methods. Transparency and first-class are improved by way of its use.

Q22. What Is Sap R/three?

A 1/3 era set of enormously incorporated software modules that plays not unusual commercial enterprise feature based on multinational leading exercise. Takes care of any agency however various in operation, unfold over the arena. In R/three machine all the three servers like presentation; application server and database server are located at exceptional system.

Q23. What Are The Benefits Of An Erp System?

The advantages derived from ERP can a long way outweigh the fees of the system, imparting that the gadget is chosen cautiously and is suitable in your corporation from a function, fee, and technology point of view.

Some of the blessings realized are:

* A unmarried integrated device

* Streamlining methods and workflows

* Reduce redundant records entry and tactics

* Establish uniform processes that are based on recognized pleasant commercial enterprise practices

* Information sharing throughout departments

* Improved access to records

* Improved workflow and efficiency

* Improved patron delight primarily based on stepped forward on-time delivery, accelerated pleasant, shortened shipping instances

* Reduced stock expenses on account of higher planning, monitoring and forecasting of necessities

* Turn collections quicker based totally on better visibility into bills and less billing and/or transport errors

* Decrease in dealer pricing through taking better benefit of amount breaks and monitoring vendor performance

* Track actual costs of activities and perform interest based totally costing

* Provide a consolidated picture of sales, inventory and receivables

An ERP device gives the strong operational spine manufacturers and distributors need to enhance the extent of manufacturing and success of orders at the same time as decreasing costs. By optimizing your production and distribution operations with ERP, you’ll also be able to cognizance on new commercial enterprise possibilities.

Q24. What Is The Ideal Background For Erp Consultants?

An best background of ERP Consultants would be numerous years of area expertise (HR, Finance, Material and so forth) accompanied through giant software education and implementation revel in with at least multiple real-world implementations.

Technical know-how with the aid of manner of deep IT education allows however no longer mandatory. Knowledge of enterprise method with the aid of way of formal commercial enterprise faculty training, another time is of help however now not necessary. However enterprise expertise by way of the manner of experience and consulting is a must.

Q25. What Is Erp?

ERP is a package with the strategies and ideas for the included control of enterprise as a whole, for effective use of control resources, to improve the efficiency of an company. Initially, ERP become centered for production industry particularly for making plans and handling core enterprise like manufacturing and financial market.

As the increase and merits of ERP package ERP software program is designed for fundamental technique of a employer from production to small stores with a goal of integrating statistics throughout the agency.

Q26. Why Do You Usually Choose To Implement Sap?

There are variety of technical motives numbers of groups are planning to implement SAP. It’s surprisingly configurable, quite comfy records handling, min information redundancy, max information consistency, you can capitalize on economics of sales like purchasing, tight integration-cross function.

Q27. Different Types Of Erp?

SAP, BAAN, JD Edwards, Oracle Financials, Siebel, PeopleSoft. Among all the ERP’s most of the groups applied or trying to enforce SAP because of wide variety of benefits over different ERP applications.

Q28. What Is The Difference Between Olap And Data Mining?

OLAP – On line Analytical processing is a reporting device configured to understand your database schema, composition records and dimensions. By simple point-n-clicking, a person can run any quantity of canned or consumer-designed reviews without having to realize some thing of SQL or the schema.

Because of that previous configuration, the OLAP engine “builds” and executes an appropriate SQL. Mining is to construct the software to in particular observe particular analyses, often algorithmic; even more frequently misappropriate known as “reporting.

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

Performance Heavy reporting at the side of everyday OLTP transactions can produce loads of load each at the R/three and the database (cpu, memory, disks, etc). Just test the weight put on your gadget at some point of a month give up, area quit, or 12 months-give up — now believe that taking place even extra frequently.

Data evaluation — BW uses a Data Warehouse and OLAP principles for storing and studying information, wherein R/three became designed for transaction processing. With loads of paintings you can get the identical evaluation out of R/3 however most in all likelihood would be simpler from a BW.

Q30. What Are Internal Tables Check Table, Value Table, And Transparent Table?

Internal table: It is a popular facts kind object, which exists most effective during the runtime of the program.

Check desk: Check table will be at field degree checking.

Value table: Value table might be at domain stage checking

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

Transparent desk: – Exists with the equal structure each in dictionary as well as in database exactly with the same facts and fields.

Q31. Is There A Benchmarking Tool To Fine Tune Erp Performance?

Every ERP dealer gives performance recommendations that may be utilized by gadget directors to best tune overall performance. Some of them are very comprehensive and address quality-tuning at the utility, database, operating system, processor or even the network stage.

Other ERP carriers provide equipment which can leverage the leading facet database tuning, running machine tuning and network performance tuning tools.

Q32. Can Bw Run Without A Sap R/3 Implementation?

Certainly. You can run BW with out R/3 implementation. You can use pre-described business content material in BW the usage of your non-SAP statistics. Here you sincerely need to map the switch structures related to BW facts assets (InfoCubes, ODS tables) to the inbound data documents or use third element device to connect your flat files and different records assets and load information in BW. Several third party ETL products together with Acta, Infomatica, DataStage and others will have been certified to load statistics in BW.

Q33. What Is Ides?

International Demonstration and Education System. A sample application furnished for quicker gaining knowledge of and implementation.

Q34. Is There A Segmentation Of The Erp Market?

There isn't any easy way to phase the ERP marketplace in a specific way that may be conveniently adopted by an employer as a thumb rule. However SAP R/three, Oracle Applications, BaaN Series, People Soft & Ramco Marshall constitute the excessive-end of the ERP market. SSA BBCS & JD Edwards represent the medium-quit marketplace. Scala, Intentia Movex & QAD MFG / PRO constitute the low-end of the market.

This division is normally primarily based on past installation, pricing and positioning of the goods via the ERP providers themselves. It does now not always suggest that low stop merchandise lack functions or high quit products have all capabilities. It can be instructive to be aware that a large company HLL makes use of QAD MFG/PRO (a low quit ERP) and a small company Microland uses SAP R/three (a excessive stop ERP).

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

The widespread SAP advice is to always upgrade to the modern-day SAP ERP launch in an effort to use the latest functionality SAP gives. SAP ERP 6.0 is the “cross-to release” and the muse for any destiny improvements.

Use the Product Availability Matrix at http://service.Sap.Com/pam to find out approximately all SAP improve alternatives. The Product Availability Matrix bundles technical and launch making plans facts on SAP components for quick reference. You will find records on the availability of SAP thing releases (product versions), protection give up dates and upgrade paths, as well as technical launch statistics (DB platforms, JSE platforms, working structures, languages, countries, and so forth).

Q36. Where Do You Get Erp Software Market Information?

Once once more Gartner group and IDC, Data Quest are the top resources of ERP marketplace associated records. India precise records is made available via IDC India.

Q37. What Is Bex?

Bex stands for Business Explorer. Bex enable cease person to locate reports, view reviews, examine statistics and can execute queries. The queries in workbook can be saved to their respective roles in the Bex browser. Bex has the subsequent components: Bex Browser, Bex analyzer, Bex Map, Bex Web.

Q38. How Much Does It Cost To Go For Erp?

The value of ERP mission would range appreciably from one example to different. The actual value relies upon on the character of the enterprise, the size of the company, the geographical distribution of the organizational units consisting of offices, vegetation, warehouses and distribution factors, the quantity of consumer licenses and the extent of ERP implementation (the variety of purposeful modules applied). A standard mid-length Indian agency with approximately Rs one hundred- three hundred crores of annual enterprise will have to make investments about 5 to twenty crores of rupees inside the ERP mission. This consists of ERP software program licenses, server price, verbal exchange community fee and the price of experts who could do the implementation.

Large groups with Rs a thousand+ crores of annual business may make investments Rs 100+ crores in ERP task. A variety of small agencies have controlled to implement ERP in approximately Rs 1 crore. It may be stated right here that during a typical set up the price of ERP software bills for most effective about 20% of the general value. A major issue in ERP challenge is the price of the implementation representative (each internal and external).

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

The four primary motives to pick out Mosaic 21 Applications are:

Software Functionality: remarkable person pleasant capability to fulfill all of your commercial enterprise procedure necessities.

Technology platform: guarantees the security and integrity of company records at the same time as providing the lowest general fee 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 actual world enjoy inside the production and distribution industries.

Q40. What Is The Erp Life Cycle?

The set of sports via which ERP is applied in an organisation constitutes the ERP lifestyles cycle. This may be compared to the nicely developed System Development Life Cycle (SDLC) within the conventional Structured System Analysis and Design (SSAD). Typical ERP undertaking includes the subsequent steps:

Step 1: ERP readiness evaluation

Step 2: Preparing the enterprise for ERP

Step three: ERP Feasibility Study

Step 4: Process modelling and documenting the “AS IS” techniques & “TO BE” methods (together with BPR)

Step five: Detailed plan for ERP implementation (includes ERP software program choice, choice of implementation companions, implementation technique – “Big Bang” or Modular Implementation – and the final and unique quantity of implementation)

Step 6: Detailed implementation together with improvement, exceptional assurance and manufacturing machine

Step 7: Preparing to “pass live” including statistics migration

Step eight: Going live

Step 9: Performance evaluation, documentation, education (keeps in early degrees also) and future plans.