Defining SAP data extract files

You can access SAP data extract files on your local computer or a network drive, or from a folder located on an ACL Server (if installed). The SAP data extract files imported using this method must be output using the SAP Audit Format (formerly known as the SAP Private File Format).

To create an ACL table from a SAP data extract file:

  1. Select File > New > Table.

    The first page displayed in the Data Definition Wizard depends on your configuration. If integration with ACL Server is enabled the Select Platform for Data Source page is displayed, otherwise the Select Local Data Source page is displayed.

  2. Complete one of the following steps to select the location of the file:
    • If the Select Platform for Data Source page is displayed and you want to use ACL to define the file, select Local and click Next. In the Select Local Data Source page select Disk and click Next.

    • If the Select Platform for Data Source page is displayed and you want to use an ACL Server to define the file, select ACL Server and select the server profile from the drop-down list, and then click Next. In the Select ACL Server Data Source page select Flat Files and click Next.

    • If the Select Local Data Source page is displayed select Disk and click Next.

  3. In Select File to Define, locate and select the file you want to create the ACL table from and click Open.
  4. In the Character Set page, verify that the correct character set option has been selected and click Next.
  5. In the File Format page, verify that the SAP private file format / DART option has been selected and click Next.
  6. In the SAP Private File Format page, select the appropriate option for field naming:
    • Use local language field descriptions as ACL field names – Select this option to use the localized field descriptions configured for the SAP ERP system, instead of the standard German language field names. This option is recommended if the ACL table will only be used in a single language.

    • Use standard-delivered SAP German abbreviations as ACL field names – Select this option if you prefer to use the German field names, or if the ACL table will be used in multiple languages.

  7. Click Next.
  8. In the Save Converted SAP File As dialog box, enter the filename and modify the folder location for the ACL data file, as necessary, and click Save.
  9. In the Final page, verify the settings for the new ACL table and click Finish.
  10. Enter a name for the ACL table you are adding to your project and click OK.

Section contents



(C) 2013 ACL Services Ltd. All Rights Reserved. | Send feedback