alternateplanet

January 11, 2010

List of SAP Security Tables

Filed under: SAP, Security — Tags: , — admin @ 8:00 pm

USR* table contains user master information.
AGR* tables dontains data about roles.
USH* table has change documents information.
You can use SQVI or SE16 to get data from these tables.

Table Description
AGR_1016 Name of the activity group profile
AGR_1016B Name of the activity group profile
AGR_1250 Authorization data for the activity group
AGR_1251 Authorization data for the activity group
AGR_1252 Organizational elements for authorizations
AGR_AGRS Roles in Composite Roles
AGR_DEFINE Role definition
AGR_HIER2 Menu structure information – Customer vers
AGR_HIERT Role menu texts
AGR_OBJ Assignment of Menu Nodes to Role
AGR_PROF Profile name for role
AGR_TCDTXT Assignment of roles to Tcodes
AGR_TEXTS File Structure for Hierarchical Menu – Cus
AGR_TIME Time Stamp for Role: Including profile
AGR_USERS Assignment of roles to users
USER_ADDR Address Data for users
USGRP User groups
USGRPT Text table for USGRP
USH02 Change history for logon data
USOBT Relation transaction to authorization object (SAP)
USOBT_C Relation Transaction to Auth. Object (Customer)
USOBX Check table for table USOBT
USOBX_C Check Table for Table USOBT_C
USOBXFLAGS Temporary table for storing USOBX/T* chang
USR01 User Master Data (runtime data)
USR02 Logon data (password,user name, validity date etc..)
USR04 User master authorization (one row per user)
USR06 License data
USR10 Authorisation profiles (i.e. &_SAP_ALL)
USR11 Text for authorisation profiles
USR12 Authorisation values
USR13 Short text for authorisation
USR40 Table for illegal passwords ( never enter * in this table)
UST04 User profiles (multiple rows per user)
UST10C Composit profiles (i.e. profile has sub profile)

This is the vast list of USR,USH & AGR tables

