|
| |
| |
| |
|
|
|
| Free Download SAP BASIS Books And Interview Questi |
| ABC Analysis,Access Control,Accessing Tasks,Account Payable,Activities,Admin Books,Admin Functions, Administration,administrator,ALE INTEGRATION,Alert Monitor(CCMS),Alert Monitor(CCMS),ALO8 BOOKS,Application Layer,application modules, R/3 Architecture,Archiving,ASAP,Audit Files |
| Language: |
| RSS Feeds for this Blog |
|
Statistics |
| Unique Visitors: 55 |
| Total Unique Visitors: 53445 |
| Visitors Out: 410 |
| Total Visitors Out: 410 |
|
|
|
| |
|
|
| |
|
| SAP Administrative Options |
| 2008-04-11 08:42:41 |
Purpose Administrative options — with the exception of the startup functions -r and -a — are sent to a running SAProuter, which then executes the appropriate function.SAProuter is started with the command saprouter -r (AS/400: saprouter '-r' ), see Starting SAProuter. Features The following list provides an overview of the administrative options: Option -s (stop saprouter) Option -n (new saprouttab) Option -t (toggle trace) Option -c (cancel connection n) Option -l / -L Option -d (dump buffers) Option -f (flush buffers) Option -p Option -a Options must be placed in quotation marks under OS/400, for example, enter saprouter '-s' to stop SAProuter.Expert Opt...
|
| |
|
| Option -t (toggle trace) SAProuter Administrative Options |
| 2008-04-11 08:42:20 |
Use The command saprouter -n (AS/400: saprouter '-n' ) is used to report changes in the route permission table to the running SAProuter. It causes SAProuter to use the updated table, as named with option -R (default saprouttab ). If you would like to enter, for example, other restrictions in the route permission table, you do not have to stop and restart SAProuter, but you can use this function. The new route permission table does not affect connections which already exist! Even if the existing connection is not allowed according to the new table, it is retained!Expert Options SAProuter Additional OptionsOption -M . SAProuter Additional OptionsOption -A SAProuter Additional OptionsOption -H [-P ] SAProuter Additional OptionsOption -C SA...
|
| |
|
| Option -c (cancel connection n) SAProuter Administrative Options |
| 2008-04-11 08:41:52 |
Use Internally, each connection using SAProuter has a number, which can be seen with option -l / -L. This function can be used to close a connection. The command saprouter -c 2 (AS/400: saprouter '-c 2' ) closes the connection with the (internal) number 2.Expert Options SAProuter Additional OptionsOption -M . SAProuter Additional OptionsOption -A SAProuter Additional OptionsOption -H [-P ] SAProuter Additional OptionsOption -C SAProuter Additional OptionsOption -S SAProuter Additional OptionsOption -V SAProuter Additional OptionsOption -T SAProuter Additional OptionsOption -G SAProuter Additional OptionsOption -K SAProuter Additional OptionsOption -R SAProuter Additional OptionsSAProuter Additional ...
|
| |
|
| Option -l / -L SAProuter Administrative Options |
| 2008-04-11 08:41:42 |
Use You can use the saprouter -l (AS/400: saprouter '-l' ) function if you want SAProuter to display route information on the screen. The saprouter -L (AS/400: saprouter '-L' ) function provides even more detailed information.The information contains:A table with the connection number, client, partner, and service for each existing connection The total number of clients, the working directory in which SAProuter is running, and the path of the route permission table. If you want to display the SAProuter information from a remote host, you should use the option -H [-P ].Expert Options SAProuter Additional OptionsOption -M . SAProuter Additional OptionsOption -A SAProuter Additional OptionsOption -H [-P ] SAProuter Additional Options...
|
| |
|
| Option -d (dump buffers) SAProuter Administrative Options |
| 2008-04-11 08:41:30 |
Use If this function is used, detailed information on the host names involved in the connection and their IP addresses is written to the trace file (default dev_rout, or the name specified with option -T). The trace file is not overwritten, the information is simply appended at the end.Expert Options SAProuter Additional OptionsOption -M . SAProuter Additional OptionsOption -A SAProuter Additional OptionsOption -H [-P ] SAProuter Additional OptionsOption -C SAProuter Additional OptionsOption -S SAProuter Additional OptionsOption -V SAProuter Additional OptionsOption -T SAProuter Additional OptionsOption -G SAProuter Additional OptionsOption -K SAProuter Additional OptionsOption -R SAProuter Additional OptionsSAProuter Additional OptionsOption -...
|
| |
|
| Option -f (flush buffers) SAProuter Administrative Options |
| 2008-04-11 08:41:17 |
Use This function can be used to empty the internal buffer (which is written to the trace file with option -d (dump buffers)).Expert Options SAProuter Additional OptionsOption -M . SAProuter Additional OptionsOption -A SAProuter Additional OptionsOption -H [-P ] SAProuter Additional OptionsOption -C SAProuter Additional OptionsOption -S SAProuter Additional OptionsOption -V SAProuter Additional OptionsOption -T SAProuter Additional OptionsOption -G SAProuter Additional OptionsOption -K SAProuter Additional OptionsOption -R SAProuter Additional OptionsSAProuter Additional OptionsOption -a SAProuter Administrative OptionsOption -p SAProuter Administrative OptionsOption -f (flush buffers) SAProuter Admini...
|
| |
|
| Option -a SAProuter Administrative Options |
| 2008-04-11 08:31:53 |
Use This option is not sent to a running SAProuter, but is used to start SAProuter with an external library. is the relative path name of the library. A string can also be passed to the library with option -A . Note that SAP cannot guarantee support if you use an external library. Please contact the vendor of the external library if you have problems.Option -M . SAProuter Additional OptionsOption -A SAProuter Additional OptionsOption -H [-P ] SAProuter Additional OptionsOption -C SAProuter Additional OptionsOption -S SAProuter Additional OptionsOption -V SAProuter Additional OptionsOption -T SAProuter Additional OptionsOption -G SAProuter Additional OptionsOption -K SAProuter Additional OptionsOption -R SAProuter Additional OptionsSAProute...
|
| |
|
| SAProuter Additional Options |
| 2008-04-11 08:31:43 |
Purpose The additional options — with one exception — are indicated by uppercase letters. They can be combined with each other and with an administrative option, as long as this makes sense. The ways in which the options can be combined are indicated in the sections in which they are described.If an invalid combination of SAProuter options is specified, SAProuter behaves as if only saprouter was specified and shows the online help. Implementation Considerations The additional options can also be omitted, there are default values that are specified for each option. Features Option -R Option -K Option -G Option -T Option -V Option -S Option -C Option -H [-P ] Option -A Option -M . Options must be plac...
|
| |
|
| Option -R SAProuter Additional Options |
| 2008-04-11 08:31:31 |
Use You can use the saprouter -R (AS/400: saprouter '-R ' ) option to specify the file containing the route permission table. If an entry is not made, SAProuter searches the file ./saprouttab (UNIX and AS/400) :\usr\sap\saprouter\saprouttab (NT) The route permission table is essential for SAProuter (version >= 23). If it is not found, SAProuter terminates with an appropriate message.If you want to permit all connections, you must specify the following single-line route permission table: P * * *Option -M . SAProuter Additional OptionsOption -A SAProuter Additional OptionsOption -H [-P ] SAProuter Additional OptionsOption -C SAProuter Additional OptionsOption -S SAProuter Additional OptionsOption -V SAProuter Additional OptionsOption -T ...
|
| |
|
| Option -K SAProuter Additional Options |
| 2008-04-11 08:31:21 |
Use For SNC connections to be possible with SAProuter, SAProuter must be started with this option: saprouter -r -K (AS/400: saprouter '-r -K ' ). There must also be a KT entry in the route permission table specifying that connections with a certain host (whose SNC name is known) should be SNC connections. is the SNC name of the host on which the SAProuter is running. See also: SNC - Secure Network CommunicationOption -M . SAProuter Additional OptionsOption -A SAProuter Additional OptionsOption -H [-P ] SAProuter Additional OptionsOption -C SAProuter Additional OptionsOption -S SAProuter Additional OptionsOption -V SAProuter Additional OptionsOption -T SAProuter Additional OptionsOption -G SAProuter Additional OptionsOption ...
|
| |
|
| Option -G SAProuter Additional Options |
| 2008-04-11 08:31:09 |
Use When you start your SAProuter, you can specify a log file. UNIX/NT: saprouter -r -G AS/400: saprouter '-r -G ' is the name (relative path name) you specify for the log file. All important activities, such as starting the connection and runtime operations, are logged in this file:Connection from (client name/address) Connection to (partner name/address) Partner service Start time End time Connection requests rejected after checking the route permission table. If this option is not used, a log file is not created.Option -M . SAProuter Additional OptionsOption -A SAProuter Additional OptionsOption -H [-P ] SAProuter Additional OptionsOption -C SAProuter Additional OptionsOption -S SAProuter Additional OptionsOption -V SAProuter Add...
|
| |
|
| Option -T SAProuter Additional Options |
| 2008-04-11 08:30:58 |
Use A trace file is used to search for and correct errors. It logs in detail - the higher the trace level (see Option -V), the more detailed the information - what SAProuter does. From this, you can see in which function an error occurred, why a connection was not established, etc.When you start SAProuter, you can specify a trace file:UNIX/NT: saprouter -r -T AS/400: saprouter '-r -T ' A trace file always exists. If the option is not used, the trace file dev_rout in the working directory is used. It resides in the working directory of the SAProuter.Option -M . SAProuter Additional OptionsOption -A SAProuter Additional OptionsOption -H [-P ] SAProuter Additional OptionsOption -C SAProuter Additional OptionsOption -S SAProuter Additional Op...
|
| |
|
| Option -V SAProuter Additional Options |
| 2008-04-11 08:30:42 |
Use This option is used to set the trace level when SAProuter is started:UNIX/NT: saprouter -r -V3 AS/400: saprouter '-r -V3' for example, starts SAProuter with trace level 3.The trace level specifies how detailed the information should be in the trace file: 1 means hardly any information, 3 very detailed information. The name of the trace file can be set with option -T.You can change the trace level while SAProuter is running with option -t (toggle trace).Trace levels 1, 2, and 3 are available, and the default value is 1.Option -M . SAProuter Additional OptionsOption -A SAProuter Additional OptionsOption -H [-P ] SAProuter Additional OptionsOption -C SAProuter Additional OptionsOption -S SAProuter Additional OptionsOption -V SAProuter...
|
| |
|
| Option -S SAProuter Additional Options |
| 2008-04-11 08:30:23 |
Use The option -S is used to specify the service (port) on which SAProuter runs (default 3299). SAProuter can, for example, be started on any other service: saprouter -r -S 4444 (AS/400: saprouter '-r -S 4444' ) starts SAProuter on the local host on service 4444. If you want to administer this SAProuter, of course you also have to define the service.Option -M . SAProuter Additional OptionsOption -A SAProuter Additional OptionsOption -H [-P ] SAProuter Additional OptionsOption -C SAProuter Additional OptionsOption -S SAProuter Additional OptionsOption -V SAProuter Additional OptionsOption -T SAProuter Additional OptionsOption -G SAProuter Additional OptionsOption -K SAProuter Additional OptionsOption -R SAProuter Additional OptionsSAPr...
|
| |
|
| Option -C SAProuter Additional Options |
| 2008-04-11 08:29:43 |
Use You can use this function to set the maximum number of clients. The default setting is 800, the maximum value is 2039. Note that two clients correspond to one connection; that is max 400 connections are preset and max. 1019 connections are possible. If you want to run 1000 connections with your SAProuter, start SAProuter as follows:UNIX/NT: saprouter -r -C 2000 AS/400: saprouter '-r -C 2000' If you would like to have more connections than the maximum (1019), you can "move" SAProuter to another port with option -p and start a new SAProuter on this port.Option -M . SAProuter Additional OptionsOption -A SAProuter Additional OptionsOption -H [-P ] SAProuter Additional OptionsOption -C SAProuter Additional OptionsOption -S SAProuter Additi...
|
| |
|
| Option -H [-P ] SAProuter Additional Options |
| 2008-04-11 08:28:52 |
Use This option has two uses: You can define the option when you start SAProuter: saprouter -r -H (AS/400: saprouter '-r -H ' ).This means that SAProuter only responds to the IP address of host ; if option -S does not define any other value, this is default port 3299. If SAProuter is started without option -H , it responds to all IP addresses of this host. can also be an IP address. The host myhost has two IP addresses: a1 and a2.The call saprouter -r (AS/400: saprouter '-r' ) causes SAProuter to respond to a1/3299 and a2/3299. The call saprouter -r -H a2 (AS/400: saprouter '-r -H a2' ) causes SAProuter to respond only to a2/3299. If you started SAProuter with option -H , you also have to define the host name for administration. For exampl...
|
| |
|
| Option -A SAProuter Additional Options |
| 2008-04-11 08:28:31 |
Use This option is only required in connection with option -a . If SAProuter is started with an external library, another string can be passed to this library with option -A (AS/400: Option '-A ' ).Option -M . SAProuter Additional OptionsOption -A SAProuter Additional OptionsOption -H [-P ] SAProuter Additional OptionsOption -C SAProuter Additional OptionsOption -S SAProuter Additional OptionsOption -V SAProuter Additional OptionsOption -T SAProuter Additional OptionsOption -G SAProuter Additional OptionsOption -K SAProuter Additional OptionsOption -R SAProuter Additional OptionsSAProuter Additional OptionsOption -a SAProuter Administrative OptionsOption -p SAProuter Administrative Options ...
|
| |
|
| Option -M . SAProuter Additional Options |
| 2008-04-11 08:28:18 |
Use You can use this option to specify a port range for outgoing connections. For example, the command saprouter -r -M 1.1023 only allows outgoing connections from ports 1 to 1023 (reserved for root under UNIX). Integration This option can be used to increase security; see Network Security with SAProuterOption -M . SAProuter Additional OptionsOption -A SAProuter Additional OptionsOption -H [-P ] SAProuter Additional OptionsOption -C SAProuter Additional OptionsOption -S SAProuter Additional OptionsOption -V SAProuter Additional OptionsOption -T SAProuter Additional OptionsOption -G SAProuter Additional OptionsOption -K SAProuter Additional OptionsOption -R SAProuter Additional OptionsSAProuter Additional OptionsOption -a SAProuter Admi...
|
| |
|
| Expert Options SAProuter Additional Options |
| 2008-04-11 08:27:55 |
Purpose SAProuter has a few expert options, which are described below. Please use these options only after consulting SAP or if you are very experienced in this area! Features Command Function Default -B Maximum queue length per client 500,000 bytes -Q Maximum total size of all queues 20,000,000 bytes -W Timeout for blocking network calls (if there is an error) 5000 msec Maximum number of clients reached SAProuter Additi...Route permission denied SAProuter Additional Optio...SAProuter Error Messages SAProuter Additional Opti...SAProuter Error DiagnosisExpert Options SAProuter Additional OptionsOption -M . SAProuter Additional OptionsOption -A SAProuter Additional OptionsOp...
|
| |
|
| SAProuter Error Diagnosis |
| 2008-04-11 08:27:38 |
The following section should help you diagnose and correct errors when working with SAProuter. SAProuter Error Messages Maximum number of clients reached SAProuter Additi...Route permission denied SAProuter Additional Optio...SAProuter Error Messages SAProuter Additional Opti...SAProuter Error DiagnosisExpert Options SAProuter Additional OptionsOption -M . SAProuter Additional OptionsOption -A SAProuter Additional OptionsOption -H [-P ] SAProuter Additional Options...
|
| |
|
| SAProuter Error Messages SAProuter Additional Options |
| 2008-04-11 08:27:26 |
Definition If an error occurs while SAProuter is in operation, an error message is displayed by the SAProuter client. Structure A SAProuter error message consists of eight or more lines, with a blank line inserted after one or two lines. SAProuter error message LOCATION SapRouter on myhost ERROR partner not reached TIME Wed Jul 23 15:24:42 1997 RELEASE 40A COMPONENT NI (network interface) VERSION 30 RC -100 COUNTER 1The first two lines are important. They indicate:On which host the SAProuter concerned is running (in this example myhost) To which application area the error belongs (here connection setup) In this example, SAProuter cannot set up the connection to its partner. You are advised to ...
|
| |
|
| Route permission denied SAProuter Additional Options |
| 2008-04-11 08:27:00 |
Prerequisites One of the most common error messages is the following: LOCATION SapRouter on myhost ERROR route permission denied TIME ..... .... ....A connection has not been set up because SAProuter does not allow the route concerned. Procedure Check the route permission table of this SAProuter (on host myhost ) carefully and change it, if necessary.You can find out which working directory the running SAProuter and the route permission table are in with option -l / -L.Remember that the first entry in the route permission table for which source address, target address, and target port match is decisive!You can import a modified route permission table with option -n (new saprouttab). Maximum number of clients...
|
| |
|
| Maximum number of clients reached SAProuter Additional Options |
| 2008-04-11 08:26:44 |
Prerequisites SAProuter does not accept a connection and outputs the following error message: LOCATION SapRouter on myhost ERROR maximum number of clients reached TIME ..... .... ....This means that SAProuter cannot accept any further clients because the maximum number has been reached (default 800). SAProuter continues execution with all other clients. Procedure In order not to have to restart SAProuter (and thereby end all existing connections), you should perform a soft shutdown of the SAProuter with option -p; SAProuter will continue running on a different port. SAProuter can then be started on the old port, possibly with a larger number of clients (see option -C ). It will then accept clients again. Maximum number of clients reached SAProute...
|
| |
|
| Option -p SAProuter Administrative Options |
| 2008-04-11 08:16:10 |
Use This option can be used to perform a soft shutdown of SAProuter. SAProuter continues running on another port, can be administered on this port, but does not accept any logon requests, and terminates automatically when there are no more clients connected. The port on which SAProuter was running before (default 3299) is now free. This is useful if:A new SAProuter is to be started without closing all existing connections More connections are required than one SAProuter alone can provide (max. 1018). If you enter the command saprouter -p , information is displayed telling you on which port SAProuter can now be administered, and the host on which SAProuter is running.The standard port on which SAProuter is running is port 65000. If it is already assigned or if a port range was alrea...
|
| |
|
| Option -s (stop saprouter) SAProuter Administrative Options |
| 2008-04-11 08:12:49 |
Use This function is used to stop a running SAProuter. Integration If the SAProuter to be stopped is not running on the default service 3299 , the service has to be made known with option -S . The commands saprouter -s -S 3299 and saprouter -s (AS/400: saprouter '-s -S 3299' and saprouter '-s') are equivalent. ...
|
| |
|
| Mass Lock All Printers with SPAD |
| 2008-03-24 06:26:54 |
If you have lots of printers (50 or more) and need to lock them for maintenance, you can used this mass locked printers tips to locked or unlocked all the SAP printers at one go. To mass Lock all the printer in SAP: Go to transaction code SPAD On top of the screen menu click Utilities -> For output devices -> Export devices On the screen Import and Export of Device Descriptions: Export/Import file name: c:\temp\printer.txt Frontend computer: Tick Export: Tick Export Export: Tick Output device: Choose the Selection options Pattern and type a * (* for all or a* for all printers starting with a) Click the Execute button Open the text file do a replace all of PADISABLED = "" to PADISABLED = "X" Then import the same file. or Another way is to go through each output devic...
|
| |
|
| Print to an USB printer from SAP |
| 2008-03-24 06:26:41 |
Is printing to a USB-printer using LOCL from SAP possible? Yes, as long as this printer is defined on local workstation, it will work. SAPLPD doesn't care on how the printer is connected, as long as Windows can print to it, SAPLPD will do its work. Define one new device, also consider giving : Device type as SAPWIN Host Printer __default (yes, two underscores default) Access Method : F Make sure your desktop/PC Windows default printer is set to this USB printer. Sending faxes from SAPPrinting ABAP Report over LAN and WANAuto convert SAP spool output to PDF fileDelete multiple spool requestHow can I print A3 format in SAPParallel printing to all the SAP device printersPrint to an USB printer from SAPMass Lock All Printer...
|
| |
|
| Parallel printing to all the SAP device printers |
| 2008-03-24 06:26:28 |
If you have a situation where reports need to be send to multiple printers, you can configure a pool device type. A pool device type contain a list of SAP printers which the reports will be directed to. Do this in transaction code SPAD for spool administration. For example, in SPAD, type ZXXX next to the field 'Output devices', Click the button Output devices. In change mode, click the Create button. Specify the Device type of your printer. Click the tabstrips 'HostSpoolAccMethod'. In the field "Host spool access method" set to "P: Device Pool". Click the tabstrips 'DevicePool' Click the options "Send to all devices in pool". Type in the list of the SAP printers device you want the report to go to in this pool under the section 'Pool Device List'. Now, w...
|
| |
|
| How can I print A3 format in SAP |
| 2008-03-24 06:26:16 |
My printer is HP LaserJet 5100 Note I can print ms word document in A3 format but I can't print A3 format in SAP My output device setting are: DeviceAttributes:Device Type = THSAPWIN: MS-Windows-Printer via SAPLPDDevice Class = Standard printerAccess Method:Host Spool Access Method = S: Print Using SAP Protocol When I print SM50 output and select format X_65_255, it can print successfully but its format is A4. What may I do wrong? Please help me how to set up for A3 printing in SAP. Ps. Do I need to assign A3 format to be default format in that printer? Is this task for BASIS or ABAP? Bankly In printer settings - SPAD - tray info - you can give the Page format for that tray .did you try setting that ? Try setting DINA3. Li...
|
| |
|
| Delete multiple spool request |
| 2008-03-24 06:26:02 |
The program are RSPO0041 or RSPO1041. This is handy whenever you encounter a user who managed to create a lot of spool requests which are choking your system. Deleting them with SP01 will be too slow and you will get time out if it exceed the online time limit specify by your basis people. Sending faxes from SAPPrinting ABAP Report over LAN and WANAuto convert SAP spool output to PDF fileDelete multiple spool requestHow can I print A3 format in SAPParallel printing to all the SAP device printersPrint to an USB printer from SAPMass Lock All Printers with SPAD...
|
| |
|
| Auto convert SAP spool output to PDF file |
| 2008-03-24 06:25:47 |
As of Release 4.6D, PDF format (Adobe Acrobat data format) can be created via the SAP spooler by using the device type "PDF1". As a workaround, a report (RSTXPDFT4) is made available for the missing "direct PDF printing", which can read spool requests, convert to PDF and perform a frontend download. Read OSS Note 317851 - Printing PDF files in 4.6C/4.6B/4.5B Note the restrictions specified in Note 323736 with the print output with PDF. Caution when modifying device type ZPDF1, see Note 437696. Version If you are in version less than 4.6D, you can configure an output type to convert the spool automatically into a PDF format into your local harddisk but not do a "direct PDF printing". When you print to this PDF output type,...
|
| |
|
| Printing ABAP Report over LAN and WAN |
| 2008-03-24 06:25:34 |
For the LAN setup for local printer you can defined it as device LOCLDevice type: SAPWINHost printer: __DEFAULTHost spool access method: F (Printing on front end computer)This printer will works fine on your LAN.For the WAN, assuming that you have 2 office connected over the internet and they work fine with the printer LOCL.Now, you need to have a Print Server where you have installed many of the printer, some of them over WAN and they will work fine if you do this :-The server must have SAPLPD installed.Output device: LPFPDevice type: SAPWINDestination host: sapdevHost printer: HP_HP1 (printer name on the Printer Server)Host spool access method: S (Print on LPDHOST via SAP protocol) Sending faxes from SAPPrinting ABAP Report over LAN and WANAuto convert...
|
| |
|
| Sending faxes from SAP |
| 2008-03-24 06:25:22 |
Some guidelines how to you can setup faxing from SAP :- You will need an additional software to be installed. The best way to do this is to get a standard desktop PC with a modem attached. Buy a copy of Winfax 10 (its only about $100 to buy.) When you have Winfax setup and working locally, install SAPLPD (put it in the startup group so its loads on startup). WinFax will create a shared fax on the PC (For e.g. IFAX). When this is done create a printer/Fax in transaction SPAD.Device type = SAPWIN Rel.4.x/SAPlpdDevice class = FaxHost Spool access method = S;print using SAP protocolDest. host = PC IP addressHost printer = Shared fax name on PC(i.e IFAX) Make sure you have all the lasted SAPLPD + dll's After that is done create the locations in transaction SCOM, they are self explainitory ...
|
| |
|
| Basis Tables Reorganization of Single Object |
| 2008-03-24 06:20:16 |
You have ARCHIVED the BSIS table (because of old data etc) and now this BSIS table has "holes" in physical structure and it's quite a large table. Here are the steps to reorg. a single object: 1. Take a backup of your Oracle database.2. Shutdown SAP3. Start Oracle Database with Rollback Segment PSAPROLLBIG (all other smaller segments not started). Remember, the size of PSAPROLLBIG should be equal or larger than your BSIS table.4. Ensure sapreorg directory has enough space for taking BSIS Oracle Export dump. The Oracle Export utility compresses the file to some extent.5. Fire your SAPDBA from Unix level.6. Go into SAPDBA "reorganisation" menu.7. Select "Reorganize Single Table / Index"8. Give BSIS as table name.9. Start.10. Don't Forget, first upgrade you...
|
| |
|
| How to Increase the Tablespace free space? |
| 2008-03-24 06:20:01 |
Your tablespace PSAPBTABD is 92% used. How to increase the free space? SAPDBA V3.1I - SAP Database Administration____________________________________________________________________________ ORACLE version : 7.3.4.3.0 ORACLE_SID : ALD ORACLE_HOME : /oracle/ALD DATABASE : open SAPR3 : 31H, 23 times connected a - Startup/Shutdown instance h - Backup database b - Instance information i - Backup archive logs c - Tablespace administration j - Check (and repair) database d - Reorganization k - Restore/Recovery e - Export/import l - Show/Cleanup ...
|
| |
|
| How to activate the IMG Change Log? |
| 2008-03-24 06:19:46 |
SCU3 transaction is used to see the IMG change logs for modified objects. If your table change log is not active, it will gives you a message that :-...table logging is switched off... This particular setting can be changed in the following path :-IMG--> Basis Components --> System Administration --> Tables changes recording You can log changes made to the following tables: - Control tables (system logic control)- Customizing tablesWhat is recorded is always in the form of complete "before" images, that is, all entries as they appear before the changes.The recorded data is compressed without buffering, and this is not an appropriate method for recording and managing large amounts of data. Activating logging impacts on performance as it entails twice as many database updates as would other...
|
| |
|
| Basis - Edit, create, delete or adjust your database table |
| 2008-03-24 06:19:33 |
Edit, create, delete or adjust your database table The database utility is the interface between the ABAP Dictionary and the relational database underlying the R/3 System. This tools allows you to delete all the data in the tables. You can call the database utility from the initial screen of the ABAP Dictionary with Utilities -> Database utility (Transaction SE14). You can use the database utility to edit all the database objects that are generated from objects of the ABAP Dictionary. These are database tables that are generated from transparent tables or physical table pools or table clusters, indexes, database views and matchcode pooled tables or matchcode views. If you want to use the database utility, you need authorization for authorization obje...
|
| |
|
| Finding any of the SAP tables that have been changed |
| 2008-03-24 06:19:21 |
During the production run of the SAP system, additional fields might have been added and you might have lost tracks of the SAP tables changes. Transaction code SPDD have been created to help you to find all the SAP tables that have been modified. Other ABAP Dictionary objects such as lock objects, matchcodes, and views, for which modification would not result in data loss, are not processed during the upgrade with transaction SPDD, but only after the upgrade is complete with transaction SPAU. SAP SQL Tuning Aid with Oracle RDBMS StatisticsSAP Tablespace sizes in large databasesSAP Transaction TableCopying table entries from client 000Transport Tables between ClientsFinding any of the SAP tables that have been chang...Basis - Edit, create, delete or adjust ...
|
| |
|
| Transport Tables between Clients |
| 2008-03-24 06:19:08 |
Use report RSCLCCOP to transport user master records, profiles and authorizatons between clients in an R/3 system. Start RSCLCCOP from the target client which the users and authorizations should be copied. Do not use this report if the target client contains some users and authorizations you want to preserve. SAP SQL Tuning Aid with Oracle RDBMS StatisticsSAP Tablespace sizes in large databasesSAP Transaction TableCopying table entries from client 000Transport Tables between ClientsFinding any of the SAP tables that have been chang...Basis - Edit, create, delete or adjust your databa...How to activate the IMG Change Log?How to Increase the Tablespace free space?Basis Tables Reorganization of Single ObjectWhat Is The Jo...
|
| |
|
| Copying table entries from client 000 |
| 2008-03-24 06:18:53 |
I need to copy table entries from client 000. I have identified which entries I need to copy through running RPULCP00 but I don't know how to move the entries. The simplest way is to go into the table through SM31Then in your top row of buttons there should be one called 'utilities' from here select 'adjust',Then select the client that you want to compare/copy from (you need to have an RFC destination set up).This will then show you the contents of the table in both clients and identify the status of each record, they will fall into the following categories:ML Differences, logon client entryMR Differences, comparison client entryL Entry only exists in logon clientR Entry only exists in comparison clientIdentical entries(...
|
| |
|
| |
 |
