12 September, 2013

TABLES IN SAP BASIS

User administration
USR01                          User master
USR02                          Logon data
USR03                          User address data
USR04                          User master authorizations
USR11                          User Master Texts for Profiles (USR10)
UST12                          User master: Authorizations
USR12                          User master authorization values
USR13                          Short Texts for Authorizations
USR40                          Prohibited passwords
TOBJ                            Objects
TOBC                           Authorization Object Classes
TPRPROF                     Profile Name for Activity Group
DEVACCESS                Table for development user
Data dictionary tables
DD02L                          Tables in SAP
DD02T                          Tables description
DD03L                          Field names in SAP
DD03T                          Field description in SAP
Workbench
TADIR                           Directory of R/3 Repository Objects
TRDIR                           System table TRDIR
TFDIR                           Function Module
TLIBG                           Person responsible for function class
TLIBT                            Function Group Short Texts
TFTIT                            Function Module Short Text
TSTC                            Transaction codes in SAP
TSTCT                          Transaction codes texts
T100                             Message text (vb e000)
VARID                          Variant data
D020T                           Screen texts
TDEVC                         Development class
TDEVCT                       Texts for development classes
E070                             Transport request
E071                             Transport request/Object key
Administration
Batch input queue
APQD                           DATA DEFINITION Queue
APQI                            Queue info definition
Job processing
TBTCO                          Job status overview table
TBTCP                          Batch job step overview
Spool
TSP02                          Spool: Print requests
Runtime errors
SNAP                           Runtime errors
Message control
TNAPR                         Processing programs for output
NAST                            Message status
NACH                           Printer determination
EDI
EDIDC                          Control record
EDIDD                          Data record
EDID2                          Data record 3.0 Version
EDIDS                          EDI status record
EDPAR                         Convert External <  > Internal Partner Number
EDPVW                        EDI partner types
EDPI1                           EDI partner profile inbound
EDPO1/2/3                   EDI partner profile outbound
Change documents
CDHDR                                    Change document header
CDPOS                                    Change document positionen
JCDS                           Change Documents for System/User Statuses (Table JEST)
Reporting tree table
SERPTREE                   Reporting: tree structure
SREPOVARI                 Reporting: tree/program
LIS structure/control tables
TMC4                            Global Control Elements: LIS Info Structure

REPORTS IN SAP BAISIS

Reports in SAP
Reports in sap is a executable program which read data from database and provide output based on selection criteria of reports.
Run Reports in SAP
SE38 -- >Enter reports name in report/program field. -- > execute
It will execute in dialog mode if we want in background we can navigate to program -- > execute in background
Some standard reports
SUSR406    Regenerate SAP_ALL profile or su21
AGR_REGENERATE _SAP_ALL  it will generate SAP_ALL in all client if we going to run in 000 client
TH_POPUP    Message to particular user
RSSNAPDL    Delete ABAP Dumps
RSBPSTDE    Delete old job statistics
RSBTCDEL    Delete old background jobs
RSCOLL00    Performance Collector
RSTRFCER    Delete EXEC LUWs
RSPO1041    Delete old Spool Files
RSARFCDL    Cleans up log file for sm58 transfers
RSPO1041    Delete old Spool Files
RDDNEWPP   Schedule DDIC Jobs
RSBDCREO    Delete Old Batch input Files
RSBTCPRIDEL    Reorganization of Print Parameters for Background Jobs
RSPO1043    Spool Data-Consistency check in Background (SP12)
SAPconnect  Start Send Process Fax/Email
RSTBPDEL    Delete Entries in DBTABLOG
RSTRFCES    Deletes tRFC and qRFC entries
RSTS0024    Delete job log headers from TST01 that are older than jobs
SBAL_DELETE    Deletes application logs
RBDCPCLR    Deletes Obsolete change pointers
RSARFCEX    Retries entries in sm58 that may have failed due to temp conn errors
RSN3_STAT_COLLECTOR- Non R/3 Stat collector
RSAL_BATCH_TOOL_DISPATCHING - Job for monitoring
RSN3_AGGR_REORG    Program for Starting the Reorganization Function

