SAP Knowledge Base Article - Public

3296065 - What is the difference between Update, Upsert, Import Complete Object and import Individual Object


You want to know the difference about the several actions available under Data workbench.


SAP Cloud For Customer.


  •  Update:

Overview: Update existing data using object IDs. Use an exported data file to update.
Context/When to Use: To update previously imported data.

For update of Individual Object, you can export existing data into a data file and use the data file to update.

  • Upsert

Overview: Data with new external keys is created. Existing data is updated.

Context/When to Use: Use upsert when it’s unclear if previously imported data exists.

  • Import Individual Business Object

Overview: Imports data into a specific business object or a specific child item.

Context/When to Use: To import data into a business object and its child items. Example: Opportunity/Opportunity Item/Revenue Plan Reporting.

  • Import Complete Business Object

Overview: Imports all data into a business object.

Context/When to Use: To import additional data or add a child item to a previously imported business object.

See Also

Help Portal


Actions; Data workbench; Update; Upsert; Import; Complete Business Object; Individual Business Object. , KBA , LOD-CRM-INT-DWB , Data Workbench , How To


SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications 2202