Archive for the ‘Everyday stuff’ Category
You are currently browsing the archives for the Everyday stuff category.
8
Jul
2011
SAP: substitution/validation transactions
A quick and simple way to locate a validation/substitution rules can be achieved through the utilization of two transactions GGB0/GGB1 respectfully.
Within the transaction if accessed the menu panel Environment – Directory one can select the level of detail and display an entire collection of all the rules that exist in the system.
27
Jun
2011
SAP: scan ABAP programs
Useful little program that can help you scan other SAP programs RPR_ABAP_SOURCE_SCAN.
22
Nov
2010
SAP: transport classes
If you know how to transport copies of objects then you are half way there. So a quick and easy way to figure out what to put in to your transport [Change Object List] perform the following steps:
- go to SE24
- type in your class name
- click Goto – Object Directory Entry
At this point you should see your object definition entries: R3TR – CLAS – <CLASS NAME>. Grab that and move your transport.
14
Nov
2010
SAP Portal [object is currently locked by user]
If you are working with an SAP portal and get to a point that you are unable to edit an object because it is locked by a user [most likely your own user] you have the option to release the lock by performing the following action:
- Select System Administration
- Select Monitoring
- Expand Portal menu on the left hand side
- Select Object Locking
- Select the locked object and click the Unlock button
8
Nov
2010
ABAP Runtime Analysis – variant setup
Runtime analysis can be used to quickly get to the bottom of which tables are referenced during a transaction/program/function-module call.
I like running SM30 over ST22 because you get a nicer presentation of what tables were hit. ST22 tends to bee too detailed in majority of my scenarios.
By default the report is initialized with the DEFAULT variant. This is limiting and will not give you as much information as you might want. Typically on a new system I set up my own variant that allows me to access more information.
Steps to set up your own variant:
Select the drop down option in the Variant selector panel- Click the green check-box on the next screen without changing the parameters of the Selection Criteria for Variants pop-up
- You will be presented with two default Variants – DEFAULT and TMP; ignore those and click on the Create button
- Type in the name and continue
Here’s the most important part of this trick. When you get to the main configuration page of the variant go to the third tab [Duratn/type] and in the Aggregation pick the None option.- Once done click Save as… button and you are ready to run your Analysis.
7
Apr
2010
SAP tp: return codes
For each step that takes place within the tp command there could be 8 different possible return codes [0, 4, 6, 8, 12, 13, 14, 16]. The meaning for each of those codes is as follows:
Transport imported successfully:
0: Transport successful
4: Warning occurred
Transport did not import successfully:
6: Post-processing is required
8: Transport carried out with an error [individual object could not be transported successfully]
ex: objects could not be overwritten
Transport termination:
12 and greater: transport was terminated
28
Jan
2010
Microsoft Outlook Problem [inserted images are not displaying]
I ran in to a problem with my Microsoft Outlook application. Suddenly some [not all] embeded [not attachments] images in my inbound emails would not display.
I know the data was there for I could see the red box [representing an un-loaded image] and I could copy and paste the actual data in to a separate application like Microsoft Word [copying the image allowed me to see the whole file].
So as always I did some digging online and found a solution:
1. Locate the Outlook Temporary Items folder by opening the Registry and finding HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Outlook\Security. Double click on the OutlookSecureTempFolder key.
2. Right click the Value Data field and select Copy. It should be in the form of %USERPROFILE%\Local Settings\Temporary Internet Files\OLK6 where OLK6 is some randomly generated string that always starts with OLK.
3. Open Windows Explorer, paste in the Address field and press Enter (or select GO). You will be navigated to this folder.
4. Select All the files in this folder and Delete.
5. Launch Outlook. The images should now appear in the Email.
That fixed my problem.
12
Nov
2009
SAP: set a printer to print on a Single Side
By default SAP printers are set up to print pages based on printer’s default settings. To change that behaviour and control how the data is printed you can do the following:
- Execute transaction: SPAD
- Select your output device and enter the configuration screen
- On a 4.6C version you can go to the Output attributes tab and look at the “Output attributes for list drivers and Smart Forms” section
- Examine the drop down for the Print mode
- Typically by default you will see DEFAULT as the setting that is displayed, simply change the value to S SIMPLEX to allow the data to be prined on a Single Side
For more information on the matter for SAP version 7.0 you can have a look at this document.
29
Jun
2009
SAP: Favorites and Links
All information about user set up – like favorites and links – are stored in system tables.
So if you want to take a look how the information is layed out just hit se16 and take a look at the following tables.
SMEN_BUFFC: stores favorites informatoin
COLUMN-UNAME will display user name
COLUMN-REPORT will display transaction code
SMEN_BUFFI: stores user associated links
COLUMN-UNAME will display user name
COLUMN-URL will display the link of the address
6
May
2009
SQL: SELECT random number of rows
Here’s a quick way of requesting a random number of rows from a MySQL database:
SELECT * FROM <tablename> order by rand() limit <n>;
tablename: is the name of the table you wish to access
n: is thenumber of rows you wish to return
Be careful though, don’t use this logic on a database with a large record, the performance will be unpleasant.