23 August, 2013

Kernel In SAP

Kernel In SAP
Kernel contains the executable files. It contains those files which are used to run every event in SAP. Example: starting database, shutdowns of database, starting sap, shutdown of sap, saposcol, to uncar the sap files etc.
The applications are coded and run in an OS and DB-independent manner. Thus, the kernel of an SAP system consists of all native programs and dynamic libraries that are required for launching the Runtime, executing ABAP or Java codes, communicating with the outside world of the application server like OS, DB and network. These native binaries can be categorized through different aspects:
            DB-dependent vs. DB-independent:
            Unicode vs. Non-Unicode:
            Primary vs. subsidiary:
The SAP R/3 or J2EE engine kernel consists of executable that are directly used by the SAP processes, by the database administration utilities, or by the installation programs etc. Some of these programs can be very useful even when the SAP system is down. The SAPCPE process will make sure that once the kernel upgrade is done, the kernel files are in synch in all the locations.

Location
In a standard standalone SAP server the kernel or runtime directory is
/usr/sap/<SID>/SYS/exe/uc
Some important kernel files in sap
R3trans_164-20000978.SAR: R3trans_164-20000978.SAR' is a compressed archive with the latest version of R3trans from the SAP Service Marketplace, used when we patched the kernel.
SAPCAR: SAP Compression and Archiving program
Cleanipc: Cleans Inter-Process Communications Memory
disp+work: Dispatcher & Workprocess - "The complete Kernel" - Here the complete ABAP is processed.
Dpj2ee: Dispatcher for Java
Dpmon: Used to get the process overview of an instance in text mode.
Enserver: SAP Enqueue Server
Jcmon: Program to monitor and manage Java processes
Jcontrol: Program to control Java processes
jenqulib.jar:            Java Enqueue Library
jlaunch: Program starts the Java processes.
Rfcping: Ping the RFC layer.
sapccm4x: CCMS Agent for Abap
sapccmsr: CCMS Agent for Java
sapcontrol: 'sapcontrol' is used to stop/start/monitor the sap instances (for example, from the sapmc).
Sapstart: Starts SAP processes
Sapstartsrv: Starts SAP processes.
startdb          Program to start the database
startj2eedb Program to start the database (Java)
startrfc: The tool is a very easy SAP command line interface to start all of the implemented function modules of SAP systems.
Startsap: Program to start SAP
stopdb: Program to stop the database
stopj2eedb: Program to stop the database (Java)
stopsap: Program to stop SAP
tp: The Transport Tool. This program coordinates the complete import and export of program and table changes made within the SAP system in order to transport them through the complete System Landscape.
icmadmin.SAR: Tool to monitor and manage the Internet Communication Manager (ICM) from the SAP System (transaction SMICM).
Icman: Tool to monitor and manage the Internet Communication Manager (ICM) from the SAP System (transaction SMICM).
Icmbnd: Program to bind ports with numbers from 0 to 1023
Icmon: Internet Communication Manager (ICM) used for HTTP(S), SMTP based communication used to monitor and manage the Internet Communication Manager (ICM) from the SAP System (transaction SMICM).
instance.lst List of database-independent executables. These executables are valid for all database systems used by the SAP system.
instancedb.lst List of database-dependent executables. These executables can only be used with a particular database system.
Kernel Upgrade  Process:
Find the current version of the J2EE kernel (Any one step)
            Execute the command disp+work –v in cmd
            SYSTEM->STATUS
            SM51->Release Notes
Know about Unicode or non-Unicode(Any one step)
            TP –V from command prompt
            Winmsd  from command prompt
            Isainfo –v in Unix
            SE38 run report RSPARAM RSPFPAR
Download the kernel according to your need from SAP Market place
            http://service.sap.com/swdc