Table name Description
AGRR2 R2 transfer structure
AGRR2T R2 roles transfer structure – Texts
AGR_1016 Name of the activity group profile
AGR_1016B Name of the activity group profile
AGR_1250 Authorization data for the activity group
AGR_1251 Authorization data for the activity group
AGR_1252 Organizational elements for authorizations
AGR_1253 Authorization Data for Activity Group – Static Objects
AGR_AGRS Roles in Composite Roles
AGR_AGRS2 Role definition
AGR_ATTS Role attributes
AGR_BOR_DTL Extended BOR Details for Menu Nodes
AGR_BUFFI Internet Links for a Role
AGR_BUFFI2 Internet links table – Customer version of SAP roles
AGR_BUFFI3 Internet links table – SAP versions of SAP roles
AGR_CATS Transfer structure for categories/PFCG start
AGR_CUSTOM Role Customizing objects
AGR_DATEU Personal settings for roles
AGR_DEFINE Role definition
AGR_EXT_DTL Extended Details for Menu Nodes
AGR_FAVOS Personal settings for PFCG
AGR_FILT Transfer table filter for PRGN_TREE_START
AGR_FLAGS Role attributes
AGR_FLAGSB Role attributes
AGR_HIER Table for Structure Information for Menu
AGR_HIER2 Menu structure information – Customer version of SAP roles
AGR_HIER3 Menu structure information – SAP version of SAP roles
AGR_HIERT Role menu texts
AGR_HIERT2 Role menu texts – Customer version of SAP objects
AGR_HIERT3 Role menu texts – SAP Original
AGR_HIER_BOR Table for Object-Oriented Navigation (OBN)
AGR_HPAGE Role Home Page
AGR_HPAGET Description of the Home Page for a Role
AGR_ICON Display the status icon in the Profile Generator
AGR_INFO Filter Values from Generation Run
AGR_LOGSYS Logical system
AGR_LSD Role attributes
AGR_MAP MiniApp and Text
AGR_MAPP MiniApps in Role
AGR_MAP_KNUMA Conversion Table AG_GUID CRM <> KNUMA
AGR_MARK Table for report SAPPROFC_NEW
AGR_MEM_INITIAL Agreements: Buffer for Intial Upload
AGR_MINI MiniApps in Role
AGR_MINI2 MiniApps in Role
AGR_MINIT Role mini-appl texts
AGR_MINIT2 Role mini-application texts
AGR_NSPCE Namespace
AGR_NUMBER Internal Counter for Assigning Profile Names
AGR_NUM_2 Internal Counter for Assigning Profile Names
AGR_OBJ Assignment of Menu Nodes to Role
AGR_POPUP Structure for dialog box
AGR_POPUP2 Structure for transaction assignment
AGR_POPUP3 Auxiliary structure to input authorization objects
AGR_PROF Profile name for role
AGR_REL_KNUMA_CM Assignment: Agreement –> Campaign
AGR_SELECT Assignment of roles to Tcodes
AGR_SHIER Structure for the Drag and Drop Tool
AGR_SHIERT Structure for the Drag and Drop Tool
AGR_SHIER_BOR Structure for Additional Details with no STRING Field
AGR_SMENU Transfer structure for role maintenance
AGR_SPRTXT Structure for the Drag and Drop Tool
AGR_START Start Role Maintenance: Structure for Tree
AGR_STRING Structure for the Drag and Drop Tool
AGR_STRUC Structure to transfer Tcodes into the Profile Generator
AGR_ST_NAME Role Name
AGR_TAB PFCG start tree transfer structure
AGR_TCDTXT Assignment of roles to Tcodes
AGR_TCODE3 Assignment of roles to Tcodes
AGR_TCODES Assignment of roles to Tcodes
AGR_TCODES_TEXTS Transaction Codes with Texts from AGRs
AGR_TEXTS File Structure for Hierarchical Menu – Customer
AGR_TIME Time Stamp for Role (Menu, Profile, Authorizations)
AGR_TIMEB Time Stamp for Role (Profile Generation)
AGR_TIMEC Time Stamp for Role (User Assignment)
AGR_TIMED Time Stamp for Role (Profile Comparison, RFC Distribution)
AGR_TRAN Transport modules of external personalization objects
AGR_TRANS Help Structure for Translation
AGR_TXT Role and Text
AGR_UPLO Stucture for upload node types
AGR_UPLT Stucture for upload node types
AGR_UPLTX Stucture for upload description text
AGR_USERS Assignment of roles to users
AGR_USERT Assignment of roles to users
USH02 Change history for logon data
USH02_ARC_TMP Change History for Logon Data: Last Entries from Archive
USH04 Change history for authorizations
USH04_ARC_TMP Authorizations Change History: Last Entries from Archive
USH10 Change history for authorization profiles
USH10_ARC_TMP Change History for Profile Data: Last Entries from Archive
USH12 Change history for authorization values
USH12_ARC_TMP Change History for Authorizations: Last Archive Entries
USR01 User master record (runtime data)
USR02 Logon Data (Kernel-Side Use)
USR03 User address data
USR04 User master authorizations
USR05 User Master Parameter ID
USR06 Additional Data per User
USR06SYS System-Specific User Classification (License-Related)
USR07 Object/values of last authorization check that failed
USR08 Table for user menu entries
USR09 Entries for user menus (work areas)
USR10 User master authorization profiles
USR11 User Master Texts for Profiles (USR10)
USR12 User Master Authorization Values
USR13 Short Texts for Authorizations
USR14 Surchargeable Language Versions per User
USR15 External User Name (Replaced By Table USRACL)
USR16 Values for Variables for User Authorizations
USR20 Date of last user master reorganization
USR21 Assign user name address key
USR21S Shadow table: Assignment of user name to address key
USR22 Logon data without kernel access
USR30 Additional Information for User Menu
USR40 Table for illegal passwords
USR41 User master: Additional data
USR41_MLD Transaction Data for USR41
USRACCNTV Generated Table for View USRACCNTV
USRACL SNC Access Control List (ACL): User
USRACLEXT Extended SNC Access Control List (ACL) for Users
USRARCSTAT Reloaded Archiving Runs
USRATTR Additional Attributes for Users
USRBF User Buffer Contents for Fast RFC Logon
USRBF2 User buffer content for fast RFC logon – new
USRBF3 User Buffer Content for Fast RFC Logon – New
USRCD Structure for Change Documents Display in RSUSR100
USRCDT Structure for Change Documents (Technical View)
USRCOBJ Object Filters for Exploding Product Structures
USRCOMB Critical Combinations of Authorizations
USRCOMBT Short Texts for Critical Combinations of Authorizations
USRCRCOMB Part List of Variants for Critical Combinations of Auths
USRDFLT User Settings Field/Value Combination
USRDFLT_KEY Key for User Settings
USRDFLT_PERS User Settings
USRDFLT_PERS_ALV User Settings – ALV Display
USREF Transfer structure for cross-reference function modules
USREFUS Reference user for internet applications
USREFUSVAR Assignment of Reference User Variabe to Reference User
USREL_2 User Administration: Relationship Between Two Objects
USREL_3 User Administration: Relationship Between Three Objects
USREL_AT User Administration: User in Relationship (with Time)
USREL_SA GUM: Assignment of Role/Position to System (Type)
USREL_UA GUM: Assignment of Role to User
USREL_US GUM: Assignment of User (Group) to System (Type)
USREL_USA User Administration: User – System – Activity Group
USREL_UT User Administration: User in Relationship (with Time)
USREL__A User Administration: System – Activity Group
USREL__S User Administration: System in Relationships
USREL__U User Administration: User in Relationship
USREXTID Assignment of External ID to Users
USREXTIDH External ID (Access Using Hash Value)
USREXTIDT Values Table for External ID Type
USREXTIDTT Values Table for External ID Type (Texts)
USRFIELD Central user maintenance: Field maintenance allowed or not
USRFLD CUA: Definition of Logical Fields
USRFLDDEF CUA: Definition of Logical Field Names of ALE Distrib. Users
USRFLDGRP CUA: Field Selection Groups
USRFLDSEL CUA: Field Attributes
USRFLDT CUA: Text Table to Define Logical Fields
USRFLDTSEL Selection of fields
USRFLDVAL CUA: Selection Criteria for Field Attributes
USRGENPRS Table for General Workplace Personalization Data
USRGETFTR Transfer Structure
USRGETSTRC Structure for user transfer
USRGIFAV iPPE Interface: Favorite
USRGIFOL iPPE Interface: Folder
USRGIPROFIL User Assignment to an iPPE Profile
USRGIPROFIL_DYNP Dialog Structure: User Assignment – iPPE Workbench
USRGIPROFIL_WTY Assign User Profile
USRGISETTINGS User Settings for the iPPE Workbench
USRGISTACK iPPE Workbench: Stack
USRINFO Extended User Info for SM04
USRINKONS Reference table for FMs for determining inconsistencies
USRLISTPROFILE Variable List Definition in PDM Environment
USRLUIPROFILE User Assignments to Profiles in the iPPE Workbench Express
USRLUIPROFILE_DYNP User Assignments to Profiles
USRLUISETTINGS User-Specific Settings of the iPPE Workbench Express
USRLUISETTINGS_DYNP User-Specific Settings for Profile
USRM0 Material Master User Settings: Screen Reference “User”
USRM1 Material Master User Settings: Organizational Levels
USRM2 User Settings for the Material Master: Logical Screens
USRM3 Material Master User Settings: Retail Organizational Levels
USRMETHOD Method to be called when distributing users
USRMM User settings: material master
USROBJECTS Table of Previous Initial Object in Structure Overview
USRPDM User-Specific Data in the PDM Environment
USRPWDHISTORY Password History
USRSETTINGS_DYNP User Settings: Navigation Tree – Dialog Structure
USRSTAMP Time Stamp for all Changes to the User
USRSYSACT CUA: Roles in Distributed Systems
USRSYSACTT CUA: Roles in Distributed Systems
USRSYSLNG User’s Language in a System
USRSYSPRF CUA: Profiles in Distributed Systems
USRSYSPRFT CUA: Profile Text in Distributed Systems
USRSYSUPL CUA: Price Lists in SAP System
USRSYSUPPL CUA: Assignment of User Types to Price Lists
USRSYSUTPA CUA: System Measurement: User Types with Attributes
USRSYSUTYP CUA: Texts for User Types in SAP System
USRSYSUZUS CUA: Texts for Special Versions
USRSYSVTYP Generated Table for View USRSYSVTYP
USRTICLASS Class Assignment for Tabular Maintenance of iPPE
USRTREECOL User-Specific Column Permutations per Array Type
USRURLPRS Table for Personalization of Services
USRURLSVR Logical Web Servers for Logical Systems (User-Specific)
USRVAR Variants for Critical Authorizations
USRVARCOM Variants of Critical Combinations of Authorizations
USRVARCOMT Short Texts for Variants of Critical Combs of Authorizations
USRVARID Part List of Variants for Critical Authorizations
USRVART Short Texts for Variants of Critical Authorizations
USRVIEWCOL User-Specific Column View
USRVIEWTAB User-specific Tabstrip View
USR_AUFK User-Defined Fields of AUFK
USR_FLAGS Various Flags for Authorization Programs
USR_FLGNT Personal User Settings / Without Transport
USR_LIST Generated Table for View USR_LIST
USR_QUERY BW Query
USR_TREESNODE Node Structure of a Simple Tree (Report SAPTREX3)
USR_VALUES Transfer structure for selection acc. to auth. values

