At the top of the Mapping screen are all the SAP fields that were touched during the recording. At the bottom of the screen is a preview of the Excel worksheet or other data file.
To upload data to SAP, drag an Excel column from the Data Source Preview to the row containing the SAP field.
Specifying the mapping for individual fields may help you to be more precise in mapping than dragging columns. Select the field, and then under Mapping Type for that field, click the arrow. Click to upload or download.
XML upload to SAP
Access upload to SAP
Excel upload to SAP
You can name your scripts in any way that allows you to easy recognize them. However, we suggest that you add the following to your file names:
When you create a script, you can ensure that anyone who runs that script first validates the data in the accompanying data sheet before posting it. With validation included in the script, you do not need a separate validation sheet. Validation is off by default and must be turned on in the mapping screen.
Any validation errors appear in the validation log column of the data source sheet. You map the column to the row you want in the mapper.
Important: Before you turn validation on, be sure that the script contains only one commit code and that the commit code appears at the end of the script.
A commit code represents any kind of save action. Example commit code values include =BU and =SICH.
If a transaction script contains more than one commit code, some of the data might be committed to SAP during validation. This has been fixed in Studio v11.0.2.
To turn validation on or off
After selecting a particular destination type user can undo any step performed in mapping. The number of levels of undo is unlimited.
To undo mapping
You can undo all your recent mapping changes by clicking the Undo All button that is available on the Edit tab. Note that Undo All undoes only those changes that could be undone with individual clicks. To make Undo All available again, you must make a change to the file. You are prompted to ensure that you want to undo all changes.
Changes are permanently saved only when you click Save or Save As. When the file is saved, Undo and Undo All are no longer available.
Mapping can be changed, even after the script has been saved. On the Mapping pane, click Update mapping.
Sometimes values required by an SAP screen are not available from your data sheet or an SAP screen does not appear even though you have data to upload for that screen. Settings on the Properties slide-in enable the transaction to continue in these situations.
To enable a transaction to complete regardless of data or screens
Skip Screen If Not Found: Select this check box for screen fields to ensure that a transaction is completed whether the screen appears during the run or not. If a screen appears during a Transaction, the appropriate data is uploaded. If a screen is not used, the transaction continues. With this setting, one script can be used for all runs of a transaction.
Skip screen does not work for individual line items. If skip screen is inside a loop, either it applies to all line items or to none.
Skip Transaction If Empty: You can select this property for each field that requires a value in the data source. In your data sheet, you add an indicator symbol to tell TRANSACTION to skip the field, usually a backslash "\". In the Advanced Run Options slide in, you turn on the functionality by specifying the indicator symbol and selecting the check box. For more information, see "Advanced Run Options" in the TRANSACTION Advanced User Guide.
Also in this section