Sapdatabase for all sap modules

sapdatabase provides you all sap modules information,latest updates

Sapdatabase for sap education

sapdatabase provides you all sap modules material,interview needs

Sapdatabase for all sap information

Sapdatabase makes you as a sap professional

Sapdatabase for outsourcing and online training

Sapdatabase provides you online training,outsource services for all sap modules in econamic fee

Sapdatabase for sap jobs

Sapdatabase makes job searching for you

Showing posts with label INTERVIEW QUESTIONS. Show all posts
Showing posts with label INTERVIEW QUESTIONS. Show all posts

Thursday, March 15, 2012


Sapscript and smartforms
Sap script is client dependent and smart form is client independent.
Smartforms has Only 1 main window while Sap script has 99 main windows
You can not print labels using smart forms

sapscript smart forms and adobe forms
Sapscript is client dependent whereas smartform is client independent.Main window is compulsory in scripts whereas main window not compulsory in form.
Smartform output can be seen in web while in scripts it is not possible.smartform generates function module while scripts dont generate function module.

screen and subscreens in module pool.
Screen has it’s own gui status while subscreen does not have any gui status.Sub screens are part of main screen.

What is the difference between Clustered Tables and Pooled Tables?
A pooled table is used to combine several logical tables in the ABAP/4 dictionary. Pooled tables are logical tables that must be assigned to a table pool when they are defined.Cluster table are logical tables that must be assigned to a table cluster .when they are defined.Cluster table can be used to store control data they can also used to store temporary data or text such as documentation.

 user exits and customer exit.
User exit is sap defined includes so to modify it we need key from SAP.while customer exit like function exit , screen exit we don’t need any key.

standard table and hashed tables.
Standard table can be accessed by key as well as index while You can only access hashed tables by specifying the key. The system has its own hash algorithm for managing the table.

In BDC we have to take care of field mapping whereas field mapping is taken care by sap in lsmw.
BDC is mostly used for customised data upload while LSMW is used for uploading Master data.
In BDC we need to write large code but in LSMW small coding is needed.

BADI is business add ins, it is used to customize the standard business flow
BAPI is Business application programming interface. It is nothing but Remote enabled function module which can be called from outside the SAP System.

user exit and customer exit
User exit is an include program given by SAP in that you can write your code , It needs Access key from SAP while key is not required in case of customer exit

Select single and select up to one row
Select single will fetch only one record while select up to n row. Will fetch n rows from database

Normal (Classical) report and ALV report
To display the output in classical report you use WRITE Statement. To display the output in ALV we have different function modules and class like REUSE_ALV_GRID_DISPLAY , REUSE_ALV_LIST_DISPLAY and CL_SALV_TABLE.If you run the classical report in background after JOB finished you can see it’s output which stored in spool, While in case of ALV you need code
extra to store the output as it will not generate the spool.

 ALV list display and ALV grid display
You cannot retrieve the output for the report which is displayed using
ALV GRID Display.As spool Request will not be created for the same. While in case of list display Report out put will be there in spool request.

BAPI and RFC function module
BAPI is nothing but remote enabled function module
BAPI is provided as a method of business objects

sap 4.7 and ECC 6.0
SAP 4.7 is based on Web AS
ECC 6.0 is based of Netweaver 7.0.

 get cursor and hide in interactive report
Get cursor will provide the location cursor position in the report
While hide is use to pass the data from basic list to secondary list

Normal function module and RFC
You cannot call normal function module from outside the current system
while RFC function module can be called from outside the SAP system.

Subroutine and function modules.
Subroutine is local to the program while function module is global.
To call subroutine from outside its main program you need to write its main program name in the bracket

At selection screen and At selection screen output.
At selection screen output is called first
All dynamic commands and screen modification is done in AT selection screen output.

direct input and batch input
The basic difference is validation is not done in direct input by pre-defined function while in batch input it is covered.

synchronous and asynchronous in BDC
Synchronous mode will wait until the BDC session gets over while asynchronous mode will not wait for that

At selection screen and at selection on field name
At selection screen is used to validate the whole screen elements while at selection field is used to validate the particular field.When you display the error message in at selection on field the focus will
be on that particular field while in case of At selection screen the focus will not be on any particular field.

PBO and PAI event in module pool
Process Before Output and Process after input.
PBO will be called before the screen is displayed to the user while process after input is called once user interact with screen.

