Skip to Content
avatar image
Former Member

How to delete data in a field with - MASS DATA MAINTENANCE

Dear SAP-Community,

we have made entries in a field within many hundred customers.

Now we want to change some of this entries. Changing (and adding) of entries is no problem.

However we also want to delete some of these entries in some customers. How can we do this? (It did not work, if we try to import an empty field.)

Best regards

P

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Feb 15, 2017 at 10:38 PM

    Dear Phil,

    That isnot possible with mass data maintenance, because if you have empty entries in the csv column this same column is not considered on migration. It is like that column doesnt exist.

    Like you said, if you have entries in the column ( adding or changing) works fine. I suggest and you should use the migration tool for that and in the property set to Replace already existing records (Migration mode to overwrite existing records completely with data from the source file that has the same ID. New records are added. Any previously imported information in fields that are blank now, is lost. You can use this, for example, to overwrite master data before Go Live).

    BR,

    LM

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Dear Luciano, thank you for your reply. One more question: What happens to existing fields that are not mentioned in the Migration file? Will they be deleted in C4C or remain? Thank you in advance! Phillip

  • avatar image
    Former Member
    Mar 08, 2017 at 09:55 AM

    Dear Luciano, thank you for your reply. One more question: What happens to existing fields that are not mentioned in the Migration file? Will they be deleted in C4C or remain? Thank you in advance! Phillip

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Just to inform that we can delete some data trough DWB. To perform that we need to set the column = tobedelete = true according to specific objet id. To understand that please have a look into how to work with data workbench feature.