Friday, June 10, 2011

SAP BASIS Certification Questions - part - 1

Hi All,
Here I will list some SAP BASIS Questions and answers which will help for SAP BASIS Certification. Questions will be like MCQ and the right answer are in Bold font and Green color.

1) Which of the following components indicate that R/3 in DB?
    a) Multiple DB's
    b) Database Servers
    c) 3 Separate hardware servers
    d) DB service, app service and presentation service.

2) Which of the following is not contained in R/3 DB?
    a) The R/3 Repository
    b) R/3 Kernel 
    c) Customer Data
    d) Transaction Data
    e) Customizing Data
    f) ABAP Dictionary

3) Which of the following is correct in regards to R/3 clients?
    a) The R/3 client has it's own customer data and programs which are not accessible to other clients.
    b) An R/3 client has all R/3 repository objects and client independent customizing with all other clients in   the R/3 System.
    c) An R/3 client shares customizing and application data with other clients in the same R/3 system.
    d) An R/3 clients enables you to separate application data from customizing data.

4) Which of the following statements is correct in regard to SAP Clients ?
    a) All customizing settings are independent.
    b) A client has unique set of application data.
    c) A client has it's own repository objects.
    d) All customizing settings are client dependent.

5) Which of the following strategies enables R/3 customers to avoid making modification to SAP Standard objects.
    a) Using enhancement techs such as program exits and menu exits.
    b) Modifying SAP delivered objects.
    c) Changing SAP Standard functionality using IMG.
    d) Performing customizing to provide the required functionality.

6) Which of the following statements are correct in regard to IMG?
    a) The IMG consists of series of customizing activities for defining a Companies Business Process.
    b) The IMG is a online resource providing the necessary info and steps to help you implementing the R/3 application modules.
    c) IMG is client independent.
    d) All of the above. 

7) Which of the following strategies enables an Enterprise to meet its business needs by changing or enhancing R/3 functionality.
    a) Maintaining application data using the various R/3 Business transactions in the SAP std
    b) Using the ABAP workbench to create and read R/3 repository objects 
    c) Using customizing to modify R/3 programs after obtaining an access key from OSS.
    d) Using Customer Exits to Enhance the functionality of Existing SAP Objects. 

8)  Which of the following statements are correct in regards to modifications.
    a) A modification is a change to an SAP std object.
    b) A modification must be registered using the SAP OSS
    c) SAP recommends modification only if customer's business meets cannot  by customizing enhancement.
    d) All of the above

9) Which of the following statements are correct in regards to the customizing
    a) Customizing enables R/3 applcn process to be set to reflect a companies business needs.
    b) Customizing can be performed only from IMG.
    c) Customizing is necessary because R/3 delivered w/o Business process.
    d) None of the above.

10) Which of the following is correct in regard to R/3 repository
    a) Customers can develop new repository objects using tools in the ABAP workbench.
    b) Customer developed repository objects reside in the R/3 repository objects.
    c) Customers can create and assign new repository objects to a development object
    d) All of the above.

Some Interesting SAP Executables

CAR: The Compression Tool of SAP for nearly all delivered files and executables. CAR is the name for old releases and the SAPCAR is the name as of 4.6D. It works a bit similar to WinZip.

DIPGNTAB: Activation and adjustment of the nametabs with the ABAP Dictionary


DW - Disp+Work: "Dispatcher and Work Process" - The Complete kernel - Here the complete ABAP is processed..


Niping: Small Client and Server in order to test the SAPRouter internally with the NI-Protocol(SAP Network Interface).


LIB-DBSL: The Database Shared Library for the kernel programs 

LIBRFC: The RFC(Remote Function Call) Library, that is available for any platform to develop and run a RFC Server or RFC Client.


NTSCMGR.exe: The tool for installing the SAPRouter as service. It is part of every Windows SAP Kernel. As it has no known errors, it is not necessary, to patch it. Just use ntscmgr.exe from your existing windows kernel.


r3check: This is a tool, that can Cluster-tables for errors.


r3ldctl: The tool for exporting all table structures to the file system during a OS/DB Migration.


r3load: The table import & export tool of SAP during installation, Upgrade and migration.


r3setup: The installation and migration tool for all SAP systems upto Release 6.10


r3szchk: The tool for determining the sizes of the different tables in the target database during the import in an OS/DB Migration.


