This document explains how to handle multiple recordings in LSMW when uploading mass data to transactions that have multiple access sequences, such as pricing and freight conditions. It provides step-by-step instructions for creating recordings for each access sequence, mapping source fields to target fields, and selecting the appropriate recording during conversion based on the data in the source file. Executing the conversion will then populate the correct access sequence screen according to the data. This allows efficient mass uploading of data to transactions with multiple configurable sections.
This document explains how to handle multiple recordings in LSMW when uploading mass data to transactions that have multiple access sequences, such as pricing and freight conditions. It provides step-by-step instructions for creating recordings for each access sequence, mapping source fields to target fields, and selecting the appropriate recording during conversion based on the data in the source file. Executing the conversion will then populate the correct access sequence screen according to the data. This allows efficient mass uploading of data to transactions with multiple configurable sections.
This document explains how to handle multiple recordings in LSMW when uploading mass data to transactions that have multiple access sequences, such as pricing and freight conditions. It provides step-by-step instructions for creating recordings for each access sequence, mapping source fields to target fields, and selecting the appropriate recording during conversion based on the data in the source file. Executing the conversion will then populate the correct access sequence screen according to the data. This allows efficient mass uploading of data to transactions with multiple configurable sections.
This document explains how to handle multiple recordings in LSMW when uploading mass data to transactions that have multiple access sequences, such as pricing and freight conditions. It provides step-by-step instructions for creating recordings for each access sequence, mapping source fields to target fields, and selecting the appropriate recording during conversion based on the data in the source file. Executing the conversion will then populate the correct access sequence screen according to the data. This allows efficient mass uploading of data to transactions with multiple configurable sections.
Download as DOC, PDF, TXT or read online from Scribd
Download as doc, pdf, or txt
You are on page 1/ 22
Handling multiple recordings in LSMW
By Dhanalakshmi Dhivanand Target Audience: The readers must be able to create LSMW and they should be familiar with ABAP report programming. Purpose of this tutorial: This Blog explains on how to use Multiple Recordings in LSMW. This is applicable for the transactions which has multiple access sequences like VK11, TK11, etc. (Pricing Conditions, Freight Conditions, etc.) Introduction: LSMW is the SAP provided plug-in, in which users can upload mass data. If the requirement does not suit the standard available programs in SAP LSMW, users can create their own recordings for the transactions through LSMW recording. TCODE: LSMW Create new Project, Sub Project and Object:
Main Screen: Step 1: Maintain Object Attributes Execute Maintain Object Attributes step and create the recording. In this example, let us create Pricing conditions for the condition type, which has 2 access sequences.
Select Batch Input Recording radio button and click on the Overview button as shown in the below screenshot.
From the appearing screen, click on the Create button to start with your recording.
Name the recording and its description.
Give the entries as below
Press Enter, you will get a pop up, where you can enter the transaction code.
This Condition type has 2 access sequences.
1. Select the first radio button and press Enter.
Provide values and click on save in VK11 transaction for 1st access sequence. Sample input is given in the below screen for recording.
When the transaction is saved, Batch input recording screen appears as shown in the below screenshot.
Click on Default ALL button, you will get the corresponding FIELD name and description for the recorded parameters. Save it.
Recording for the first Key combination (Radio Button) has been completed
2. Create recording for the 2nd access sequence as follows.
The difference between 1st and 2nd access sequence is the number of fields. In the 2 nd access sequence, Sales Document Type is the difference. Click here to continue...
Please send us your fee
Handling multiple recordings in LSMW
...Previous Below is the sample data for recoding
Click Default All to map the field name and description for all the recorded parameters.
Save it. Now recording is done for the second Key Combination(Radio Button)
Go back to the Object Attributes screen and enter the recording names in Recording field as show in the below screenshot.
To add multiple recordings, click on Interval button
Press Enter and Save it.
Step 2: Maintain Source Structures Go back to the main screen and create the source structure.
Place the cursor on Source Structures and click on Create button.
Save and click on Back button
Step 3: Maintain Source Fields
Click on the Table Maintenance button and add fields to the source structure.
Add fields as shown in the below screenshot.
Below is the list of fields created so far.
Save and Go back to the Main Screen
Step 4: Maintain Structure Relations
Click here to continue...
Handling multiple recordings in LSMW
...Previous Place the cursor on each source structure and click the Create Relationship button. Mapping will be done as show in the below screenshot.
Save and Go Back to the main screen.
Step 5: Maintain Field Mapping and Conversion Rules Click on Extras Auto-Field Mapping to map the source and target structure fields. (This works when both source and target structure fields are in the same name).
Double Click on AUART field, in the appearing field editor, write the below code.
SKIP_RECORD transfers the control to next recording.
Based on the data the recording will be selected in this step. Save and go back to the Main screen. Step 6: Maintain Fixed Values, Translations, User-Defined Routines This Step is Optional. No need to give any value in this step.
Step 7: Specify Files
Specify the file which has data in this step.
Save and Go back to the main screen.
Step 8: Assign Files
Place the cursor on source file and click on the Create Assignment button.
Save and go back to the main screen
Step 9: Read Files
In this step, all the data will be read from Presentation server.
Execute it.
Step 10 : Display Read Data
Go back to the Main screen
To ensure that all the data have been read properly, execute this step.
Step 11 : Convert Data
This step will actually executes the conversion program, which was done in field mapping step.
Click here to continue...
Handling multiple recordings in LSMW
...Previous Step 12 : Display Converted Data
The converted data appears as shown in the below screenshot.
Step 13 : Create Batch Input Session
Click on Execute Button. The below application server path has the converted data.
Step 14 : Run Batch Input Session
Execute the below Batch input session.
Select the session and execute it in foreground.
According to the data, first access sequence is selected and data is filled in the screen as shown in the below screenshot.
Save the transaction.
The second record in the attached text file, is for the 2 nd access sequence. According to the data, second access sequence is selected.
Sample Data: Click here for the test data used. Summary: As a result of this tutorial, the user will be able to
Create multiple recordings in LSMW
Switch to the appropriate recording according the data from the flat file.
Cond.Type SELKZ Val.From ZSAL X 1000 12/31/9999 ZSAL X 1000 12/31/9999
