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.
SAP B1 Academy Editorial
Published • 2 min read
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:
CardCodefor Business Partners,ItemCodefor 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
- 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. - Edit the values in Excel, then save as tab-delimited text or CSV, keeping both DTW header rows.
- In the DTW wizard, choose Update existing objects and clear Add new objects, so a typo in a key cannot create a duplicate record.
- Run a simulation with Test run enabled and read the log for every rejected line.
- Run the real import, then re-run your export query and compare the results with your edited file.
Typical Use Cases
- Payment terms: update
PayTermsGrpCodefor a customer group after a credit policy change. - Sales employee reassignment: change
SalesPersonCodewhen territories are realigned. - Item properties and groups: update
ItemsGroupCodeor property flags for a new catalog structure. - Prices: use the Items Prices child file (
Items_Prices) withPriceListandPricecolumns 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.
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.