r3trans: This is the tool for that does the real work for TP. TP controls the import and export of change request r3trans does them using scripts. that were generated from TP.


r3up: The tool that control the upgrades of an SAP System.


rfcexec: The tool to start other programs from within on the OS level via the gateway on any other server.


rfcoscol: Similar to SAPOSCOL. It is needed when no SAP instance is running on the DB server.


SAPCAR: The compression tool of SAP for nearly all delivered files and executables. It works a bit similar to WInZip.


sapevt: This programs is able to trigger events within SAP System. The TP Tool uses this feature. It can be used as trigger for self-written interfaces as well.


sapftp: FTP Client that can be used from within the SAP System to communicate with other FTP servers.


saphttp: HTTP Client, that can be used from within SAP system to communicate with other HTTP Servers.


sapinst:  The installation tool for all SAP System as of Release 6.20


saplicense: The tool for the installation of a New SAP License. This is needed when the license expires. 


saposcol: The SAP interface to the Operating System for Performance Data. The Operating System Collect collects CPU usage, Disk Performance, Paging etc.


sappad: Very nice & small Editor a lot better than notepad. 


sapfar: This tool can be used for checking the profiles after changes and before restarting the SAP system.


saprouter: The program for the Router connection from customers to SAP and vice versa.


sapxpg: The tool for starting OS commands from within SAP Systems.



Thursday, June 9, 2011

SAP BASIS Important Tables

There are some important tables to know for different maintenance work. Some tables for BASIS & ABAP listed at below(with meanings)

BASIS Related:
User administration
TABLE           Description

USR02           User Mater
USR02           Logon Data
USR03           User Address Data
USR04           User master Authorization
USR11           User Master Text for Profiles
UST12           User Master Authorization
USR12           User Master Authorization Values
USR13           Short Text for Authorization
USR40           Prohibited Passwords
TOBJ             Objects
TOBC            Authorization Object Classes
DEVACCESS Table for Developers


Batch Input Queue
APQD            Data Definition Queue
APQI             Queue info definition


JOB Processing

TBTCO          Job Status overview table
TBTCP           Batch Job Step Overview

SPOO
TSP02            Spool: Print Request

Runtime Errorse
SNAP             Runtime Errors


Message Control
TNAPR           Processing Programs for output
NAST             Message Status
NACH            Printer Determinattion


Change Document
CDHDR          Change Document Header
CDPOS          Change Document positioned
JCDS              Change Document for system/Users status
SERPTEE       Reporting Tree Structure



Workbench and Data Dictionary
DD02L           Tables in SAP
DD02T           Tables description
DD03L           Field name in SAP
DD03T           Field Description in SAP
TADIR            Dictionary in R/3 Repository Objects
TRDIR            System table TRDIR
TFDIR            Function Modules
TLIBG            Person Responsible for function Modules
TLIBT             Function Groups short texts
TFTIT             Function Modules short texts
TSTC             Transaction codes in SAP
TSTCT           Transaction codes texts
T1000             Message texts
VARID           VARIENT DATA
D020T            Screen Text
TDEVC          Development class
TDEVCT        Text for Development Class

SAP BASIS Housekeeping jobs

In every SAP live system , basis guy need to run some programs background periodically that automatically deletes old data. For examples deleting old spool requests list, batch input sessions, collecting system performance statistics. Definitely these will effect on  system performance. At below I am listing some important programs that are important to run periodically as background jobs. Use transaction code SM36 to schedule these jobs.




Job Name Related Program Varient Interval Description




SAP_REORG_JOBS RSBTCDEL YES Daily Deletes old background jobs.



SAP_REORG_SPOOL RSPO0041 YES Daily Deletes old spool requests.



SAP_REORG_BATCHINPUT RSBDCREO YES Daily Deletes old batch input sessions.


SAP_REORG_ABAPDUMPS RSSNAPDL YES Daily Deletes old dumps produced by ABAP abnormal terminations
SAP_REORG_JOBSTATISTIC RSBPSTDE YES Monthly Deletes job statistics for jobs not run since the specified date 
SAP_REORG_UPDATERECORDS RSM13002 NO Daily Deletes old completed update records


SAP_COLLECTOR_FOR_JOBSTATISTIC RSBPCOLL NO Daily Generates runtime statistics for background jobs

SAP_COLLECTOR_FOR_PERFMONITOR RSCOLL00 NO Hourly Collects system performance statistics