Procedure documentation Maintaining the SAPBWKEY Column Locate the document in its SAP Library structure

Prerequisites

You have completed the following steps:

Created a local copy of the Shapefile

Downloaded BW master data into a dBase file

Integration

The SAPBWKEY is maintained in the dBase file with the suffix .dbf. This file contains the attribute table.

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. From the C:\SAPWorkDir directory, open the cntry200.dbf file. The attributes table from the shapefile is displayed in an Excel worksheet.
  4. Repeat this procedure for the 0D_COUNTRY.DBF file that you created in the step Downloading BW Master Data into the dBase File. This file shows you which values from the SAPBWKEY are used for which countries.
  5. In the 0D_COUNTRY.DBF file, use the short description (0TXTSH column) to compare the two tables.

Note

ESRI delivers an ESRI BW map data CD. This CD contains the SAPBWKEY (corresponding to the SAP country key) for the characteristic 0D_COUNTRY. This is why the SAPBWKEY column in the cntry200.dbf file is already filled with the correct values.

You have to copy the SAPBWKEY manually to the attributes table in the shapefile:

Note

If you are working with compounded characteristics, copy the complete SAPBWKEY, for example, for region 01 compounded with country DE copy the complete value DE/01.

Do not under any circumstances change the sequence of the entries in the attributes table (for example, by sorting or deleting rows). If you were to change the sequence of the entries, the attribute table would no longer agree with the index and the geometric files.
  1. When you have finished maintaining the SAPBWKEY column, save the attributes table in the shapefile, in this example, cntry200.dbf.