January 10, 2010

SAP Transport types

Filed under: BASIS, SAP — Tags: , — admin @ 6:00 pm

A quick recap on various types of transports in SAP:

K type: The system owner does not get changed with K type transport. This kind of transport is only allowed to consolidation and production system. After the K type of transport is done no correction is allowed to those objects. Any changes to K type transport objects in consolidation system are called repair.
The repairs can be done to those objects if the change option is selected in SE06 and change option is there in client level selection in T00 table. Generally K type transport is used for stage and production environment.

C type: With the C type transport the ownership of that object is also transferred to the target. After the transport is done, the target system is the owner of the transported objects. The objects will be originals of the target system. These kind of transports are generally done in a four tier architecture, where a bundle of development objects can go from the sandbox environment to development environment or development environment to integration environment and vice versa. SAP recommends doing these transports when the objects should move to another system for further development work.

T type: T type is called a transport of copy. The ownership of the object remains with the source; the target system just gets the copy of the objects. When a sap patch is applied to the development system and transported to other systems, those are perfect example of T type transports.

Different types of Users in SAP

Filed under: BASIS, SAP — Tags: , — admin @ 6:00 pm

There are 5 different User types:

  1. Dialog
  2. System
  3. Communication
  4. Service
  5. Reference

Description about the above User types:

