Preparing Changes with a Template File
Downloading and understanding the template, filling in values, the row actions, using your own spreadsheet, uploading, reading the findings, preparing large volumes.
Draft brief for authors. Section page.
Source in the product repository: docs/reviews/upload-and-download-template-review.md, the templateIntro* texts in i18n/i18n.properties, srv/lib/upload-limits.js, app/mdm100/webapp/i18n/i18n.properties.
In this section
- Downloading a TemplateDownload an empty template or one pre-filled with selected or all records, with the fields you choose, from Manage Master Data Objects.
- Understanding the TemplateThe sheets, the five header rows, the Introduction sheet, key and optional columns, and what you must not change.
- Filling In ValuesHow to write text, numbers, dates, times, yes/no, units and descriptions so that every cell is accepted, and what an empty cell means.
- Row Actions: Create, Change, Delete and SAP OperationsThe Action column decides what a row does in SAP: change a record, create one, delete one, or run an SAP operation such as Install; each kind sends different cells.
- Using Your Own SpreadsheetAny spreadsheet of the object is accepted: headers by technical name or label in any shipped language, the header row anywhere, no Introduction sheet needed.
- Uploading a FileUpload a filled template or your own spreadsheet; the upload becomes a Task you can check before anything reaches SAP.
- Reading the Upload FindingsAn upload reports every problem at once with the cell, the value found and what the field expects; nothing is uploaded until the file is corrected.
- Preparing Large VolumesHow to split files, choose parallel or one-at-a-time processing, use background runs and scheduling, and plan the quota for tens of thousands of records.
Last updated: