1.What is an ERP ?
ERP stands for Enterprise Resource Planning Software and is a integrated computer based system used to manage a company's resources effectively. It ensures smooth information amongst various departments in an enterprise or a company and manages workflows.
2.What are the different types of ERP's ?
SAP
Baan
JD Edwards (now acquired by Oracle)
Siebel
Peoplesoft (now acquired by Oracle)
Microsoft Dynamics
3.Tell me briefly about SAP.
SAP stands for Systems Applications and Products in Data Processing.It was Founded in 1972 by Wellenreuther, Hopp, Hector, Plattner and Tschira and is a German Company.
SAP is name of the company as well its ERP product.
SAP is #1 in the ERP market .As of 2010, SAP has more than 140,000 installations worldwide ,over 25 industry-specific business solutions, and more than 75,000 customers in 120 countries.
4. What are the different SAP products ?
SAP R/3 - It succeds 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 , HR etc which encompass almost all enterprise departments.
mySAP - It is a suite of SAP products which apart from SAP R/3 also includes SRM , PLM, CRM, SCM
5.What is NetWeaver ?
Netweaver is an integrated technology platform such that all the products in the mySAP suite can run on a single instance of netweaver known as SAP Web Application Server (SAP WEBAs).
The advantage of using Netweaver 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.
6.List the Different Modules in SAP.
FI (Financial Accounting)
CO(Controlling)
EC(Enterprise Controlling)
TR(Treasury)
IM (Investment Management)
HR (Human Resource)
SD (Sales and Distribution)
MM (Materials Management)
PM (Plant Maintenance)
PP (Production Planning)
QM - Quality Management
BW (Business Warehousing)
There are many industry specific solutions that SAP provides apart from the list of modules above which is ever growing.
7.What is Meta data, Master data and Transaction data
Meta Data: Meta Data is data about Data. It tells you about the structure of data or MetaObjects.
Master Data: This Data is key business information like Customer information , Employee , Materials etc. This is more like a reference data. For Ex. If a customer orders 10 units of your product instead of asking customer for his shipping address 10 times , the same can be referenced from the Customer Master Data.
Transaction Data: This is data related to day to day transactions.
8.Is SAP A Database ?
NO. SAP is not a database but its an application that makes use of databases provided by other vendors like Oracle , SQL Server etc.
9. How many SAP Sessions can you work on at a given time ?
At any given time for a particular client , you can work on 6 sessions at max.
10.What is a transaction in SAP terminology ?
In SAP terminology, a transaction is series of logically connected dialog steps.
Yes, you can run business warehouse without R/3 implementation. You have to simply transfer structures associated with business warehouse data sources (ODS table, Infocube) to the inbound data files or use third party tools to connect your flat files and other data sources.
The data sets are sequential files processed on the application server. They are used for file handling in SAP.
Variables are parameters of a query that are set in the parameter query definition and are not filled with values until the queries are entered into the workbooks.
Variables are used in different application
To view transaction table TSTC you can use transaction code st11, and you can define a new t-code using transaction se93.
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.
Three stages of data-mining includes
Different layers in R/3 system includes
To create a table in the data dictionary, you have to follow this steps
AWB stands for Administrator Workbench. It is a tool for monitoring, controlling and maintaining all the processes connected with data staging and processing in the business information warehousing.
Bex means Business Explorer. It allows end user to locate reports, analyze information, view reports and can execute queries. The queries in workbook can be saved to their respective roles in the Bex browser. It has following components Bex analyzer, Bex Map and Bex web.
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.
Data Element: It is an intermediate object between domain and table type
Domain: It defines the attributes such as length, type, and possible value range
To use parameter IDs, you need to "set" values in the global memory area and then "get" values from this parameter ID memory area. In the case of the online program, you have to "Set" values from screen fields, and you will "get" these values for screen fields.
LUW is a span of time during which database records are updated either commit or rollback.
BDC stand for Batch Data Communication. The methods of BDC are
The baseline date is the date from which the payment terms apply. Usually, it is the document date on the invoice but can also be the date of entry or posting date from the ledger.
In certain industries, it is not possible to create new master records for every vendor trading partner. One-time vendor enables for a dummy vendor code to be used on invoice entry and the information that is normally stored in the vendor master, is keyed on the invoice itself.
While executing the SAP Payment Run the standard stages of SAP includes
The difference between the residual and partial payment includes
It is the standard data type object; it exists only during the runtime of the program.
The application layer of a R/3 system is made up of the application server and the message server. Application programs in an R/3 system run on application servers. Using the message server, the application servers communicate with presentation components, the database and also with each other. All the data are stored in a centralized server, which is known as a database server.
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.
SAP ABAP is the programming language used within SAP to customize, generate forms, generate reports, etc. While SAP basis is, the administration module of SAP used to control code changes, upgrades, database admin, network setup, etc.
The different types of the source system in SAP includes
In the SAP source system, extractors is a data retrieval mechanism. It can fill the extract structure of a data source with the data from the SAP source system datasets.
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.
The approach to writing BDC program is to
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.
To deal with communication, you can use two types of services
"Reason Codes" are tags that can be allocated to describe under/overpayments during the allocation of incoming customer payments. They should not be mixed up with "void reason codes" used when outgoing cheques are produced.
The SAP gateway process uses TCP/IP protocol to communicate with the clients.
Pooled tables are used to store control data. Several pooled tables can be united to form a table pool. Table tool is a physical table on the database in which all the records of the allocated pooled tables are stored.
If the data in one of the base tables of a matchcode ID changes, the matchcode data has to be updated. The update type stipulates when the match-code has to be updated and how it has to be done. The update type also defines which method is to be used for building match-codes.
.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.
Business Content in SAP is a pre-configured and pre-defined models of information contained in the SAP warehouse which can be used directly or with desired modification in different industries.
Dispatcher is a component that takes the request for client systems and stores the request in queue.
The common transport errors include
This Interview Questions and Answers are useful for Freshers and Experienced both.