SAP Library - Find your answers

Role & Profile

What is the difference between role and a profile?

Role and profile go hand in hand. Profile is bought in by a role. Role is used as a template, where you can add T-codes, reports..... Profile is one which gives the user authorization. When you create a role, a profile is automatically created.

What is the use of role templates?

User role templates are predefined avtivity groups in SAP consisting of tyransactions, reports and web addresses.

What is the different between single role & composite role?

A role is a container that collects the transaction and generates the associated profile. A composite reole is a container which can collect several different roles

What profile versions?

Profile versions are nothing but when u modify a profile paarameter through a RZ10 and generate a new profile is created with a different version and it is stored in the database.

Is it possible to change role template? How?

Yes, we can change a user role template. There are exactly three ways in which we can work with user role templates
- we can use it as they are delivered in sap
- we can modify them as per our needs through pfcg
- we can create them from scratch.
For all the above specified we have to use pfcg transaction to maintain them.

Personalization Tab Within PFCG

Please expalin the personalization tab within a role.

Personalization is a way to save information that could be common to users, I meant to a user role... E.g. you can create SAP queries and manage authorizations by user groups. Now this information can be stored in the personalization tab of the role. (I supposed that it is a way for SAP to address his ambiguity of its concept of user group and roles: is "usergroup" a grouping of people sharing the same access or is it the role who is the grouping of people sharing the same access?)

How to insert missing authorization? Ways?

su53 is the best transaction with which we can find the missing authorizations.and we can insert those missing authorization through pfcg.

Table of authorisation field settings

Is there a table for authorisations where I can quickly see the values entered in a group of fields?
In particular I am looking to find the field values for P_ORGIN across a number of authorisation profiles, without having to drill down on each profile and authorisation.

AGR_1251 will give you some reasonable info.

Table with deleted users

Someone has deleted users in our system, and I am eager to find out who. Is there a table where this is logged?

Debug or use RSUSR100 to find the infos.

Run transaction SUIM and down its Change documents.

How can I make T_Code SPRO Read Only

I have a requirement to make SPRO read only. As you know it has a tree like structure and to make it read only seems like impossible.

You cannot make SPRO 100% display only by ANY setting. The SCC4 option only turns configuration tables to not-modifyable but still allows the non-config delivery class tables (or those configured to be changeable) to be modifed. It does nothing for the tcodes that are NOT table maintenance and not controlled by S_TABU_DIS. These will still allow configuration. All the tcodes in the SPRO are in several tables CUST_ACTOBJ (spelling?) is one.

You only real option is to create a role with all the tcodes in them that are in the SPRO , remove the create and change to display ( generally by changing the last nunmer on the 4 digit tcodes to 3) and removing all the Create and change access in all the activities and allow only the display.

PFCG allows you to create a role from a SPRO project so the usermenu will come close to the SPRO menu, which your changes it will be display.

Mass Delete of Old Roles

How can i do a mass delete of the roles without deleing the new roles.

There is a SAP delivered report that you can copy, remove the system type check and run. To do a landscape with delete, enter the roles to be deleted in a transport, run the delete program or manually delete and then relase the transport and import them into all clients and systems.

It is called: AGR_DELETE_ALL_ACTIVITY_GROUPS.

To used it, you need to tweak/debug & replace the code as it has a check that ensure it is deleting SAP delivered roles only. Once you get past that little bit, it works well.

Frequently Asked Questions on Authorization

Role & Profile

What is the difference between role and a profile?

Role and profile go hand in hand. Profile is bought in by a role. Role is used as a template, where you can add T-codes, reports..... Profile is one which gives the user authorization. When you create a role, a profile is automatically created.

What is the use of role templates?

User role templates are predefined avtivity groups in SAP consisting of tyransactions, reports and web addresses.

What is the different between single role & composite role?

A role is a container that collects the transaction and generates the associated profile. A composite reole is a container which can collect several different roles

What profile versions?

Profile versions are nothing but when u modify a profile paarameter through a RZ10 and generate a new profile is created with a different version and it is stored in the database.

Is it possible to change role template? How?

Yes, we can change a user role template. There are exactly three ways in which we can work with user role templates
- we can use it as they are delivered in sap
- we can modify them as per our needs through pfcg
- we can create them from scratch.
For all the above specified we have to use pfcg transaction to maintain them.

Personalization Tab Within PFCG

Please expalin the personalization tab within a role.