1. Dialog:- For Dialog User GUI Login is possible,Initial password and expiration of password and Multi GUI Logins are checked.
Individual system access (personalized)
It is possible to log on using SAP GUI. The user is therefore capable of interaction through SAP GUI.
The system checks whether the password has expired or is initial.
The user can change his or her password himself or herself.
Multiple dialog logons are checked and, where appropriate, logged.

Purpose of Dialog User is for individual human users.

2. System:- For a System User GUI Login is not possible, Initial password and expiration of password are not checked.
System-related and internal system processes.
It is not possible to log on using SAP GUI. The user is therefore incapable of interaction through SAP GUI.
The password change requirement does not apply to the passwords, that is, they cannot be initial or expired.
Only a user administrator can change the password.
Multiple logons are permissible.

Purpose of System User is for background processing and communication within a system (internal RFC calls) and between multiple systems (external RFC calls).

3. Communication:- For a Communication User login is not possible, Users are allowed to change password through some software in middle tier
Individual system access (personalized)
It is not possible to log on using SAP GUI. The user is therefore incapable of interaction through SAP GUI.
Although the system checks whether the password has expired or is initial, the implementation of the requirement to change the password, which exists in principle, depends on the logon method (interactive or non-interactive).

Purpose of this User is for external RFC calls of individual human users.These are used for login to system through external systems like web application

