SAP NETWEAVER OVERVIEW A fully integrated suite of technology products that can run either the mySAP Business Suite applications or a bespoke development using Java. We simplify the marketing descriptions and translate them into the everyday SAP technical environment.
SAP NetWeaver Application Server SAP say "Supports platform-independent Web services, business applications, and standards-based development, enabling you to leverage existing technology assets for Web-services-oriented solutions" Find out more at http://service.sap.com/webas
We say "Previously called the SAP Web Application Server, the ABAP stack is SAP BASIS with the capability of serving html and jsp pages and sending and receiving emails, the J2EE stack is a radically different technology when run as a standalone component but well integrated when run as a double stack ABAP and J2EE server"
SAP NetWeaver Business Intelligence SAP say "Enables you to integrate data from across the enterprise and transform it into practical, timely business information to drive sound decision-making" Find out more at http://service.sap.com/bi
We say "The latest version of SAP Business Warehouse, providing data warehousing tools for SAP and non-SAP based applications" more are
SAP NetWeaver Portal SAP say "Unifies critical information and applications to give users role-based views that span the enterprise, enabling you to take full advantage of your information resources" Find out more at http://service.sap.com/nw-ep
We say "Previously called SAP Enterprise Portal and sits in front of SAP applications, replacing SAPGUI for normal users and gives a true, role based view of the business across SAP and non-SAP applications"
SAP NetWeaver Exchange Infrastructure SAP say "Delivers open integration technologies that support process-centric collaboration across the extended value chain" Find out more at http://service.sap.com/xi
We say "Also known as SAP XI, it sits behind SAP and non SAP applications and acts as a central interface hub, reducing the need for point to point interfaces"
SAP NetWeaver Master Data Management SAP says "Ensures cross-system data consistency and helps integrate business processes across the extended value chain" Find out more at http://service.sap.com/mdm
We say "Ensures you have consistent information in all systems – one customer record, one material record etc by providing a central repository for Masterdata from where it is distributed out to other applications"
SAP NetWeaver Mobile SAP say "Provides a "future-proof" mobile run-time environment based on open and flexible technology standards and a powerful development environment for building integrated mobile solutions with native or browser-based user interfaces" Find out more at http://service.sap.com/mobile
We say "Allows you to see applications on PDA’s , phones and other mobile devices"
Netweaver Releases Support Packages Stacks SAP naming has always been complicated and SAP Netweaver is no exception. There are 2 main releases of SAP Netweaver; SAP Netweaver 04 This was the first major release of SAP Netweaver, providing a consistent set of the technical applications, receiving support packages in Stacks, tested across all components SAP Netweaver 7 (Previously called Netweaver 04S) This was originally planned as a minor release of Netweaver components to deliver all the functionality necessary to support the mySAP Business Suite for that runs on Netweaver 04. Subsequently this version of Netweaver has been confirmed as a full release and is now called SAP Netweaver 7 Traditional Support Packages In the old component days of SAP, applying support packages was relatively easy. You picked your product, you downloaded the latest patches and applied them. Now with the increasing interconnectedness of SAP Applications, this is no longer feasible in practise. Support Package Stacks To ensure consistent patching across a landscape, Support Packages are now released in Stacks. These ensure that the component applications you use (eg mySAP ERP 2004, Enterprise Portal and MDM) are all brought up to a compatible level of support package. SAP supply tools for determine the packages necessary across the components in the application landscape, more information can be found at http://service.sap.com/sp-stacks. These stacks are particularly relevant to landscapes based upon SAP Netweaver 04 and 04s.
Further Information http://service.sap.com/netweaver - The starting point on the SAP Service Marketplace for SAP Netweaver http://service.sap.com/nw04operation - Detailed technical configuration documents on running the Netweaver Components http://service.sap.com/nw04 - Further information on SAP Netweaver 04
SAP Help Website Netweaver 04 - The English SAP help on Netweaver 04
SAP Help Website Netweaver 04s - The English SAP help on Netweaver 04s
The place for SAP consultants to find SAP Jobs openings.
SAP Jobs recruiter, post your job vacancies and offer here or search for your potential SAP candidate.
SAP Jobs seeker, post your resumes and let the jobs offer come to you via your mail box or search for your desired SAP vacancy .
For those who want to evaluate the SAP Jobs market, this is the best SAP Jobs forums because new jobs are posted daily from different countries around the world.
For SAP Fresher, the most important things to do is to study the specific SAP Jobs requirment and tried to get the required SAP training. Occasionally, you will also get to see some SAP resumes from Job seeker which will provide you with the guideline on how your resume should be written.
SAP Jobs Recruiter, as this is a global database, it would help greatly if you could state :-
the countries, place of work, remuneration currency, SAP experience, skills required, whether you are looking for locals or international SAP candidate. SAP Career FAQ What are the basic skills required (area of expertise)to get into SAP implementation? Activity in any module in SAP is just the representation of what is taking place physically in that Org. One must have knowledge of these activities and how these have been represented in SAP. Now if these are represented than what are the basic settings that we have made in CUSTOMISATION. And also you must have a good problem solving skill.
SAP was founded in 1972 as Systemanalyse und Programmentwicklung by five former IBM engineers in Mannheim, Germany (Dietmar Hopp, Hasso Plattner, Klaus Tschira, Claus Wellenreuther and Hans-Werner Hector). The acronym was later changed to stand for Systeme, Anwendungen und Produkte in der Datenverarbeitung ("Systems, Applications And Products in Data Processing"), in 1976 SAP GmbH was founded; the next year its headquarters was moved to Walldorf and since the 2005 annual general meeting the company's official name is just SAP AG. Henning Kagermann became the sole CEO of SAP in 2003. Reputation SAP is the largest software company in Europe and the third largest in the world[citation needed]. It ranks after Microsoft and IBM in terms of market capitalization. SAP is also the largest business application and Enterprise Resource Planning (ERP) solution and software provider in terms of revenue.
Oracle Corporation, SAP's major competitor in the USA, filed on 22nd March 2007 a case against SAP for malpractice and unfair competition in the Californian courts. The complaint alleged that a Texas subsidiary, SAP TN (formerly TomorrowNow before purchase by SAP), which provides discount support for legacy Oracle product lines, used the accounts of former Oracle customers to systematically download patches and support documents from Oracle's website and appropriating them for SAP's use. Some ERP market analysts suggest the suit could be part of a strategy by Oracle to decrease SAP's presence in the software maintenance market, in which Oracle and SAP compete (the latter through its subsidiary TomorrowNow).
Products SAP's products focus on Enterprise resource planning (ERP), which it helped to pioneer. The company's main product is mySAP ERP. The name of its predecessor, SAP R/3 gives a clue to its functionality: the "R" stands for realtime data processing and the number 3 relates to a 3-tier architecture: database, application server and client (SAPgui). R/2, which ran on a Mainframe architecture, was the first SAP version.
Other major product offerings include Advanced Planner and Optimizer (APO), Business Information Warehouse (BW), Customer Relationship Management (CRM), Supply Chain Management (SCM), Supplier Relationship Management (SRM), Human Resource Management Systems (HRMS), Product Lifecycle Management (PLM), Exchange Infrastructure (XI), Enterprise Portal (EP) and SAP Knowledge Warehouse (KW).
The APO name has been retired and rolled into SCM. The BW name (Business Warehouse) has now been rolled into the SAP NetWeaver BI (Business Intelligence) suite and functions as the reporting module.
The company also offers a new technology platform, named SAP NetWeaver. While its original products are typically used by Fortune 500 companies, SAP is now also actively targeting small and medium sized enterprises (SME) with its SAP Business One and SAP All-in-One.
According to SAP AG[citation needed], there are over 100,800 SAP installations serving more than 38,000 companies. SAP products are used by over 12 million people in more than 120 countries[citation needed].
SAP holds a partnership with Hewlett-Packard. This partnership will expand around new services linked to NetWeaver and Enterprise SOA (service-oriented architecture). The software infrastructure for business applications developed by SAP is to be upgraded by Hewlett-Packard. One of the services to be upgraded is the Discovery System which was launched by SAP earlier this year. Among other services there are assessment, government and architecture for R3.
The steps below will guide to Generate a Solution Manager Key with T-code SMSY which is mandatory for SAP ECC 5.0 version onwards. [Edit section] Steps After executing T-code SMSY in Solution Manager system, you need to do the following steps 1. Create a system by right clicking on System entry and select Create new system. 1. Enter the System Name i.e SID (3 chars) 2. Product = SAP ECC (select from the list) 3. Product Version= ECC 5.0 (select from the list) 4. Save the entries. 2. Select Menu Item System--->Other Configuration" and enter the SID which you have created earlier. 1. Enter the Server Name(hostname) 3. Finally click on Generate "Installation/Upgrade Key Button " The system generates a Key ,copy that Key and paste it in the SAPINST screen when it prompts for Sol man Key.
question asked in HCL 1.) in transaction sm50 what is cancle with core and without core 2.) system refresh steps 3.) daily task 4.) size of ur database 4.) yours achievement in ur company 5.) error no 1026 6.) if all ur background jobs fails what will u do 7.) t_code for local client copy 8.) draw the structure of R/3 archictecture 9.) what is the transaction code for checking authorization objects 10.) difference b\w check and check\maintain 11.) what will u observe in db02 12.) tell some thing on sox rules 13.) short dump errors with discription 14.) tms error 15.) steps to alter table space
1.) in transaction sm50 what is cancle with core and without core Cancel with Core : Cancels the work process. A core file is created, which you can view in transaction ST11. Cancel without Core : Cancels a work process, and a core file is not written.
3.) daily task SM37 – Simple job selection, ST22 : ABAP dump analysis, SM21 – System LogSM13 - we will check update status SM12 – Check any Obsolete lock entriesSP01 – Check any spool errors, Db02 – Check any critical table spacesDB12 – We will check database logs ST02 – check Tuning summaryST04 – Check the performance of the Database.
4.) size of ur database 60GB or 80GB.
5) t_code for local client copySCCL
6) what is the transaction code for checking authorization objects SU24
10.) difference b\w check and check\maintain Check : An authority check is carried out against this object.The PG does not create an authorization for this object, so field values are not displayed. No default values can be maintained for this authorization. Check/Maintain : No check indicator is set.An authority check is always carried out against this object.The PG does not create an authorization for this object, so field values are not displayed. No default values can be maintained for this authorization.
15.) steps to alter table space alter tablespace add datafile path size size of the Ans : System Refresh is a simplified term to Client Copy. Client Copy means copying the production client on to the quality to test the real data. As recommend by SAP this need to carried out every 3 months. The system refersh is nothing but the deletion of the client and replacing the data from other client. For example : you have clients 111, 222 and 333. Suppose when you want to refresh the client 111 you remove the client 111 and replace it with 222 0r 333 as per your reqiurement. In Real TIme refresh of clients will be happen at the time of development stage. size of ur database Ans : in real time its 100gb to 10tb according to client requirement
11.) what will u observe in db02 SAP* tcode DB02 is use to check database size, tablespaces size, current statistic, checking freespace.
1- tell me the detail process of system copy . and what is system copy?
2- tell me the detail process of remote client copy?
3-how much time remote client copy will take?
4- what is datbase reorganization?
5- in sm12 if any update fails what will i do?
6- what is abap dumps explain? give me some name of abap dumps which u have recive?
1.system copy is two types one is homi-genious and hetrogenios in homogenios...making one more system as like runing system. purpose is for applying patch or upgradation and addons can done on system copyed one. system copy can done in two ways one is exporting the DB and importing db in new system other one using the control file.
2.remore client copy is done by using scc9 and before copying remore clien copy we need add remote systme with RFC. then we can run the remore client copy.remore client copy time is depending upon the ur profile selection if you selected sap_ all it will take more time like more then 15 hours or if you selected the sap_ user profiel then it will the four to five hours.time will varies depending up on ur selected profiles like sap_all ,sap_user ,sap_cust...etc
3.generally more then 10 houres
4.if your using orcle 9i you need to go for datbase reorganization..becsuse oracle tables are not locally managed data dictinary file So it will take more disk space for data .if we use datbase reorganization will get extry free speace.
5.we can moniter update work process from the sm13 here depending on error message we can say the soluion.. any way posssibities are archive struck and no db space and need to fix the patch....due to dead locks...
6. ABAP dump is noting but error dumps while excuting the transaction.these ABAP dump can see from the SM21 /SM22/SM37
Now a days solution manager is mandatory. 1. it is used for generating keys and downloading support packages 2. it is used to document user requirments and preparing senarios what needs to to be adopted using solution manager, where the blue print is the part of solution manager 3. it is used for reporting, solution desk,to manage the change requests and use to monitor entire landcape Central message processing in the SAP Solution Manager: - Display customer data, problem description, priority, attached documents, Service Level Agreements (SLA) - Assign processor - Send messages to the creator and other processors - Forward message to other processors or support units - Create documents and URLs - Attach documents - Status assignment and monitoring - Create a worklist with selection conditions *-- Shankar I have a requirement to install SAP Solution Manager Solution Support Enablement Package (SEP) in our solution manager 4.0. This SEP contains, RBE, TDMS, ...etc., I checked for the software download at market place but couldn't find the software package, can anyone help me to download this SEP for windows/oracle. Look at following: http://service.sap.com/swdc -> Download -> Installations and Upgrades -> Entry by Application Group -> Installations and Upgrades -> SAP Technology Components -> SAP Support Enablement Package - >SAP Support Enabl. Package 1.0 How to configure the service desk on Solution Manger 4.0. I want to cofigure Solution Manger only for service desk I have install Solution Manger 4.0. What is the Step please explain. Check: http://service.sap.com/rkt-solman There are tutors, PDFs and powerpoints to guide you through the configuration process. *-- Markus If you have 3 or 4 client systems, must you install SAP solution manager for each one of these systems and manage them independently -or- 2. Can you install One Solution manager, that will manage all 3 these systems in one solution manager -or- 3. Do you install 3 Solution managers for each of the systems, then another one linked to the 3 individual solution managers, which then in turn manages the 3 systems in one. In any System landscape only one solution manager is installated in one system and it will communicate with the other system using the RFC and collect the report from each and every system through (SDCC
Using transaction SE11, create a table (ZTABLE) with the same fields as the table in the external database, make sure that the type and lengths of the fields are identical. Using transaction SE11, create a view (ZTABLE_VIEW, projection view) using BASIS table ZTABLE Using SVRMGRL> create dblink REMOTE_DB as connect to remote_user identified by password; (database link created)drop table ZTABLE; (table dropped)create synonym ZTABLE for ZTABLE@REMOTE_DB; (synonym created) Using transaction SE16 , type in ZTABLE_VIEW and hit RETURN Enter value in key fields and hit execute. (displays rows from the remote table) Tips and Tricks To see the complete text of an error/warning message on the SAPGUI status bar, right click on the message and drag left. To prevent your spool requests getting deleted from the BASIS cleanup jobs, you need to uncheck the Delete after print checkbox in the print control screen, execute transaction SP01, find your spool#, click on Attributes and change the Delete After date Short cuts using the OK-code box. %sc Search in page %pc Download do local file p+ Page up p- Page down p++ Top of page p-- End of page Use transaction AL11 to browse the application servers directory
Step 1 (UNIX SETUP)Logon to your as sidadmChange directory to /sapmnt/SID/global (or any directory globally available across all application servers)Create the following entries in file SAP_EMAIL_GATEWAY.sh and save the file #!/bin/shGWCONFIG=/sapmnt/SID/global/SAP_EMAIL_GATEWAY.cfgexport GWCONFIG/sapmnt/SID/exe/mlunxsnd $* Execute the command: mlosmadm SAP_EMAIL_GATEWAY.cfg (enter the following information) System name : SIDClient : 200Username : MAILADMPassword : initpassLanguage : ELoadbalancing : YMessage Server : Codepage : Step 2 (SAP SETUP) Logon to SAPSYSTEM (SID) via SAPGUITransaction SU01, create user MAILADM and password initpass, usertype CPIC Transaction SM59, Click Create RFC Destination : SAP 4.5 INTERNET MAIL GATEWAY Connection Type : TDescription : INTERNET EMAIL GATEWAYHit RETURNClick EXPLICIT HOSTEnter /sapmnt/P21/global/ SAP_EMAIL_GATEWAY.shSave your entries Transaction SCOT, click Edit--> CREATE NODES Node : EMAIL Description : SAP CONNECT NODE FOR EMAIL (continue)RFC DESTINATION: (choose SAP 4.5 INTERNET MAIL GATEWAY from the pull down menu)Choose radio button InternetAddress area : *DOMAIN (your intranet domain)CcontinueFormat : DOC, DAT, R3F, TXT, RAW,PPT,XLS (continue)ContinueSet further address types : NMinimum waiting : 5 minutesCheck both Node is in use', Node can resolve path references ContinueChoose Goto--> Schedule Background JobEnter name for the job & save Configuring outbound SAP to Internet mail Gateway (Upto R/3 3.1I) SAP can be configured to send and receive emails from different sources. This section explains how to integrate SAPOffice with an external email system. This is in no way supplementing the online documentation available on the online documentation CD supplied by SAP but simplyfies the process to the bare Internet email must be configured and running prior to this. Email from SAP is forwarded to the users external email client such as Eudora, Outlook etc. You can configure inbound and outbound forwarding. Outbound flow forwards a SAP message (eg:update termination) via UNIX sendmail to the intended recepient. Inbound accepts a message from sendmail and places it in the users SAPOffice inbox. Many SAP shops prefer to configure outbound only. Configuring outbound forwarding SAP configuration Create your RFC destination for outbound email using transaction SM59 RFC Destination : SAP_INTERNET_GATEWAY Connection Type : T Description : SAP internet mail gateway Click on 'Explicit Host' if you want on demand gateway dameon invocation. Program : /sapmnt/SID/exe/mlunxsnd Target Host : Enter hostname that runs your central instance. Click 'Test Connection' and you should see a successfull message. Choose menu Tools-->Administration-->Management-->Process Technology-->Office-->Office Settings Click Internet Gateway Gateway Destination : SAP_INTERNET_GATEWAY Path for configuration file : /sapmnt/SID/exe/sap_mailSID.cfg Return Address : .com Click Internet Settings and fill in the following fields Save the settings Click Back Choose menu Office-->Addresses-->Communication Types Type in INT over the Comm. type and Internet Mail over description. . Check Maintain and Send checkboxes and Save your entries. UNIX configuration . cd /sapmnt/SID/exe .mlosadm sap_mailSID.cfg Client 000 Username : MAILADM Password : MAILADM Language : E System name : SID System number : Hostname : Gateway hostname: Gateway server sapgw Sendmail Command : Update file : Y Testing Logon to SAP Execute transaction SO01 Write a message and send it to If you don't see the mail in your internet mailbox, go back and review steps 1-12 Back to Top FTP from ABAP There are 2 ways of executing FTP from an ABAP (online or batch mode), Initiated from the operating system. A script is available in the utility repository that explains how to do this very easily. Initiated from the ABAP itself An example is given below. Create a logical OS command 'zftp' using transaction SM69. Make sure that you enable 'comand line parameter allowed' checkbox Create a shell script called 'zftp' with the following lines RMTHOST=`echo $2 tr '[A-Z]' '[a-z]'` ftp -v $RMTHOST <<> /out/zftp.$$ 2>&1 lcd /out put $1 bye EOF Use the SXPG_COMMAND_EXECUTE function module to call this script (zftp) with the filename you want to transfer as the parameter. Eg: call function 'SXPG_COMMAND_EXECUTE' exporting commandname = tables exec_protocol = exceptions no_permission = 1 command_not_found = 2 parameters_too_long = 3 ... Back to Top Enable web based online documentaion (R/3 4.0 or above) Install Netscape webserver or use an existing web server (requires administrators privelege) Create a directory called SAPDOCS4 under your web server document root. Mount the CDROM containing online documentation on your PC or your UNIX server. Recursively copy all files under /cdrom/docs/ to the SAPDOC4 directory under the web server root. Create the following entries in your /usr/sap/SID/SYS/profile/DEFAULT.PFL eu/iwb/installed_languages = ENeu/iwb/help_type=2eu/iwb/server_win32=webserver.domain.comeu/iwb/path_win32=saphelp/helpdata Restart your SAP system Back to Top How to access an external database from ABAP via DBLINK (ORACLE) Using transaction SE11, create a table (ZTABLE) with the same fields as the table in the external database, make sure that the type and lengths of the fields are identical. Using transaction SE11, create a view (ZTABLE_VIEW, projection view) using BASIS table ZTABLE Using SVRMGRL> create dblink REMOTE_DB as connect to remote_user identified by password; (database link created)drop table ZTABLE; (table dropped)create synonym ZTABLE for ZTABLE@REMOTE_DB; (synonym created) Using transaction SE16 , type in ZTABLE_VIEW and hit RETURN Enter value in key fields and hit execute. (displays rows from the remote table) Tips and Tricks To see the complete text of an error/warning message on the SAPGUI status bar, right click on the message and drag left. To prevent your spool requests getting deleted from the BASIS cleanup jobs, you need to uncheck the Delete after print checkbox in the print control screen, execute transaction SP01, find your spool#, click on Attributes and change the Delete After date Short cuts using the OK-code box. %sc Search in page %pc Download do local file p+ Page up p- Page down p++ Top of page p-- End of page Use transaction AL11 to browse the application servers directory structure
Using Transaction variants Change SAP standard screens by hiding fields, screens, tabstrips, changing field properties, ... read on Show all users per Application server Transaction AL08
To log a user off via an ABAP CALL 'SYST_LOGOFF'.
Advanced SM04 program The following program displays the Ip address , workstation name , Nt user name etc. Plus you can send instant messages to users just by clicking on the user name. It will show a red band for users who exceeds session limit. ( That you can adjust ). Created this for R/3 4.6C and above. (Submitted by Joy Ramachandran) - Click here to download zuser.txt
Changing the SAP Logo on the top right of the SAPGui Change file sapalogo.bmp in directory C:\Program Files\SAP\FrontEnd\SAPgui\themes\default (SAP 4.6C)
Transaction code - SMW0X - Binary data for WebRFC applicationHit EnterClick ExecuteClick Settings -> Maintain MIME typesClick the Create buttonFill in :- TYPE : image/gif EXTENSION : .GIFClick SaveClick Back to the Binary data for WebRFCClick CreateFill in :- Obj. name : ZXXXX.GIF Description : Company LogoClick Import and specify the filename where your GIF file is located.File type is BIN. Finish press the Transfer button.If successful, your logo will be shown in the Binary data for WebRFC.Transaction codeSM30 - Table/View - SSM_CUSTClick MaintainClick New EntriesName Value to be setSTART_IMAGE ZXXXX.GIFRESIZE_IMAGE NOLogoff and Login again Automated transports
1. Create table ZTRAN in the data dictionary. The program will write the log in this table.Name ZTRAN Transparente Tabelle Kurzbeschreibung Tabelle für Protokollierung Auto-Transportaufträge Letzte Änderung DZVONYAR 22.10.1997 Mastersprache D Status aktiv gesichert Entwicklungsklasse ZZDZ -------------------------------------------------------------------------------- AusliefKlasse A Anwendungstab. (Stamm- und Bewegungsdaten)
Feldname Key Datenelem. Typ Länge PrüfTab Kurzbeschreibung ZAUFTRAG TRKORR CHAR 10 * Korrektur/Transportauftrag/Com ZZIELSYS TARSYSTEM CHAR 10 * Zielsystem der Korrektur ZZIELMAND MANDT CLNT 3 * Mandant ZSEND_NAM SO_SND_NAM CHAR 12 Sender: Name. ZDATUMBEG ZDATUMBEG DATS 8 Datum vom Anfang des Autotrans ZTIMEBEG ZTIMEBEG TIMS 6 Zeitpunkt vom Anfang des Autot ZDATUMEND ZDATUMEND DATS 8 Datum vom Ende des Autotranspo ZTIMEEND ZTIMEEND TIMS 6 Zeitpunkt vom Ende des Autotra ZRETCODE ZRETCODE CHAR 4 Returncode des Transportes 2. Create the next programs in the system. Program ZZDZTRAN Include ZZDZTRA1 3. Create user TRANSPORT 4. Schedule program ZZDZTRAN to run periodically under user-id TRANSPORT as shown: Job name AUTOTRANSPORT_C30 AUTOTRANSPORT_P30 Job class A A Job frequency 10 Min 10 Min Program name ZZDZTRAN ZZDZTRAN Parameter C30 P30 C30: Test system P30: Production system 5. Send a mail in the following format to user TRANSPORT : Title Must be started with the next string: @4A@ (It will be displayed later as the transport icon.) Body Zeitpunkt SS:MM <- Hier evtl. Zeitpunkt eingeben!
Auftrag Ziel ! DIESE ZEILE NICHT ÄNDERN! System Mand ! DIESE ZEILE NICHT ÄNDERN! --> BEGINN ! DIESE ZEILE NICHT ÄNDERN! xxxK90xxxx xxx xxx Kommentar xxxK90xxxx xxx xxx Kommentar ... xxxK90xxxx xxx xxx Kommentar <-- ENDE ! DIESE ZEILE NICHT ÄNDERN! Zeitpunkt SS:MM = Time hour:minute ( The request will be imported later than hour:minute) Auftrag = Change request Ziel = target Mand = Client Kommentar = Comments DIESE ZEILE NICHT ÄNDERN = DO NOT CHANGE THIS LINE Fill out SS:MM and all the x-es as required.
The program will read the mail and import the change requests into the target systems. Peter Dzvonyar To find out transports released from a specified system in the last specified number of days using in the specified transport directory. Command line parameters are:Number of days: $1Source system : $2Transport dir : $3 (if different from /usr/sap/trans)#!/bin/sh if [ $# != 4 ] then echo "Incorrect usage. Usage: $0
Change SAP standard screens by hiding fields, screens, tabstrips, changing field properties
Use Transaction Variants to make fields Mandatory, Hidden or Display. Also applicable to screens and tabstrips. You can hide unwanted screens and fields in any of the standard SAP programs without changing any of the standard programs. Additional features such as making the variant as default on the standard SAP transaction code is only available as of 4.6x. Transaction SHD0 - Create a variant for the required transaction by changing the layout through hiding fields and screens. Transaction SE93 - Create a variant transaction (e.g. for VA02 = ZVA02). Next allocate the transaction variant to this variant transaction. In 4.6c, you can default your transaction variant as the standard variant. (SHD0 - Edit -> Activate/Deactivate as standard variant)
Transaction code - SMW0X - Binary data for WebRFC applicationHit EnterClick ExecuteClick Settings -> Maintain MIME typesClick the Create buttonFill in :- TYPE : image/gif EXTENSION : .GIFClick SaveClick Back to the Binary data for WebRFCClick CreateFill in :- Obj. name : ZXXXX.GIF Description : Company LogoClick Import and specify the filename where your GIF file is located.File type is BIN. Finish press the Transfer button.If successful, your logo will be shown in the Binary data for WebRFC.Transaction codeSM30 - Table/View - SSM_CUSTClick MaintainClick New EntriesName Value to be setSTART_IMAGE ZXXXX.GIFRESIZE_IMAGE NOLogoff and Login again
Users are motivated to work, and can work efficiently, if your SAP systems have good response times. A slow system is not unlike downtime, and it causes frustration. Since no absolute standards exist for what defines good performance, Symmetry defines performance in relation to the expected load on the system. System performance is relevant to which SAP product you run, any custom configuration in your application, your type of hardware, number of user transactions, and size of database. Good system performance is a prerequisite for the effectiveness of your SAP systems and their acceptance by users. Therefore, regular monitoring and quality assurance testing should be performed for your SAP system. Symmetry’s Performance Tuning services for both technical tuning and application tuning employ measures ensuring optimal system performance. In addition to analysis strategies and background information, it utilizes the following guidelines for performance optimization: Change as much as necessary but as little as possible. Never change parameters or take tuning measures without first performing an analysis. Verify whether changes made provide desired results. Take small steps, not making too many changes at once. Understand exceptions to rules through thorough verification of tuning measures. Benefits of Symmetry’s Performance Tuning services include: Increased user productivity and satisfaction Reduced downtime Proper workload distribution Informed decision-making for SAP system extensions
Is there a document that will help me troubleshoot system performance? What are the steps on how to troubleshoot?Troubleshooting is a BIG task of itself, there is no single reference document because there are too many reasons why a system can appear "slow" to the user:- Different DatabasesEvery database has its own mechanism for optimizing access, even more, each database has BOOKS on performance optimization. This can start from parameters to database layout to operating system configuration, used filesystems, mount parameters...- Different Operating SystemThe same goes for operating systems, a standard Windows 2000 (or 2003) isn´t configured for optimal throughput, there is a LOT to tune, e. g. enable "background process priorities", stop non-needed services, network configurations (TCP window sizes) etc. Also the connection between application and database servers can be an issue- SAP ItselfAlmost for each and every long running program there are optimizations, be it on ABAP layer or on selection layer. Out of my experience, most self developed programs (Z*-programs) are the main issue, because developers program "quick-and-dirty" doing "select *" and other things.For e.g.:If CPU is 100% Busy, what action should be taken to keep CPU idle?This can't be answered generally. One need to check what process is using so much CPU - then one can start digging deeper. To add info regarding this issue, you may use:st06->details analysis menu->snapshot analysis->top CPU from there, start to narrow down. Posted by SAP Basis notes at 11:28 AM0 comments Labels: SAP Performance Tuning Tuning Summary In Transaction ST02 My current system is SAP R/3 Enterprise 4.70. I have some questions about tuning summary in transaction ST02 : To the best of my knowledge I am answering your questions. Ok1. Do we have to increase every profile parameter value which is displayed in red alert in transaction ST02 ?Ans: Ofcourse it shoud be, since each buffer holds different values, wherever the red alert is there change the parameter value.2. Why do the swapped objects always increase after a few days of tuning (in RZ10) & system restart?Ans: Since more data had been fed into the server, it needs more space to hold in buffer while retrieving the data. Since buffer is shot in space, swap memory will be used. It is not enough to increase the buffer and that does not mean tuning, tuning in the sense full analysis of the problem and working in that particular area to resolve the issue. For example, creation of index, data archival, availability of statistics, alotting of no. of work process, etc.3. Is there any standard in tuning ST02 to hold up the increasing value of swapped objects?Ans: No. It depends on requirement.4. After analysing ST02, how can we calculate the value of the parameter profile to be increased (in RZ10) ?Ans: yes, use the command:sappfpar check pf=\\usr\sap\trans\tpparam (or)sappfpar check pf=\\usr\sap\trans\tp_domain_ Posted by SAP Basis notes at 11:27 AM0 comments Labels: SAP Performance Tuning SAP System Performance Issues My server becomes slow when more users login.What could be the reason? Is it because of less hardware resource?Server configuration is 104GB HDD, 2GB Ram.OS:Win 2003 server.Database:Oracle.I manage SAP R/3 4.6C systems on Risc 6000 machines, under Oracle 9.2.The overall performance problem for me is to know if SAP response time is acceptable ; if not, do this :- at AIX level : utilities are topas, to catch what's wrong : Disk I/O ? CPU bottleneck ? Too much swap ?- at Oracle level : tkprof but don't know much about this.- at SAP level : you can manage SAP memory, Oracle and OS too.If SAP response time is acceptable, then try this :Try to have a look at OS response time : ST06 : look at CPU, Memory, Swap, Disk and Lan response time.Try to have a look at buffer quality : ST02, if many fields are red, investigate each fields dependant parameters.Try to have a look at DB response time : ST04N, databuffer quality (SGA zone), how much physical reads / logical reads Ratio, wait times, number of user calls, Shared Pool cache hit ratio should be >96%, Sort usage, Redo logging.I use this kind of procedure to manage my systems.SAP Tips by: Christophe RabeauIt depends how much you allocated for SGA (database buffers, shared pool buffer, redo log buffers), how much you allocated for SAP buffers esp. Program buffers and whether the server have any other external processes/programs running.How many Dialog Work Processes you allocated…I think your problem most likely is you don’t have enough of these Dialog processes. Also maybe users running inefficient reports/programs which are holding the Dialog processes, goto SM50 & check all DIA (Dialog) with status “waiting”…if ALL are “running” then you have wait time (problems !) for other users wanting to process transactions .To troubleshoot performance, you need these tcode tools:-ST04 – Database ß in here, check especially for Expensive SQLs (Detail Analysis à SQL Request)ST02 – SAP buffersST06 – OS statsST05 – SQL traceSE30 – Abap runtime analysisSAP Tips by: Derek PhungA few step which you can exercise to sort/identify performance issues.* ST03, ST02, ST04 are the tcode for workload, tuning and DB Performance Monitoring codes.* ST06 FOR Operation System Monitoring.** SM51 OR SM50 is process overview which tells you the workprocess sequence. ( Ideally 10-15 process with OLTP and batch process scheduled at peak and off peak times respectively) say 8-17 hrs and 17-8 hrs for Batch Process)Operation Mode can be configured in RZ04 tcode.** Check for top CPU in ST06 tcode. CPU should not exceed more than 60% for long time for any process.** Based of No. of instances ( Application Servers ) should have adequately sized.** Most resources intensive process have to be scheduled in Batch Process ( in Background in Non Peak Hours )** Look for unnecessary Jobs Active During Prime Time** Look for Parameters Set To Your Business Process.( RZ10, RZ11 ) Check Snote:0124361 Posted by SAP Basis notes at 11:26 AM0 comments Labels: SAP Performance Tuning SAP Load Balancing and Work Processes Troubleshoot The benefit of segregating user groups by line-of-business (using logon groups) is related to the point that groups of users (like SD users or HR users, for example) tend to use the same sets of data. They (generally) work with the same groups of tables and hit the same indexes using the same programs (transactions).So, if you can group all of the users hitting the same tables, onto (or one set of) App server(s), then you can tune the App server buffers to a much greater extent. If the FI users (generally) never hit against the HR tables then the App servers in the FI group don't (generally) have to buffer any HR data. That leaves you free to make memory and buffer adjustments to a more drastic extent, because you don't have to worry (as much) about screwing the HR users (as an example), when you're adjusting the FI server group.So, (in opinion only) you should start with a buffer hit ratio analysis / DB table & index access analysis (by user group) to see where you would get the best benefit from this kind of setup. If you don't have this kind of info, then creating logon groups by line-of-business may have no benefit (or worst case, may make performance degrade for the group with the highest load %). You need some historical information to base your decision on, for how to best split the users up. You may find that 50% of the load is from the SD users and so you may need one group for them (with 3 App servers in it) and one other group for everyone else (with the other 3).The logon group(s) will have to be referenced by SAP GUI, so SAP GUI (or saplogon.ini + maybe the services file, only) will have to change to accomodate any new groups you create in SMLG. Also consider that there's variables for time-of-day (load varies by time-of-day) and op-mode switches (resources vary by op-mode).All Work process are running? What will be our action?Are all the work processes (dia,btc,enq,upd,up2,spo) running or just all the dialog work processes? If all the work processes are running, then you may want to look at SM12 (or is SM13?) and see if updates are disabled. If they are, look at the alert log (if it's an Oracle database) and see if you have any space related errors (e.g. ORA-01653 or ORA-01654). If you do, add a datafile or raw device file to the applicable tablespace and then, re-enable updates in SM12.If only all the dialog work processes are running, there are several possible causes. First, look to see if there's a number in the Semaphore column in SM50 or dpmon. If there is, click once on one of the numbers in the Semaphore column to select it and then, press F1 (help) to get a list of Semaphores. Then, search OSS notes and, hopefully, you'll find a note that will tell you how to fix the problem.If it's not a semaphore (or sometimes if it is), use vmstat on UNIX or task manager on Windows to see if the operating system is running short on memory which would cause it to swap. In vmstat, the free column (which is in 4k pages on most UNIX derivatives) will be consistently 5MB or so and the pi and/or po columns will have a non- zero value. The %idle column in the cpu or proc section will be 0 or a very low single digit while the sys column will be a very high double-digit number because the operating system is having to swap programs out to disk and in from disk before it can execute them.In task manager, look at free memory in the physical memory section under the performance tab. If it's 10MB or 15MB (I think), then the operating system will be swapping.Usually, when all the dialog work processes are running, you won't be able to log in via SAPgui and will need to execute the dpmon utility at the commandline level. The procedure is basically the same on UNIX and Windows.On UNIX:telnet to server and login as sidadm user.cd to /sapmnt/SID/profile directoryexecute "dpmon pf=SID_hostname_SYSNR" (e.g. PRD_hercules_DVEGMS00) select option "m" and then, option "l"On Windows:Click on START, then RUNType "cmd" and press enterchange to drive where profile directory resides (e.g. f:)cd to \sapmnt\SID\profileexecute "dpmon pf=SID_hostname_SYSNR" (e.g. PRD_zeus_DVEGMS00) select option "m" and then, option "l"On both operating systems, you'll see a screen that looks like what you see in SM50. Depending on what you see here, will depend on what you do next, but checking the developer trace files (e.g. dev_disp) in the work directory (e.g. /usr/sap/SID/DVEGMS00/work) is never a bad idea.
ABAP ObjectsABAP Objects is a new concept in R/3 Release 4.0. The term has two meanings. On the one hand, it stands for the entire ABAP runtime environment. On the other hand, it represents the object-oriented extension of the ABAP language.The Runtime EnvironmentThe new name ABAP Objects for the entire ABAP runtime environment is an indication of the way in which SAP has, for some time, been moving towards object orientation, and of its commitment to pursuing this line further. The ABAP Workbench allows you to create R/3 Repository objects such as programs, authorization objects, lock objects, Customizing objects, and so on. Using function modules, you can encapsulate functions in separate programs with a defined interface. The Business Object Repository (BOR) allows you to create SAP Business Objects for internal and external use (DCOM/CORBA). Until now, object-oriented techniques have been used exclusively in system design, and have not been supported by the ABAP language.The Object-Oriented Language ExtensionABAP Objects is a complete set of object-oriented statements that has been introduced into the ABAP language. This object-oriented extension of ABAP builds on the existing language, and is fully compatible with it. You can use ABAP Objects in existing programs, and can also use "conventional" ABAP in new ABAP Objects programs.ABAP Objects supports object-oriented programming. Object orientation (OO), also know as the object-oriented paradigm, is a programming model that unites data and functions in objects. The rest of the ABAP language is primarily intended for structured programming, where data is stored in a structured form in database tables and function-oriented programs access and work with it. The object-oriented enhancement of ABAP is based on the models of Java and C++. It is compatible with external object interfaces such as DCOM and CORBA. The implementation of object-oriented elements in the kernel of the ABAP language has considerably increased response times when you work with ABAP Objects. SAP Business Objects and GUI objects - already object-oriented themselves - will also profit from being incorporated in ABAP Objects. SAP objects are contained:● Within the initial content provided with the portal. See Standard Initial Content.● Within the business packages delivered by SAP that can be imported into the portal from the Portal Content Portfolio area in the SAP Developer Network (SDN) at www.sdn.sap.com.The content objects provided by SAP (the initial content) can be found in the Portal Catalog in the following folder: Portal Content/Content Provided by SAP. Objects in this folder belong to the SAP namespace. The ID of the object contains one of the following prefixes:● com.sap*● com.sap.pct* Do not make any changesto objects in the SAP namespace. If you do so, and a new version of the object is then imported into the portal, the object will be overwritten and you will lose all your changes....FeaturesYou have two possibilities for reusing objects provided by SAP and adapting them to your needs:1. Scenario 1: You use the SAP objects that are delivered without a namespace.2. Scenario 2: You create a delta link from an SAP object.ActivitiesScenario 1: You use the SAP objects that are delivered without a namespaceAs described above, the objects in initial content belonging to the SAP namespace can be found in the Portal Catalog in the following folder: Portal Content/Content Provided by SAP. You may not use or change these objects.In parallel, there are copies of these objects in two other folders of the Portal Catalog: Portal Content/Portal Administrators and Portal Content/Portal Users. These folders contain for example:● the administrator roles● the standard user role● the preconfigured page for the navigation areas in the portalYou can change all the objects in these two folders as needed by opening them in the Portal Content Studio for editing. Since the objects are not in the SAP namespace, you can use or change the objects.You can use the objects in these two folders because they have a delta link relationship to the original objects in folder Content Provided by SAP. The initial content is provided by SAP together with the delta link relationships.Note the following for the administrator roles:● If you want to change the preconfigured administration roles, always use the administrator roles in the folder Portal Content/Portal Administrators.● If you want to assign administrator roles to users, always use the administrator roles in the folder Portal Content/Portal Administrators.Scenario 2: You create a delta link from an SAP objectYou can derive an object from an SAP object with a delta link. You assign the derived object a name in your own namespace. You do this by copying the SAP object from the Portal Catalog and inserting it elsewhere in the Portal Catalog as a delta link. See Creating Delta Links. In this way you create a reference to a delivered object that is not part of your own namespace (the source object) from an object belonging to your own namespace (the target object).You can now change "external" contents within your own object by working on the reference object, and not on the original object delivered by SAP. The system records the changes that you make (such as deleting folders or adding folders to role hierarchies) as a delta link. ResultIn both scenarios the advantages of the delta link method become apparent:● You can make changes to a target object (delta link object) and the source object remains unchanged.● If the source object is reimported into the portal at a later time with changes to its contents, these changes appear automatically in all the derived target objects.● When you import the content object again, your changes to the derived (target) object are retained.
Creating Archiving Objects Prerequisites The programs you enter must already exist in the system. Procedure Call transaction AOBJ. Choose New Entries and enter the following data: General Information Object NameName of the archiving object TextShort description Application AreaOrganizational category for assigning archive files Application ComponentUsed for assigning archive files Programs and Functions Write Program Name of the program that writes the archive files Interruption Possible Setting this indicator means the archiving object supports Interruption and Continuation of an Archiving Session. If you set this, the write program must also handle the interruption request. This indicator must not be set if the Do Not Start Before End of Write Phase is set. Delete Program Name of the program that deletes the data from the database after the write program has finished Do Not Start Before End of Write Phase If this indicator is set, the delete programs do not start until the write program is finished. To actually start the delete phase immediately, the Start automatic. indicator must be set in archiving-object-specific Customizing. This indicator should not be set for most archiving objects. Before you set this indicator, decide whether you actually need to use this indicator or can do without it. Reload Program (optional)Name of the program with which the data can be loaded from the archive back into the database. Prohibit New Session During Reload If this indicator is set, no new archiving session is generated when reloading archiving sessions. The reload program is not authorized to call the function module ARCHIVE_SAVE_OBJECT. Preprocessing Program (optional)Name of the program with which data is to be prepared for data archiving. Postprocessing Program (optional)Name of the program with which data is to be processed after it has been archived. If, for example, the data is only marked for deletion in the delete program, the actual deletion can be executed in the postprocessing program. Index Build Program Name of the program for building indexes ArchiveSelect.Active If this indicator is set, the Archive Selection pushbutton is displayed in transaction SARA for building and deleting indexes. If you select archive files using variants, do not set this indicator. Index Delete Program Name of the program for deleting indexes Index Build Allowed If this indicator is set, an index can be created for this archiving object. For more information, see Creating ADK Indexes and Using Them to Access Archive. The actual index creation can be controlled by a Customizing entry. "Invalid" Indicator Cannot Be Revoked If this indicator is set, the "Invalid" indicator for archiving sessions cannot be reset in archive management once it is set. Archiving Object Generated Indicates the archiving object was generated. As of SAP Web Application Server 6.10 write and delete programs can no longer be generated at runtime. Cross-ClientArchiving is client-independent. End DialogDialog mode must stop before archiving can begin. Only set this if collisions may occur during data archiving. In general, this should not be set as it was primarily designed for older archiving objects where parallel operation was not able to be guaranteed between online operation and data archiving. Documentation Info for Write Program Name of the document containing information about the object-specific write program Info for Delete ProgramName of the document containing information about the object-specific delete program. Info for Reload Program Name of the document containing information about the object-specific reload program. Info for Preprocess ProgName of the document containing information about the object-specific preprocessing program. Info for Postproc ProgName of the document containing information about the object-specific postprocessing program. Info for Read Program Name of the document containing information about the object-specific read program. You create the documents using the documentation maintenance transaction (SE61). Save your entries and return to the initial screen of transaction AOBJ. ResultYour new archiving object is included in the list of archiving objects in the system. You can now create additional information about your archiving object by selecting the line and choosing one of the actions under Archiving Object.
DB14 : Daily SAP Basis job log to be monitoredSAP provides an excellent DBA tools (for Oracle DB) which is called BRTOOLS. BRTOOLS is a compilation tools range from BRBACKUP (tools to maintain backup database), BRARCHIVE (tools to maintain archive files backup), BRCONNECT (tools to maintain checking database, updating database statistics, etc), BRRESTORE (tools to maintain database restoration), and some specific and useful tool. When SAP Basis running one or more tools from BRTOOLS, it will create a job log to provide SAP Basis some information about BRTOOLS activities whether it succeed, succeed with warning, or failed. We can access those log from SAP R/3 through SAPGUI.SAP provides DB14 tcode for SAP Basis to access those database logs. Through this article, I’ll show you how to monitored your database logs.First, type DB14 on your SAPGUI screen. You’ll have this screen : To check your BRCONNECT logs, just click BRCONNECT button. You’ll see some logs. The one which coloured grey is BRCONNECT job that had run well or successfully. The other one which coloured yellow is BRCONNECT job that had run but ended with warning. If your BRCONNECT job hadn’t run well then it will show you red coloured log. To see what’s really happened, justdouble click one of i logs. For more detailed information, click Detail Log button. For BRBACKUP job log, you can click BRBACKUP button. For more information about BRBACKUP activities, double click on one of its log. To get more detailed information, click on Detail Log button. For BRARCHIVE log activities, click on BRARCHIVE button. For detailed information, just double click on one of its lines and you’ll get this screen. For detailed information, you have to click Detail Log button. SAP through Going Live Check event will check this log to make sure that your SAP production system is ready to go live. They will mention and warn you if something wrong with your backup configuration. So, make sure that you’ll have this log check every day to make your system has high availability and minimize your SAP production downtime. Checking SAP R/3 Database via BRTOOLSBRTOOLS is a database tool developed by SAP to help SAP Basis manage his Oracle based SAP R/3 database. In the last tutorial, I had shown you how to check your database through DB13 tcode. DB13 is database independent tcode to manage your database whether you’re using MS SQL, Oracle, DB2, or SAPDB.Here, I am going to demonstrate how to use BRTOOLS to check your Oracle 9i database. You need to logon to your SAP R/3 server using ORA[SID] user. Type BRTOOLS on your console and then you’ll have this screen. For your information, I’am using UNIX OS. It might be different when you’re using Windows OS. Choose number 6 option by typing 6 and then press ENTER. To check your database choose number 1 option and then press ENTER. In this screen, you might need to input some information about your database such as your SAP Database profile, your database user and password, database owner, and something you might not want to be checked. For this moment, I am using default properties and press ENTER. This screen show you BRTOOLS confirmation. Just type C and then press ENTER to proceed to the next step. Press ENTER to proceed. Now, you’ll see that database check process is running. Wait until it finished. Type S to stop and exit from BRTOOLS menu. Now you had learn how to check your SAP R/3 database by using DB13 tcode and BRTOOLS command. In the next tutorial, I’ll show you another tips and trick that might be useful and helpful. Stay there and always connected. Checking SAP R/3 DatabaseMost Basis jobs are related with database server. Whether you’re using Microsoft SQL server from Microsoft, Oracle Database from Oracle, DB2 Universal Database from IBM or SAPDB from MySQL AB, all your job are facing with them closely. SAP are design its database very complex and beatiful. SAP also develop database tools to accompany you as Basis in order free you from complicated and frustated database specific related jobs such as rebuilding index, checking tablespace, checking whole database, updating your database statistic, monitoring your database growth, etc.I just going to explain about BRTOOLS for Oracle because I only have Oracle database right now. BRTOOLS has numerous tools inside it. To check your Oracle database, you can go to your SAP screen. Go to DB13 tcode. Double click on current date. Choose Check Database. If you want to run check database command now, just choose Start Immedietly. But if you want to run it later, just schedule it on appropriate time.Checking SAP R/3 tablespacesSAP R/3 are ERP software using large database. Usually commercial databases such Oracle, DB2, Informix is used as its database server. Mine using Oracle 9.2.0.6.SAP tcode DB02 is use to check database size, tablespaces size, current statistic, checking freespace statistic, analyze detailed tablespace, checking missing indexes, and space critical objects. Actually, we can do more than that.SAP R/3 installation created 6 tablespaces by default. Here are name of their tablespaces :• PSAPTEMP • PSAPUNDO • PSAP[SID] • PSAP[SID]620 • PSAP[SID]UDR • SYSTEM I am using SAP R/3 Enterprises 4.7 ext 200 version. It may be different if you are using old or new ones. SAP R/3 data is saved on PSAP[SID] tablespace. So, we need to managed this tablespace carefully. When you type DB02, Press Space Statistic button to find out tablespace size and its growth. Tablespace’s growth can be seen daily, weekly, or monthly. To check tablespace current size, just click Current Size button. Click on PSAP[SID] tablespace and then, click Freespace Analysis. If your PSAP[SID] tablespace size is reaching 95% level, you should consider increasing its size. You can use BRTOOLS to increase tablespace size.
Configuration Steps: To configure the BI Administration Cockpit follow the steps below: 1. Go to transaction SPRO. 2. Click ‘SAP NetWeaver’ dropdown. 3. Then select ‘Business Intelligence’ dropdown. 4. Click ‘Setting for BI Content’ dropdown. 5. Then again select ‘Business Intelligence’ dropdown. 6. Now Click ‘BI Administration Cockpit’. 7. Here you follow sequence of steps as shown under ‘BI Administration Cockpit’ dropdown as follow:
Activate the new technical content in SAP NetWeaver BI. Assign the BI Administrator Role. Control Updating of Statistics. Schedule Technical Content Process Chains. Connect BI system and Portal. Install Business Package’ BI Administration 1.0’. Set Up Call to BI Administration Cockpit. Additional information on the individual steps can be found in the configuration IMG. There are some stander process chains which have to be scheduled in order to transfer BI Statistics Data to the new Technical Content. SAP
In SAP NetWeaver BI7.0 Query Runtime Statistics is split into two major parts: Front End and OLAP Statistics: Runtime of BI front end application and Runtime of query in OLAP processor. Data Manager: Runtime for retrieval of data from BI InfoProvider or the BI Accelerator. The key feature in Query Runtime Statistics is ‘Statistics Detailed Levels’. It allows level of detail of statistic data collected for certain BI object. The main InfoProvider for query runtime monitoring is 0TCT_MC01 which contain aggregated information on query runtime. InfoProvider 0TCT_MC02 gives detailed statistics of query runtime where as 0TCT_MC03 is used for query performance tuning at data manager level. SAP
Data Load Statistics This gives an overview of length of the load process and process chain, as well as length of number of data records from InfoPackages and data transfer process. 0TCT_MC21 contain Process (Chain) statistics. 0TCT_MC22 contains DTP statistics. 0TCT_MC23 contains InfoPackage statistics.
Data Load Status This feature gives following information Process Status Process chain Status Process Status Process Type Selection
BI Object Request Status Infocube Status DataStore Object Status Master Data Status PSA data Status
InfoProvider Request Status Infocube Correctness Aggregate Rollup DataStore Object Correctness DataStore Object Activation In technical content 0TCT_MC11 InfoProvider collects Object Request Status and 0TCT_MC12 contains Process Status All these feature help us for ‘Easy administration for complex Enterprise Data Warehouses’. These are important to someone like me who is on production support project as valuable time can be given to the trouble shooting activity.
These r the some issues which u can face.Duplicate Fiscal Period values in Query If you open up a drop down box ("Select Filter Value") for Fiscal Year/Period to filter your query, you are presented with duplicate entries for Month & Year. Due to Fiscal Year Period InfoObject taking data from Master Data not InfoProvider. Thus it picks up all available periods not just Z2. Auto-Emails being delayed Emails coming from BW from process chains are delayed 2 hours on BW before being released Due to userids that send these emails (e.g. ALEREMOTE) being registered on a diffferent timeazone (i.e. CET) from the BW system (i.e. GMT) “Pgm_Not_Found” short dump Whenever a query is run via RRMX or RSRT Call transaction RS_PERS_ACTIVATE to Activate History and Personalisation Characteristics not found When running a query the warning message Characteristic does not exist is displayed for the following: 0TCAACTVT, 0TCAIPROV, 0TCAVALID We activated the three characteristics listed and the warnings stopped. NO need to make them authorisation-relevant at this stage.(also did 0TCAKYFNM) System generated Z pgms have disappeared Post-upgrade the system Z-pgms ceased to exist Discovered in Development so we compared with pre-upgraded Production and then recreated them or copying them from production. Conversion issues with some Infoobjects Data fails to Activate in the ODS targets For the InfoObjects in question, set the flag so as not to convert the Internal values for these infoobjects InfoObject has Conversion routine that fails, causing load to fail The routine prefixes numeric PO Numbers with 0’s. SD loads were failing as it was not able to convert the numbers. Presumably the cause of the failure was the running of the Pre-Prepare RSMCNVEXIT pgm. Check the Tick box in the Update rule to do the conversion prior to loading rather than the other way round. Requests fail to Activate on numeric data Request loads OK (different from above issue) but fails to Activate Forced conversion within the update rules using Alpha routine. Deleted Request and reloaded from PSA. Database views missing after pre-PREPARE work Views got deleted from database, although not from data dictionary Recreated the views in the database using SE14. Workbook role assignations lost We lost a few thousand workbook assignments when we transported the role they were attached to into Production The workbooks did not exist in Development, thus they all went AWOL. We wrote an ABAP program to re-assign them in production
SAP Java Development Infrastructure Supports Developers from Project Start to Finish (PDF 607 KB) - This SAP Insider article from the early days of the development infrastructure overviews the topic when it was still called JDI and explains why it is a key differentiator between SAP NetWeaver Developer Studio and other approaches to a typical Java IDE. However, the concepts described are still valid for the NWDI as we call it now. An SAP-Partner's NWDI success story Keeping Track of the Software Development - Find out about one customer’s and partner’s experience with NWDI in this SAP INFO article. Back to top NWDI Background and Technology Basics
The Evolution of Development Infrastructure - Here, you'll find a discussion on what it means to use a central development infrastructure - not only for source code, but for all development steps. Why DTR? - The Design Time Repository (DTR) is the source code versioning system of NWDI/JDI created by SAP and based on the open standards of WebDAV and Delta V. Find out what is is different in DTR compared with other versioning concepts. Component Model - Development in the NWDI is based on SAP's component model, which is used to structure applications as reusable components while serving as a basis for a new build process. The component model doesn't change the Java and J2EE objects you already know, but adds metadata that define the encapsulation of objects and their interfaces. Find out how this structured approach to development can change the way you work. Development Landscapes - Software development in the NWDI is organized in tracks. Tracks define logical systems for the phases of development and consolidation and define the way objects are transported during all steps of the development of a specific release. Learn about what is possible with tracks, and how to structure an NWDI landscape to develop multiple releases of a product. JDI Software vs. JDI Content - "On which release and SPS level do I have to run my JDI / NWDI server when I develop applications for a specific SP stack?" is an important question. Well, in principle the NWDI version is independent of the version of the software that you develop - read more in this blog. Enhancements of the Change and Transport System – Implications on Transports in a Heterogeneous SAP System Landscape (PDF 140 KB) - The Change and Transport System (CTS, SAP NetWeaver usage type AS ABAP) is enhanced with SAP NetWeaver 7.0 SPS 12 to be capable of transporting non-ABAP object types, such as those from the SAP NetWeaver usage types PI (Exchange Infrastructure), EP (Portal), etc. The article discusses the implications on transports for different usage types including the NWDI. Back to top Best Practices and How-To-Guides for NWDI-based Development
How to Setup an NWDI Track for Composition Environment Development (PDF 378 KB) - Find out how to set up a track to develop new composite applications for the SAP NetWeaver Composition Environment (CE) platform. This How-to Guide focuses on what you need to set up new software components for development with CE, their dependencies, and specifics within the track configuration. The Fast Way To Component-Based Development Using SAP NetWeaver CE 7.1 - This article series describes how to develop applications for the SAP NetWeaver platform according to SAP's component model using DI services like development configurations and development components without the neccessity of any server installation. Part I: Concepts and Development Scenarios (PDF 143 KB) explains what your options are when you want to produce software using SAP NetWeaver CE 7.1 including prerequisites and benefits of the various approaches Part II: Local Development Configurations (PDF 152 KB) focusses on the fastest way to CE development using local development confgurations in the scenario "Component-Based Development with Optional Development Infrastructure" If you want to find out more about the Composition Environment visit the area Development and Composition in the SAP NetWeaver Capabilities section, where you will find general information on Composition Environment with Getting Started section, installation information, example applications, etc. Back to top Avoiding and Solving Problems
How to Analyze, Handle, and Avoid Conflicts in the SAP NetWeaver Development Infrastructure.This article describes a life-like assembly problem, caused by a conflict in the DTR, how it was solved, and how it could have been avoided. CBS Secrets Unveiled - Understanding Broken and Dirty DCs (PDF 204 KB) - This article is aimed at helping developers and administrators better understand the component build in SAP NetWeaver '04 and 2004s (7.0) by explaining typical build problems and how to resolve them. Java Development NWDI - Q & A - This page provides some valuable insights in the form of common questions about NWDI.
AL11 View the SAP File Structure on the server DB02 Database Monitor DB20 Refresh Database Statistic by Table X OSS1 SAPNet Support – OSS Link PFCG Security Role Maintenance X RZ10 System and Tuning Parameters SE10 Transport and Change Organizer X SE30 Transaction Run-Time Analysis SE37 ABAP Function Editor X SE38 ABAP Program Editor SE93 Transaction Authorization Objects X SM01 Lock Transactions SM02 System Messages X SM04 User Sessions SM12 Table Locks X SM13 Update Locks SM19 User Security Audit Maintenance X SM20 Audit Logs SM21 System Logs X SM37 Job Maintenance SM50 Work Process Overview X SM59 RFC Maintenance SNOTE SAP Note Assistant X SP01 Spool Output SPAD Output Device Maintenance X SPAM Support Package Application Manager ST02 Tuning Summary X ST03 Workload Analysis ST03N Workload Analysis (Graphic) X ST04 DB/2 Performance Monitor ST05 Trace Requests X ST06 Operating System Monitor ST22 Short Dump Analysis X STMS Transport Management System SU01 User Maintenance X SU02 Profile Maintenance SU10 Mass User Change X SU53 Missing User Authorizations
1. Open a web browser window and link to the SAP Marketplace using http://service.sap.com/patches. 2. If a Client Authentication popup appears, click the OK button. 3. On the SAP Service Marketplace popup, type in your User name (OSS ID) and Password in the spaces provided. Click the OK button. 4. Click on My Application Components in the navigator tree on the left. 5. Click oIn the navigator tree on the right-hand side of the My Application Componentsscreen.
For R/3, expand as follows:
SAP R/3 Enterprise SAP R/3 ENTERPRISE 47X200 SAP R/3 Enterprise Server SAP KERNEL 6.20 32-BIT NT/I386 MS SQL Server
6. This produces a list of MS SQL Server dependent kernel patches. Scroll down the Download screen until under the File Name column you find SAPEXEDB_.SAR. Click on the Info hyperlink to the right of SAPEXEDB_.SAR. On the SAP Download Area – Info File popup, find the patch number value. This is the patch level of the latest kernel. If the kernel patch level is higher than your current kernel patch level, you may need to apply the newer kernel patch. Close the SAP Download Area – Info File popup. 7. To download a kernel patch, click on the SAPEXEDB_.SAR hyperlink. Click the Download button. On the File Download popup, click the Save button. On the Save As popup, select a location to store the kernel patch and click the Save button. 8. Now backup a step and instead of clicking MS SQL Server, click #Database independent. The full path would look like this:
SAP R/3 Enterprise SAP R/3 ENTERPRISE 47X200 SAP R/3 Enterprise Server SAP KERNEL 6.20 32-BIT NT/I386 #Database independent
9. This produces a list of database independent kernel patches. Scroll down the Download screen until under the File Name column you find SAPEXE_.SAR. Click on the Info hyperlink to the right of SAPEXE_.SAR. On the SAP Download Area – Info File popup, find the patch number value. This is the patch level of the latest kernel. If the kernel patch level is higher than your current kernel patch level, you may need to apply the newer kernel patch. Close the SAP Download Area – Info File popup. 10. Use the same instructions in step 7 to download the patch. Make sure that the version number of your database independent files matches the version number of your MS SQL Server dependent file. 11. Once you have downloaded the kernel patch, you may leave the SAP Marketplace.
