Downloading BI Master Data into a dBase File (SAP Library

Downloading BI Master Data into a dBase File

Use

To maintain the SAPBWKEY column in the shapefile attribute table, you have to specify the corresponding BI country key for every row in the attribute table. As this information is contained in the BI 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 BI 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. The Display Characteristic 0D_COUNTRY: Detail dialog box appears.

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

4. Choose Geo Data Download (All).

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.

Note

If the Geo Data Download (All) 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.