Personalization is a way to save information that could be common to users, I meant to a user role... E.g. you can create SAP queries and manage authorizations by user groups. Now this information can be stored in the personalization tab of the role. (I supposed that it is a way for SAP to address his ambiguity of its concept of user group and roles: is "usergroup" a grouping of people sharing the same access or is it the role who is the grouping of people sharing the same access?)

How to insert missing authorization? Ways?

su53 is the best transaction with which we can find the missing authorizations.and we can insert those missing authorization through pfcg.

Table of authorisation field settings

Is there a table for authorisations where I can quickly see the values entered in a group of fields?
In particular I am looking to find the field values for P_ORGIN across a number of authorisation profiles, without having to drill down on each profile and authorisation.

AGR_1251 will give you some reasonable info.

Table with deleted users

Someone has deleted users in our system, and I am eager to find out who. Is there a table where this is logged?

Debug or use RSUSR100 to find the infos.

Run transaction SUIM and down its Change documents.

How can I make T_Code SPRO Read Only

I have a requirement to make SPRO read only. As you know it has a tree like structure and to make it read only seems like impossible.

You cannot make SPRO 100% display only by ANY setting. The SCC4 option only turns configuration tables to not-modifyable but still allows the non-config delivery class tables (or those configured to be changeable) to be modifed. It does nothing for the tcodes that are NOT table maintenance and not controlled by S_TABU_DIS. These will still allow configuration. All the tcodes in the SPRO are in several tables CUST_ACTOBJ (spelling?) is one.

You only real option is to create a role with all the tcodes in them that are in the SPRO , remove the create and change to display ( generally by changing the last nunmer on the 4 digit tcodes to 3) and removing all the Create and change access in all the activities and allow only the display.

PFCG allows you to create a role from a SPRO project so the usermenu will come close to the SPRO menu, which your changes it will be display.

Mass Delete of Old Roles

How can i do a mass delete of the roles without deleing the new roles.

There is a SAP delivered report that you can copy, remove the system type check and run. To do a landscape with delete, enter the roles to be deleted in a transport, run the delete program or manually delete and then relase the transport and import them into all clients and systems.

It is called: AGR_DELETE_ALL_ACTIVITY_GROUPS.

To used it, you need to tweak/debug & replace the code as it has a check that ensure it is deleting SAP delivered roles only. Once you get past that little bit, it works well.

Basis Administration Questions Answers

What is th difference between Sap lock and database lock?

A "SAP lock" is named "enqueue lock", the enqueue is on a much higher level, e. g. a complete sales document is locked there whereas in the datbase usually only row locks exist. Since SAP runs on more database than Oracle (thanx god) one needed to have a mechanism, that is database independent and on a higher level.

What is the diff between clients 000 and 001?

Client 000 is the SAP source client, client 001 exists only on certain installations (e. g. solution Manager). *-- Markus

I would like to know is there anyway to transport roles from Production to Development or Sandbox.

Goto PFCG and enter the role which you want to transfer to other system. goto utilities->Mass download it will ask the path where to download/save that role on local desktop give the location and save it. Next logon to the system where you want that particular role.
PFCG-> Role -> upload.
Give the path where the role is saved. it accepts and generates successfully. *-- Mahesh

What is the need of having Development system?

To develop and custamize SAP to companies requirement. say if you dont have DEV, after go-live(started using SAP (PRD}) if you want to do some changes to application, you cannot do changes directly to PRD server, which may cause problem the PRD server live data. so you do the required changes on DEV first and test them on QAS, if it works fine
them transport the same to PRD.

Difference between Application server and Central Instance?

AS: Is just a dialog instance.
CI: Is Dialog instance + Database Instance.

What is Transport domain and Domain controller?

TD: is the collection of transport controller, trans directory and all other systems in the group.

TC: A system which will have trans directory, and in which the total landscape is designed and maintained. in stms you can see all these. *-- Suneel

What are SNOTES ? How to apply them in SAP ?

The name of the transaction is SNOTE. A "note" in general is a hint, documentation, error/bug description and may contain code corrections, that are applied with the transaction SNOTE.

What is OSS ?

OSS is the old name of the nowadays "sapnet" which contains everything you need to run SAP a program, patches, installation/upgrade documentation etc.

What are different modules used like EP, XI, CRM ,BW, etc?

Those are not different modules but different products.

EP = Enterprise Portal
XI = Exchange Infrastructure
CRM = Customer Relationship Management
BW = Business Warehouse (that is the old term), it's now call BI (Business Intelligence)

What is the correct use of SPAM, SAINT, SPAD and SPDD transactions. When should we use each?

