Maintain Object Attributes
Set import method as "Batch Input Method" and record the batch input for MM01. Click on "Recording Overview" button to start recording.
Set recording name and transaction code.
Created recording. We will set material description, unit of measure, material group, material style and product hierarchy from text file input data. Industry sector and material type are set with default value.
You can maintain field names and default values of each field by double clicking on the field. Names will help you identify fields easily.
Maintain Source Structures
Set source structure name. This represent the row type of text file.
Maintain Source Fields
Complete the source structure by defining source structure (row type) fields. Easiest way is to select your source structure and click on "Table Maintenance". Now you can set field names, data type, length and description of each field.
Save fields.
Maintain Structure Relations
Since this project has only one source and one target, system will automatically assign them together. In a more complex projects you may have to manually assign them depending on number of source/target structures.
Maintain Field Mapping and Conversion Rules
Here we map source fields with target fields. That is input file structure with MM01 target.
Select a field and click on "source field" then select the source field.
Map all fields similarly.
Maintain Fixed Values, Translations, User-Defined Routines
We can skip these as we do not have any conversions for legacy data.
Specify Files
This step set how the legacy data is extracted. You can extract from front end PC or from application server location.
In this example we will upload from frond end PC.
Specify the file location, name and format. Set options depending on the field separator of import file and if field header exists or not.
Save go to next step.
Assign Files
Assign the source structure with the file specified in the above step. Since project only has one file and one source structure, system will automatically assign them.
Save and move to next step.
Read Data
Read data from file.
Display Read Data
Display data read from the file.
Save.
Convert data
Convert data on conversion rules defined. This step will map the source data to target fields.
Display Converted Data
Display converted data.
Create Batch Input Session
Set the BDC session name and create batch session.
You can view the created session in batch input overview transaction SM35.
Run Batch Input Session