Stop , check and exit
If you use the STOP statement within an event block, the system stops processing the block Immediately.If you use the EXIT statement within an event block but not in a loop, the system stops Processing the block immediately If you use the CHECK <expr> statement within an event block but not within a loop, and the Condition <expr> is not fulfilled, the system exits the processing block immediately. <expr> can be any logical expression or the name of a selection table. If you specify a selection table and the contents of the corresponding table work are do.

free and refresh in internal table
You can use FREE to initialize an internal table (along with header line ) and release its memory space.
REFRESH will only initialize an internal table (along with header line)

Clear and delete.
The major difference is clear is used with internal table while delete is used with database table.

Collect and sum
COLLECT <line> INTO <itab>. The statement first checks whether the internal table contains an entry with the same key. If not,it acts like INSERT. If there is already a table entry with the same key, COLLECT does not insert new line. Instead, it adds the values from the numeric fields of the work area <line> to thevalues in the corresponding fields of the existing table entry.
SUM.Can only be used in loops through internal tables. Calculates the sums of the numeric fields in all lines of the current control level and writes the results to the corresponding fields in the work area.

call transaction and session method
Call transaction is Synchronous Processing while session (classical) method is Asynchronous Processing In call transaction we can update the database both synchronously and asynchronously. We can specify the mode in the program. While in session method it is Synchronous Database update.
In call transaction No batch input processing log is maintained while in session method details log is maintained.Call Transaction method is faster than the session method.

 At first and at last control break event
As the name suggest AT FIRST executed for the first time while AT LAST executed in last.

 Enhancement point and Enhancement Section
Both the enhancement-point and section are available for you to change standard SAP code. Difference is in fact that you use Enhancement-point to add ABAP code to standard SAP and enhancement-section to replace/extend standard SAP code.

Classical and drill down report

In classical report user cannot interact with report whereas in drill down report user can interact with report.Drill down facility is not provided in classical report while in drill down  it is provided.
If they ask you in detail then tell the interviewer that interact with the report means in drill down report we have one basic list and 20 secondary lists so we can directly go to 5th list or 10th list as per our requirement.similarly we can come back to any list. Drill down means showing data in basic list first and when we double click on any field we get summarized list. NOTE:- to go to next list in drill down report use following syntax
SY-LSIND = < list number> example: to go to 15th list SY-LSIND = 15 to come to 5th list from 15th list use F3 KEY OR PRESS BACK BUTTON

end of page and top of page
Top of page trigger when report encounter the first write, skip or new-line statements.
End of page trigger when page size is over or report display gets over.

 Table and structure
Table has physical definition into the underline database while structure does exist physically in the data base.

table and views
Table has data init while view does not contain data in it. Both exist in the data base. when u run the view it queries the database and gives the respective data.

inner joins and for all entries
Inner join joins the table at database level whereas For..All..Entries joins the table at application level.
In For..All..Entries when the condition gets satisfied data is fetched in one single shot from database table whereas in inner join data is fetched iteration by iteration It is always good programming practice to join tables at application level because if we join tables at database level then there might be performance issue

Transparent table pool table and cluster table
Transparent Table: Exists with the same structure both in the dictionary and database exactly with same data and fields. it’s to store transaction data. It’s one to one Relation table Pool tables: These are logical tables must be assigned to a table pool when they are defined. Its use to store control data. its many to one relation table Clustered tables: these also logical tables and must be assigned to table cluster when they are defined. It’s also used to store control data, temporary data or text ex. documentation. It’s also many to one relation table.

Top of page and top of page during line selection
Top of page is triggered for the basic list while top of page at line selection triggers at secondary list.

 Start_form and End_form in sap script
start_form function module is called if we want to use different forms with similar characteristics in a single spool request ,it must be closed by END_FORM function module
open dataset and close dataset
Open dataset is use to read / write file into application server while  close data set is use to close that file.

 Data element and domains
Domain gives technical details like length , decimal etc..while data elements gives description and business details

set screen and call screen
Set screen <no> set the next screen value and temporarily override the next screen value in screen attribute. While call screen <no> jump to the screen specified in <no>.

 Internal Session and External Session
External session is nothing but the window you have opened in your screen By Default you can open 6 external sessions( 6 windows = you can increase it via basis’s setting). Internal session is created when you call any Functional module or any other task in your program. counts for internal sessions are 9.

 Elementary and collective search help
An Elementary Search help defines the flow of a standard input help. It is composed of a selection method that defines where to get the data that will make up the hit list, An interface consisting of search help parameters that define the exchange of data between the screen and the selection method and a dialog type that controls how the hit list will be displayed.A Collective Search help is a combination of several elementary search helps giving the user a different search paths. The interface parameters of the elementary search help are assigned to the parameters of the collective search.