SPAM is for installing support packages, SAINT is used to install new addons. SPAD is for creating printers (I assume you meant SPAU) and SPDD is for adjusting modification to dictionary objects.

Is it possible to update Support Release packages from OS level?

No - you can import them but the full process will require additional steps the tools "tp" and "R3trans" are not aware of. The way is to use SPAM - but SPAM has the possibility to schedule those imports in the background.

After doing any Support Package update in SPAM, are there any further steps to carry out for this update to take effect?

No, they are active immediately

SAP Administration Questions Answers

What is the use of profile paramater ztta/roll_area?

The value specifies the size of the roll area in bytes. The roll area is one of several memory areas, which satisfies the user requests of user programs. For technical reasons, however, the first 250 KB or so of a user context are always stored in the roll area, further data
- up to the roll area limit ztta/roll_first,
- in the extended memory, up to the limit ztta/roll_extension or if extended memory is exhausted, then
- again in the roll area, until the roll area is full, then
- in the local process area, up to the limit abap/heap_area_dia or abap/heap_area_total or until the address space or the
swap space is exhausted.

Followed by termination with errors like STORAGE_PARAMETERS_WRONG_SET an error code, that points to memory bottleneck Minimum data transfer with context change; however, the increase helps to avoid problems (address space, swap space, operating system paging). *-- Anupam Sharma

What is R/3? and what is basis version?

SAP Basis:
- Provides the runtime environment for all SAP applications
- Optimally embeds the application in the system environment
- Defines a stable architecture framework for system enhancements
- Contains the tools for administering the entire system
- Allows the distribution of resources and system components
- Provides interfaces for decentralized system parts and external products.

An R/3 instance is a group of R/3 services that are started and stopped as a unit (by an R/3 dispatcher) and have a common instance profile. The name of an R/3 instance is composed of letters standing for the relevant services, and an instance number which is unique for each computer. The services may be D, V, E, B, M, G, or S, which respectively stand for dialogue, update, enqueue, background, message, gateway, and spool services.

Tips by : Suresh Babu

I would like to know the version or name of SAP that is implemented in real time?

This is a very generic question and really depends on what you are implementing (modules).

The history of the "R/3" is

3.0D Basis 300
3.0E Basis 300
3.0F Basis 300
3.1H Basis 310
3.1I Basis 310
4.0B Basis 400
4.5B Basis 450
4.6C Basis 460
4.71 Basis 6.20
4.72 Basis 6.20
5.00 Basis 6.40 (ECC 5.0 - Enterprise Core components)
6.00 Basis 7.00 (ECC 6.0) - actually in RampUp

All of those have increased business functionality and interfaces to other systems (CRM, BW etc.)

What is mysap?

It's a term for all the systems that in a contract (e. g. a MySAP business suite consist of ERP2005, CRM2005, SRM2005).

What is the systems configuration required to implement SAP.. i.e for production,development and QAS servers the hard disk space, RAM, Processor

This also depends on what your are implementing, how many users will work on the system, how many records in what area are created etc.

We need a BIG database system and an even bigger application server for ~ 900 users and 12 languages.

What is ASAP?

It's an old term for an implementation strategy. Blueprint -> prototype -> goLive (if you want to say it in one sentence).

How should I set priority for Printing say like user, teamlead, project manager?

There's nothing like "priority" settings for spool processes. Just define more (profile parameter rdisp/wp_no_spool) processes so people don't need to wait.

Using Tc SGEN I have generated 74% job and later I have terminated the job. I wish to start generating from where it stopped I have refreshed but to no chance nothing was done. How should I further proceed so as to complete the remaining job..

Start SGEN again and select the same you have selected before. It will popup and ask if you want to start from scratch or generate the just the remaining.

Interview Questions for SAP Basis

What is private mode? When does user switch to user mode?

Private mode is a mode where the heap data is getting exclusively allocated by the user and is no more shared across the system. This happens when your extended memory is exhausted.

What is osp$ mean? What if user is given with this authorisation?

OPS$ is the mechanism the adm users uses to connect to the database .

Why do you use DDIC user not SAP* for Support Packs and SPam?

Do _NOT_ use neither DDIC nor SAP* for applying support packages. Copy DDIC to a separate user and use that user to apply them.

Can you kill a Job?

Yes - SM37 - select - kill

If you have a long running Job, how do you analyse?

Use transaction SE30.

How to uncar car/sar files in a single shot?

on Unix:
$ for i in *.SAR; do SAPCAR -xvf $ i; done

When we should use Transactional RFC ?