--->Support Packages and Patches --->SAP NetWeaver ---> SAP NETWEAVER---> SAP NETWEAVER 7.0 (2004S) ---> Entry by Component---> Application Server Java--->SAP Kernel 7.00 32 bit UNICODE
Uncar the .SAR files in any location
            SAPCAR -xvf <filename.SAR>
            Ex:- /usr/sap/<SID>/SYS/exe/uc/NTAMD64_NEW
            Note in case of error
Rename the SAPCAR file to SAPCAROLD and then extract the kernel files again:
            SAPCAROLD.EXE -xvf <filename.SAR>
Bring SAP and OS COLLECTOR down:
            Stop sap from MMC
            In windows, stop the SAPOSCOL (Start-> run-> services.msc)
In Unix servers, stop the SAPOSCOL use the command:
saposcol –k
Note: SAPOSCOL service should be stopped because it also will get overwritten by the new file. Also, in UNIX servers, the owner of SAPOSCOL service is the user "root". In this case, you will have to login as "root" user and stop the service.
Take Backup of the present Kernel directory
            /usr/sap/<SID>/SYS/exe/uc/NTAMD64
Copy the new kernel files to the KERNAL LOCATION folder location
            EXA:-
 /usr/sap/<SID>/SYS/exe/uc/NTAMD64_NEW    FILES TO
/usr/sap/<SID>/SYS/exe/uc/NTAMD64
Bring SAP and OS COLLECTOR UP:
            Start sap from MMC
            In windows, start the SAPOSCOL (Start-> run-> services.msc)
In Unix servers, start the SAPOSCOL use the command:
saposcol –l
From command prompt enter disk+work for check kernel version which have been upgrade
Check DB connection using R3trans -d


18 August, 2013

TYPE OF USER

Type of user in SAP
Dialog:  This is the most commonly used type. This user type is primarily for individuals to gain interactive system access.  A user of this type can perform dialog processing in interactive mode, background processing, and batch input processing and CPI-C services provided there are no explicit restrictions via assignment of specific authorizations.
SAP licensing can prohibit multiple concurrent use of the same user id in production SAP systems.
     GUI login is possible.
     Initial password and expiration of password are checked. 
     Multi GUI logins are checked.
     Usage: - These are used for GUI logins.

Communication:  This user type is used for dialog-free communication between systems such as RFC (Remote Function call) communication. This user is not allowed to logon to the R/3 system or start dialog processing.
         GUI login is not possible.
         Users are allowed to change password through some software in middle tier.
         Usage: - These are used for login to system through external systems like web application.

System: This is the user type which can be used for dialog-free communication within a system (such as for RFC users for ALE, TMS, workflow and CUA) and for background processing.
A specific use of the system user type is validity period of a password won’t apply for this type. So, this can be used to run background jobs and in between RFCs so that jobs or RFC communications won’t fail due to expiry of the password.
Please note that logon in dialog is not possible used System user type.
         GUI login is not possible.
         Initial password and expiration of password are not checked.
         Usage: - These are used for internal use in system like background jobs.

Service: This user type is a dialog user which is available to a large, anonymous group of users. For example, to access via ITS (Internet Transaction Server)
There won’t be any check on initial password or expired passwords for this user type. Also, multiple logons are explicitly permitted for this user type.
         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
         Usage: - These are used for anonymous users. This type of users should be given minimum authorization.
Reference: This user type is in general, non-person related user.  This user type cannot be used for logon. Instead this user type will serve as a reference for assigning additional identical authorizations to other users.
         GUI login is not possible.
         Initial password and expiration of password are not checked.
         Usage: - These are special kind of users which are used to give authorization to other users.

17 May, 2013

SAP BASIS QUESTION

1. What are you roles and responsibilities in your company?
Monitoring
Troubleshooting
Kernel upgrade
TMS configuration
RFC configuration
Installation
System refresh
Client creation and client copy
Apply note and patches
2. How you will do client copy?
     Using TCODE SCCL, SCC7, SCC8
