Importing the Multiple materials and fields from excel from Local file system using BADI

[former_member188878]

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.