Procedure documentation Converting dBase Files into CSV Files Locate the document in its SAP Library structure

Prerequisites

You have completed the following steps:

Downloaded BW master data into a dBase file

Geocoded using ArcView GIS

Integration

The result of the geocoding is the dBase file Geocodierung_Result.dbf. This file contains the BW master data enhanced with columns X and Y. Since the attribute table is stored in dBase file format, you must convert it into CSV (comma separate value) format, which can be executed by the BW Staging Engine. You can convert the table in Microsoft Excel.

Procedure

  1. Launch Microsoft Excel and choose File ® Open.
  2. From the dropdown box in the Files of Type field, choose dBase Files (*.dbf).
  3. Open the file Geocoding_Result.dbf. The attribute table with the geo-attributes is displayed in Excel.
  4. Choose File ® Save As...
  5. From the Save as Type selection list, choose CSV (Comma Delimited).
  6. Save the table.

Result

You have converted the dBase file to a CSV file with the geo-attributes of the dynamic geo-characteristic 0D_SOLD_TO. You system administrator can now schedule a master data upload.

Note

When you upload the CSV file you must map the values in column X to the attribute 0LONGITUDE and the values in column Y to the attribute 0LATITUDE.