A "transactional RFC" means, that either both parties agree that the data was correctly transfered - or not. There is no "half data transfer".

What is the use of Trusted system. I know that there is no need of UID and PWD to communicate with partner system. In what situation it is good to go for Trusted system ?

E. g. if you have an R/3 system and a BW system and don't want to maintain passwords. Same goes for CRM and a lot of other systems/applications.

Let me know if my understanding below is correct:
1) By default the RFC destination is synchronous
2) Asynchronous RFC is used incase if the system initiated the RFC call no need to wait for the response before it proceeds to something else.

Yes - that's right.

But keep in mind, that it's not only a technical issue whether to switch to asynchronous. The application must also be able to handle that correctly.

Which table contains the details related to Q defined in SPAM? Is there a way to revert back the Q defined? If yes, How?

There is a "delete" button when you define the queue. If you already started the import it's no more possible since the system will become inconsistent.

What is a developer key? and how to generate a developer key?

The developer key is a combination of you installation number, your license key (that you get from http://service.sap.com/licensekey) and the user name. You need this for each person that will make changes (Dictionary or programs) in the system.

What is XI3.0 ? EXPLAIN XI = Exchange Infrastructure - Part of Netweaver 2004.

SAP Exchange Infrastructure (SAP XI) is SAP's enterprise application integration (EAI) software, a component of the NetWeaver product group used to facilitate the exchange of information among a company's internal software and systems and those of external parties. Like other NetWeaver components, SAP XI is compatible with software products of other
companies.

SAP calls XI an integration broker because it mediates between entities with varying requirements in terms of connectivity, format, and protocols. According to SAP, XI reduces integration costs by providing a common repository for interfaces. The central component of SAP XI is the SAP Integration Server, which facilitates interaction between diverse operating systems and applications across internal and external networked computer systems.

How to see when were the optimizer stats last time run? We are using win2k, oracle 9, sapr346c.

Assumed DB=Oracle

Select any table lets take MARA here but you should do the same for MSEG and few others to see whether the dates match or not.Run the following command on the command prompt:-

select last_analyzed from dba_tables where table_name like '%MARA%';

Here i am posting 10 sample basis questions
Answers

1. Which of the following are standard users in SAP systems? (More than one answers)

a)sap
b)ddic
c)system
d)sap*

Here i am posting 10 sample basis questions

1. Which of the following are standard users in SAP systems? (More than one answers)

a)sap
b)ddic
c)system
d)sap*

1)The local memory of the work process consist of ( More than one answer can be correct)

1. Roll buffer


2. Roll area


3. Paging buffer


4. Page area

1. SM04


2. SM02


3. SM12


4. SM21

1. At least one V2 WP should be configured in a SAP system.


2. If V1 WP are unavailable V2 WP can process V1 requests.


3. If V2 WP are unavailable V1 WP will process the V2 requests.


4. None of the above.

1. Two SAP systems are stored in two different databases.


2. The same user id’s are used by all the SAP System to connect to the same database.


3. The multiple SAP systems are differentiated using the SCHEMA ID.


4. None of the above.

1. SM01


2. SMSY


3. SM66


4. SM13

1. Database layer


2. Application Layer


3. Operating system layer


4. Presentation layer

1. Tables


2. Fields


3. Data elements


4. Domain

1. Activation


2. Version management


3. Profile parameter changes


4. Table entries

1. MARA


2. SARA


3. DB15


4. ARCH

1. SALE


2. FILE


3. DB15


4. DB16

What is the use of profile paramater ztta/roll_area?

The value specifies the size of the roll area in bytes. The roll area is one of several memory areas, which satisfies the user requests of user programs. For technical reasons, however, the first 250 KB or so of a user context are always stored in the roll area, further data
- up to the roll area limit ztta/roll_first,
- in the extended memory, up to the limit ztta/roll_extension or if extended memory is exhausted, then
- again in the roll area, until the roll area is full, then
- in the local process area, up to the limit abap/heap_area_dia or abap/heap_area_total or until the address space or the
swap space is exhausted.

Followed by termination with errors like STORAGE_PARAMETERS_WRONG_SET an error code, that points to memory bottleneck Minimum data transfer with context change; however, the increase helps to avoid problems (address space, swap space, operating system paging).

What is R/3? and what is basis version?

SAP Basis:
- Provides the runtime environment for all SAP applications
- Optimally embeds the application in the system environment
- Defines a stable architecture framework for system enhancements
- Contains the tools for administering the entire system
- Allows the distribution of resources and system components
- Provides interfaces for decentralized system parts and external products.

