SAP Interview Questions and Answers
Question - 21 : - What is Bex?
Answer - 21 : - Bex stands for Business Explorer. Bex enables end user to locate reports, view reports, analyze information and can execute queries. The queries in workbook can be saved to there respective roles in the Bex browser. Bex has the following components: Bex Browser, Bex analyzer, Bex Map, Bex Web.
Question - 22 : - What are variables?
Answer - 22 : - Variables are parameters of a query that are set in the parameter query definition and are not filled with values until the queries are inserted into workbooks. There are different types of variables which are used in different application: Characteristics variables, Hierarchies and hierarchy node, Texts, Formulas, Processing types, User entry/Default type, Replacment Path.
Question - 23 : - What is AWB?. What is its purpose?
Answer - 23 : - AWB stands for Administrator WorkBench. AWB is a tool for controlling, monitoring and maintaining all the processes connected with data staging and processing in the business information whearhousing.
Question - 24 : - What is the significance of ODS in BIW?
Answer - 24 : - An ODS Object serves to store consolidated and debugged transaction data on a document level (atomic level). It describes a consolidated dataset from one or more InfoSources. This dataset can be analyzed with a BEx Query or InfoSet Query. The data of an ODS Object can be updated with a delta update into InfoCubes and/or other ODS Objects in the same system or across systems. In contrast to multi-dimensional data storage with InfoCubes, the data in ODS Objects is stored in transparent, flat database tables.
Question - 25 : - What are the different types of source system?
Answer - 25 : - SAP R/3 Source Systems, SAP BW, Flat Files and External Systems.
Question - 26 : - What is Extractor?
Answer - 26 : - Extractors is a data retrieval mechanisms in the SAP source system. Which can fill the extract structure of a data source with the data from the SAP source system datasets. The extractor may be able to supply data to more fields than exist in the extract structure.
Question - 27 : - Describe how SAP handles Memory Management?
Answer - 27 : - ST02 / ST03 In general via table buffers, you could go into the whole Work Process, roll in, roll out, heap (private) memory, etc. However just as a Unix or DBA admin would know, is you look this up when needed for the exact specifics.
Question - 28 : - Can you create a table with fields not referring to data elements?
Answer - 28 : - YES. eg:- ITAB LIKE SPFLI.here we are referring to a data object(SPFLI) not data element.
Question - 29 : - What are the different types of data dictionary objects?
Answer - 29 : - tables, structures, views, domains, data elements, lock objects, Match code objects.
Question - 30 : - What should be the approach for writing a BDC program?
Answer - 30 : - STEP 1: CONVERTING THE LEGACY SYSTEM DATA TO A FLAT FILE to internal table CALLED "CONVERSION".
STEP 2: TRANSFERING THE FLAT FILE INTO SAP SYSTEM CALLED "SAP DATA TRANSFER".
STEP 3: DEPENDING UPON THE BDC TYPE
i)call transaction(Write the program explicity)
ii) create sessions (sessions are created and processed.if success data will transfer).