Back to Tutorials
DTW & Migration•2 min read
TUTORIAL • OPEN

Mass-Updating Existing Master Data with DTW (Without Breaking Anything)

Change price lists, payment terms, or item properties for thousands of records using DTW update mode. Includes the minimal-column technique.

SB1

SAP B1 Academy Editorial

Published • 2 min read

Save
Bulk master data maintenance in a spreadsheet.
Bulk master data maintenance in a spreadsheet. (Image source: SAP B1 Academy Lab)

DTW is not only a go-live tool. It is also the fastest safe way to change hundreds or thousands of existing Business Partners or Items at once, such as new payment terms after a credit review, or new item properties for a catalog restructure.

The Minimal-Column Technique

When DTW updates a record, it writes every column present in the template. Blank cells can overwrite existing values. The safest approach is therefore to delete every column you are not changing and keep only:

  • RecordKey: a running number for DTW's internal linking.
  • The primary key: CardCode for Business Partners, ItemCode for items.
  • The fields you actually want to change.

A file with three columns is far less risky than the full 200-column template.

Step-by-Step Update

  1. Export the current data with a query (for example SELECT CardCode, GroupNum FROM OCRD WHERE CardType = 'C') so you have a backup and a starting point.
  2. Edit the values in Excel, then save as tab-delimited text or CSV, keeping both DTW header rows.
  3. In the DTW wizard, choose Update existing objects and clear Add new objects, so a typo in a key cannot create a duplicate record.
  4. Run a simulation with Test run enabled and read the log for every rejected line.
  5. Run the real import, then re-run your export query and compare the results with your edited file.

Typical Use Cases

  • Payment terms: update PayTermsGrpCode for a customer group after a credit policy change.
  • Sales employee reassignment: change SalesPersonCode when territories are realigned.
  • Item properties and groups: update ItemsGroupCode or property flags for a new catalog structure.
  • Prices: use the Items Prices child file (Items_Prices) with PriceList and Price columns to update a specific price list only.

Safety Checklist

  • Always run updates in a test company copy first.
  • Schedule large updates outside business hours. DTW holds locks while it writes.
  • Keep the original export, the edited file, and the DTW log together as your change record for auditors.
Complete Consultant Toolkit

The Ultimate SAP B1 SQL & HANA Query Cookbook

Instant-download PDF playbook plus ready-to-import .sql files for Financials, Inventory Audit, Sales Margin, and Approval Alerts.

Get it ($29)