An R/3 instance is a group of R/3 services that are started and stopped as a unit (by an R/3 dispatcher) and have a common instance profile. The name of an R/3 instance is composed of letters standing for the relevant services, and an instance number which is unique for each computer. The services may be D, V, E, B, M, G, or S, which respectively stand for dialogue, update, enqueue, background, message, gateway, and spool services.

Tips by : Suresh Babu

I would like to know the version or name of SAP that is implemented in real time?

This is a very generic question and really depends on what you are implementing (modules).

The history of the "R/3" is

3.0D Basis 300
3.0E Basis 300
3.0F Basis 300
3.1H Basis 310
3.1I Basis 310
4.0B Basis 400
4.5B Basis 450
4.6C Basis 460
4.71 Basis 6.20
4.72 Basis 6.20
5.00 Basis 6.40 (ECC 5.0 - Enterprise Core components)
6.00 Basis 7.00 (ECC 6.0) - actually in RampUp

All of those have increased business functionality and interfaces to other systems (CRM, BW etc.)

What is mysap?

It's a term for all the systems that in a contract (e. g. a MySAP business suite consist of ERP2005, CRM2005, SRM2005).

What is the systems configuration required to implement SAP.. i.e for production,development and QAS servers the hard disk space, RAM, Processor

This also depends on what your are implementing, how many users will work on the system, how many records in what area are created etc.

We need a BIG database system and an even bigger application server for ~ 900 users and 12 languages.

What is ASAP?

It's an old term for an implementation strategy. Blueprint -> prototype -> goLive (if you want to say it in one sentence).

How should I set priority for Printing say like user, teamlead, project manager?

There's nothing like "priority" settings for spool processes. Just define more (profile parameter rdisp/wp_no_spool) processes so people don't need to wait.

Using Tc SGEN I have generated 74% job and later I have terminated the job. I wish to start generating from where it stopped I have refreshed but to no chance nothing was done. How should I further proceed so as to complete the remaining job..

Start SGEN again and select the same you have selected before. It will popup and ask if you want to start from scratch or generate the just the remaining.

What is the use of profile paramater ztta/roll_area?

The value specifies the size of the roll area in bytes. The roll area is one of several memory areas, which satisfies the user requests of user programs. For technical reasons, however, the first 250 KB or so of a user context are always stored in the roll area, further data
- up to the roll area limit ztta/roll_first,
- in the extended memory, up to the limit ztta/roll_extension or if extended memory is exhausted, then
- again in the roll area, until the roll area is full, then
- in the local process area, up to the limit abap/heap_area_dia or abap/heap_area_total or until the address space or the
swap space is exhausted.

Followed by termination with errors like STORAGE_PARAMETERS_WRONG_SET an error code, that points to memory bottleneck Minimum data transfer with context change; however, the increase helps to avoid problems (address space, swap space, operating system paging).

What is R/3? and what is basis version?

SAP Basis:
- Provides the runtime environment for all SAP applications
- Optimally embeds the application in the system environment
- Defines a stable architecture framework for system enhancements
- Contains the tools for administering the entire system
- Allows the distribution of resources and system components
- Provides interfaces for decentralized system parts and external products.

An R/3 instance is a group of R/3 services that are started and stopped as a unit (by an R/3 dispatcher) and have a common instance profile. The name of an R/3 instance is composed of letters standing for the relevant services, and an instance number which is unique for each computer. The services may be D, V, E, B, M, G, or S, which respectively stand for dialogue, update, enqueue, background, message, gateway, and spool services.

Tips by : Suresh Babu

I would like to know the version or name of SAP that is implemented in real time?

This is a very generic question and really depends on what you are implementing (modules).

The history of the "R/3" is

3.0D Basis 300
3.0E Basis 300
3.0F Basis 300
3.1H Basis 310
3.1I Basis 310
4.0B Basis 400
4.5B Basis 450
4.6C Basis 460
4.71 Basis 6.20
4.72 Basis 6.20
5.00 Basis 6.40 (ECC 5.0 - Enterprise Core components)
6.00 Basis 7.00 (ECC 6.0) - actually in RampUp

All of those have increased business functionality and interfaces to other systems (CRM, BW etc.)

What is mysap?

It's a term for all the systems that in a contract (e. g. a MySAP business suite consist of ERP2005, CRM2005, SRM2005).

What is the systems configuration required to implement SAP.. i.e for production,development and QAS servers the hard disk space, RAM, Processor

This also depends on what your are implementing, how many users will work on the system, how many records in what area are created etc.

