Show TOC

Downloading BW Master Data into a dBase FileLocate this document in the navigation structure

Context

The first step in SAPBWKEY maintenance for dynamic geo-characteristics and their geocoding is to download the BW master data table into a dBase file.

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 dialog box.

  2. In the InfoObject field, enter the name of the dynamic geo-characteristic that you want to geocode (in this example: 0D_SOLD_TO).

  3. Choose Display. The Display Characteristic 0D_SOLD_TO: Detail dialog box appears.

  4. Choose the Business Explorer tab page. In the BEx Map area, 0DSOLD_TO is displayed as a dynamic geo-characteristic.

  5. Choose Geo Data Download (All).

    Note

    If you only want to maintain those entries that have been changed since the last attribute master data upload, choose Geo Data Download (Delta). The geo-data has to be downloaded in the delta version before you execute the realignment run for the InfoObject. Otherwise the delta information is lost.

  6. The system asks you to select a geo-attribute that you want to include in the dBase file. The system only displays those attributes that were defined as geo-relevant. In this case, select both attributes: 0D_COUNTRY and 0D_REGION.

  7. Choose Transfer Selections.

  8. Transfer the file name suggested by the system and choose Transfer.

    Note

    The proposed file name is made up of the technical name of the characteristic and the .dbf extension. You can change the file name and create a directory. If you do not specify a path, the file is automatically saved in the SAP work directory.

Results

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