SAP R/3 Tips and Tricks – Cheat Sheet for Interview Answers - Terminology explain
Lately I found a very helpful SAP website.
SAP R/3 Tips and Tricks – by Ricardo Fernandes de Miranda
Below are the topics focus on the website. Visit: http://www.sapfans.com/sapfans/saptips.htm
SAP R/3 Tips and Tricks – by Ricardo Fernandes de Miranda
Below are the topics focus on the website. Visit: http://www.sapfans.com/sapfans/saptips.htm
- Logging on without being authorized
- Specialcopy and paste
- Long messages on footer
- Direct input logs
- Graphics on SAPscript
- Adding icons
- Filling up an empty date field quickly
- Setting up module FI/CO without using IMG
- Displaying check object when not authorized
- Table analyses between two systems
- Correction and transport system
- General command field formats
- Report command field formats
- Helpful reports
- Unconditional mode when importing or exporting a request/transport
- Main return codes of tp program
- Scheduling of system maintenance jobs
- Locking the whole system
- Connection between SAP R/3 and operating system
- SQL code help
- Oracle import and export explanations
Client 066 usually exists in a SAP system due to EarlyWatch services. Often this
client does not have master users. If it is true, anyone can log into the
system using the client 066, user SAP*, and password PASS. Enjoy yourself.
client does not have master users. If it is true, anyone can log into the
system using the client 066, user SAP*, and password PASS. Enjoy yourself.
Click on the area and press CTRL+Y. It allows you to copy many lines at once
and paste them afterwards.
and paste them afterwards.
Click on the message and hold the mouse button. After moving the mouse to the
left side.
left side.
The transaction BMV0 (direct input logs) shows all direct input logs.
The program RSTXLDMC can be used to upload graphics (file extension .tif on
PC files) into individual standard text.
PC files) into individual standard text.
Check the icon code using transaction ICON. A technical view can be found at
the include named «ICON». Sequences of characters begin and
finish with the symbol @. Even plain files under operating system can contain
those strings.
the include named «ICON». Sequences of characters begin and
finish with the symbol @. Even plain files under operating system can contain
those strings.
Strike the key F4 (or click on matchcode symbol) and press ESCAPE. The current
date is automaticly set.
date is automaticly set.
Almost all parameters can be set using the transactions ORFA (Asset Accounting),
ORFB (Financial Accounting), and ORKS (Cost Center Accounting).
ORFB (Financial Accounting), and ORKS (Cost Center Accounting).
Soon after the lock try to access the transaction SU53. It reports the last
objects verified and also the respective values.
objects verified and also the respective values.
The contents of a table between two systems can be checked through the transaction
OY19.
OY19.
The transaction SE10 provides the easiest way to manage any request/transport
and corrections.
and corrections.
| /n | Skip to the next record if you are processing one batch input session |
| %pri | Print the current report |
| RSCLTCOP | Copy tables across clients |
Run the command R3trans
-u under user «SysID»adm.
-u under user «SysID»adm.
| 0 | Successfully done |
| RSBTCDEL | Clean the old background job records |
Using the command tp locksys «SysID» only the user SAP* will be allowed to login.
The command tp unlocksys «SysID» cancels the lock.
The command tp unlocksys «SysID» cancels the lock.
The command sapevt can be used to trigger an event from the operation system. Thus, a job
previously defined within R/3 will be released.
previously defined within R/3 will be released.
Run the command oerr ora «error number» under user ora«SysID».
Run the command imp help=yes under user ora«SysID». This format can also be used with exp,
impst, and expst.
impst, and expst.
Of course it does not guarantee a successful implementation. It is a great
deal of summed up aid, though.
- Team integration has to be enhanced
- Set high standards of performance for implementation team
- IT teamsand users have to work closely during the implementation
- New ways of thinking and acting must not be discarded
- Do not underestimate the user training needs
- Project management should be on the critical list
- The nearest SAP branch should be your partner
- Consultants are not always the key to succeed
- Consultants are a good source of knowledge. On the other hand, letting them make configuration
changes the transfer of knowledge will be harmed - Foreign consultants usually do not know country-specific details
- Deepening your basis knowledge is always useful
- Avoid changing standard R/3 objects as much as possible
- Always follow the SAP rules to give names to your own objects
- Establish SAP connection as soon as possible
- Exchange information with other companies
- Focus on interfaces with non-R/3 applications
- Plan the whole environment carefully (servers, network, protocols, etc.)
- Development and production environment should be totally independent
Some special features allow you wide modifications without changing standard
SAP R/3 objects. Those
techniques are not as widespread as they should be. In fact they are powerful
tools.
- Field exit
- User exit
- Validation
- Substitution
- Set
- Key words
- Requirements & formulas
After entering a value in a field, it can be checked through a field exit. The
system makes the field value available to be checked and changed in an
ABAP/4 function.
system makes the field value available to be checked and changed in an
ABAP/4 function.
Points previously set in the system that let you evaluate data. The fields available
are also previously defined by SAP. All fields value available can be checked
in an ABAP/4 program.
are also previously defined by SAP. All fields value available can be checked
in an ABAP/4 program.
It allows solid data entry regarding special rules. According to previous
rules, the system can evaluate an entry and a message can appear on the
user’s terminal if a check statement is not met. A validation step contains
prerequisite statement and check statement. Both of them are defined using
Boolean Logic or calling an ABAP/4 form.
rules, the system can evaluate an entry and a message can appear on the
user’s terminal if a check statement is not met. A validation step contains
prerequisite statement and check statement. Both of them are defined using
Boolean Logic or calling an ABAP/4 form.
Fields contents can be changed using substitution. When data are being entered,
the data can be substituted by another value regarding rules previously
defined. A substitution step contains prerequisite statement, substitution
value and substitution exit. All of them are defined using Boolean Logic
or calling an ABAP/4 form.
the data can be substituted by another value regarding rules previously
defined. A substitution step contains prerequisite statement, substitution
value and substitution exit. All of them are defined using Boolean Logic
or calling an ABAP/4 form.
Values or ranges of values are specified under a set name. Sets are easier to
create and maintain instead of using tables. They give you more flexibility
when maintaining your system.
create and maintain instead of using tables. They give you more flexibility
when maintaining your system.
It allows changes on field description according to data element. The short
key word used on most screen to identify the corresponding field contents
can be changed too.
key word used on most screen to identify the corresponding field contents
can be changed too.
ABAP/4 forms that can be used to handle pricing procedures, rounding rules, copy
and data transport Sales activities.
and data transport Sales activities.
- System gets stuck
- Short dump
- Field exits are completely ignored
- Transaction SE16 (table contents) does not work properly
- Rollback segments are too small
- Files for rollback segments are already enormous
- Extended help under windows does not link correctly
- Release procedure with classification does not work
- Transport area is overloaded
- Instance does not establish communication
It happens mostly when archive area is overloaded. Run the program brarchive
with deletion option to release disk space.
with deletion option to release disk space.
Not always the problem is technical. Try to create all SAPoffice users through
transaction SO32 (create all SAPoffice users) and review your application
data carefully.
transaction SO32 (create all SAPoffice users) and review your application
data carefully.
Make sure your SAP profile parameter contains the option abap/fieldexit = yes.
Make usage of the menu option to regenerate the display program. You can also
try changing key words according to field names. Choose Option -> Parameters
users.
try changing key words according to field names. Choose Option -> Parameters
users.
Before increasing up the rollback segment size you should verify your programs.
Very often the problem belongs to them.
Very often the problem belongs to them.
Check the rollback segments configuration. It has to match the allocated area
on tablespaces. Changes have to be done using Oracle tools.
on tablespaces. Changes have to be done using Oracle tools.
Check the file sapdoccd.ini under your presentation server. It must be
present in the main windows directory and should assign to help files directory.
present in the main windows directory and should assign to help files directory.
As a matter of fact you are not the only one to notice it. It hardly works.
Before using release strategy you should apply all notes on OSS. Pray might
be useful too.
Before using release strategy you should apply all notes on OSS. Pray might
be useful too.
The command tp clearold «SysID» cleans up the transport
area according to parameters previously set on the plain file TPPARAM.
area according to parameters previously set on the plain file TPPARAM.
Shutdown the whole system and check the Interprocess Communication Facilities. Any
references should be found. Either the command IPCS (UNIX) or showipc
«INSTANCE NUMBER» (SAP) show all message queue, semaphore
set and shared memory identifier. Before trying again you have to remove
them using the command IPCRM (UNIX) or cleanipc «INSTANCE
NUMBER» (SAP).
references should be found. Either the command IPCS (UNIX) or showipc
«INSTANCE NUMBER» (SAP) show all message queue, semaphore
set and shared memory identifier. Before trying again you have to remove
them using the command IPCRM (UNIX) or cleanipc «INSTANCE
NUMBER» (SAP).
| Note: | Research based on version 3.0f under Unix, Oracle data base and Windows. |
Simple changes can rise your system security. Usage of SAProuter is a good choice
when correctly implemented. Login through SAP LogonPad (from version 3.0f
onwards) improve the access control. SAP profile parameters shall also
contain:
- Rdisp/gui_auto_logout = 1800
- Login/fails_to_session_end = 3
- Login/fails_to_users_lock = 5
- Login/min_password_lng = 6
- Login/password_expiration_time = 90
The user connection is closed after 30 minutes without usage.
After 3 wrong password the connection is automaticly closed.
After 5 wrong password the user is locked.
Password length at least 6 characters.
Password expires after 3 months.
Indeed these powerful ABAP/4 functions are very interesting and can bring some
advantages. Improve your home development easily. They belong to standard
objects and should never be changed.
- Ws_upload
- Ws_download
- Ws_excel
- Bp_joblog_read
- Rs_send_mail_for_spoollist
- Bp_event_raise
- So_wind_spool_list
- So_spool_read
- G_set_get_all_values
- Rzl_sleep
- Rzl_submit
- Ws_execute
- Ws_file_delete
- Ws_volume_get
- Ws_msg
- Popup_to_display_text
- Popup_to_confirm_step
- Popup_to_confirm_with_message
- Popup_to_confirm_with_value
- Popup_to_confirm_loss_of_data
- Popup_to_decide
- Popup_to_decide_with_message
Transfer files from the frontend to the application server.
Transfer files from the application server to the frontend.
Download files at the frontend in excel format.
Fetch job log executions.
Send message from ABAP/4 program to SAPoffice.
Trigger an event from ABAP/4 program.
Browse printer spool numbers according to user informed.
Fetch printer spool according to the spool number informed.
Fetch values from a set.
Hang the current application from 1 to 5 seconds.
Submit a remote report.
Execute an external program on the presentation server.
Delete file at the frontend.
Get the label from a frontend device.
Create a dialog box in which you display an one-line message.
Create a dialog box in which you display a two-line message.
Create a dialog box in which you make a question whether the user wishes to perform
the step.
the step.
Create a dialog box in which you inform the user about a specific decision point
during an action.
during an action.
Create a dialog box in which you make a question whether the user wishes to perform
a processing step with a particular object.
a processing step with a particular object.
Create a dialog box in which you make a question whether the user wishes to perform
a processing step with loss of data.
a processing step with loss of data.
Create a dialog box in which you require the user between the two processing alternatives,
or to cancel the action.
or to cancel the action.
Create a dialog box in which you inform the user about a specific decision point
via a diagnosis text.
via a diagnosis text.
Information
Technology has many key words and SAP
R/3 has introduced many others. In order to understand even better
this field you should keep in mind those terms.
- ALE (Application Link Enabling)
- Application server
- Batch Input
- CATT (Computer Aided Test Tool)
- CCMS (Computer Center Management System)
- Central System
- Client
- Client/Server System
- Communication Server
- Company code
- Computer type
- CPI-C (Common Programming Interface-Communications)
- Correction
- CSP
- Data base server
- Direct Input
- Dispatcher
- EarlyWatch
- Ethernet
- FDDI (Fiber Distributed Data Interchange)
- Field status
- Firewall It is a means of controlling access through a public network to a privatenetwork.
- FTP (File Transfer Protocol)
- GUI (Graphic User Interface)
- IDES (International Demonstration and Education System)
- IMG (Implementation Management Guide)
- Instance
- IDoc (Intermediate Document)
- ITS (Internet Transaction Server)
- Kernel
- LAN (Local
Area Network) - Matchcode
- Number range
- OLE
- OSS (Online Service System)
- Repair
- RFC
- Semaphores
- SysID
- TCP/IP
- Telnet
- Token Ring
- Transport
- WAN (Wide Area Networks)
- Work process
- Workbench
- Workflow
- X.25
It provides integration for separate R/3 systems, keeping full interaction.
This makes possible distributed enterprise applications.
This makes possible distributed enterprise applications.
The application server is used to run the business application programs in
the R/3 client/server concept. The application modules are loaded from
the data base server to the application server as required. Thus the application
server requires only storage capacity to accommodate UNIX, Swapping and
the SAP runtime environment.
the R/3 client/server concept. The application modules are loaded from
the data base server to the application server as required. Thus the application
server requires only storage capacity to accommodate UNIX, Swapping and
the SAP runtime environment.
A technique to input data safely. It ensures application data integrity for
background interfaces. It pretends to be someone typing. See also direct
input.
background interfaces. It pretends to be someone typing. See also direct
input.
It allows you to combine and automate sequences of repeatable transactions
in test procedures. CATT reduces the number of manual tests, and forces
you to test systematically, defining input values and expected test results.
in test procedures. CATT reduces the number of manual tests, and forces
you to test systematically, defining input values and expected test results.
It allows you to monitor, control and configure your R/3 system. This toolset
lets you analyze and distribute client workloads and report on resource
consumption for system components.
lets you analyze and distribute client workloads and report on resource
consumption for system components.
In an R/3 central system, both application and data base software are run
on one computer.
on one computer.
In commercial, organizational and technical terms, a self-contained unit in
an R/3 system with separate master records and its owns set of tables.
an R/3 system with separate master records and its owns set of tables.
Client/server systems are structured modularly, with components working in a sender/receiver
relationship. Software components can also be used in a client/server relationship.
relationship. Software components can also be used in a client/server relationship.
It provides the connection between local area and wide area networks and may
be either a router, a bridge or a gateway. In R/3 installations, the communication
server must support the TCP/IP protocol over wide area networks.
be either a router, a bridge or a gateway. In R/3 installations, the communication
server must support the TCP/IP protocol over wide area networks.
The smallest organizational unit for which a complete self-contained set of
accounts can be drawn up for purposes of external reporting. This involves
recording all relevant transactions and generating all supporting documents
for legally-required financial statements, such as balance sheets and profit
and loss statements.
accounts can be drawn up for purposes of external reporting. This involves
recording all relevant transactions and generating all supporting documents
for legally-required financial statements, such as balance sheets and profit
and loss statements.
The R/3 system supports various computer types of SAP’s platform partners,
such as Bull, DEC, IBM and HP. The suitability of a particular computer
type depends on sufficient CPU performance.
such as Bull, DEC, IBM and HP. The suitability of a particular computer
type depends on sufficient CPU performance.
Common Programming Interface of Communication has been introduced by IBM as a
high-level interface to SNA/LU6-2. CPI-C has become the subject of the
X/Open stardarlization and is used by SAP to facilitate program-to-program
communication between R/3 and external system. SAP offers CPI-C libraries
based on TCP/IP.
high-level interface to SNA/LU6-2. CPI-C has become the subject of the
X/Open stardarlization and is used by SAP to facilitate program-to-program
communication between R/3 and external system. SAP offers CPI-C libraries
based on TCP/IP.
It contains all the objects that a developer has changed or created. It also
controls customizing that has been maintained.
controls customizing that has been maintained.
A system to help SAP employees to give comprehensive support to their clients.
The data base server stores the SAP application programs and data in the R/3
client/server concept. It also handles the SAP update program and batch
jobs.
client/server concept. It also handles the SAP update program and batch
jobs.
A recent technique to input data safely. It ensures application data integrity
for background interfaces. See also batch input.
for background interfaces. See also batch input.
The system R/3 agent that identifies the type of task (on-line, update, batch,
etc.) and sends the job to an idle work process.
etc.) and sends the job to an idle work process.
It is a service that entails having your R/3 installation regularly inspected
by SAP employees, in other to ensure high system availability and high
data throughput at all time.
by SAP employees, in other to ensure high system availability and high
data throughput at all time.
It is a LAN architecture using bus topology. The transmission speed is 10
MBit/s.
MBit/s.
It is a local high-speed network with ring topology based on light wave conductors.
The transmission speed is 100 MBit/s.
The transmission speed is 100 MBit/s.
Indicator that specifies whether a field can take an entry in the entry screen or
if it must be filled.
if it must be filled.
It is the most commonly used file transmission protocol of the TCP/IP protocol
family.
family.
A graphical interface used by SAP environment as part of the three tiers.
It is normally called user frontend.
It is normally called user frontend.
It is a model of an international firm. It is a separate demonstration and
education system for speeding up the pilot process.
education system for speeding up the pilot process.
It is a hierarchical structure that reflects the R/3 component hierarchy and
contains every configuration activity. Released from version 3.0 onwards.
contains every configuration activity. Released from version 3.0 onwards.
It means application server and each one has its own set of work processes.
An IDoc is a data container for data exchange between SAP systems or between
an SAP system and an external system.
an SAP system and an external system.
It links the R/3 application server with one or more Web servers, thus enabling
the R/3 to communicate with the Internet.
the R/3 to communicate with the Internet.
It means a standard core previously configured. A set of default parameters
delivered with the system.
delivered with the system.
It is a network foa a tightly limited area with high level data transmission
performance. Common LANs include Ethernet, Token Ring and FDDI. These LANs
support different transport protocols, such as TCP/IP and IPX.
performance. Common LANs include Ethernet, Token Ring and FDDI. These LANs
support different transport protocols, such as TCP/IP and IPX.
A tool for finding specific record. It is made up of search terms. It is
used to find possible entries for an input field.
used to find possible entries for an input field.
A range of numbers that are laid down per file for the assignment of document
numbers. It can be internal (carried out automatically by the system) or
external (carried out manually by the user).
numbers. It can be internal (carried out automatically by the system) or
external (carried out manually by the user).
It is a technique introduced by Microsoft to incorporate objects of one application
into another.
into another.
SAP’s Online Service System offers fast and effective help for R/3 System problems.
It is also the basic element of communications between customers, partners,
and SAP.
It is also the basic element of communications between customers, partners,
and SAP.
It contains all the objects that a developer has changed but the originals
of the objects are located in another system.
of the objects are located in another system.
A way to implement communication between application programs via Abap/4
function call.
function call.
When a work process locks a resource, it sets a semaphore. Another work process
that also wants to access it must then wait.
that also wants to access it must then wait.
A set of three letters or number that identify a system. Some sets are not
allowed because they are used by SAP. They are informed when the system
is installed.
allowed because they are used by SAP. They are informed when the system
is installed.
It
is the most widely used transport protocol for open systems. R/3 clients
and servers communicate using TCP/IP.
is the most widely used transport protocol for open systems. R/3 clients
and servers communicate using TCP/IP.
It provides terminal access to hosts using TCP/IP protocol. It is a well-known
command among Systems Administrators.
command among Systems Administrators.
It is a LAN architecture with ring topology. The transmission speed is 4 MBit/s
or 16 MBit/s. This involves a ‘free token’ which circles the loop picking
up transmissions. The receiver station places a confirmation bit into the
busy token. As soon as the busy token reaches the sender station again,
it is converted back to a free token and sent on to the next station.
or 16 MBit/s. This involves a ‘free token’ which circles the loop picking
up transmissions. The receiver station places a confirmation bit into the
busy token. As soon as the busy token reaches the sender station again,
it is converted back to a free token and sent on to the next station.
It is a request to transport objects from the software development environment,
identified as the source system, to the specified target system.
identified as the source system, to the specified target system.
They are normally operated either by the telephone company or by private companies
that offer leased lines, switched lines or packet lines.
that offer leased lines, switched lines or packet lines.
Work processes perform the bulk of the processing carried out by SAP systems.
They perform dialog steps in user transactions and carry out updates, lock
management, printing services, and so on.
They perform dialog steps in user transactions and carry out updates, lock
management, printing services, and so on.
The ABAP/4 Workbench, a graphical programming environment, is used to create
application programs. The programming tools are accessed using buttons,
dialogs and windows.
application programs. The programming tools are accessed using buttons,
dialogs and windows.
It consists of time and logical sequence of work items, which are precessed
by human agents or mechanical processing units.
by human agents or mechanical processing units.
It is a standardized network access protocol for the packet switching network.
The maximum transmission speed is 64 KBit/s.
The maximum transmission speed is 64 KBit/s.