Please download the dossier by clicking on the dossier button x
×

Set-based data importation into an enterprise resource planning system

  • US 20070220027A1
  • Filed: 03/17/2006
  • Published: 09/20/2007
  • Est. Priority Date: 03/17/2006
  • Status: Active Grant
First Claim
Patent Images

1. A method of importing data in an enterprise resource planning system from a source table in a first system to a target table in a second system comprising:

  • receiving data records organized within rows of a first table, wherein the first table comprises a first record identification reference column comprising one or more record identification references, wherein a record identification reference of the first record identification reference column relates a first data record of the first table with a record identification of a second data record;

    assigning a new record identification to the second data record during importation of the second data record to the target system; and

    executing a database query on the entire first table to merge the data records of the first table with a first target table within a target system, wherein executing the database query to merge the data records comprises;

    merging data records of the first table with the first target table; and

    updating each record identification reference of the first table to relate the corresponding data record of the first table with a record identification of a data record within the target system; and

    relating the updated record identification reference of the first data record of the first target table with the new record identification of the second data record.

View all claims
  • 2 Assignments
Timeline View
Assignment View
    ×
    ×