We need a BIG database system and an even bigger application server for ~ 900 users and 12 languages.

What is ASAP?

It's an old term for an implementation strategy. Blueprint -> prototype -> goLive (if you want to say it in one sentence).

How should I set priority for Printing say like user, teamlead, project manager?

There's nothing like "priority" settings for spool processes. Just define more (profile parameter rdisp/wp_no_spool) processes so people don't need to wait.

Using Tc SGEN I have generated 74% job and later I have terminated the job. I wish to start generating from where it stopped I have refreshed but to no chance nothing was done. How should I further proceed so as to complete the remaining job..

Start SGEN again and select the same you have selected before. It will popup and ask if you want to start from scratch or generate the just the remaining.

What is private mode? When does user switch to user mode?

Private mode is a mode where the heap data is getting exclusively allocated by the user and is no more shared across the system. This happens when your extended memory is exhausted.

What is osp$ mean? What if user is given with this authorisation?

OPS$ is the mechanism the adm users uses to connect to the database .

Why do you use DDIC user not SAP* for Support Packs and SPam?

Do _NOT_ use neither DDIC nor SAP* for applying support packages. Copy DDIC to a separate user and use that user to apply them.

Can you kill a Job?

Yes - SM37 - select - kill

If you have a long running Job, how do you analyse?

Use transaction SE30.

How to uncar car/sar files in a single shot?

on Unix:
$ for i in *.SAR; do SAPCAR -xvf $ i; done

When we should use Transactional RFC ?

A "transactional RFC" means, that either both parties agree that the data was correctly transfered - or not. There is no "half data transfer".

What is the use of Trusted system. I know that there is no need of UID and PWD to communicate with partner system. In what situation it is good to go for Trusted system ?

E. g. if you have an R/3 system and a BW system and don't want to maintain passwords. Same goes for CRM and a lot of other systems/applications.

Let me know if my understanding below is correct:
1) By default the RFC destination is synchronous
2) Asynchronous RFC is used incase if the system initiated the RFC call no need to wait for the response before it proceeds to something else.

Yes - that's right.

But keep in mind, that it's not only a technical issue whether to switch to asynchronous. The application must also be able to handle that correctly.

Which table contains the details related to Q defined in SPAM? Is there a way to revert back the Q defined? If yes, How?

There is a "delete" button when you define the queue. If you already started the import it's no more possible since the system will become inconsistent.

What is a developer key? and how to generate a developer key?

