Mass Data Update

[Former Member]

Hi All,

I have a requirement to update some lakhs of records for a single field.

What would be the best possible way to do this.

Manually or through API's.

Please suggest.

Thanks

AJ

[former_member189669]

Hi Amruta,

Best way to do this is to create an import map and perform a manual import from excel file.

Eg. Say you are importing 1lakh customers.

1.Create a list of customers in an excel in a column.

2. Have the values to be updated for each customer in adjacent column.

3.Connect to excel from import manager.

4.Create map for the two fields.

5.Add Customer number as Matching record (assuming it is unique).

7.Select default import action as Update mapped fields

8. Perform import.

For all the customers, you ll have the missed values updated.

Suggest you try this method for sample records of 10customers and verifyfor correctness of map.

Then go for bulk updation.

Please let us know if this was successful.

Regards,

Vinay M.S

[Former Member]

Hi,

I am aware of the manual process,i wish to know how good it is to do this through API's.

and which one is a better option in my case.

Also i wanted to know,Does ABAP api works either ways.i mean to push a records from MDM to ECC and vice versa?

Thanks

AJ

[Former Member]

Why don't you use MDIS?

It's best to leave it running in background...

[former_member189669]

Hi Amruta,

Hi Amruta,

It is possible to update records in MDM using ABAP API also . Make use of API - ' Update_Simple'.

A structure needs to be created in R/3 in which data is passed to API.

Note that the Field names have to be same as the codes in MDM structure .For eg. MDM Field code is 'Name' corresponding field in structure has to be 'Name' .And, this is case-sensitive. The field must have required API type.

Eg .[Field] Name (Single-valued) API Type: TYPE= MDM_PERSONNAME

API 'Update_Simple' Parameters to be defined are :

IV_OBJECT_TYPE_CODE: Table code; Character based, non language dependent unique

table descriptor

IV_INTERNAL_ID: Internal record

IS_DDIC_STRUCTURE: Any DDIC structure

An Example :

CALL METHOD lr_api->mo_core_service->update_simple

EXPORTING

iv_object_type_code = Customers

iv_internal_id = lv_key

is_ddic_structure = ls_record_data.

Above API executes Push method by passing data from ECC to MDM .

An API 'retrieve_simple' executes Pull functionality by retreive data from MDM to ECC.

Regards,

Vinay M.S