4. Service:- For a Service User GUI login is possible.Initial password and expiration of password are not checked.Multiple logins are allowed.Users are not allowed to change the password. Only admin can change the password.
Shared system access for a larger, anonymous group of users. Assign only very restricted authorizations for this user type.

Purpose of this User is for anonymous users. This type of users should be given minimum
authorization.After an individual authentication, an anonymous session begun with a service user can be continued as a person-related session with a dialog user.

5. Reference:- For a Reference User GUI login is not possible.Initial password and expiration of password are not checked.
User type for general, non-person related users that allows the assignment of additional identical authorizations, such as for Internet users created with transactions SU01.

Purpose of this Users are special kind of users which are used to give authorization to other users.

January 7, 2010

Fundamentals of RFC (Remote Function Calls)

Filed under: BASIS, SAP — admin @ 6:00 pm

Fundamentals of RFC

Communication between applications of different systems in the SAP environment includes connections between SAP systems as well as between SAP systems and non-SAP systems. Remote Function Call (RFC) is the standard SAP interface for communication between SAP systems. The RFC calls a function to be executed in a remote system. You can also call a function module in the same system as an RFC; however, RFCs are usually used when the calling and called function modules are running in different systems.

In the SAP system, the RFC interface system provides this function. The RFC interface system allows function calls between two SAP systems or between an SAP system and an external (non-SAP) system.
RFC is an SAP interface protocol that is based on the Common Programming Interface for Communication (CPI-C) and allows cross-host communication between programs. This means that ABAP functions can be called from external applications and tools, and that external applications can be called from the SAP system.

RFC means that the ABAP programmer does not have to write his or her own communication routines. For an RFC call, the RFC interface Converts all parameter data to the format required in the remote system calls the communication routines that are required to communicate with the remote system handles errors that occur during the communication.

January 6, 2010

SAP Types of RFC (Remote Function Calls)

Filed under: BASIS, SAP — Tags: , — admin @ 6:00 pm

Types of RFC (Remote Function Calls)

Synchronous RFC (sRFC)
For communication between different systems and between SAP Web AS and SAP GUI.

Asynchronous RFC (aRFC)
For communication between different systems and for parallel processing of selected tasks.

Transactional RFC (tRFC)
A special form of asynchronous RFC. Transactional RFC ensures transaction-like processing of processing steps that were originally autonomous.

Queue(d) RFC (qRFC)
Queued RFC is an extension of tRFC. It also ensures that individual steps are processed in sequence.

RFC is a superordinate term for various implementation variants. sRFC is the synchronous call of function modules. This means that the client waits until the server has completed its processing. In an SAP system, an RFC can also be performed asynchronously in another work process. This variant is called aRFC.

There is also tRFC, the transactional Remote Function Call. Transactional RFC is asynchronous and ensures that data that is sent more than once due to network problems, can be recognized at the server side, by assigning a Transaction Identifier (TID). This allows you to prevent data being processed more than once, leading to erroneous information in the application. Due to the asynchronous processing, however, parameters can only be transferred from the client to the server in this case. Returning information or status information directly is not possible.