3. If SAP* is not available then how u will do?
Go to rz10 and change parameter login/no_automatic_user_sapstar 0 to 1so u can login withsap*. 
4. After client copy is table space and database sizes will be increased or not?
Well the actual size will increase
5. How to do client copy fast?
    Local client copy SCCL will be fast
6. What are various profiles available for client copy?
SAP_ALL
SAP_USER
SAP_CUST
SAP_UCUSTSAP_APPL
7. How to do transport’s between Production and Development?
STMS
8. How to apply OCS Patches?
   SPAM
9. How to do client copy?
    Using TCODE SCCL, SCC7, SCC8
10. How to do transports from OS level?
Logon with <SID>adm go to command prompt.
Go to path /usr/sap/trans/bin/
Assume Your DEV to QAS
First add request to buffer.
tp addtobuffer DEVKXXXXX QAS pf=/usr/sap/trans/bin/tp_domain_<SID>.PFL
Now import Phase
tp import DEVKXXXXX QAS client=XXX pf=/usr/sap/trans/bin/tp_domain_<SID>.pfl
Check for the return codes.
11. Where the transport data files will be placed?
You will need /usr/sap/trans/data and /usr/sap/trans/cofiles
12. How to make security authorization reports?
SUIM
Reports->Authorizations
13. In which table failed user login attempts will be there?
14. How to see the table entry values?
      SE19
15. How you will give new authorizations?
      PFCG
16. Have you participated in Kernel upgrading and OCS Patches?
 Yes
17. Have you done any up gradations?
      NO
18. How to configure TMS?
      STMS
19. What is transport domain?
All SAP Systems that are managed jointly by the Transport Management System.
All systems in a transport domain have the same settings as the Change and Transport System.
20. What is Consolidation route and delivery routes? How you will identify them?
consolidation route:
consolidation route is defined between the development system (consolidated system) and the quality system (integration system)
Delivery route:
Delivery route is the transport route that connects the integration system and the Delivery system (Production system)
Domain controller:
it is the central admin of the system
transport domain:
it is the place the transport layer and routes can be configured to access this transaction use stms
21. Transport error codes and their description?
Return code (4) indicates imported ended with warning.
Return code (8) indicates not imported ended with error
Return code (12) indicates import is cancelled.
       Return code (16) indicates import is cancelled.
22. The transaction should not be displayed in User Easy access menu. How to do userauditing in sap? What will u audit?
23. How to find users used transaction codes which are not authorized for?
Use Tcode SUIM
Select Users -> by transaction authorizations -> type the Transaction code
24. How to schedule online and offline backup which takes every day, every week. How to monitor it?
DB13
1. To access the DBA Planning Calendar in the SAP system, go to the DBA Cockpit and choose JobsDBA Planning Calendar.
 2. Double-click on the scheduled backup task whose history you want to display. A backup that has failed is indicated in red.
The upper part shows general information about the task. The lower part shows whether the task was successful and any messages that were generated
25. How will u send mail after completion of backup?
     1.Choose CCMS Configuration Alert Monitor, or call transaction RZ21.
      2. In the Methods group box, select Method Definitions and choose Display Overview.
      3.Select the method CCMS_OnAlert_Email and choose Edit Data.
      4.Choose change mode with the Display « Change ( <!--[if !vml]--> <!--[endif]-->) pushbutton, and choose the Parameters tab page.
26. How will u integrate existing ecc6 environment into solution manager
27. What are the regular activities u do in solution manager and how to update SAP?
1.Solution Manager Setup
2.ASAP roadmap
3.EarlyWatch Alert
4.Central System monitoring through CCMS
5.System Availability Monitoring through CCMSPING
6.Maintenance Optimizer
7.Service Desk
29. How to lock or unlock a transaction code using sm01?
      By editing table TSTC.
