Functional Domain Tables
Here are a list of tables which you may find useful related to their domain.
SM12 – Lock Entries Tips
If you check SM12 you may find some lock entries – this is not a problem. Locked entries are required in standard SAP processing. In most instances the entry will remain in SM12 for a few seconds milliseconds, however they could remain in SM12 for a lot longer depending on the logical unit of work.
Factors which can impact the entry in SM12:
- Sizing and performance of the enqueue server.
- Sizing and performance of the application server/number of available processing sessions. (indirectly related)
- Program logic being executed on the application server.
What you may not know is that there is a hidden menu path for SM12 analysis. To activate this menu path you can do the following:
Run SM12, then enter OK code “test”. You will now see the top menu path has included a new Menu Option labelled “Error Handling”.
This menu option has many parameters and test functions which you can use to analyse the enqueue and dequeue processes.
If you require advice on how to use this new functionality you can refer to OSS note 5424 which is the SM12 FAQ! Success!
Download Sales Orders according to SH Party
Recently Asked: How do you download sales orders in SAP by ship to party address?
Its easier than you think:
You can easily do this in VA05.
When in VA05 change the Search parameter from Sold to Party to Ship To Party by selecting the “Partner Function” button Ctrl+F10. Then use the other selection parameters as required.
The resultant lists can be downloaded/exported from the ALV grid.
If you dont find SH partner function in in VA05,please add it in the below mentioned menu path
IMG–>SD–>Sales–>Lists–>Set updating of partner index
Add SH to Transaction Group ’0′.
Then you can get a report based on Ship to Party in VA05.
LIS SIS Update Analysis
Tip – You may be using LIS (Logistics Information Services) or SIS (Sales Information Services) and woudl like to analyse what structures are updated with what Key Figures and Characteristics, you can do that with these awesome transaction codes:
MC30 Update Log
MCE2 PURCHIS: Update Diagnosis Purch.Doc.
MCVCHECK01 SIS: Update Group Check
MCVR SIS: update diagnosis – order
MCVS TIS: Update Diagnosis: Transportation
MCVT SIS: update diagnosis – delivery
MCVV SIS: update diagnosis – billing doc.
SAP Tips – Information Structure Updates
If you wish to see which information structures have been updated from Sales or Transportation you can use the following transaction codes:





