SAP R3 Interview Questions and Answers
Question - 61 : - Mention what is the difference between OLAP and Data Mining?
Answer - 61 : -
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.
Question - 62 : - What is Metadata, Transaction data, and Master data
Answer - 62 : -
- Meta Data: Meta Data is data about Data. It states the structure of data or MetaObjects.
- Transaction Data: This is data related to day to day transactions.
- 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 ten units of your product instead of asking the customer for his shipping address ten times, the same can be referenced from the Customer Master Data.
Question - 63 : - Can we run business warehouse without SAP R/3 implementation?
Answer - 63 : - Yes, you can run business warehouse without R/3 implementation. You have to merely 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.
Question - 64 : - What are variables?
Answer - 64 : - 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.
Question - 65 : - Mention the different types of variables?
Answer - 65 : -
Variables are used in different application
- Hierarchy nodes
- Characteristics variable
- Formulas
- Hierarchies
- Text
- Replacement Path
- Processing Types
- User entry/default type
Answer - 66 : - To view transaction table TSTC you can use transaction code st11, and you can define a new t-code using transaction se93.
Question - 67 : - Mention what are the main three stages of data-mining?
Answer - 67 : -
The three stages of data-mining include
- Initial Exploration
- Model building
- Deployment
Answer - 68 : -
- It is expensive
- Demands highly trained staff
- Lengthy implementation time
- Interfaces are a little bit complex
- Does not determine where master data resides
Question - 69 : - Mention what are the different layers in R/3 system?
Answer - 69 : -
- Different layers in R/3 system includes
- Database layer
- Presentation Layer
- Application layer
Question - 70 : - Explain what AWB is?
Answer - 70 : - AWB stands for Administrator Workbench. It is a tool for controlling monitoring and maintaining all the processes connected with data staging and processing in the business information warehousing.