Mass Processing Overview

Mass Capabilities using MDG

 

·       We can Initiate mass processes on both the system MDG and MDC.

·       In Both cases it will create Mass process CR in MDG.

·       After CR got submitted, we will have the same Workflow like it have for single object processing in MDG.

Application we have in MDG for Mass Processing

·       File Upload/Download

·       Mass Changes

·       Data Import Framework

Mass Change

·       For example, if we want to change the authorization group to XYZ for all the material starting from M1 to M500.

·       To do this, go to search application and then select the Materials which we need to change and then click on Mass change button.

·       Then the application will show the selected material where we can delete or reselect the materials.

·       After next, it will show all the attributes.  Provide value which we want to change.

·       It will show us the confirmation screen showing the current values and changed value.

·       After pressing Execute changes, it will ask for the CR types.

·       All CR will come which having business activity for mass changes. 

File Upload and Download

·       There are two application 1. File Upload 2. File Download

·       Using File Download application, we can download one sample record with all the list of attributes.

·       So, here we get perfect template to upload the data.

·       First, we will see file download, on Fiori launchpad we will have application File download.

·       We can download or upload data based on Entity. So, we need to select entity first.

·       After Selecting entity click on next then we need to select object like take an example we are downloading material then we need to select material number or range or based on other parameters also we can download that particular materials.

·       After that, in define file structure, select data row in selected option (left hand side) and at right hand side we need to select attributes which we want to download. Here we need to select key field as mandatory.

·       If we select Header in Selected option then in downloaded file the data will group by key field. So, its recommended to use Data row only.

·       If we want to exclude some attribute from upload then in Process modelling there is option called define governance scope in which we can exclude that particular attribute and it will not upload in the MDG system though user can give values in file.

·       If we just don’t want to keep any attribute in the file upload/download UI screen then we can go to UI modelling and then Define Filed properties for UI.

·       So here we can select the entire entity or else we can select particular attribute from the entity. Here ‘No Selection’ means it won’t be a part of selection screen.

·       After that we can click on Next. There one option there called conversion which will do conversion on data like adding leading zeros.

·       In Separator we will use Tabular format mostly. Comment symbol you can give so in download we can add comments to our file.

·       After next, it will show you and summery and you can save the variant so in future we can use that same setting to download files again.

·       The file will be download in text format only. Further we can copy the data into excel and can change the values.

·       After that we can upload this file. To do so, in fiori or nwbc there is an application called file upload.

·       In this application the selection criteria option will not be there.

·       We need to select the attribute in perfect sequence which are there in our text file. Here we can use saved variant so that the same setting can be applied to this.

·       In Upload Mode there are two options 1. Overwrite and Add Attributes 2. Add Rows

·       Second option will be display for SU type 4.

·       For first option it won’t add new rows it will only update the previous values.

·       In File Upload we cannot create new data. We can only modify existing data.

·       In SU type 4 we can rows. Like for material we can add plant data. But we cannot add material.

·       After in check and execute it validate the data if there is any error it will show here.

·       If it doesn’t have any error then one popup will come where it asks for CR creation.

·       After ok it will create one CR for file upload.

Data Import Framework

·       This will be use as Initial load of data.

·       There are two option of loading data.

·       In first option will load the records directly into active area. In this we have one file which having records and will load that records into Active tables directly without MDG processes.

·       In Second option will load the data into MDG staging tables. Here will create mass CR for all the records. It will go through all governance process. All validation and derivation will get executed. After activation of data it will move into Active tables.

·       For loading data into SAP active tables, there are multiple options like LSMW, BDC, BODS, LTMC, IDOCS and Custom ABAP Programs.

·       In Direct load approach the data may be inconsistent and further we need to use some data quality rules.

·       The T-code for DIM is ‘DTIMPORT’. There we can see objects we can select. These objects will be DIF objects which will be linked with the SAP standard Business Objects.

·       This will always import XML file.

·       Let’s suppose that XML file have 100 material records out of which 80 records are existing records and 20 records are new one. Means 80 records are already present in active tables.

·       So, there is one checkbox called ‘Overwrite’ if we don’t select that, the system will assume that all the records are new one. If system found the record which is already there in system then it will ignore those records.

·       But if we select that checkbox then system will change that existing records which are already present in system.

·       So, in our scenario 80 records will be created newly and existing 20 records will get updated.

·       Now in right side there is UI section called Governance Settings. If we don’t select the checkbox ‘Governance’ then it will consider it as loading data into directly Active area.

·       For Data Import framework, the Business actively should be ‘MATB’ for material. Then those CR types will appear on the Governance section.

·       If we don’t select governance checkbox then the data will get load into active area directly which is first option. The second option is if we select the checkbox then it will go though the MDG processes which is second option.

·       The option 3 is, if we don’t select governance checkbox we can set the attribute ‘Post Processing’ as Defined by change request where we can give change request type. In this scenario, if we loading 100 records and if there are 10 records with issues like missing mandatory fields or something like that then for those record systems will create CR and for other 90 records which are error free is get load into active area.

·       After this we have option like ‘Scheduling Setting’. If we select ‘Import Now’ then the system will start process as soon as we start the process of importing. If select ‘Schedule Future Import’ then we can set the date and time so on that particular time the import will start.

·       Another option is ‘Parallel Processing’. If we don’t select the checkbox then system will run the task one by one sequential.

·       In we select the checkbox then we need to enter Queue name and no of processes which will be provided by Basis peoples.

·       In t-code ‘SMQ1’ they will configure that and create ‘bgRFC’ Queues and we need to give that queue name there. So, it will not hamper the other business queues.

·       After setting these all setting we can load the data file into system. Click on Add button which will show is sub-objects. Select object and in source path we need to provide the logical path name. Basis team will create this path. We can put our XML file into that path.

·       This logical file path will be linked to physical file path.

Creation of File path

·       T-code ‘FILE’.  Here we can configure our file name. under logical file name we will have physical file path name. in that something like <FILENAME> will be which indicate generic file name. Means it can have any name.

Backend Configuration

·       MDGIMG -> General setting -> Data Transfer -> Define Object types for Data Transfer

·       Here we can link DIF Business Object with SAP standard Business Object

·       We don’t touch here anything. Its already done by SAP.

·       Under each BO, we will have Detailed information in which there will be IDOC Message Type. Which means the XML file which is getting import into system by DIF should aligned with the XML generated by IDOC. So, we can download the template of XML from here and further we can add the data into XML files.

·       We can create one program which will convert Excel file into XML file and will store that file into logical system.

·       There will be Import class we called it as File Loader Class. This class have all the logic to read data from file and create CR and load data into active area. In this class the ‘Load’ method will be.

·       If we don’t want to create that XML and all then SAP has provided one BADI under the path

·       MDGIMG -> General setting -> Data Transfer -> BADI: Creation of File Converter for Data Import. In this BADI we can select the file from application server which is tabular separated or Comma separated files and there we can write logic to convert the data into EDIDD structure which is IDOC format.

·       In this BADI we will give Converter in Filter.

·       So, in DIF UI screen there will be one button on top called ‘Select Converter’ where we can select that filter converter and according to that the BADI will get executed.