Monday, March 5, 2012

What is sap system refresh when and why it is done?

System refresh and client copy can be the same thing.  Normally when you want to refresh a system this normally means refreshing the clients using a client copy like SCCL or SCC8.  
A system "copy" is very different as this is far more involved than a simple "client refresh" 

Imagine you have a DEV and a PRD system and after 6 months the data in DEV is very old so you would perform a client copy SCC8 from PRD to DEV using a profile that copies the application data from PRD to DEV - it actually deletes the data and replaces it with data from PRD.  If however your DEV system died and needed to be completely rebuilt, you would use "Homogeneous System Copy" - you install the OS, Database and SAP and then process the system copy - which makes a complete copy of PRD (all clients)
Client copy - a single client refresh from PRD to DEV - can be just application data, or user data, or configuration or any combination you choose system copy - all clients 100% copied PRD to DEV
The system refersh is nothing but the deletion of the client and replacing the data from other client.   For example : you have clients 100, 200 and 300.  Suppose when you want to refresh the client 100 you remove the client 100 and replace it with 200 0r 300 as per your reqiurement. Mostly the refresh of clients will be happen at the time of development stage.
System Refresh is a simplified term to Client Copy. Client Copy means copying the production client on to the quality to test the real data. As recommend by SAP this need to carried out every 3 months.
The process to carry out the same is as follows: 
 1. Create a client on quality system using txn scc4
 2. Create a RFC between Production system and Quality System (need to create on quality system)
 3. Login to the newly created client using sap* and pass as a password
 4. Txn sccl to start the client copy. You can test the client copy by selecting the test run option. (test run will estimate the time taken for the activity).

Monday, February 27, 2012

difference between jspm & sdm in sap

Differences between jspm & sdm

SDM                                                                                              JSPM
We can deploy or install  patches                                         We can install  patches
We can also uninstall patches                                               we cannot un deploy the patches
It cannot check patch dependency & database consistency  it will check the patch dependency & db                                                  
SDM does not depend on JSPM                                          JSPM backend connect with SDM,with out
                                                                                              sdm we cannot connect jspm
patches can be deployed in any location                              patches can be deployed in trans directory 

what is the use of Visual admin or using visualadmin what tasks you performed

Visual admin:
It is a Dynamic tool 
using visual admin we can install license 
We can start & stop services 
we can stop & start applications ( Not application servers)
we can access visual admin remotely
We can create the users 
We can monitor logon user sessions
We can connect jco connections 
we can export & import the certificates (EX : sso certificates )   
we can deploy services like ear,.rar files 
We can alsp access the offline config-tool editor 
we need to user name & pwd required to logon to visual admin 
P4 port is used to login to visual admin 

Path: usr/sap/sid/DVEBMGS<SNO>/J2ee /admin/go.bat

Oracle errors during sap connections ORA-01017,ORA-01031,0RA,012541,ORA1631,1634,1653,1654,255,2772,12541

0RA-01017: When brarchive/ br backup runs (OSS notes 400241-361641)
Check the following
init ora should have os_authent_prefix ops$,remote _os_authent TRUE
Check if OPS$SIDADM exist & it owns SAPUSER table and it has  SAPCHMAOWNER   and password entered in the table

select* from "OPS$ADM" .SAPUSER;
if there are no entries set the password of SAPCHMAOWNER
brconnect -u system / -f chpass - -o -p
make sure the resource and connect is assigned to OPS$ users. to be able to process brbackup make sure sapdba is assigned as well.

How to assign sapdb & sapoper to system;
Connect as a sys grant sysdba to system;grant sysoper to system
if you cannot login login as sys change the password and re login using orasid ,orapws file =PWDSID.ora password =XXXX entries =100

ORA-01031:insufficient privileges 
during brbackup run.Make sure orasid belongs to dba & oper,sidadm belongs to sapsys,dba & oper as the os level  (oss note 134592) run sapdba_role.sql /as orasid:sqlplus /nolog @sapdba_role.sql SID

ORA-012541 Transnames.ora error 
Check db_domain in init.ora if there is domain defind make sure tnsnames.ora has domains
tnsping sid
R3trans -d

ORA1631/1632 Max Extents reached 
increase extents in SE!4

ORA-1653/1654 Table space over flow 
Using Brtools add data file or resize data file

ORA-255/272 Oraarch full 
Move the file to some other place  or delete old archive files

ORA-12541 listener not start 
 Start Listener manually  

Work process die soon after they start in sap system

