Skip to Content
avatar image
Former Member

Duplication of records

Hi All

How can i validate while importing data whether records are existing or not.If its existing i should not upload.

Please suggest

Regards

Sandeep

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 18, 2012 at 09:10 AM

    Hi Sandeep,

    I am assuming that you are asking above query to identify duplicate records while importing records through Import Manager or MDIS.

    When you create a map in import manager, you specify "Matching Fields" under "Match Records" tab in Import Manager. So based upon the matching fields, system will identify already existing records.

    On right hand side, in Match Records tab only, you can specify default import action "Set Default Import Action".

    Here, Match type 'None' means that records are not already existing in the system. You can select import action as "Create" here.

    Match Type 'Exact' means that records are already existing and the record in your source file is duplicate of some record in the destination table. For such match type, you can set Import action as Update or Skip(won't touch already existing records) as per your requirement.

    I hope this solves your doubt. Kindly let me know if you have any more queries.

    Thanks and Regards,

    Ankush

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      HI Ankush

      I have done it already i just wanted to check if anything else which pops up as an error when we enter a record which is already present in the table

      Regards

      Sandeep

  • avatar image
    Former Member
    Sep 18, 2012 at 08:34 AM

    Hi Sandeep,

    You can compare your existing records with standard tables in SAP,

    for example , if you are all the records are in internal table means,

    anyway its having primary key's,based on that you can neglect the existing records.

    Regards,

    Bastin Vinoth NG

    Add comment
    10|10000 characters needed characters exceeded