Service Commands in Import and Export Scenarios

For key fields and the first field that has a commit among the fields of a detail table, the system adds service commands on the Mapping tab of the scenario you are creating on the Import Scenarios (SM206025) form or the Export Scenarios (SM207025) form. Service commands are commands that invoke hidden actions in the system, such as searching for the record by the key field, refreshing the form, and adding a new line to the detail table. The system automatically adds service commands to the scenario immediately before the commands that invoke them.

For example, suppose that on the Import Scenarios form, you are mapping the Type field of the Invoices and Memos (AR301000) form. The system automatically inserts a set of service commands before the mapping of the Type field: The <Key: DocType> and <Key: RefNbr> commands invoke search by the key fields, and the <Action: Cancel> command restores the default settings for the selected document type.

On the table toolbar of the Mapping tab of the Import Scenarios form or the Export Scenarios form, by default, the Show All Commands option is selected in the drop-down list, which means that you can view the service commands that the system automatically adds to the import scenario.

You can replace service commands with your own commands to change the default behavior of the system. For example, if you map the first field that has a commit among the fields of a detail table, the system adds the <Line Number>=-1 service command. That means that a new row is added for each new detail line. You can specify the needed line number in the <Line Number> command to modify the value of the previously imported detail line. Line numbering starts with 0.