Symptoms :
All the work process die right after the instance is started
The sap mmc shows work process with status "ended"
Only one work process shows "Wait".
An ABAP dump saying PXA_NO_MEMORY is generated as soon as a user login.The SAPMMC syslog shows the errors "sap-Basis system;Shared memory for PXA buffer now available"

Cause of errors 
The instance profile contains Misconfigured memory related parameters.Most likely the "abap/buffer size"  instance profile parameter set to high.

How to resolve
Edit the instance system profile at the OS level under usr/sap/<SID>/sys/profile and lower the value assigned to "abap/buffersize" then restart instance.Also important to find out if any other parameters ware changed.If not,The system should start once the adequate memory allocation has been set to the "abap/buffersize"parameter.   

The massage server starts but the dispatcher doesn't start in sap

Symptoms :
The dispatcher shows status "Stopped" in sap mmc
The dev_disp file shows errors
***LOG QOA =>nisertono,service_unknown(sapdp00)(nixxi.c2580)
***ERROR =>DpCommInit :Dpxxdisp.c 7326)

Cause of problem :
The Keyword in the massages above is servicce_unknown followed by the entry name"sapdp00"The dispatcher entry "sapdp00"is missing in the services file ex sapdp00 3200/tcp

How to resolve:
Add the necessary entry in the services file  EX: sapdp00 3200/TCP then Re-start the instance 

users get no logon possible massages in sap

Work processes start but no logins are possible
users get the login screen but user does not log them in instead they they get massage no logon  possible
In The sap mmc the massage server show status stopped.
The Dev_ms  files reports the errors
(Thr 2548) **** error =>Mscommlnit: Ni Buflisten( sapnsTST)
(rc =NIESERV_UNKNOWN) (msxxserv.c 8163)
Thr 2548***ERROR =>Msscomminit(msxxserv.c 1561)
Thr 2548***ERROR =>main:mssint (msxxserv.c 5023)
Thr 2548***ERROR=>logq02 =>msshalt, msstop,(msg server 2900) msxxser.c 5078)

Cause of error:
Work process ware able to start the massage server was not.The reasion is because the "services"file is missing the sap massage port entry. Ex sapmsTST 3600/TCP.

how to resolve 
Edit the services file and add the entry.Then  restart the instance.make sure you specify the appropriate tcp port.ex 3600 for massage server 

Sap does not start at all with no massage server & no dispatcher

The massage server & The dispatcher do not start at all in the SAP MMC
When trying to view the developer traces with in the SAP MMC.The network path not found.
No new developer traces written to disk  in work directory

Cause of problem :
The network Share folders sapmnt & saploc do not exit.That explains the network path not found.massage when attempting to view the developer traces within the sap MMC.

How to resolve problem:
Re create the saploc & sapmnt network folders.Both are created on usr/sap/directory . 

Sunday, February 26, 2012

Creating and Editing a Text Document in sap enterprises portal

Create a new folder called Content Management Functions. Create a new text
document within this folder. Display the document. Edit the document online.
1. Log onto the portal as EP300.C-## and create a new folder called Content
Management Functions in /documents.
2. Open the folder and create a new text file with some sample text and a
3. Open the text file to display the content.
4. Edit this text file online to add some additional text and verify that the
changes have been made.

How to Creating a Subscription for a Folder in EP portal

Subscribing to a folder you have created yourself.
1. Create a subscription to your folder SAPEP-## so that you will be notified
of any changes and on any events.
2. Change the document you created Test.txt in the SAPEP-## folder.
3. In the UWL you can check to see if you have been notified of the changes
in the document.

Assigning a Role to a User in sap enterprises portal

Assign a role to a portal user and test the navigation and content provided by
that role.
1. Assign the role you just created to your portal end user, SAPEP.E-##.
Note: In productive portal systems, portal roles are typically
assigned user groups. As an exception, in this course, we will assign
a role to an individual portal user.
2. As portal end user SAPEP.E-##, test the new content.

How to Creating Folders in the Portal Catalog in sap enterprise portel

Create a new folder in the Portal Catalog, which will become the base folder
for all content objects created by you.
1. In the Portal Content Studio, navigate to the folder SAPEP, which was
created by your instructor.
2. Create a new folder below the SAPEP folder using the following settings:
Folder Name Group ##
Folder ID group##
Folder ID Prefix
Note: The ID of each portal object must be unique. Since these
folders are created below the same PCD folder, it is important that
you follow the given naming convention (where ## is to be replaced
by your group number).

