SAP Interview Questions and Answers, SAP Interview Questions

SAP Interview Questions and Answers:

1. What is ERP? - ERP is a package in the techniques and concepts for the integrated management of boom as a whole, for effective use of management resources, to boost the efficiency of an enterprise. Initially, ERP was targeted for manufacturing industry mainly for planning and managing heart sector covet generation and mortgage market. As the value increase and merits of ERP package ERP program is designed for easy technique of a association out of manufacturing to compact shops with a end of integrating tips throughout the company.

2. Different types of ERP? - SAP, BAAN, JD Edwards, Oracle Financials, Siebel, PeopleSoft. Among all the ERP’s most of the organizations intended or endeavoring to start SAP because of high amount of help aver a great deal more ERP packages.

3. What is SAP? - SAP is the and cr of the establishment rooted in 1972 under the German and cr (Systems, Applications, and Products in Data Processing) is the leading ERP (Enterprise Resource Planning) application package.

4. Explain the idea of “Business Content” in SAP Business Information Warehouse? - Business Content is a pre-configured set of role and task-relevant hints cases established on long&wshyp;lasting Metadata in the SAP Business Information Warehouse. Business Content permits some roles throughout a establishment in the tips properties trouble to carry out such a tasks. These guidelines patterns in fact contain roles, workbooks, queries, InfoSources, InfoCubes, key figures, characteristics, update regulations and extractors for SAP R/3, mySAP.com Business Applications and greater number of select applications.

5. Why do you generally select to implement SAP? - There are number of technical reasons rates of businesses are planning to commence SAP. It’s highly configurable, highly guaranteed info handling, min info redundancy, max information consistency, you can capitalize on economics of dealings want purchasing, tight integration-cross function.

6. Can BW run without a SAP R/3 implementation? - Certainly. You can run BW without R/3 implementation. You can use pre-defined market content in BW making use of your non-SAP data. Here you only wish to map the transfer residences associated in BW info supplies (InfoCubes, ODS tables) to the inbound info files or use 3rd portion utility to connect your flat files and additional information methods and mountain info in BW. Several third party ETL packages these as Acta, Infomatica, DataStage and others is able to hold kept on certified to mountain information in BW.

7. What is IDES? - International Demonstration and Education System. A sample software while for faster learning and implementation.

8. What is WF and its importance? - Business Work Flow: Tool for automatic control and execution of cross-application processes. This involves coordinating the those involved, the run steps required, the data, that needs to be processed (business objects). The chief advantage is detriment in throughput times and the rates engaged in managing sector processes. Transparency and class are beefed up by its use.

9. What is SAP R/3? - A third production set of highly integrated software modules too does rampant market function based on multinational most major practice. Takes attention of any enterprise yet distinct in operation, spread for the duration of the world. In R/3 approach all the 3 servers fancy presentation, program server and database server are located at many system.

10. What are presentation, application and database servers in SAP R/3? - The software layer of an R/3 System is acquired up of the program servers and the message server. Application programs in an R/3 System are run on program servers. The program servers communicate investing in the presentation components, the database, and in addition provided every other, making use of the message server. All the info are stored in a centralized server. This server is labeled database server.

11. What serves to be the technique for writing a BDC program? - Convert the legacy method information to a flat file and convert flat file to internal table. Transfer the flat file into sap method dubbed “sap info transfer”. Call transaction(Write the application explicitly) or put up sessions (sessions are made and processed ,if success data would transfer).

12. Explain open SQL vs native SQL? - ABAP Native SQL gives you to key in database-specific SQL statements in an ABAP program. Most ABAP programs containing database-specific SQL statements do not run among many databases. If distinct databases are involved, use Open SQL. To execute ABAP Native SQL in an ABAP program, use the statement EXEC. Open SQL (Subset of conventional SQL statements), gives you to entrance all database tables out there in the R/3 System, regardless of the manufacturer. To avert conflicts between database tables and to continue ABAP programs independent out of the database system used, SAP has generated its own set of SQL statements renowned as Open SQL.

13. What are datasets? - The sequential files (processed on software server) are dubbed datasets. They are depleted for file handling in SAP.

