Maintaining the SAPBWKEY Column

Prerequisites

You have completed the following steps:

Creating a Local Copy of the Shapefile

Downloading BW Master Data into a dBase File

Integration

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

Procedure

Launch Microsoft Excel and choose File Open...
From the dropdown box in the Files of type field, choose dBase Files (*.dbf).
In the C:\SAPWorkDir directory, open the cntry200.dbf file. The attributes table from the Shapefile is displayed in an Excel worksheet.
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.
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.

Copy the SAPBWKEY manually to the attributes table in the Shapefile

- if you are using a different country key

- if you are working with characteristics for which the SAPBWKEY column has not been defined, or is filled with invalid values

Note
If you are working with compound 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 the rows!) If you were to change the sequence of the entries, the attributes table would no longer agree with the index and the geometric files.
When you have finished maintaining the SAPBWKEY column, save the attributes table in the Shapefile, in this example, cntry200.dbf.