Create a parameter transaction for SM01 in SE93. Go to SE97 and ensure that SM01 "trusts" your <parameter transaction>.Then call transaction <parameter transaction> and unlock SM01.
30. How to setup RFC connection in ecc6 tells me steps involved?
Use Tcode: SM59
Create
Type a RFC destination Name, Descriptions, target Host, System Number
In Connection type you must select ABAP connection, means Connection Type must be 3
In Logon tab assign Client, RFC User which you have already created (t. code: SU01), type a password and save
31. Tell me steps for support pack installation in ecc6?
ABAP Stack
1) Upgrade "Kernel"
2) Download required sp's from service marketplace.
3) Extract downloaded files to your "saptranshost"
4) Read newest sap-note about problems with SPAM/SAINT transaction
5) Logon your system (client 000) with user that has "SAP-ALL" authorization.
6) Run transaction SPAM, define queue, and start import.
JAVA Stack:
1) Download required sp's from marketplace.
2) Unpack the files or move them to the "saptranshost" depending of your release.
3) Run SAPINST or JSPM depending on your release.
Double Stack systems:
1) Patch ABAP Stack as described.
2) Patch JAVA Stack as described.
34. What is the database backup strategy in your company?
35. What is upgrade process? And how u will do that?
An upgrade updates an existing SAP system to a new release. The upgrade contains program code and data changes or introduces new areas of functionality.
36. How u will give new authorizations?
Authorization in SAP means giving users access right to a T-Code. PFCG allows Basis to change user’s authorization inside a T-Code. By adjusting the object you also can control if user can display, edit, or change certain field in the T-Code.
A Role Is created with the profile generator and allows the automatic generation of an authorization profile. The role contains the authorization data and the logon menu for the user.
PFCG
· Create new role
· Define menu and define Tcode and authorization
· Click on Authorization tab and click “display authorization data”
· Give role to user
· Save it
37. How to adjust user master records? If user master record doesn’t adjust what will you do?
The existence of a user master record is a prerequisite for logging on to the SAP System. The user master record determines which role is assigned to the user, i.e. which activities are in the user menu and which authorizations the user has.User master records are client-specific. You therefore need to maintain individual user master records for each client in your SAP System.
38. How to check Kernel, tp versions?
SM51 --> Goto Release notes.
Menu -- >system -- >status. Then click on component information button.
39. Briefly explain a recent problem you faced, which u felt proud by solving that? And how will u solved?
41. What are common background jobs that will run in your system?
SAP_CCMS_MONI_BATCH_DP
SAP_COLLECTOR_FOR_JOBSTATISTIC
SAP_REORG_ABAPDUMPS
SAP_REORG_BATCHINPUT
SAP_REORG_JOBS
SAP_REORG_JOBSTATISTIC
SAP_REORG_SPOOL
SAP_REORG_UPDATERECORDS
SAP_SOAP_RUNTIME_MANAGEMENT
42. If a background job runs more than the time it should be completed normally then what actions will u take?
    Check
Background processes are free or not
· SM21 any specific message
· SM50 monitor how much memory the background workprocess is taking
· ST06 - processor free or not or 100% used?
Looks very much like you need more memory to complete the processing -
Increase abap/heaplimit=40000000" to 2 GB and restart the ABAP server
43. How to schedule background jobs at OS level?
Actually we cannot completely schedule background at OSLevel but we can trigger a background job which has alreadyscheduled by using sapevt tool syntax as follows.
sapevt <event name> nr=<instance name> name=<host name>
46. Transport request types and its syntax?
Fourtypes of transport requests
customizing request- c type
Workbench request- k type
transport of copies – t type
relocation 
47. Where will u find transport error logs?
       SE10 -- > transport tab at right -- > select transport from list -- > click on log symbol from tool bar
