Name some drawbacks of SAP ?
Interfaces are huge problem, Determine where master data
resides, Expensive, very complex, demands highly trained
staff, lengthy implementation time.
What is Bex?
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.
What are variables?
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
What is AWB?. What is its purpose?
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.
What is the significance of ODS in BIW?
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.
What are the different types of source system?
SAP R/3 Source Systems, SAP BW, Flat Files and External
What is Extractor?
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.
Describe how SAP handles Memory Management?
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.
Describe where they would look at the buffer statistics,
and what steps they would use to adjust them?
ST02, RZ10 ...
Describe how to setup a printer in SAP or where they
would look to research why a user/users can not print?
SPAD, SP01, SM50, SU01 ...
Can you create a table with fields not referring to data
YES. eg:- ITAB LIKE SPFLI.here we are referring to a
data object(SPFLI) not data element.
What are the different types of data dictionary objects?
tables, structures, views, domains, data elements, lock
objects, Match code objects.
What should be the approach for writing a BDC program?
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).
What are the problems in processing batch input sessions
and How is batch input process different from processing
PROBLEMS: i) If the user forgets to opt for keep session
then the session will be automatically removed from the
session queue(log remains). However if session is
processed we may delete it manually.
ii)if session processing fails data will not be
transferred to SAP database table.
What does an extract statement do in the ABAP program?
Once you have declared the possible record types as
field groups and defined their structure, you can fill
the extract dataset using the following statements:
EXTRACT. When the first EXTRACT statement occurs in a
program, the system creates the extract dataset and adds
the first extract record to it. In each subsequent
EXTRACT statement, the new extract record is added to
the dataset EXTRACT HEADER. When you extract the data,
the record is filled with the current values of the
corresponding fields. As soon as the system has
processed the first EXTRACT statement for a field group
, the structure of the corresponding extract record in
the extract dataset is fixed. You can no longer insert
new fields into the field groups and HEADER. If you try
to modify one of the field groups afterwards and use it
in another EXTRACT statement, a runtime error occurs. By
processing EXTRACT statements several times using
different field groups, you fill the extract dataset
with records of different length and structure. Since
you can modify field groups dynamically up to their
first usage in an EXTRACT statement, extract datasets
provide the advantage that you need not determine the
structure at the beginning of the program.
Can a transparent table exist in data dictionary but not
in the data base physically?
NO. TRANSPARENT TABLE DO EXIST WITH THE SAME STRUCTURE
BOTH IN THE DICTIONARY AS WELL AS IN THE
DATABASE,EXACTLY WITH THE SAME DATA AND FIELDS.
What is the step by step process to create a table in
step 1: creating domains(data type, field length,
step 2: creating data elements(properties and type for a
step 3: creating tables(SE11).