qRFC with Send Queue is an extension of tRFC. It creates a layer between applications and the tRFC and only allows the tRFC to transfer a Logical Unit of Work (LUW) to the target server when its predecessors are no longer in the associated wait queues. After a qRFC LUW is executed, the qRFC manager automatically processes the next waiting qRFC LUW in accordance with the sequence in the wait queue.

January 5, 2010

SAP Client Concept

Filed under: BASIS, SAP — Tags: , — admin @ 6:00 pm

Client Concepts and Types of Data in SAP System

Data in an SAP system can be divided into two categories:

1. Client-specific data: Client-specific data such as user master and application data, which affects only one client.
2. Cross-client data: Cross-client data such as cross-client customizing data and all Repository
objects, which affects the whole system environment.

The ABAP Dictionary is a data dictionary that is part of the ABAP Repository. Each piece of the ABAP Dictionary information is entered only once and is then available anywhere in the system at any time. The ABAP Dictionary automatically supplies all new or changed information, thus providing current runtime objects and ensuring data consistency and security.

A client is a self contained unit in technical terms, wit its own master data.

The following are examples of client-specific data:
User master data, such as parameters, authorization, user groups

Customizing data, such as organizational units, assignments, and document types

Application data, such as business transaction data, and material master data

The SAP client concept can integrate several companies or subsidiaries in a single client by using company codes and the SAP authorization concept. Company codes define the smallest corporate organizational units for which a complete self-contained set of accounts can be drawn up for external reporting.
The SAP authorization concept enables the parent company to access all subsidiaries for report purposes, while subsidiary-specific data is protected against access from other subsidiaries through company code definition.

The standard client roles fulfill the optimal minimum requirements of your SAP system.

Client CUST, development and customizing, is the central customizing client where complete adaptation of the SAP system to customer-specific needs takes place. All changes performed in this client are recorded so they can be supplied to the other clients using the Transport Management System.

Client QST, quality assurance, is used to test and verify the new customizing settings in the application.

Client PRD or production is the client for production activities, that is, where your company’s business is carried out. Customizing changes imported into this client have to be first tested carefully in the QST client in order to ensure that production operation is free of disruption.

January 4, 2010

SAP User Administration

Filed under: BASIS, SAP — Tags: , — admin @ 6:00 pm

To start user maintenance you have to use the transaction code SU01. You can create a new user or copy the existing user master. The user master contain all data and setting that are required to log on to a client. In this you can find the following tabs:
Address: Personal info and address
Logon Data: Password and validity period of the user
User Default: Language, Values for printer
Parameters: User specific values for standard fields
Roles and profiles: Roles and profiles assigned to the user
Groups: Grouping users for mass maintenance

Types of User:
Dialog User, Communication User, System User, Service User, Reference User.

User ids allow access to SAP applications. Each user must have a corresponding profile specifically assigned. In many situations, multiple composite profiles can be assigned to a user ID, depending on the roles an individual user is responsible.

Authorizations are the key building blocks of SAP security. Authorization is the process of assigning values to fields present in authorization objects. In SAP, access to all system functionality is achieved through a complex array of authorizations. Sometimes users find that they lack the necessary authorizations to perform a certain function in the system, in which case the message: “You are not authorized…” is displayed at the bottom of the screen

A Profile Generator PFCG is used to automatically generate and assign authorization profiles. The administrator can also create authorization profiles manually.

Default User ids:

User Ids Client Name
SAP* 000 and 001
DDIC 000 and 001
EarlyWatch 066

A user Admin must be fimilar with the tasks and responsibilities of admin for creation, managing and controlling access to the R/3 system and its data, and also various R/3 user types and its data.
Must manage and create new user, groups and profiles using R/3 transaction.
Be fimilar with monitoring active users.
Transport client specific user objects between R/3 system or Clients.

January 3, 2010

SAP System Monitoring

Filed under: BASIS, SAP — Tags: , — admin @ 6:00 pm