49. How to transport objects from Production to Development?
It is not recommended to do direct changes into production system. Anyway for Repository changes you can export the tpz file from production environment and then import it into development. For Integration Directory changes it will be nice if you do it manually because then you don't need to change the Transport target in SLD.
50. How to define instances and operation modes?
Instances are created during R/3 System installation. Assigning instance definitions to an operation mode has no effect on the instances, directories and profiles that you create using the installation programs.
Procedure:-
Transaction RZ04
Choose Instances/OP modes
51. What are Homogenous-Heterogeneous system copy and how you will do that?
Homogeneous systemcopy means a system copy with all the database tables from one system to another system of same kind, like same os/db on both the systems.Homogenous copy is done by export/import technique.
A Heterogeneous System copy is a copy from one system to another system of a different kind, like different os/db in either of those.Heterogeneous copy is done by system migration. It is same as export/import except that it will ask for target OS and DB type and needs a key to be entered.OSS notes are applied using T-code SNOTE.
54. At OS level in which directory oracle alerts are stored?
There will be file as alert<SID>.log under
UNIX: /oracle/<SID>/saptrace/background
Windows : <Drive>:\oracle\<SID>\saptrace\background\
55. If a lock entry is holding more than 24 hours then what will youdo?If another user wants to share that lock but the user using that Locks haven’t released lock he went for holiday what will u do? This User wants lock ASAP then what will u do?
Delete lock using Tcode SM12 -- > list -- > delete by selecting the lock after asking to that user.
59. What will you do if u got Update failure?
First of all check whether the Update is ACTIVE or NOT?
Tcode SM14 & SM13.
Check the Status of Update work Process.
Check the Table spaces (Free Space)
Check OS level Space.
Check the Object Locks (SM12)
60. What will you observe in System log (SM21)?
The SAP System logs all system errors, warnings, user locks due to failed logon attempts from known users, and process messages in the system log. There are to two different types of logs created by the system log:
  Local Logs
  Central Logs
63. How you will get help from OSS notes?
OSS is an online SAP service portal which that has updates about SAP patches and latest SAP note information.
64. What is the need of having Development system?
      For development of actual system and also for made any changes and testing.
65. Difference between Application server and Central Instance?
The main difference between CI and Appl. server is that the CI has the ENQUE process that handles the DB locks.
66. How you will check whether database is active or not from OS level?
Use command in os level
      R3Trans –d if the return code is 000, means the connection is good.
ps -ef |grepora_
ps -ef |greppmon
If the entire Oracle background process are running we can say that oracle is up and running.
OR
Connect to the sql like sqlplus "/as sysdba"
sql> select status from v$instance; if the output is "open" we can say that Oracle up and running fine. 
67. How to lock a client? How to delete a client?
To lock or unlock a client only in an in R/3 System, run the following functions via Tcode SE37:
1. SCCR_LOCK_CLIENT
2. SCCR_UNLOCK_CLIENT
       Delete a client
I would prefer SCC5
68. How to login in to SAP from command level?
             1. Open the command line prompt. Start > Run
2. Execute the following command as per system address and instance number
sapgui 192.168.1.10 10

Options
192.168.1.10 = System IP address
10 = Instance number
69. How to define Logon groups? And what is Logon load balancing?
      SMLG
      Create group by providing group name and instance.
       Load distribution allows you to dynamically distribute the SAP users to application server instances. You can increase the efficiency of individual work groups by setting up multiple logon workgroups that consist of one or more application instances
70. How to find sap transaction codes?
       SE93
71. How to find list all the T codes for a role in sap?
      Goto SUIM- Transactions - > Executable by a SAP role
      The best way is to goto t-code SE16 -> AGR_1251 -> give the role name  in field AGR_Name and   S_Tcode in Object field and execute it,you will get all the t-codes under that role.
Go to T-Code PFCG
Enter role name
Hit printer icon
You will get the list of T-Codes
74. How can I delete a data file that was created by mistake?
      SQLPLUS> delete datafile xyd.dbf;
      BRtools>
75. Which pools are resizable?
       Shared pool, java pool , stream pool , large pool
76. User could not logon to the system? Why?
1.       service is closed
2.       authorization
3.       profile missing
77. How to change default client like 111?
      you need to change an instance profile parameter on the R/3 system. The parameter is: login/system_client
