Importing the Multiple materials and fields from excel from Local file system using BADI
This document help us to understand the process of loading the multiple materials with multiple fields using the material using the local and application server file system.It has help us lot to meet business expectations and hence sharing with you all.Please refere to the link How to… MDG-M: Use the Data Import Framework | SCN
1.Define file converter type to be used during the file import
Define the converter type ZIB
2.Creation of BADI for file converter and BADI for implementation
click on create BADI implementation for BADI BADI_MDG_FILECONVERTER for enhancement spot
Provide Enhancement Implementation name and short text
Provide the BADI implementation Name and class
add filter value ZIB
Copy the sample class this will copy the sample code which needs to be modify as per requirement
click on the create classes,it will open up the copied methods.
click on method IF_EX_MDG_FILECONVERTOR~GET_DATA to see the code
you can modified code as per your requirement take help of your technical team to add the code for more number of fields which you will import using CSV file from your local or Application
3.Importing the file using the webdynpro application MDG_FILE_UPLOAD_CMP, you can find this application in the role SAP_MDGM services folder adn you can add the same application for different roles.one can execute this application from NWBC work center or from roles as mention below.
execute the application as mention below,there are two options are available for import as shown below
we are moving with local file system.for importing the file from application you have do some additional setting like defining ports,fiel path as mention in configure document.We are focusing on import of material from local file system.
click on browse to select the file from application
select the fiel and click on add button to upload the file and Next..
it will Persistance choice 1,2 and 3.
1.will trigger the governance process with CR
2.will directly load the material in to active area.
3.it will send the error records to staging
in our case we are proceeding with 1 option and provide converter type ZIB as configure earlier.click next
provide the CR type MAT0B and click on next
click on start upload and click on next…
it will show you the generated CR number .know go to the NWBC click on my CR
it will display the CR which got created
once you open up the CR you have option to process the material one by on or process multiple ones.Activated the CR
the status of CR changed to final check and approved
go back to check in MM03 for the materials got created
I am attaching the sample file whic was give by SAP A-MATMAS.CSV for reference…still we are working on adding more number of fields and how they behave…but hope this will give some relief for us.