The Following are the transaction codes used for the System Monitoring:
SM12:
This Traction is used for Check for Lock Entries. There may be old locks still in place from transactions that did not release, or from when the user was cut off from the Network. If any lock entries are exist then we have to check since how long this lock existing. If, this lock existing from more than one day then we should check that particular User is available or not (By using the Transaction Code AL08). If he is not available then Delete that lock. Otherwise we should wait 1 or 2 Days.

SM13 :
This Transaction is used for Check for any Errors in Update Records. A failed or “Update Terminate” is an update to the failed database. These failed Updates occurs when a user entry or transaction is not entered or Updated in database. And we should check Whether Update is ACTIVE or not. And also we should check any Update Records are terminated.

SM21 :
This Transaction is used to check System Logs. After hitting the traction we should goto System log–> Chooseà All Remote System logs, and set Date and time to before the Last log review. And we should check whether any Errors, Warnings, Security Messages, Database, Abends, Any other different Events are there.The log is important because unexpected or unknown warnings and errors could indicate a serious problem.

SM51 :
This Transaction is used to check that all Application Servers are UP. And also This transaction is a central transaction from which you can select the instance to be monitor.

SM50 :
This Transaction is used to check Work Process Overview and for Systems with out Servers. Here all work processes with a “Running” or “Waiting” State. If Batch Jobs are not Running, If all the work processes are in use, this transaction provide a hint of this problem.

ST01 :
This Transaction is used for System Trace. By this transaction we can trace that what are the operations performed on particular file by particular user on which dates.

ST02 :
This transaction is used for Buffer tuning or Buffer Statistics. And it is used to tune Buffer perameters of R/3. The Buffer is important because significant buffer swaping reduces performance. Look under “Swaps” for Red Entries. Regularly check these entries to establish trends and get a feel of the Buffer behaviour. And in this transaction we should Maintain “Hit Ratio” is in between 90 – 100% for all , and “Heap Memory” allocated should be “0” , and “Swaps” is 0.

ST03 :
This Transaction is used to Check Work Load Analysis of . Workload Analysis is used to determine System performance. Check Statistics and Record Trends to get a feel for the System’s Behaviour and Performance. Understanding the System when it is running well helps us to determine what changes may need to be made when it is not.

ST04 :
This Transaction is used for Database Performance Analysis. This transaction provides the ability to Monitor the Database in related to 1) In Shared Pool “SQL Area Get Ratio” should be 90 – 95% 2) In Log Buffer Allocation Retries / Entries <1% 3) In Data Buffer “Quality” should be in 90 – 95% 4) In Sorts Disk / Memory <1% 5) In Table Scan & Fetches “Long Table Scans” should maintain as minimum as possible. And we should check Detailed Analysis then we should hit “Detailed Analysis menu” Button in this screen. In that we can check Database Overview like “Exclusive Lock Waits” , “Wait Events”, “Buffer Busy Waits”, “ File System Request”, “ Database Message logs”, “ SQL Requests”, Summery Report for all activities, etc

ST22 :
This Transaction is used to Analyse ABAP Dumps or Short Dumps. This transaction is also used for Analyse and Determine why the error occurred and take corrective action. It looks for an excessive number of dumps, and also dumps of an unusual nature. A ABAP dump is generated when a report or transaction terminates as a result of a serious error. The system records in the System Log(SM21) and writes a snapshot of the program terminate to a special table.

DB02 :
This transaction is used to check all table Spaces and Indexes. Here we should check table spaces sizes. If any table used space is =>99 then we should increase add the space for particular table space. And this transaction is provides a way to examine database allocation. And this transaction is allows us to monitor items such as: a) DB Space History b) DB Analysis By this transaction we can view Database history by Dates and Times.

DB12 :
This Transaction is used to check database Backups. And in this we should we see successful Backups and Unsuccessful Backups list

AL08 :
This transaction is used to Check the users on the System. This transaction displays User Ids and Terminal Names who are currently logged on the system.

SM37 :
This transaction is used for Monitoring Background Jobs. Background are batch jobs scheduled to run at specific time during the day. Here we should check for cancelled jobs. Here If we want to check particular job then,we should enter the Job Name and enter User name in User name field or ‘*’ and hit execute Button. And verify that all critical jobs are successful.

Authorizations in SAP Transportation Management

Filed under: SAP, Security, Transport Management — Tags: , — admin @ 9:00 am

The following table shows the authorization objects available in SAP TM.

Authorization Object Description
/SCMTMS/T8 Type of Customer Freight Invoice Request
/SCMTMS/EP Organizational Unit: Execution and Planning
/SCMTMS/T3 Type of Freight Order
/SCMTMS/T4 Type of Freight Request
/SCMTMS/MT Mode of Transportation
/SCMTMS/PY Party
/SCMTMS/PO Organizational Unit: Purchasing
/SCMTMS/SO Organizational Unit: Sales
/SCMTMS/T6 Type of Shipment Order
/SCMTMS/T1 Type of Shipment Request
/SCMTMS/T5 Type of Shipment
/SCMTMS/SU Supplier
/SCMTMS/T7 Type of Supplier Freight Invoice Request
/SCMTMS/G1 Transportation Allocation: Geographical Information
/SCMTMS/T2 Type of Transportation Booking Order
/SCMTMS/C4 Transportation Charges: Calculation Sheet
/SCMTMS/C2 Transportation Charges: Rate
/SCMTMS/C1 Transportation Charges: Scale
/SCMTMS/BO Business Object: Data Access
/SCMTMS/C3 Transportation Charges: Tariff
/SCMTMS/ID ID of a Business Object

January 2, 2010

How to Export and Import SAP Users and Authorizations

Filed under: BASIS, SAP — Tags: , — admin @ 6:00 pm

Export SAP Users and Authorizations:

1) Logon to the target SAP system in the client you want to save and go to transaction SCC8.

2) Select the SAP_USER profile and the Target System,

3) Click the Schedule as Background Job button and then check Immediately.

4) Click the Schedule Job button, click Continue.
If this system has more than 1 server, set Background Server to the Central Instance Server

5) Make a note of the KT transport number shown on the next window. The KT transport is for transporting client specific data.

6) The status of the export can be found using transaction SCC3.

7) After the export completes in SCC3, check the transport logs for the KT transport in SE01. The export is not finished until the “export” step shows completed successfully.

8) For systems with more than one client, you will need to follow the above steps on each client to create a transport of the users for each client.

Import SAP Users and Authorizations:

Note: This procedure assumes the Users were exported and Transport created before the client copy

1) Import the appropriate user Transport for each Client (i.e. 100, 900, 910 etc) from CMD Prompt .
Import needs to be done from CMD prompt (Not STMS), and while import is running, log off of the system as all IDs will be deleted and recreated with the import.

In the examples below a full system was assumed. If you are only importing users from a Client Copy there will only be one transport.

For All R3 Systems

tp addtobuffer xxxKT0aaaa u1 pf=

tp addtobuffer xxxKT0bbbb u1 pf=

tp addtobuffer xxxKT0cccc u1 pf=

tp addtobuffer xxxKT0dddd u1 pf=

tp import xxxKT0aaaa client pf=
tp import xxxKT0bbbb client pf=

tp import xxxKT0cccc client pf=

tp import xxxKT0dddd client pf=

2) After the import is complete, Logon to the SAP GUI for each Client as SAP*

Execute Transaction: SCC7

If a message pops up that this is a Production Client and protected from Client Copies

Go into SM31 and table T000 and change Client to “Test”

Ensure the Transport that is displayed is the Transport you imported in previous step

Select “Execute in Background”

Monitor to completion in Transaction: SCC3

Repeat this process for each Client Transport Exported/Imported

Change Target Client back to “Production” – If necessary

« Newer PostsOlder Posts »

Powered by WordPress