In this unit, we will cover some basic configuration and enhancements to support the Logistics Execution processes in SAP.
We will also cover the topic of Warehouse Controlling, which will show you how to display movement data.
Number Ranges
SAP uses number ranges to store various objects such as transfer orders and quants with a unique identification in the SAP database.
1. To complete the configuration for number ranges, navigate to the IMG, and follow the menu path:
Logistics Execution Warehouse Management Master Data Define Number Ranges
For this manual and demo purposes, we will step through the configuration for one of the number range intervals.
2. Click on the button to see the assignment of your plant number ranges:
Each item has a number range interval assignment. For example, let's look at the number range interval assigned to the Transfer Order for our plant.
3. Click the back arrow and then click the button.
4. Enter your warehouse number on the following screen and click on the button.
5. Review the number range interval assigned to the warehouse transfer orders:
6. Exit the transaction.
their own custom-developed code and integrate it into the SAP core code. SAP recognizes that every one of its customers has unique requirements and
business processes and provides these 'code exits' or 'code extensions' to them to make these modifications.
This manual is written for a functional audience; thus, we will use 'laymens' or 'non-developer' terms to describe how to use these enhancement programs. The functional team members (a.k.a Business Analysts, configurators, etc.) usually work with their developers (a.k.a. ABAP'ers) to implement the function modules and customer exits, but it is good for a functional person to know where these programs exist. It is always best practice to use configuration (changes in the IMG) to implement custom business processes, but sometimes, it is just not sufficient to simply use configuration to achieve your business process methods. A function module is a complete set of code to do 'something'. Each transaction in SAP is a function module, or a series of function modules. For example, SAP has function modules to create Transfer Orders. It is possible to copy the existing SAP 'Create Transfer Order' function module and modify it to meet your company's needs.
A customer exit is a section of code that resides within a function module. Within each function module, SAP has 'hooks' that point to customer exits and will run the code in the customer exit if that exit is activated. It allows you to branch, within a program, to a custom piece of code to do 'something' specific. For example, SAP provides customer exits within the 'Create Transfer Order' function module to select a specific set of transfer requirements for auto TOs.
The following is a reference of the commonly used function modules available in the Warehouse Management module of Logistics Execution:
Function Module Use
L_TR_CREATE_CHECK perform plausibility checks
L_TR_CREATE_UPDATE perform database updates according to plausibility checks
L_TR_CREATE perform plausibility checks and database updates
L_TR_CANCEL cancel plausibility checks and database updates
L_TO_CREATE_SINGLE Create a transfer order with one item L_TO_CREATE_MULTIPL
E
Create a transfer order with two or more items
L_TO_CREATE_MOVE_S U
Create a transfer order to move a storage unit
Function Module Use
L_TO_CREATE_MOVE_L SR
Initiate a stock transfer of storage units from an external system
L_TO_CREATE_TR Create a transfer order for a transfer requirement
L_TO_CREATE_DN Create a transfer order for a delivery L_TO_CONFIRM Confirm a transfer order
L_TO_CONFIRM_SU Confirm a transfer order for a storage unit L_TO_CANCEL Cancel a transfer order
L_TO_CANCEL_SU Cancel a transfer order for a storage unit L_REF_CREATE Create transfer orders using multiple
processing L_TO_CREATE_2_STEP_
PICKING
Create transfer orders for 2-step picking L_TO_CREATE_POSTING
_CHANGE
Create transfer orders for posting changes
The following is a reference of the commonly used,customer exits available in the Warehouse Management module of Logistics Execution:
Customer Exit Use
MWMTOAU1 Selection of TRs for automatic TO creation This task allows you to influence the selection of transfer requirements for the automatic creation of transfer orders. MWMTOAU2 Selection of TRs for automatic TO creation
via groups
This task allows you to influence the selection of transfer requirements for the automatic creation of multiple transfer orders using groups.
MWMTO001 Update own data after creating transfer orders
MWMTO002 Update own data after confirming transfer orders
MWMTO003 Customer-defined putaway strategy This task allows you to create and implement your own putaway strategy.
MWMTO004 Customer-defined picking strategy
This customer exit allows you to create and implement your own picking strategy. MWMTO005 TO-related underdelivery (shortage) MWMTO006 Storage-bin-related overdelivery
MWMTO007 Palletization and storage type search for putaway
MWMTO008 Storage type search for picking
This task allows you to create your own storage type search strategy for stock picking.
MWMTO009 Prevents deletion of TO items
This task makes it possible to prevent the deletion of transfer order items.
To view Function modules, follow the menu path:
Tools ABAP Workbench Development Function Builder Transaction Code: SE37
Click on to see the documentation of the function module.
To view customer exits, follow the menu path:
The documentation will give you a good overview of the purpose and use of the customer exit. For a functional person, this is all you really need to know about customer exits.
Warehouse Controlling
Logistics Information System (LIS) is used throughout different SAP modules:
Warehouse Management
Materials Management (Purchasing and Inventory Management)
Sales and Distribution
Production Planning (Shop Floor)
Plant Maintenance
Quality Management (Analysis and Reporting)
This section will focus on the use of LIS for the Warehouse Management module of Logistics Execution.
Once learned, the LIS tool is relatively easy to use, and it is quite useful for analysis and reporting. You can use LIS to evaluate actual data and create planning data. It also provides an Early Warning System where you can set parameters to “watch” and alerts that activate when parameters fall outside the acceptable limits.
Standard Analysis allows you to use the standard info structures for reporting and analysis. You can format and search the data in many different ways. You can also save an analysis and review it later to do historical comparisons. Use info structure S011 to access information about purchasing groups and use S012 to access information about vendors, material groups, and materials. To see the “data basis” (data included in the structure), complete the following tasks:
1. Navigate to the IMG, and follow the menu path:
Logistics – General Logistics Information System (LIS) Logistics Data Warehouse Data Basis Information Structures Maintain Self-Defined Information Structures
OR Transaction MC23
3. Click get to the following Info Structure pop-up menu:
To see only information structures that are relevant for Inventory
Management and Logistics Execution, go to the restrictions section and limit the selection to 03.
4. Select S090 (Purchasing) from the info structure column:
Key figures used in the Info Struct. S090. Characteristics are the parameters for which the key figures (quantitative amounts) are calculated in the
analysis.
You can also create your own info structures. It is easiest to copy from an existing info structure. All Info structures between S500 and S999 are custom info structures.
Standard Analysis Demonstration:
In this demonstration, we do the following:
Run a standard analysis using a variant
Save a standard analysis as a selection version
View the selection version
Run Standard Analysis using Variant
Let's run a standard analysis and look at the characteristics, key figures, and difference options in the Analysis screen.
1. To start the transaction, follow the menu path:
Logistics Logistics Execution Information System Warehouse Standard Analysis Putaways/Stock Removals
Or Transaction Code MCL1
screen below:
4. Click to execute the analysis.
On the Basic List screen above, warehouse 301 has had 5,034 lbs of materials removed from stock, 5,034 lbs of stock placed into stock, 11,100 pieces of stock removed, 11,100 pieces of stock placed into stock in the selected time period. 5. Double click on warehouse number 301 to drill down to the next level of the
analysis.
The Drilldown screen reveals the storage types that were utilized for the stock movements in the warehouse. At the top of the screen, you can see the top level of the analysis drilldown. The key values have not changed, just the
6. Click on and select Movement Type.
7. Click to switch to the movement type drilldown.
You now see that the characteristic is Movement Type, but you have now drilled into the Storage Type in addition to the Movement Type. Try switching the drilldown back to Storage Type, then double click on one of the storage types. This takes you to the data for that storage type only, and into the material(s). Each standard analysis is set up with a specific drilldown path that activates when you double click on the characteristic, but you can use the switch drilldown function to expand your characteristic selection.
Other options on this screen include:
Icon Purpose
Send the analysis via SAP Mail. Save to a PC file, like Excel. Switch to another info structure. Choose key figures.
Using Settings from the menu path, you can change the value display (percent or absolute), whether the analysis shows the characteristic
description and/or number assignment, and the column width. You can also save some of these settings.
SAPTip
When exiting the analysis, you are asked if you want to save your analysis.
You can save your analysis as a selection version and view it later. Think of it as a “snapshot in time” of the analysis you just ran.
You can also schedule your analysis to run and save the results as a selection version to be viewed later or sent to a distribution list. This is helpful if you have a large analysis with long runtime that has multiple viewers. You can schedule it during night hours and have it sent to a distribution list.
Save a Standard Analysis as a Selection Version
Click to save the analysis as a selection version and fill in the Selection version name and a Description field.
Click .
SAPTip
Another option to create a selection version is to use Transaction Code MCMO, which allows you to create a dynamic calculation for your Selection version with a Variant that you define. You can select your characteristics and key value, the distribution list, the periods to analyze, the characteristic display, and the column width.
SAPTip
You can also schedule the selection version using Transaction Code MCM8.
View the Selection Version
There are a couple of different options to view a selection version.
Using Transaction Code MCKO to see a list per info structure.
Using standard analysis.
The above example shows selection versions J001 and J002, which were created differently.
J001 was saved after executing a standard analysis. MCE7 is a standard analysis. From MCE7, you can click to view a list of selection versions saved for that standard analysis.
J002 was created using Transaction MCM5, Create Selection Version.
Standard Analysis Exercise
In this exercise, we analyze the transfer orders (putaway and picking) that you created in Unit 1 of this Logistics Execution course; we save that analysis as a selection version; and finally, we view the saved selection version.
Menu Path:
Logistics Logistics Execution Information System Warehouse Standard Analysis Putaways/Stock Removals
Or Transaction Code MCL1
1. Enter the following parameters on the selection screen:
Field Value
Storage Location 0301
Month Current and Previous month
2. Practice navigating through this screen by drilling into the Warehouse information.
What is the weight of removal for storage type 916? ___________________ Switch the drilldown to Movement Type.
What movements types are represented? ___________________ Change the characteristic display to Key and Description.
What is the description of the Warehouse? __________________ Change to Info Structure S094.
What changed? _________________ 3. Save the analysis as a selection version.
Field Value
Selection Version Y0XX
Description Selection Version Group XX
4. Using Transaction MCLI, view the selection version. Do you see yours? __________________
If not, why not? _____________________
5. Using Transaction MCKO, view the selection version. Do you see yours? ________________
Logistics Exec uti on