How to Logging on to the SAP Enterprise Portal

 Log on to the SAP Enterprise Portal.
1. Start up the Web Browser (here the Microsoft Internet Explorer)
2. Enter the URL for the logon page of your SAP Enterprise Portal. The information necessary to do this is provided by your instructor. The URL is comprised in the following way: http(s)://<host name
of portal server>.<domain>:<port>/irj For example this could be
If possible, save this URL as an Internet Explorer favorite.
3. Log on to the SAP Enterprise Portal with the user SAPEP.E-## (## refers
to your group number) and the password welcome.

Saturday, February 25, 2012

SAP Router Configuration step by step interview patron

Before going for Router installation check that for your public IP is open to sap or not.
Check for all the necessary ports. 
3299 is open to Router on SAP SIDE:
If it’s new server provide details to SAP with your <Distingushed Name>" and hostname to SAP for Certificate generation. 

Follow Below steps

1. Create a Userid like ‘ sncadm’
2. Login to the SAP Service Marketplace with the Service Marketplace USERID which is assigned to your installation.
3. Use the latest SAProuter version, which can be downloaded from SAP Service Marketplace (alias /SWDC).
4. Change to the alias /SAPROUTER-SNCADD.
5. Click on “Download Area” > “SAP Cryptographic Software” and select the correct sapcrypto library for your SAProuter "<op-sys>". Save the file to the directory where the SAProuter executable is located.
6. You can get the file car.exe/sapcar.exe, which is necessary to unpack the archive from any Installation Kernel CD. Executing the command SAPCAR -xvf SAPCRYPTO.CAR will unpack the following files: [lib]sapcrypto.[dll|so|sl] sapgenpse[.exe] , ticket
7. Edited the string in the registry under
MyComputer\HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\ saprouter and changed to “under ImagePath.

8. Information as of POINT 6:: Unpacking of SAPCRYPTO archive
c:\usr\sap\saprouter>sapcar -xvf sapcrypto.CAR
Processing archive sapcrypto.CAR...
x Changelog.txt
x Ver555.pl17
x ntintel
x ntintel/sapcrypto.dll
x ntintel/sapgenpse.exe
x ticket

9. Set your environment variable for user (sncadm) SNC_LIB and SECUDIR:

Screenshot provided below.

10. Make an entry on your service file if windows then in etc/hosts/services
If Unix then etc/hosts

Make the same entry in Router and your entire server. ( DEV, QAS, PRD) 

Screenshot provided for reference. 

11. Generate the certificate Request with the command:
sapgenpse get_pse -v -r certreq -p local.pse “<Distinguished Name>”
sapgenpse get_pse -v -r certreq -p local.pse “CN=example, OU=0000123456,
OU=SAProuter, O=SAP, C=DE”
Alternatively use the two commands:
sapgenpse get_pse -v -noreq -p local.pse “<Distinguished Name>”
sapgenpse get_pse -v -onlyreq -r certreq -p local.pse
You will be asked twice for a PIN here. Please choose a PIN and document it, you have to enter it identically both times. Then you will have to enter the same PIN every time you want to use
this PSE.

12. Display the output file "certreq" and with copy&paste (including the BEGIN and END statement) insert the certificate request into the text area of the same form on the SAP Service Marketplace from which you copied the Distinguished Name.

13. In response you will receive the certificate signed by the CA in the Service Marketplace. Copy&paste the text to a new local file named "srcert", which must be created in the same directory as the sapgenpse executable.

14. With this in turn you can install the certificate in your saprouter by calling:
sapgenpse import_own_cert -c srcert -p local.pse

15. Now you will have to create the credentials for the SAProuter with the same program (if you omit -O <user_for_saprouter>, the credentials are created for the logged in user account).
sapgenpse seclogin -p local.pse -O <user_for _saprouter>
Note: The account of the service user should always be entered in full

16. This will create a file called "cred_v2" in the same directory as "local.pse"

17. Check if the certificate has been imported successfully with the following command:
sapgenpse get_my_name -v -n Issuer
The name of the Issuer should be:
CN=SAProuter CA, OU=SAProuter, O=SAP, C=DE

18. If this is not the case, delete the files "cred_v2"and "local.pse" and start over

19. Once done please make confirm from SAP.
20. Also make sure connection saposs in sm59 working fine

Friday, February 24, 2012

User complaints that he is not login to the sap system? or user unable to login

