These material are compiled for helping junior / senior software engineers
1. Can you create a table with fields not referring to data
YES. eg:- ITAB LIKE SPFLI.here we are referening 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
2. What should be the approach for writing a BDC
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
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
3. What are the problems in processing batch input sessions and
How is batch input process different from processing online?
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
4. What does an extract statement do in the ABAP
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.
5. 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
6. What is the step by step process to create a table in data
step 1: creating domains(data type, field length, range).
step 2: creating data elements(properties and type for a table
step 3: creating tables(SE11).
7. What is the typical structure of an ABAP/4 program?
8. A situation: An ABAP program creates a batch input session. We
need to submit the program and the batch session in back ground. How to
go to SM36 and create background job by giving job name, job class and
job steps (JOB SCHEDULING)
9. What are the domains and data elements?
DOMAINS : FORMAL DEFINITION OF THE DATA TYPES.THEY SET ATTRIBUTES SUCH AS
DATA TYPE,LENGTH,RANGE. DATA ELEMENT : A FIELD IN R/3 SYSTEM IS A DATA
10. What is the alternative to batch input session?
12. What is a batch input session?
BATCH INPUT SESSION is an intermediate step between internal table and
database table. Data along with the action is stored in session ie data
for screen fields, to which screen it is passed, program name behind it,
and how next screen is processed.
13. What is the advantage of structures? How do you use them in
the ABAP programs?
Adv:- GLOBAL EXISTANCE(these could be used by any other program without
creating it again).
14. How many types of tables exists and what are they in data
4 types of tables
i)Transparent tables - Exists with the same structure both in dictionary
as well as in database exactly with the same data and fields. Both
Opensql and Nativesql can be used. ii)Pool tables &
iii)Cluster tables - These are logical tables that are arranged as
records of transparent tables. one cannot use native sql on these tables
(only open sql).They are not managable directly using database system
iv)Internal tables - .?
SAP R-3 Interview Question?
- What is the command in subscript?
- In ver 3.0b how is the print program to layout set?
- Whats an effective way of using an internal table record? What are
the types of internal tables?
- In production what is the user exit?
- What type of user exits have you written?
- Have you worked with field groups? Have you used Import/Export
- In the select statement what is group by?
- Have you used performance tuning? What major steps will you use for
- On ABAP: Did you set up a workflow? Are you familiar with all steps
for setting up a workflow?
- Have you created Maintenance dialog or Table Maintenance?
- How to create client independent tables
- Difference between client dependent and client independent tables?
- Have you created database tables?
- Difference between Search Helps and Match Codes?
- Elementary search helps, Collective search help.?
- What does an EXEC SQL stmt do in ABAP? What is the disadvantage of
- What is open sql vs native sql?
- What is a collect statement? How is it different from append?
- If an entry with the same key already exists, the COLLECT statement
does not append a new line, but adds the contents of the numeric fields
in the work area to the contents of the numeric fields in the existing
- How can I copy a standard table to make my own z_table.?
- Which transaction code can I used to analyze the performance of ABAP
- How do we debug sapscript?
- Can we create field without data element and how?
- When top of the page event is triggered?
- How do you get output from IDOC?
SAP R-3 Interview Question?
- In selection screen I have three fields, plant mat no and material
group. If I input plant how do I get the mat no and material group based
on plant dynamically?
- On which even we can validate the input fields in module progams?
- What are client dependant objects in abap/sap?
- How data is stored in cluster table?
- What is the difference between Upload and WS_Upload ?
- Open datasets, Read datasets ( Reading and writing data to files)?
- Have you set up a back ground job ? How to create a background job
without a variant ?
- Have you processed BDCs ?
- How do you send files to the legacy systems from SAP and vice versa?
How does one know that the legacy files have come on to the SAP server
you are working on?
- What kind of BDC programs are written ?
- Update types in Call transaction method. What is the difference?
- Call transaction method, how to capture the errors ?
- Data conversion experience?
- Experience with ABAP and Unix files?
- From Excel to ABAP - Is batch mode possible ?
- How to read files and process BDCs automatically?
- Difference between /N and /BEND?
- SM35 transaction . How to automate BDC ?
- BDC vs Direct Loads( have you used direct loads on SAP tables )?
- Recording Function?
- What are logical databases?
- What is Group by in Select statement?
- Catch Command?
- Explain Commit and Roll back?
- Difference between Insert, Update and Modify?
- What happens Update command is used without where clause ?
SAP R-3 Interview Question?
- Select statement to read data into internal tables. Types of Select
- hats an effective way of using an internal table record?
- Types of internal tables?
- Field groups?
- Control levels in internal tables?
- How to eliminate duplicate entries in internal tables?
- Size of the internal tables?
- Field groups and internal tables?
- Handling of internal tables?
- What is an Open Item in SAP? How will you find an Open Item in SAP?
- What are the modules in FI that you have worked on?
- In the MM module for finding out the standard cost what is the view
one has to look at?
- What is the work you have done in the MM module and what programs did
you use for creating views in MM?
- Condition technique?
- In the function module for reading text from the S.O header what
needs to be specified?
- How do you get the Sales Order (S.O) No. from the Delivery Order?
- While picking can the pick list be updated automatically?
- In delivery processing which step comes first picking,
packing,posting goods issue ?
- What happens when you post goods issue after delivery? How does the
inventory get reduced after the delivery?
- Do you need and enquiry or quotation before we start the SD process?
- Explain what are the steps in the SD process at least up to the
- What is an Unpack command?
- What is the reserve command?
- How many interactive reports did you write?
- What is the most complex interactive report that was written by You?
- Double click function on the lists, identifying the line selected by
the user on the list.
- At-Line selection, At user-command etc..,?
- Exit and Stop. What is the difference?
- Check and Continue. What is the difference?
Describe the nature of the relationship between SAP and
D&B and SAP have been Global Partners for over a year. D&B are
mySAP.com Software Alliance Partners. The joint offering, D&B for
SAP R/3, delivered as part of mySAP.com, seamlessly integrates the
D&B for SAP R/3 solution and D&B business information for
enhanced decision support. D&B also offers a Data Rationalization
Service for SAP customers to consolidate, cleanse and eliminate
redundant customer and vendor records that originate from a wide
variety of sources and multiple formats.
Is the relationship between D&B and SAP exclusive to either
No, the partnership agreement is not exclusive. It allows D&B to
work with other application software providers and SAP to team with
other content providers.
What does the inclusion of D&B for SAP R/3 in mySAP Edition
mean for customers?
Basically all mySAP Edition contract holders will automatically receive
the D&B for SAP software as part of their regular Edition upgrade
shipments. They will be able to install both A/R and A/P versions of
the software as many times as they desire under the conditions of their
SAP contract, without the need to obtain separate licences for the
D&B Add-on. Do I have to have mySAP.com to be able to use D&B
for SAP R/3? No, the software is available from SAP without the need to
purchase or install mySAP.com.
What are the benefits for SAP and D&B?
SAP differentiates itself from competitors by delivering software and
content, which is increasingly becoming a customer focus. The unique
combination of standardized software and standardized data that can be
processed in R/3 is very attractive to customers.
What is significant about online access in R/3 to D&B
The significance is that solution components allow customers real-time,
direct access to business information that previously could not be
accessed from within the R/3 software. Customers can now easily and
efficiently access business information that they require to make
certain decisions. When will the software component be available to
mySAP Edition customers? It will be made available from June and all
subsequent mySAP Editions.
What kinds of companies (markets) are you targeting with
D&B for SAP R/3?
Businesses in any industry that have customers and suppliers and have a
high volume of transactions are ideal prospects. Do you have any
customers using the software functionality today that we can talk to?
There are over 60 customers using the service. A number of success
stories are available from this Web site. Is this product/service
available globally? A Global Access version of the product has been
made available via a Software Support Package available via SAPNet. Is
this partnership a new strategy for D&B and SAP respectively? Since
the ERP market for software and services is estimated to be a $50
billion market by 2002 - establishing partnerships with companies like
SAP is key to D&B's embed strategy and long-term growth. SAP is
committed to broadening its offering based on customer needs and will
continue to work with partners to enhance SAP software. What is Data
Rationalization and Online Access? D&B's Data Rationalization
Service cleans, updates and organizes a company's customer and vendor
master data, making the transfer of legacy files easier. In a typical
project, D&B will consolidate dozens of a company's legacy customer
or vendor files containing tens of thousands of records. D&B will
clean and scrub, merge and purge data until there is one file with one
record for each company in a consistent record format. Online Access is
the ability to access D&B data directly from D&B hosts from
within the R/3 applications, either prior to creating a new Master
records, or to update an existing record.
What are the benefits in using D&B for SAP Solutions to
Real-time, online access to D&Bs risk and financial information
on more than 30 million businesses in the U.S. and Europe, 64 million
globally via the Global Access version
D&B can help cleanse and update the information being transferred
from legacy files during the implementation phase
High-quality customer and vendor master files
Improved performance in R/3
Improved risk management
Faster and effective lower-cost credit/vendor decisions
D&B also contributes to a lower total cost of ownership for the
D&B's data and services can also be used to speed up data
preparation during the implementation phase of an installation and
ensure the customer has a high quality customer and vendor master
file in mySAP.com
What are the technical prerequisites for using D&B for
Key prerequisites for the installation of the D&B software are that
the SAP customer is using at least R/3 Release 3.1 or higher, and that
the R/3 Financial Accounting application (incl. Credit Management
module) has been implemented and is operational. It is also necessary
that the communication server for SAP has been enabled and that
connectivity is achieved between the customers R/3 and D&Bs LAN.
Can the D&B Online Access software be
D&B delivers a standard online service for R/3. If a customer wants
to customize the software, D&B is willing to provide technical
information to support the effort. All customization costs will be
incurred by the customer.
How secure is the existing data in SAP R/3?
Data is secure and kept completely confidential for customers that
migrate legacy data to R/3 using the D&B Data Rationalization
Service. D&B will not manipulate any existing data in R/3 or take
any data from R/3.
Who has access to view D&B information SAP
D&B information is visible from the Credit Management and Accounts
Payable screens within the Financial Accounting application of R/3.
However, since the information is stored in R/3, it is possible for
other users such as sales and marketing associates to view it. However,
the customer must configure the SAP security to allow such viewing.
Who will provide technical support of the D&B
SAP will provide for the first-level support while D&B will handle
the second-level support if required.
Will the D&B product remain on SAP's global price
D&B is the first company to have its online access application
D&B for SAP R/3 listed on SAPs global price list. The application
will remain on SAP's price list for all non-Edition customers.
What is the price of the D&B data?
Dun & Bradstreet has its own pricing models based on the volume of
data purchased by customers.
Didn't D&B compete against SAP, providing client/server
software a few years ago?
D&B Software, a former company of The Dun & Bradstreet
Corporation, did develop and market client/server software. The company
was sold to GEAC Computer Company in Toronto in 1996 when the
corporation refocused its strategy on delivering content.
Is it difficult to install D&B for SAP R/3?
No, it is very easy. The whole process should take less than half a
day. D&B provides in-depth documentation to assist in the
How is the software delivered?
D&B for SAP R/3 software is delivered on separate CDs within the
Edition shipment and contain a set of transport files that need to be
installed in the R/3 system. These transport files are available for
R/3 Release 3.1h and higher. The transport files configure an area on
the database to hold the D&B data, as well as configuring the SAP
How do upgrades work?
Upgrades work in a similar way to other SAP add-on solutions. When an
upgrade takes place in R/3, the data remains in the R/3 database and
D&B access needs to be upgraded (no repository switch upgrade).
What is data quality?
Within SAP, data quality is defined as postal validation, duplicate
checking, and error tolerant searching. Postal Validation enhances
address information by comparing data against address directories
provided from local postal authorities around the world. Duplicate
Check avoids duplicate entries by scanning the database for potential
duplicates before new customer data is committed to the database.
Finally, Error Tolerant Searching provides flexibility by giving users
the ability to conveniently search their SAP system for business
information as required. Involvement of a data quality initiative helps
you maintain a reliable source of information for all departments
within your own organization while simultaneously maximizing
interactions with your vendors, customers, and business partners.
When and where should I integrate data quality into my SAP
Suite of applications or other projects in my enterprise?
Data quality should be integrated any place where data is entered,
loaded, processed, or updated. Data quality should be built into the
beginning phases of all Enterprise Resource Planning, Customer
Relationship Management, and Business Intelligence projects. Too many
projects focus on data quality as an afterthought, at the back-end of a
data repository or when a project has failed. By not incorporating data
quality measures at every customer touch point, on both front and
back-end operations, the cost of cleansing the data dramatically
increases as well as how long the cleansing process takes to complete.
Can I integrate a data quality solution within other software
Data quality solutions can be fully integrated into CRM, ETL (Extract
Transform Load), ERP, or BI solutions and have the advantage of being
"seamless" to the end user - reducing the learning curve, as well as
decreasing the implementation timeframes. Your data process flow should
not have to be modified to add a new data quality solution. Through
integration and strategic partnerships you are assured that you are
getting a best-of-breed solution. However, keep in mind it is not
absolutely necessary for the solution to be fully integrated.
Firstlogic also provides tools that your organization can easily
integrate on your own, and oftentimes stand-alone solutions may be more
effective for specific projects.
Will Firstlogic's Global Data Quality Connector for SAP manage
my international data?
Yes. Built on a global framework capable of validating address
information for over 190 countries in a single processing pass,
Firstlogic's Global Data Quality Connector for SAP allows you to
identify country names, format and standardize addresses, correct
missing address information, and assign postal codes for each
respective country. Furthermore, Firstlogic's Easy IQ technology offers
the ability to complete/populate addresses with minimal data or offer
suggestions for possible matches. This easy address system is ideal in
call centers or any transactional environment where data needs to be
cleansed at the point-of-entry. The software improves real-time
transactions for your call centers, sales, and support centers by
providing accurate address data for your customer facing employees. How
easy is it to maintain Firstlogic's Global Data Quality Connector for
SAP after implementation? Ongoing maintenance should be minimal. Once
the solution is implemented and configured, typically maintenance will
only be required when you receive postal directory updates, upgrade to
a new data quality release, or decide to change your application or
What are the benefits of a data quality solution?
The biggest benefit is the confidence you have that your data is
accurate. A data quality solution also allows you to:
Manage customer data in different formats initially residing in
Build and maintain successful relationships
Better understand and service your customers
Enhance knowledge management and business intelligence initiatives
with reliable and accurate information
Deliver clean, reliable data throughout your expanding information
supply chains to all varieties of operational and analytical
applications throughout your enterprise
How does Firstlogic's Global Data Quality Connector for SAP
Firstlogic's Global Data Quality Connector is integrated at the BASIS
layer and communicates with the SAP Applications via TCP/IP leveraging
SAP's Remote Function Call (RFC) interface. As users make postal
validation inquiries in either batch or real-time, calls are made
outside of the SAP Application to Firstlogic's RFC Server. Once the
customer's address has been received by Firstlogic's technology, our
Information Quality Suite parses, standardizes, and corrects records
according to configurable business rules and local postal authority
standards. To ensure your customer view is optimized, Firstlogic's
technology catches duplicates at the point of entry; not after
redundant information has infected your SAP Environment. Before any
customer, vendor, or business partner is committed to the database,
Firstlogic's Information Quality suite will immediately inspect the
data upon input. The connector scans the entire database for duplicates
and assigns a similarity match score to potential duplicates. At that
point, the user can determine whether the entered record is unique or a
duplicate that should be eliminated from the system. In addition,
convenient Error Tolerant Searching is available for prompt and precise
address recognition. This improves transaction processing, saves time
locating records, and optimizes system efficiency.
Explain the architecture of Firstlogic's Global Data Quality
Connector for SAP Systems.
Integrated at the BASIS/WAS layer, Firstlogic has developed Business
Add-Ins (BAdI's) that can be leveraged with a single instantiation;
allowing for all SAP modules that utilize SAP's Business Address
Services framework to leverage the compelling advantages of Firstlogic
technology. Furthermore, Firstlogic's Information Quality Suite has
been developed as a Remote Function Call (RFC) Server: the most common
integration component of SAP software. Utilizing SAP's RFC interface,
SAP makes calls to Firstlogic technology for address check, updates,
duplicate checks, and error tolerant searches.
Why does SAP support Linux?
SAP's goal is to be able to provide its customers the maximum of
flexibility to create the best IT environment for their needs and be
able to get the most value out of their business applications driving
growth and profit. Openness, flexibility, and integrity of our products
have always been part of our product strategy, putting customers in the
position to decide what's best for their IT environment. So the main
reason is to offer you a free choice. Many SAP customers want to use
Intel hardware and at the same time use their Unix know-how. Linux is
growing with incredible speed and absolutely meets the quality
standards of SAP. And thanks to the platform-independent SAP
architecture, the port of the SAP kernel was fairly easy: none of the
SAP business applications had to be modified. Another reason is the
number of Unix operating systems SAP has to support. Especially when
you try to get maximum performance out of your hardware resources,
there are significant differences between the different Unix flavours.
SAP has to maintain, test and support each possible combination of OS,
database, hardware and mySAP release. With Intel moving to 64 bit there
is a high probability of even more Unix flavours. A consolidation of
these Unix derivatives would benefit both vendors and customers. From
our point of view Linux has a realistic chance to become the unified
Unix running on different hardware platforms. If Open Source continues
like this, it is very important for a software company to adapt early
to the new situation. We are very proud that SAP was the first software
in the world that run mission-critical ERP operations on Linux. We
expect Linux to be successful in low and high end installations and
SAP, as Trusted Adviser, is helping customers to make the right
decisions around SAP on Linux.
What is the SAP LinuxLab?
The SAP LinuxLab assists in the releasing of SAP software on Linux and
drives the porting of SAP software to new platforms, like the Intel
Itanium or IBM Power PC. Furthermore it helps other SAP departments
with developing on and for the Linux platform and processes
Linux-specific support problems - internal ones, as of external - or
forwards them to the appropriate hardware or software partner.
Currently, developers from Bull, Dell, Fujitsu-Siemens, HP, IBM, Intel,
Novell/SUSE, RealTech, Red Hat, SAP, SUN and a number of temporary
"guests" share the same rooms in the LinuxLab. Despite our hardware
partners being competitors, the cooperation is excellent and we had a
number of very successful projects. The LinuxLab also cloesely
cooperates with (and is located directly next to) SAP's Server
Infrastructure department, which is responsible for the development of
the SAP kernel, the basis layers on top of the native operating
systems, which make SAP's business applications platform independent.
What role does SAP play in the Open Source scene?
We are supporting Open Source when it comes to Linux as an operating
system or MaxDB (formerly Adabas/D or SAP DB) as a database. In fact,
back in 1999, we were the first business software provider to support
Linux as an operating system for running SAP solutions. We work closely
with the Linux distributors and our partners to ensure our solutions
work smoothly on Linux. Our main focus with SAP on Linux is helping our
customers build the IT environment that is right for them. More and
more customers are requesting help with SAP on Linux. And we are there
to provide them with the high quality support they expect from SAP.
Interested in offering your software to SAP customers so they
can enhance functionality of their SAP servers running
SAP is open to third party software and hardware products. As SAP only
uses standard APIs provided by the Linux OS, third party software is
usually transparent to us. Whereas we usually do not certify third
party software, LinuxLab is open for joint development efforts.
What does "SAP NetWeaver on Linux" mean?
SAP is the market leader of inter-enterprise software solutions with
the world's largest enterprise software customer base. SAP has more
than 10 million licensed users, more than 20,000 installations in more
than 100 countries and supports 28 different languages. More than half
of the world's top 500 companies use SAP software!
SAP supports the mySAP Business Suite in a productive environment under
Linux. This also includes the database server (IBM DB2/UDB, Informix,
Oracle and SAP DB) as well as the application server and the frontend.
You can run SAP on Linux in homogeneous and heterogeneous
The mySAP Business Suite is running upon the SAP NetWeaver, which
includes components like the SAP Web Application Server or the SAP
Enterprise Portal. For a more detailed view on SAP NetWeaver please
refer to http://www.sap.com/netweaver.
Where can I get the mySAP Business Suite on Linux?
You can order the mySAP Business Suite on Linux just like mySAP
software on any other platform. If you are a SAP customer already,
there will be no additional charges. From Release 4.6 onwards, the
mySAP Business Suite on Linux is part of the standard delivery.
Where can I get Linux for mySAP Business Suite?
Linux distributors like Debian, Mandrake, Red Hat or SUSE offer Linux
together with a set of other software packages, installation routines,
documentation and support. Whereas there is a de facto standard for the
Linux kernel itself, the distributions differ in other areas,
especially in the administration area.
Will pricing be changed for mySAP Business Suite on
Standard pricing for mySAP Business Suite applies also to mySAP
Business Suite on Linux.
What are the main reasons for SAP customers choosing
Each SAP customer has a unique set of reasons for running SAP on Linux,
depending on the very specific customer's SAP scenario. Among many
reasons customers decide for Linux as the operating system of choice,
because they seek increased
Scalability with different sized commodity, or even large former Unix
or mainframe systems
Freedom of choice for technology vendors
Replacing larger Unix-based SAP servers
Where do I get support?
Support of SAP solutions on Linux meets the same high standards as for
any other platforms. SAP is offering installation and migration tools
and paths, and support staff trained for SAP on Linux matters. For
porting and highly technical issues, SAP has the SAP LinuxLab, where
hardware and software partners are working closely together to "bring
you the best SAP on Linux experience".
Standard SAP support covers SAP related problems as on other platforms
too. During message processing, if the problem turns out to be caused
by a non-SAP part of the installation/system, it might become necessary
to envolve further expertise, as of the hardware- or software partner
and its support organisation. Therefore it is strongly recommended for
SAP customers, running SAP software on the Linux platform, to maintain
a support contract for both, hardware and operating system, so a
seamless support process chain can be ensured.
Support for the operating system can either be covered directly by the
vendor itself, like Red Hat or Novell/SUSE, or by a 3rd party company
offering equivalent support, like all our Linux hardware partners do in
combination with their products.
Our Linux hardware and our database partners provide the same degree of
support for Linux with their products as they already do for the
respective Unix - if the necessary support contracts are given. Red Hat
and SUSE offer direct operating system support contracts as well.
Please get in contact with your hardware or software vendor for more
information. This practice helps all involved parties to solve any
possibly arising problem as fast as possible. If the support coverage
is incomplete, it can lead to avoidable delayments in problem solving -
and please keep in mind: extraordinary expenses by SAP or our partners,
caused by missing support coverage, may get billed to the customer
Which releases of mySAP Business Suite are supported on
mySAP Business Suite on Linux is generally available for use in a
productive environment starting with release 4.0B.
Which databases are supported for mySAP Business Suite on
Supported databases for mySAP Business Suite on Linux are IBM DB2/UDB,
Informix, Oracle and SAP DB/MaxDB.
Will a customer get support when recompiling the Linux kernel
or using 3rd-party software that modifies it?
Usually there should be no need for recompiling the Linux kernel when
using SAP software on Linux, since the supported Linux distributors are
shipping optimized kernels for the respective hardware architectures
with revised and tested drivers. Any modification to the tested
environment would furthermore make it nearly impossible for the Linux
distributor to track a problem down. The same applies to 3rd party
software that modifies the Linux kernel and is distributed only in a
closed, binary-only, way. Therefore the following can't be supported:
Recompiling the Linux kernel, with or without source modifications
Loading of 3rd party binary Linux kernel modules which have not been
shipped by the Linux distributors
Loading of any unsupported Linux kernel modules
Loading of any closed source drivers drivers
Which server configurations of mySAP Business Suite will be
supported on Linux?
SAP supports mySAP Business Suite on Linux for database and application
servers in homogeneous and heterogeneous environments. Please get in
contact with your hardware partner for system sizing and similar.
Is Linux supported as a frontend platform?
The "SAPGUI for the Java Environment" can be downloaded from the SAP
ftp servers. This project (formerly known as PlatinGUI - platform
independent GUI) started in spring 1998 with the following objectives:
build one GUI for all platforms (MacOS, Linux, OS/2, Win32, AIX, HP/UX,
Solaris, Tru64 ...)
provide Control-Enabling with Java Beans
create a new, flexible GUI-architecture
support web browser integration
What is ERP?
ERP is a package with the techniques and concepts for the integrated
management of business as a whole, for effective use of management
resources, to improve the efficiency of an enterprise. Initially, ERP
was targeted for manufacturing industry mainly for planning and
managing core business like production and financial market. As the
growth and merits of ERP package ERP software is designed for basic
process of a company from manufacturing to small shops with a target of
integrating information across the company.
Different types of ERP?
SAP, BAAN, JD Edwards, Oracle Financials, Siebel, PeopleSoft. Among all
the ERPs most of the companies implemented or trying to implement SAP
because of number of advantages aver other ERP packages.
What is SAP?
SAP is the name of the company founded in 1972 under the German name
(Systems, Applications, and Products in Data Processing) is the leading
ERP (Enterprise Resource Planning) software package.
Explain the concept of "Business Content" in SAP Business
Business Content is a pre-configured set of role and task-relevant
information models based on consistent Metadata in the SAP Business
Information Warehouse. Business Content provides selected roles within
a company with the information they need to carry out their tasks.
These information models essentially contain roles, workbooks, queries,
InfoSources, InfoCubes, key figures, characteristics, update rules and
extractors for SAP R/3, mySAP.com Business Applications and other
Why do you usually choose to implement SAP?
There are number of technical reasons numbers of companies are planning
to implement SAP. It's highly configurable, highly secure data
handling, min data redundancy, max data consistency, you can capitalize
on economics of sales like purchasing, tight integration-cross
Can BW run without a SAP R/3 implementation?
Certainly. You can run BW without R/3 implementation. You can use
pre-defined business content in BW using your non-SAP data. Here you
simply need to map the transfer structures associated with BW data
sources (InfoCubes, ODS tables) to the inbound data files or use 3rd
part tool to connect your flat files and other data sources and load
data in BW. Several third party ETL products such as Acta, Infomatica,
DataStage and others will have been certified to load data in BW.
What is IDES?
International Demonstration and Education System. A sample application
provided for faster learning and implementation.
What is WF and its importance?
Business Work Flow: Tool for automatic control and execution of
cross-application processes. This involves coordinating the persons
involved, the work steps required, the data, which needs to be
processed (business objects). The main advantage is reduction in
throughput times and the costs involved in managing business processes.
Transparency and quality are enhanced by its use.
What is SAP R/3?
A third generation set of highly integrated software modules that
performs common business function based on multinational leading
practice. Takes care of any enterprise however diverse in operation,
spread over the world. In R/3 system all the three servers like
presentation, application server and database server are located at
What are presentation, application and database servers in SAP
The application layer of an R/3 System is made up of the application
servers and the message server. Application programs in an R/3 System
are run on application servers. The application servers communicate
with the presentation components, the database, and also with each
other, using the message server. All the data are stored in a
centralized server. This server is called database server.
What should be the approach for writing a BDC
Convert the legacy system data to a flat file and convert flat file
into internal table. Transfer the flat file into sap system called "sap
data transfer". Call transaction(Write the program explicitly) or
create sessions (sessions are created and processed ,if success data
Explain open SQL vs native SQL?
ABAP Native SQL allows you to include database-specific SQL statements
in an ABAP program. Most ABAP programs containing database-specific SQL
statements do not run with different databases. If different databases
are involved, use Open SQL. To execute ABAP Native SQL in an ABAP
program, use the statement EXEC. Open SQL (Subset of standard SQL
statements), allows you to access all database tables available in the
R/3 System, regardless of the manufacturer. To avoid conflicts between
database tables and to keep ABAP programs independent from the database
system used, SAP has generated its own set of SQL statements known as
What are datasets?
The sequential files (processed on application server) are called
datasets. They are used for file handling in SAP.
What are internal tables check table, value table, and
Internal table: It is a standard data type object, which exists only
during the runtime of the program. Check table: Check table will be at
field level checking. Value table: Value table will be at domain level
checking ex: scarr table is check table for carrid. Transparent table:
- Exists with the same structure both in dictionary as well as in
database exactly with the same data and fields.
What are the major benefits of reporting with BW over
R/3? Would it be sufficient just to Web-enable R/3
Performance - Heavy reporting along with regular OLTP transactions can
produce a lot of load both on the R/3 and the database (cpu, memory,
disks, etc). Just take a look at the load put on your system during a
month end, quarter end, or year-end - now imagine that occurring even
more frequently. Data analysis - BW uses a Data Warehouse and OLAP
concepts for storing and analyzing data, where R/3 was designed for
transaction processing. With a lot of work you can get the same
analysis out of R/3 but most likely would be easier from a BW.
How can an ERP such as SAP help a business owner learn more
about how business operates?
In order to use an ERP system, a
business person must understand the business processes and how they
work together from one functional area to the other. This knowledge
gives the student a much deeper understanding of how a business
operates. Using SAP as a tool to learn about ERP systems will require
people understand the business processes and how they integrate.
What is the difference between OLAP and Data
OLAP - On line Analytical processing is a reporting tool configured to
understand your database schema ,composition facts and dimensions . By
simple point-n-clicking, a user can run any number of canned or
user-designed reports without having to know anything of SQL or the
schema. Because of that prior configuration, the OLAP engine "builds"
and executes the appropriate SQL. Mining is to build the application to
specifically look at detailed analyses, often algorithmic; even more
often misappropriate called "reporting.
What is Extended Star Schema and how did it
The Star Schema consists of the Dimension Tables and the Fact Table.
The Master Data related tables are kept in separate tables, which has
reference to the characteristics in the dimension table(s). These
separate tables for master data is termed as the Extended Star Schema.
Define Meta data, Master data and Transaction data
Meta Data: Data that describes the structure of data or MetaObjects is
called Metadata. In other words data about data is known as Meta Data.
Master Data: Master data is data that remains unchanged over a long
period of time. It contains information that is always needed in the
same way. Characteristics can bear master data in BW. With master data
you are dealing with attributes, texts or hierarchies. Transaction
data: Data relating to the day-to-day transactions is the Transaction
Name some drawbacks of SAP
Interfaces are huge problem, Determine where master data resides,
Expensive, very complex, demands highly trained staff, lengthy
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 Path.
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
What are the different types of source system?
SAP R/3 Source Systems, SAP BW, Flat Files and External Systems.
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.
DEVFYI - Developer Resource - FYI
Click here to get Interview's Topic Index