Map fields manually to an Access database file - Automate_Studio - Latest

Automate Studio with Studio Administrator User Guide

Product type
Software
Portfolio
Integrate
Product family
Automate
Product
Automate > Automate Studio
Version
Latest
Language
English
Product name
Automate Studio
Title
Automate Studio with Studio Administrator User Guide
Topic type
Administration
Overview
How Do I
Installation
First publish date
2018
ft:lastEdition
2024-03-11
ft:lastPublication
2024-03-11T17:14:05.914572

map step of record map run process

If your script includes a loop, you need to map the fields manually, using separate tables for the header and line item.

Tip: Tips: If you are using a new, unnamed database file, you can also map fields by dragging them to the Data Set panel. Then change the mapping direction to Upload to SAP for the fields that you want to upload. If Access has been configured incorrectly, Studio may crash when you click "Start Access." Configure Access correctly to resolve the issue.

Map fields

  1. In the Data Set panel, click Add Column.
  2. Click the Map to box, and click the field that you want to map.
  3. Studio automatically updates the field name.
  4. Choose the mapping direction.
  5. Click OK.
  6. Repeat until all the fields you want to include are mapped to the data file.
  7. Be sure to include the RUN LOG field.
  8. Click the File tab, click Save, and save both files.

Enter the data

  1. Click the Map tab, and then click Start Access to enter the data in the Access database file.
  2. After you enter the data, save the data file and close it.
  3. In Studio, in the Data Set panel, click the folder icon and open the data file.
    Tip: If you are using a new, unnamed database file, you can rename or delete a table: Right-click the table name in the Data Set panel, and then choose the option that you want.

For instructions on adding a loop in Access, see Add a loop in Access.

After you map the script, the next step is to Run: Upload the mapped data to SAP.