Ask the user what error he is getting and collect more information about the error.
Try login to system by yourself & make sure sap is up and running on particular server .
If you get connection refused massage  or not in to sap than
Login to sap system at Os level using  <SID>ADM
To check the sap service is up or not by using  sidadm>ps -ef| grep dw(Dispatcher work process)
                                                                            sidadm>Ps –ef|grep ora( to check oracle is up or not)
Both are not running check with team if any maintenance in the progress
Check the outlook mail or massage if any maintenance of server mail is there
If not try to bring sap server to up and later investigate why the system went down.
Login as sidadm >startsap it will strat both oracle& sap

1)If not start due to oracle process down
Check If oracle listener is running or not sidadm  > ps –ef | grep lsntctl
Or login as  ora SID  at Os  level  orasid> lsnrctl status
Now start the database manually
Orasid>sqlplus “/as sysdba”
Go to the <SID>adm screen and start the sap using sidadm >satartapr3  or startsap
Now inform to the users that sap server up& running and can start their work 

2)Now database is running but sap is not running
Go to <sad>adm  screen
Sidadm>r3trans –d  look for return code 0000  it return code 0012  read trans.log file detail error massage
Possible causes for user unable to login:
File system full : check the following file systems
1)df -k | grep usr/sap (alter if it is 100% full)
2)df –k| grep sapdba( check all the file systems are ok below 100%)
3)df-k |grep oraarch (check it is 100% full)
A)Check the (core)dump file at usr/sap/<sid>/DVEBMGS00/work. look for file “core” and delete it
b)Check the background job log file /usr/sap/sid/sys/global/client no>joblg if any old joblogs not needed then delete them to cleanup
c)If sapdata is full increase the file system by asking network team
d)If oraarch is full move the archive log files from orcle/sid/oraarch to different location or run brarchive with -sd option  

Wednesday, February 22, 2012

Sequence of sap Start up procedure in ABAP stack

The SAP System comprises of Database Instance,
Central Services (Message server, Enqueue)
finally the multiple Dialog Instances (ABAP Work Process).
The sequence of startup is extremely important.
• login to SAP with the <sid>adm user To startup the SAP system
• The <sid>adm user belongs to the Unix Group called sapsys on the Unix flavers .
• The <sid>adm belongs to the Windows Group called SAP_<sid>_GlobalAdmin and Administrators Group.
• first the database instance will start
• If Central Services has been setup, this has to be started next. This means that the Enqueue Service and the Message service should be started.
• An independent program called SAP OS Collector (saposcol) is started along with the remaining ABAP work processes in the Central Instance.The dispatcher work process is started after that
• Saposcol collects statistical data from the operating system such as CPU and Memory usage parameters
• Then the individual dialog instances can be started. There is no dependency between the dialog instances
Role of SAP profiles in startup.
• Each SAP instance , whether it is application instance or a dialog instance has three profiles.
START PROFILE ( START<Instance><Instance Number>_<Host name> )
INSTANCE PROFILE (SID<Instance><Instance Number>_<Host name> )

• The start profile is read by the sapstartsrv process and inputs are provided on the SAP system ID and number, as well the physical file paths of the sap executables for starting message service and enqueue service.
• Once the dispatcher work process is started, the Default Profile file is read. This file provides the necessary information to the dispatcher on the memory and sap application performance settings required to run the instance.
• The instance profile is the last file to be read. Any settings in the instance profile file will override the settings in the default profile file.

Monday, February 20, 2012

BI System Daily Monitoring Report & Sap Bi system monitoring tcodes

BI System Daily Monitoring Report
Tcode Activities from SAP BI.
RSPCM Monitoring Process chains
SM58 Monitoring Transactional RFC
RSMO Monitoring Loads
RSA1 Checking source system connectvity
DB02 Check database size and consistency check logs
DB12 Backups  log
SM13 Check Update process and terminated updates
SM51 Check for the Availability of DB and all application servers
SM37 Check  cancelled Jobs and Job queues
ST02 Check SAP Buffers
SM21 Critical/Serious system log messages
ST22 Check and Analyze Program terminations (short dumps)
OSS1 Research SAPNet database for short dumps, determine relevance to THE CLIENT and forward it to super-users
SM50 Check Work process status
SM12 Check Lock Entries
SP01 Check spool request status
ST06 Check for the OS logs
SMLG Check for logon load balancing
SM66 Check for long running Background jobs
ST03 Check for Average Response time
AL08 Check user load balancing across application servers
DB13 Check for completion of Backups
ST06 Check Disk I/O response times
DB01 Check for the database deadlocks


1.Create RFC Destinations in J2EE Engines in SAP EP 7.0

2.Create RFC Destinations for SAP EP 7.0 in SAP BI

