SAP ERP Interview Preparation Guide

Download PDF

The four main reasons to choose Mosaic 21 Applications are:

☛ Software Functionality - superb user friendly functionality to meet all your business process reQuirements
☛ Technology platform - ensures the security and integrity of enterprise data while providing the lowest total cost -of ownership
☛ Proven Implementation Control - with the Mosaic Implementation Methodology (MIM) you are ensured an expeditious and successful implementation
☛ Industry Knowledge and Expertise - Mosaic's resources have real world experience in the manufacturing and distribution industries

Mosaic Data Solutions offers the functionality, technology platform, industry knowledge and implementation expertise to help you realize the full benefits of an ERP solution.

SAP R/3 – It succeeds SAP R/2 and is market leader in ERP. R/3 stands for three tier architecture i.e. Presentation, Logic and Data tier. It has many modules like SD, FI, and HR etc which encompass almost all enterprise departments.
My SAP – It is a suite of SAP products which apart from SAP R/3 also includes SRM, PLM, CRM, SCM

At any given time for a particular client , you can work on 6 sessions at max.

☛ OLAP: OLAP stands for Online Analytical Processing it is a reporting tool configured to understand your database schema, dimensions and composition facts
☛ Data Mining: It is an analytic process to explore data in search of consistent patterns or systematic relationship between variables.

An ODS object serves to store debugged and consolidated transaction data on a document level. It defines a consolidated dataset from one or more info-sources. This data-set can be evaluated with a Bex query or Infoset query. The data of an ODS object can be updated with a delta update into InfoCubes or other ODS object in the same system or across systems. In contrast to multi-dimensional data storage with InfoCubes, the data in ODS object is stored in transparent, flat database tables.

While executing the SAP Payment Run the standard stages of SAP includes
☛ Entering of parameters: It includes entering company codes, vendor accounts, payment methods, etc.
☛ Proposal Scheduling: The system proposes list of invoices to be paid
☛ Payment booking: Booking of the actual payments into the ledger
☛ Printing of Payment forms: Printing of payment forms

Company in SAP is the highest organizational unit for which financial statements like profit and loss statements, balance sheets can be drawn according to the requirement of organizations. A single company contains one or many company codes. All the company codes in SAP must use same COA (chart of accounts) and fiscal year.

Business Warehouse uses a DATA WAREHOUSE and OLAP concepts for analyzing and storing data While the R/3 was intended for transaction processing. You can get the same analysis out of R/3, but it would be easier from a BW.

.sca stands for SAP component Archive. It is used to deploy the java components, patches and other java developments in the form of .sca,.sda,.war and .jar.

The common transport errors include
☛ 1. Return code 4: Imported with warnings, generation of program, columns or row missing
☛ 2. Return code 8: Imported with syntax error, program generation error, dictionary activation error, etc.
☛ 3. Return code 12: Indicates import cancelled due to object missing, object not active, etc.
☛ 4. Return code 18: Indicates import cancelled due to system down while import, user expired during import and insufficient roles or authorization

ERP stands for “enterprise resource planning”. The definition of enterprise resource planning is an integrated software solution used to manage a company’s resources. ERP systems integrate all business management functions, including planning, inventory/materials management, engineering, order processing, manufacturing, purchasing, accounting and finance, human resources, and more.

Tell me about this.” Well-designed and well-implemented ERP systems help management keep track of the tiniest pieces of inventory. Custom transaction software enables employees to make real-time inventory changes. While this concept seems geared toward manufacturing, it’s applicable to any business that offers something for sale. For instance, it would also be appropriate for a retail store, food-service operation or a government facility.

Net weaver is an integrated technology platform such that all the products in the SAP suite can run on a single instance of net weaver known as SAP Web Application Server (SAP WEBAs).
The advantage of using Net weaver is you can access SAP data using the web (http protocol) or even mobile. Thus you can save on costs involved in training users on SAP Client side GUI.

The data sets are sequential files processed on the application server. They are used for file handling in SAP.

Different layers in R/3 system includes
☛ 1. Presentation Layer
☛ 2. Database layer
☛ 3. Application layer

LUW is a span of time during which database records are updated either commit or rollback.

It is the standard data type object; it exists only during the runtime of the program.
☛ 1. Check the table will be at field level checking
☛ 2. Value table will be at domain level checking
☛ 3. Transparent table will exist with the same structure both in the dictionary as well as in the database exactly with the same data and fields

The approach to writing BDC program is to
☛ 1. Create recording
☛ 2. Convert the legacy system data to a flat file into the internal table referred as “Conversion.”
☛ 3. Transfer the Flat file into the SAP system called “SAP Data Transfer.”
☛ 4. Depending upon the BDC type CALL TRANSACTION or CREATE SESSIONS

Dispatcher is a component that takes the request for client systems and stores the request in queue.

The star schema consists of the fact tables and the dimension tables. The master data related tables are kept in separate tables, which has reference to the characteristics in the dimension tables. These separate tables for master data are termed as the Extended Star Schema.

If the candidate has only worked on financial systems, for example, how did she handle integrating payroll automation with HR? You might also invite the candidate to discuss a few examples of flaws or bugs that she later resolved.

☛ 1. FI (Financial Accounting)
☛ 2. CO (Controlling)
☛ 3. EC (Enterprise Controlling)
☛ 4. TR (Treasury)
☛ 5. IM (Investment Management)
☛ 6. HR (Human Resource)
☛ 7. SD (Sales and Distribution)
☛ 8. MM (Materials Management)
☛ 9. PM (Plant Maintenance)
☛ 10. PP (Production Planning)
☛ 11. QM – Quality Management
☛ 12. BW (Business Warehousing)
There are many industry specific solutions that SAP provides apart from the list of modules above which is ever growing.

To view transaction table TSTC you can use transaction code st11, and you can define a new t-code using transaction se93.

BDC stand for Batch Data Communication. The methods of BDC are
☛ 1. Direct Input Method
☛ 2. Batch Input Session Method
☛ 3. Call transaction Method

The difference between the residual and partial payment includes
☛ Partial payment: For example, let say invoice A456 exits for $100 and customer pay $70. With the partial payment, it offsets the invoice leaving a remaining balance $30
☛ Residual Payment: While in residual payment, invoice A456 is cleared for the full value $100 and a new invoice line item is produced for the remaining balance of $30.