The default value is 000.
The expert said that you need to make the change, save the instance profile and activate it. Then stop and restart the R/3 instance for the change to take effect.
82. If job is slow?
83. List of r/3 user types?
1.       Dialog user
2.       System user
3.       Communication user
4.       Reference user
5.       Service user
84. How to unlock the object?
      SE03 -- >unlock object (request)
85. What is Difference between SPAD and SPAU?
     SPAD spool administration (printing process and device setting)
     SPAU repository objects
86. What is SSO? How to configure SSO?
      The SAP GUI’s Single Sign-On (SSO) functions enable you to configure transparent user authentication for access to AS ABAP systems. With SSO, SAP GUI users can only select the AS ABAP system to log on to from the SAP Logon Pad, without needing to interactively provide a user name and a password.
You can use the SSO functions of the SAP GUI to facilitate user access to multiple AS ABAP systems in an SSO environment. In addition, the use of SSO can reduce your administration costs, while strengthening the overall security of your systems.
87. How to check cpu usage in EP?
      ST06
88. If java is down how you will do trouble shooting?
89. How to take back up on EP?
90. How to apply job on OS Level?
91. Difference between system refresh and client copy?

      Sometimes these are the same, For example, if you are performing a copy to an existing client for the express purpose of updating the data, then it is called Client Refresh. If you are copying to a newly created client then it is more appropriate to say “client copy.” Another way of thinking about this is that a client copy from production to a QA server or from production to DEV server is really a client refresh.
92. Where you have to see oracle parameter?
      DB26
94. If table space auto extend size how to see the size?
95. Difference between Remote client copy and Export and import?
    Remote client copy is done in the same land scape i.e. it is in LAN or wan, client import and export are two different landscape. Remote client copy is performed when small amount of data to be transported that suppose 20 GB, whereas client export/import is performed when huge amount of data to be transported that suppose 300 GB. Local Client Copy is done within same system(QA to QA) Remote Client copy is done with different system(QA to PRD)
96. What are steps for DB Refresh?      1. Pre Copy steps
      2. Restoring/Copying the database files
      3. Post Copy Steps.
97. What are the Pre-requisite for system copy?
• An SAP ECC 6.0 system, QAS, (similar to PRD in memory and disk configuration) should be installed with a valid SAP license key. (NOTE: Be certain that both the DNS name and NetBIOS name of the server are in all CAPITALS, 8 characters or less, and contain no special characters.)
• The source system should be backed up (Full Backup) and the media should be accessible from the target system.
• Perform a backup of the original QAS system to restore to in case of difficulties.
• Anything from the target that will need to be restored (user definitions, profiles, jobs, printers, RFC destinations, etc.) after the copy must be saved out. In addition, take a snapshot of the client change settings (SCC4), system change options (SE03), workbench organizer/transport system configuration (SE06), and any other setting that will need to be restored in the target system.
• Identify which transports exist in QAS but not in PRD and remind the owners that all transports which have not moved to PRD before the copy will no longer exist in QAS. Preferably, everything should be pushed through pre-copy (including LCP and CRT imports, Hot Packs, and other SAP transports associated with notes).
• Communicate to everyone that any spool data, datasets, master data, etc. which exist only in QAS will need to be moved elsewhere, printed out, or otherwise repositioned before the copy.
• Security profiles and user lists need to be repositioned so they can be recreated post-copy.
• Any external programs affected by the move (BSI, etc.) must be dealt with post-copy.
101. What are the table space names that you see in DB02?
         PSAPSR3
PSAPSR3700
PSAPSR3DB
PSAPSR3USR
PSAPTEMP
PSAPUNDO
SYSAUX
SYSTEM
102. What are the Parameters need to be set when connecting EP to r/3 system what are they?Connector:
Application Host : <host. Domain> :< port>
Remote Host type: 3
SAP Client: Client
SAP System ID: System ID
SAP SYSTEM NUMBER: 00
SYSTEM TYPE: SAP_R3