3.Maintain Portal Server Settings for SAP EP 7.0 in SAP BI

4.Maintain Single Sign-On in SAP BI

5.Export the BI Certificate in SAP BI

6.Import the BI Certificate into SAP EP 7.0

7.Create BI Systems in SAP EP 7.0

8.Configure User Management in SAP EP 7.0

9.Export the Portal Certificate into SAP EP 7.0

10.Import the Portal Certificate into SAP BI

11.Import the SAP Basis Plug-In into SAP BW

Create RFC Destinations in J2EE Engines in SAP EP

1.Start the SAP J2EE Engine Administrator with go.bat

2.Connect to the Portal Server.

3.Select <SID>/Server<...>/Services/Jco RFC Provider.

4.Maintain an RFC destination:


Gateway host: <GATEWAY_HOST>

Application server host: Same as Gateway host

System number: <SYSTEM_NUMBER>

Client: <BW_CLIENT>

User: <USER> (User in the BW system)

Password: <PASSWORD>

5.Transfer the RFC destination to the available RFC destinations with the Set button.

6.Start the RFC server with the Start button.

Create RFC Destinations for SAP EP 7.0 in SAP BI

Display and Maintenance of RFC Destinations (SM59).

2.Choose Create.

3.Maintain the RFC destination:

RFC destination: <RFC_DESTINATION>

Connection type: T for TCP/IP connection

Technical settings

Activation type: Registered server program


Gateway host: <GATEWAY_HOST>

Gateway service: sapgw<SYSTEM_NUMBER>


Send SAP logon ticket: Activate

4.Save your entries.

Maintain Portal Server Settings for SAP EP in BI

1.Start the transaction Table View Maintenance ( SM30).

2.Enter RSPOR_T_PORTAL as the table.

3.Choose Maintain.

4. choose New Entries.

5.Maintain the connected portal:

RFC destination: <RFC_DESTINATION>

Name of the system: <SYSTEMALIAS>

Portal URL Prefix: <PORTAL_URL_PREFIX>, for example, http://<portalserver><domain>:<port>

6. Save your entries.

Maintain Single Sign-On in SAP BI

1.Set the following profile parameter using the Maintaining Profiles transaction (transaction code RZ10):

login/create_sso2_ticket=1 or


The value 1 means that the certificate is signed by SAP CA. The value 2 means that the certificate is self-signed.

Set login/accept_sso2_ticket=1

Export the BI Certificate in SAP BI

1.Start the transaction Trust Manager for Single Sign-On with Logon Ticket (transaction STRUSTSSO2).

2.Select your own certificate by double clicking on the system name.

3.In the menu, choose Certificate - Export.

4.Enter the file path <BW_SID>_certificate.crt (<BW_SID> is the system ID of the BW system).

5.Choose Binary as the file format.

Import the BI Certificate into SAP EP 7.0

1.Start the SAP J2EE Engine Administrator with go.bat

2.choose <SID>/Server<...>/Services/Key Storage.

3.Select the view TicketKeystore under Views.

4.Under Entry, click on Load.

5.Open the file <BW_SID>_certificate.crt.

SAP J2EE Engine accepts the SAP Logon Tickets from the BI system.

1.Start the SAP J2EE Engine Administrator with go.bat

2.Choose <SID>/Server<...>/Services/Security Provider.

3.Choose Ticket as Application.

4.Choose the Authentication tab page.

5.Change the options for and insert the following values:

trustedsys¡<Number>=<BI_SID>, <BI_CLIENT> (z. B. BIP, 000)

perform the following steps to use the option Send SAP Logon Ticket

1.Start the SAP J2EE Engine Administrator with %INSTALLATION_ROOT%\admin\go.

3.In the tree, choose <SID>/Server<...>/Services/Security Provider.

4.Choose evaluate_assertion_ticket as Application.

5.Choose the Authentication tab page.

6.Change the options for and insert the following values:

Create BI Systems in SAP EP 7.0

1.Start the iView System Administration - System Configuration- System Landscape.

2.Choose New- System

3.choose either the R/3 with Dedicated Application Server for R/3-System as a template.


Type of user assignment: admin,user¡

Logical system name:¡ <SID>CLNT<MANDANT>

SAP client: <CLIENT>

SAP system ID (SID) (R/3 name): <SID>

System type: SAP_BI

System name: <SID>CLNT>

WAS host name: <HOSTNAME>:<PORT>

WAS path: /sap/bw/bex

WAS protocol: http or https
4. Maintain an alias for the system in the System Aliases view.