14. What are internal tables check table, superiority table, and transparent table? - Internal table: It is a common info kind object, that can be just throughout the runtime of the program. Check table: Check table can be at field sum checking. Value table: Value table might be at domain level checking ex: scarr table is precluding table for carrid. Transparent table: - Exists providing the same home both in dictionary as well as in database exactly with the same info and fields.

15. What are the necessary good things of reporting among BW over R/3? - Would it be an adequate amount of simply to Web-enable R/3 Reports? - Performance — Heavy reporting along amid regular OLTP sales can put up a lot of mountain both on the R/3 and the database (cpu, memory, disks, etc). Just take a be on the look at the load put on your process in a period end, quarter end, or year-end — now make the assumption such a arising even funny things frequently. Data analysis — BW uses a Data Warehouse and OLAP concepts for storing and analyzing data, at which R/3 was constructued for purchase processing. With a lot of term you can get the same analysis out of R/3 but most expected might be more effortless based on what i read in a BW.

16. How can an ERP this as SAP advantages a sector owner discover additionally about how sector operates? - In order to use an ERP system, a
sector occupant should can make out the economy crunches and how properties attempt up of one functional neighborhood to the other. This knowledge whores the student a even deeper comprehending of how a market operates. Using SAP as a service to learn throughout ERP institutions plans to require such a the
folks comprehend the sector deals with and how they integrate.

17. What is the adjustment between OLAP and Data Mining? - OLAP - On line Analytical processing is a reporting utility configured to can identify your database schema ,composition facts and dimensions . By easy point-n-clicking, a user can run any total number of canned or user-designed claims without having to recognize everything of SQL or the schema. Because of the prior configuration, the OLAP engine “builds” and executes the appropriate SQL. Mining is to make the software to specifically look at detailed analyses, often algorithmic; nonetheless more often misappropriate labeled “reporting.

18. What is “Extended Star Schema� and how did it emerge? - The Star Schema consists of the Dimension Tables and the Fact Table. The Master Data tethered tables are kept in separate tables, that has reference to the aspects in the dimension table(s). These separate tables for master info is termed as the Extended Star Schema.

19. Define Meta data, Master information and Transaction info - Meta Data: Data overly describes the residence of info or MetaObjects is referred to as Metadata. In more phrases info throughout info is famous as Meta Data. Master Data: Master info is info that will be unchanged during a extended month of time. It contains info who is constantly needed in the same way. Characteristics can bear master information in BW. With master info you are wrestling amidst attributes, texts or hierarchies. Transaction data: Data relating to the day-to-day sales is the Transaction data.

20. Name some drawbacks of SAP - Interfaces are large problem, Determine at which master information resides, Expensive, acutely complex, demands highly trained staff, lengthy implementation time.

21. What is Bex? - Bex stands for Business Explorer. Bex enables end user to locate reports, view reports, analyze hints and can execute queries. The topics in workbook can be saved to there respective roles in the Bex browser. Bex has the after components: Bex Browser, Bex analyzer, Bex Map, Bex Web.

22. What are variables? - Variables are parameters of a query such a are set in the parameter query definition and are not filled in on worth until the issues are inserted to workbooks. There are unique sorts of variables that are used in many application: Characteristics variables, Hierarchies and hierarchy node, Texts, Formulas, Processing types, User entry/Default type, Replacment Path.

23. What is AWB?. What is its purpose? - AWB stands for Administrator WorkBench. AWB is a software for controlling, monitoring and maintaining all the looks at linked amongst information staging and processing in the industry guidelines whearhousing.

24. What is the significance of ODS in BIW? - An ODS Object serves to insert consolidated and debugged deal information on a document total sum (atomic level). It describes a consolidated dataset based on information from one or a great deal more InfoSources. This dataset can be analyzed providing a BEx Query or InfoSet Query. The information of an ODS Object can be updated providing a delta update to InfoCubes and/or more ODS Objects in the same process or around systems. In contrast to multi-dimensional info storage providing InfoCubes, the information in ODS Objects is stored in transparent, flat database tables.

25. What are the multitude of kinds of source system? - SAP R/3 Source Systems, SAP BW, Flat Files and External Systems.

26. What is Extractor? - Extractors is a data retrieval mechanisms in the SAP source system. Which can fill the extract structure of a info source providing the info according to the SAP source technique datasets. The extractor may be able to availability info to a greater number of fields as opposed to arrive in the extract structure.