23
Apr
2010
SAP: WE20 partner set up “Please enter a permitted partner number”
A new inbound IDOC failed to process with a “EDI: Partner profile not available” error.
I’ve attempted to set up a new partner but failed to do so due to the “Please enter a permitted partner number” error when using WE20 transaction and setting up a new LS partner.
A quick debugging session revealed that the program was checking a TBDLS table [Logical Systems].
After this I’ve simply used SPRO transaction to update the:
Spro – IMG – Basis Components – Application Link Enabling (ALE) - Sending and Receiving Systems – Logical Systems – Define Logical System
Add the new logical system and you will be able to set up the new partner now.
23
Dec
2009
SAP: STMS transport stuck
When coming across a situation where thetransprts are stalling/hanging in the STMS queue there are a few things that you can do:
The fist and most obvious course of action is to contact your Basis support team.
Given that you are reading this article you probably wanted or were forced to figure this one out on your own so here are a few helpful actions that you can take to narrow down the problem:
TP processes:
Go to the SM51 and check if any of the TP processes are still running, you might be required to kill these before proceeding haulted imports.
Check the TP System Log:
You can do this by STMS – Overview – Imports – Select Queue System – Goto – tp system log – F5
This will show you a step by step log of what has occured in the system, you would be able to see which transports are being processed and what has completed.
Check the Import Monitor:
You can do this by STMS – Overview – Imports – Select Queue System – Goto – Import Monitor
This will show you the queue of active transports [if any], if you see that there is a collection of unprocessed imports then you need to flush the queue.
Check TMS background job:
You can also check if the background job RDDIMPDP is running.
From tim to time it happens that the import queue becomes inconsistent and the system stalls, as a result you can be stranded without any of your transports moving ot he next system.
Tables:
TMSTLOCKR: will unlock a given transport from the transport queue [the transport truck will dissapear after deleting of the entry int he table]
TRBAT: will contain values correspondign to active imports, if you have a stuck transport that is haulting a collection of other transports a simple delete from this table will re-initialize the queue and push the backed up imports forward.
TRJOB: should also be cleared in order to continue the regular flow of backe up transports
For any additonal information please refer to the following notes:
818065, 302859, 556941, 556946, 71353, 49242, 323726, 56311, 24800, 486991, 506771, 138200
25
Nov
2009
SAP: deleted users [when/who]?
Actions that are done to a user profile, be that creation, modification or deletion are tracked in a table USH04.
The field PROFS will reflect each of the actions referencing the following characters:
A: add
M: modify
D: delete
Simply enter the user you are interested in and see what has occured over the year.
19
Nov
2009
SAP GUI: enable/disable input field history on text fields
This is sort of a usless but still somewhat interesting fact: I ran in to a problem where a user wasn’t able to see his history when he entered data in to his sap gui. It didn’t matter which field it was every time he would re-login he would not see the data he entered just minutes ago.
I did some reasearch and seen a lot of posts about SAPHistory*.mdb file in the SapWorkDir directory. The user’s history was was being generated so the problem was being caused by something else.
Then I came across a post talking about Low Speed Connection [Reduced Network Traffic] setting which can be found by going through your login pad, clicking on the system and displaying the properties window – followed by going to the Network tab. From what I’ve read it seems that having the setting set to Low Speed Connection could cause the problem of missing input field history. Even though this seemed promissing after getting the user to try a different machine with the High Speed enabled he was still showing the problem.
The final peace of information that I’ve aquired from the web was a little neat SAP feature: if you get to an input field and hold down your Ctrl button you can right click on your mouse and get a pop-up window that would allow you to Disable/Enable History functionality. Typically the field is set to Defaut Settings, so the only thing left to do was to figure out if the user’s default settings were set to Disable History for his SAP system.
to be continued…
PS: another interesting fact that I picked up somewhere: if you scroll up/down using your keyboard in the history field you can delete entries by pushing the delete key. I know, it’s neat.
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.
4
Aug
2009
SAP: List of tables pertaining to Transport Requests
| TABNAME | Description | |
| E070 | Change & Transport System: Header of Requests/Tasks | |
| E070A | Change & Transport System: Attributes of a Request | |
| E070C | CTS: Source/Target Client of Requests/Tasks | |
| E070CREATE | Change & Transport System: Creation Date of Request | |
| E070CTV | Generated Table for View E070CTV | |
| E070DEP | Change & Transport System: Dependencies of Requests | |
| E070L | CTS: Index for Assigning Numbers to Requests/Tasks | |
| E070M | CTS: Target Package/Layer for Requests | |
| E070TC | Help Table for E070 for Client-Specific Imports | |
| E070USE | Use of Current Requests by Users | |
| E070V | Generated Table for View E070V | |
| E071 | Change & Transport System: Object Entries of Requests/Tasks | |
| E071C | Change & Transport System: Client-Specific Lock Flag | |
| E071E | Lang. Transport: Positive List for Generic Object Selection | |
| E071K | Change & Transport System: Key Entries of Requests/Tasks | |
| E071KC | Change & Transport System: Key Entries of Requests/Tasks | |
| E071KF | Change & Transport System: Nametab Info. on (CHAR)Key Fields | |
| E071KFINI | Change & Transport System: Nametab Info. on (CHAR)Key Fields | |
| E071K_30 | Change & Transport System: Key Entries of Requests/Tasks | |
| E071K_KEY | E071K Key Fields | |
| E071S | System-Specific Import Status of Objects | |
| E071V | Generated Table for View E071V | |
| E07T | Change & Transport System: Short Texts for Requests/Tasks | |
| E07T_OLD | E07T Before TRKORR Extension |
Useful transport tables [listed above].
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
19
Mar
2009
UltraEdit Backup Files
I love workign with UltraEdit though there is one thing that always annoys me. Every time I update the contents of a file the program creates a backup file in the same directory. Well for those of you who run in to the same problem here’s how you go about fixing this issue:
Go to:
Advanced -> Configuration ->File Handling -> Backup
By default the configurations are set up to create a .BAK file in the same directory. Although the functionality is annoying I still think it’s quite useful. So the best thign to do [in my oppinion] is to populate the default directory field with the a directory somewhere on your local computer.
13
Mar
2009
When was the last System Refresh done in an SAP system?
To quickly check when your DEV/QA system was refreshed from a production box perform the following steps:
- Execute the transaction SCCL
- Fill in the Source Clinet filed [ie: 001]
- Select <Goto> <Log display> from the main menu
You should see a screen with a list of dates of when the system was last refreshed.
Other useful transactions:
SCC9: client copy – copy a client
SCC8: client export
SCC7: client import
SCC1: copy as per transport request
11
Mar
2009
AMFPHP + Flex 3 = Error [unable to open 'services-config.xml']
While trying to configure the AMFPHP set up with the Flex 3 framework I ran in to a problem while setting up the services-config.xml.
I’ve created the file in the root directory and specified in the Flex Compiler [Additional compiler arguments] the following string -locale en_US -services “services-config.xml”.
As soon as I clicked OK an error popped up with a message unable to open ’services-config.xml’. After trying varying things I was able to figure out that the problem was with the location of the file. Simply placing the file at the root of the directory wasn’t the right location. I needed to put the file in the same directory as the main MXML executable – after that the program worked as expected.