A system alias in the format <SID>CLNT<CLIENT> must exist, where <SID> is the system ID and <CLIENT> is the client for the system. CLNT is predefined. In addition to the system alias in the format above, you can also maintain other system aliases.

In order to use the example role Business Explorer an alias must be maintained in SAP_BW. Multiple system aliases can be defined for a BI system.

5.Save your entries.

Export the Portal Certificate into SAP EP 6.0

To export the portal certificate from the J2EE engine, follow these steps:

1. Start the SAP J2EE Engine Administrator with <PORTAL_DIRECTORY>\admin\go.bat.

2. Connect to the portal server.

3. Choose <SID>/Server<...>/Services/Key storage from the tree.

4. Select the view TicketKeystore under Views.

5. If the SAPLogonTicketKeypair-cert is not available under Entries, generate a portal certificate

6. Under Entry, choose Create.

Enter the following values in Key and Certificate Generation:

The value CN=Common Name is displayed as the owner in transaction STRUSTSSO2 and serves to identify the certificate. SAP recommends that you use <HOSTNAME_PORT> from the portal server.

Entry name: SAPLogonTicketKeypair (the entry SAPLogonTicketKeypair-cert is generated automatically)

Store certificate: X

7. Choose Generate to generate the certificate.

8. Highlight SAPLogonTicketKeypair-cert under Entries.

9. Under Entry, choose Export.

10. Export the portal certificate as <PORTAL_SID>_certificate.crt in file format X.509 Certificate (.crt).

Import the Portal Certificate into SAP BI

1.Choose the menu command Certificate - Import in the transaction STRUSTSS02 and import the file PORTAL_SID>_certificate.crt in binary format.

2.In order to adopt the certificate into the SSO access control list (ACL), in the menu, choose Edit- Certificate in ACL.

In the SAP Enterprise Portal 7.0 you can specify the system ID of the portal as the system and the value 000 as the client.

3.In order to adopt the certificate into SSO access control list (ACL), in the menu, choose Edit- Adopt Certificate.

4.If you want to distribute the settings to multiple application servers, select Distribute in the context menu for the tree on the left side.

5.Save your entries.

Maintain User Assignments in SAP EP 7.0

1.Start the iView System Administration - System Configuration - System Landscape.

2.Navigate to the previously created system, open the context menu and choose Open -Authorizations.

3.Search for the user or the user group or role, add it and issue read authorization.

Import the SAP Basis Plug-In into SAP BI

1. Download the SAP Basis Plug-In (PI_BASIS) from the SAP Software Distribution Center in the SAP Service Marketplace (quick link SWDC).

2. Start the Transport Management System (transaction code STMS).

3. Import the SAP Basis Plug-In into the BW system.

Saturday, February 18, 2012

Assign Operation Modes to Instances & Advantages of Operations ModeAssign Operation Modes to Instances

An operation mode defines a resource configuration for the instances in your R/3 System. It can be used to determine which instances are started and stopped, and how the individual services are allocated for each instance in the configuration.

Operation modes define:
• The number of work processes used for each service in the instance
• The times that the services are available
Operation modes support automatic switching of work process types.

Advantages of Operations Mode:
• The instance need not be restarted
• The switch between two operation mode
• Efficient utilization of resources
To configure Operations Mode go to
Sap Menu -> Tools -> CCMS -> Configuration -> Operation Modes/Instances
On enter Transaction code: RZ04

There are four steps for configuring Operation Mode:
Define an Operation Mode
Define the Instance
Assign the instance and the work process distribution to the Operation Mode.
Maintain the Operation Mode time table.
A Operation Mode should initially be defined to which the instance file parameters and the corresponding Work Process allocation will be allocated.
The fields in the create Operation Mode screen:
SAP System Name: The name of the system for which the Operation Mode is being created (SID)
Operation Mode: Name of the Operation Mode.
Short Description: A Short description about the Operation Mode.

Assign Operation Modes to Instances
To assign the Operation Mode to the instance profile, from the initial Maintain Operation Mode and Instance screen click on Instance/Operation modes.
Next to each Operation Mode a distribution of work processes for that operation mode is given. Note that the sum for all the Operation should be the same.

Assign Operation Modes to Instances
To assign the Operation Mode to the instance, select any of the instance and go to Instance à Maintain Instance à Work process Distribution. The below window is displayed.
This gives the details of the Operation Mode.
Click on the Other Operation Mode at the button of the window.
Put the name of the New Operation Mode
Adjust the number of WP as per your requirement.
Click on the Save Button.