The developer key is a combination of you installation number, your license key (that you get from http://service.sap.com/licensekey) and the user name. You need this for each person that will make changes (Dictionary or programs) in the system.

What is XI3.0 ? EXPLAIN XI = Exchange Infrastructure - Part of Netweaver 2004.

SAP Exchange Infrastructure (SAP XI) is SAP's enterprise application integration (EAI) software, a component of the NetWeaver product group used to facilitate the exchange of information among a company's internal software and systems and those of external parties. Like other NetWeaver components, SAP XI is compatible with software products of other
companies.

SAP calls XI an integration broker because it mediates between entities with varying requirements in terms of connectivity, format, and protocols. According to SAP, XI reduces integration costs by providing a common repository for interfaces. The central component of SAP XI is the SAP Integration Server, which facilitates interaction between diverse operating systems and applications across internal and external networked computer systems.

How to see when were the optimizer stats last time run? We are using win2k, oracle 9, sapr346c.

Assumed DB=Oracle

Select any table lets take MARA here but you should do the same for MSEG and few others to see whether the dates match or not.Run the following command on the command prompt:-

select last_analyzed from dba_tables where table_name like '%MARA%';

Caution: more than one answer may be correct.
Please mark ALL correct answers.

Question:
When creating a logon group for Logon Load Balancing, which of the following CANNOT be specified?

A. Maximum allowable response time.
B. Maximum number of users who may be logged on to the instance.
C. Name of the instance defined for the logon group.
D. Maximum number of sessions per user.
E. Name of the logon group

Question:
Which R/3 System user is used for starting external programs using SAP background jobs?

A. DDIC
B. SAP*
C. SAPR3
D. SAPCPIC
E. adm

Question:
Name the R/3 System transaction used for mointoring a spool requests.

A. SM50
B. SM51
C. SPAD
D. SP01
E. SM37

Question:
Which of the following is authorized to maintain R/3 user id parameters?

A. Only the R/3 system administrator.
B. All R/3 users having an account in the same R/3 client.
C. Only the user himself.
D. Only the R/3 system administrator and the user.

Question:
Given a LAN with an R/3 Central Instance with database (Node: host1, Instance Name:DVEBMGS01, SAPSID:C11), and R/3 Dialog Instance (Node: host2), and several R/3 Frontend PC's what is the name of the profile where the SAPDBHOST parameter is defined?

A. C11_DVEBMGS00_host1
B. The SAPDBHOST parameter is defined in the database startup profile.
C. TEMU.PFL
D. DEFAULT.PFL
E. START_DVEBMGS01_host1

Question:
Given and R/3 Central Instance with all services installed, using Instance ID01, and having the SAP ID of C11. What is the name of the directory where the work process trace files are written (for Windows NT replace the "/" with "\")?

A. /usr/sap/C11/DVEBMGS01/data
B. /usr/sap/C11/DVEBMGS01/log
C. /usr/sap/C11/DVEBMGS01/work
D. The trace files are written in internal database tables.
E. The trace files are written in the home directory of the database.

Question:
Which of the following functions is NOT possible using the SAP Online Service System (OSS)?

A. Execute online searches for R/3 Notes.
B. Register problems with the SAP Hotline.
C. Lookup SAP training dates and course offerings.
D. Register changes to SAP objects.
E. Apply for official Internet address from SAP.

1)Which SAP system parameter points to the path of the transport directory?

1. DIR_HOME
2. DIR_DBMS
3. DIR TRANS
4. DIR_EXECUTABLE

1. BD15
2. BD54
3. BD64
4. BD87

1. RZ04
2. SM69
3. SM58
4. SM30

1. WE05
2. WE20
3. BD15
4. BD87

1. Logical system
2. Message Type
3. Program ID
4. Partner Profile

1. Access to http://service.sap.com/ is available only to customers.
2. Access to http://help.sap.com/ is available only to SAP partners.
3. Access to http://service.sap.com/ is available only to SAP customers and partners.
4. All of the above.
5. None of the above.

1. Object keys in a SAP system are stored in table ADIRACCESS.
2. To create a customer program ZABCD you require an object key.
3. To modify a customer program ZABCD you need an object key.
4. To create a customer program ZABCD you need a developer key.
5. None of the above.

1. SAP_ALL
2. SAP_ABA
3. SAP_NEW
4. SAP_ CUST

1. SCC1
2. SLOG
3. SCCL
4. SCC3

1. DDIC
2. BASIS
3. SAP*
4. SYS

1)What will happen if a background job is running and the Operation Mode Switch is activated in between?

1. The job will be cancelled


2. The job will be put in Suspended state


3. The Job will continue to run and once it finishes then the Operation Mode Switch will occur


4. The Operation Mode will happen the next day

1. DEV, QAS & PRD systems on one Server


2. DEV & QAS on one server and PRD on another server


3. DEV, QAS & PRD on separate server


4. DEV on one server and QAS & PRD on one server

1. Connection between Dialog & Spool Work Process


2. Connection between OS Spool and the Actual Printer


3. Connection between Spool Work Process and OS Spool


4. Connection between Spool Request & Output Request

1. 1000


2. 999


3. 500


4. 998

1. TMSADM


2. SAPDPIC


3. DDIC


4. SYS

1. transport.ini


2. DOMAIN_DEV.cfg


3. TP_.PFL


4. tpimport.pfg

1. Dispatcher


2. Message server


3. Work process


4. SAPGUI

1. In the TemSe database


2. at the Operating system


3. in the shared memory of the central instance


4. in the shared memory of the dialog instance

1. roll first, heap memory until exhausted, remaining of roll area, then Extended memory


2. roll first, Extended memory until quota reached, remaining of Roll area, then Heap memory


3. Extended memory until quota reached, then the whole of Roll area, then heap memory


4. roll first , then heap memory, then extended memory , remaining roll area.

1. sapxpg


2. gwrd


3. dpmon


4. sapevt

What is th difference between Sap lock and database lock?

A "SAP lock" is named "enqueue lock", the enqueue is on a much higher level, e. g. a complete sales document is locked there whereas in the datbase usually only row locks exist. Since SAP runs on more database than Oracle (thanx god) one needed to have a mechanism, that is database independent and on a higher level.

What is the diff between clients 000 and 001?

Client 000 is the SAP source client, client 001 exists only on certain installations (e. g. solution Manager). *-- Markus

I would like to know is there anyway to transport roles from Production to Development or Sandbox.

