Downloading BW Master Data into a dBase File (SAP Library

Downloading BW Master Data into a dBase File

Use

To maintain the SAPBWKEY column in the shapefile attribute table, you have to specify the corresponding SAP BW country key for every row in the attribute table. As this information is contained in the BW master data table, you have to download it into a local dBase file to compare it with the entries in the attribute table and maintain the SAPBWKEY.

Prerequisites

You have created a local working copy of the shapefile.

Procedure

...

1. Log on to the BW system and go to the InfoObject maintenance screen (transaction RSD1). This takes you to the Edit InfoObjects: Start screen.

2. In the InfoObject field, enter 0D_COUNTRY and choose Display. You reach the Display Characteristic 0D_COUNTRY: Detail screen.

3. Choose the Business Explorer tabstrip. In the BEx Map area, 0D_COUNTRY is shown as a static geo-characteristic.

4. Choose Geo data download (everything).

5. Accept the file name proposed by the system by choosing Transfer.

Note

The proposed file name is made up of the technical name of the characteristic and the .dbf extension; therefore, in this case the file is called 0D_COUNTRY.DBF.

This graphic is explained in the accompanying text

If the Geo data download (everything) pushbutton is deactivated (gray), there is no master data for the InfoObject. If this is the case, download the texts for the InfoObject manually to get to the SAPBWKEY.

Result

The status bar contains information on how much data has been transferred.

Note

If you have not specified a directory for the file name, the file is saved in the local SAP work directory.