Goto PFCG and enter the role which you want to transfer to other system. goto utilities->Mass download it will ask the path where to download/save that role on local desktop give the location and save it. Next logon to the system where you want that particular role.
PFCG-> Role -> upload.
Give the path where the role is saved. it accepts and generates successfully. *-- Mahesh

What is the need of having Development system?

To develop and custamize SAP to companies requirement. say if you dont have DEV, after go-live(started using SAP (PRD}) if you want to do some changes to application, you cannot do changes directly to PRD server, which may cause problem the PRD server live data. so you do the required changes on DEV first and test them on QAS, if it works fine
them transport the same to PRD.

Difference between Application server and Central Instance?

AS: Is just a dialog instance.
CI: Is Dialog instance + Database Instance.

What is Transport domain and Domain controller?

TD: is the collection of transport controller, trans directory and all other systems in the group.

TC: A system which will have trans directory, and in which the total landscape is designed and maintained. in stms you can see all these. *-- Suneel

What are SNOTES ? How to apply them in SAP ?

The name of the transaction is SNOTE. A "note" in general is a hint, documentation, error/bug description and may contain code corrections, that are applied with the transaction SNOTE.

What is OSS ?

OSS is the old name of the nowadays "sapnet" which contains everything you need to run SAP a program, patches, installation/upgrade documentation etc.

What are different modules used like EP, XI, CRM ,BW, etc?

Those are not different modules but different products.

EP = Enterprise Portal
XI = Exchange Infrastructure
CRM = Customer Relationship Management
BW = Business Warehouse (that is the old term), it's now call BI (Business Intelligence)

What is the correct use of SPAM, SAINT, SPAD and SPDD transactions. When should we use each?

SPAM is for installing support packages, SAINT is used to install new addons. SPAD is for creating printers (I assume you meant SPAU) and SPDD is for adjusting modification to dictionary objects.

Is it possible to update Support Release packages from OS level?

No - you can import them but the full process will require additional steps the tools "tp" and "R3trans" are not aware of. The way is to use SPAM - but SPAM has the possibility to schedule those imports in the background.

After doing any Support Package update in SPAM, are there any further steps to carry out for this update to take effect?

SAP Basis Certification Sample Questions

Caution: more than one answer may be correct.
Please mark ALL correct answers.

Question:
When creating a logon group for Logon Load Balancing, which of the following CANNOT be specified?

A. Maximum allowable response time.
B. Maximum number of users who may be logged on to the instance.
C. Name of the instance defined for the logon group.
D. Maximum number of sessions per user.
E. Name of the logon group

Question:
Which R/3 System user is used for starting external programs using SAP background jobs?

A. DDIC
B. SAP*
C. SAPR3
D. SAPCPIC
E. adm

Question:
Name the R/3 System transaction used for mointoring a spool requests.

A. SM50
B. SM51
C. SPAD
D. SP01
E. SM37

Question:
Which of the following is authorized to maintain R/3 user id parameters?

A. Only the R/3 system administrator.
B. All R/3 users having an account in the same R/3 client.
C. Only the user himself.
D. Only the R/3 system administrator and the user.

Question:
Given a LAN with an R/3 Central Instance with database (Node: host1, Instance Name:DVEBMGS01, SAPSID:C11), and R/3 Dialog Instance (Node: host2), and several R/3 Frontend PC's what is the name of the profile where the SAPDBHOST parameter is defined?

A. C11_DVEBMGS00_host1
B. The SAPDBHOST parameter is defined in the database startup profile.
C. TEMU.PFL
D. DEFAULT.PFL
E. START_DVEBMGS01_host1

Question:
Given and R/3 Central Instance with all services installed, using Instance ID01, and having the SAP ID of C11. What is the name of the directory where the work process trace files are written (for Windows NT replace the "/" with "\")?

A. /usr/sap/C11/DVEBMGS01/data
B. /usr/sap/C11/DVEBMGS01/log
C. /usr/sap/C11/DVEBMGS01/work
D. The trace files are written in internal database tables.
E. The trace files are written in the home directory of the database.

Question:
Which of the following functions is NOT possible using the SAP Online Service System (OSS)?

A. Execute online searches for R/3 Notes.
B. Register problems with the SAP Hotline.
C. Lookup SAP training dates and course offerings.
D. Register changes to SAP objects.
E. Apply for official Internet address from SAP.

Keyword: SAP HR
Title : SAP HR Interview Questions - Set 2

Keyword: SAP HR
Title : SAP HR Questions - Set 3

Keyword: SAP HR
Title : SAP HR Interview Questions - Set 4

Keyword: SAP HR
Title : SAP HR Interview Questions - Set 5