Procedure documentation  Downloading BW Master Data into a dBase File Locate the document in its SAP Library structure

Use

The first step in the SAPBWKEY maintenance for dynamic geo-characteristics and their geo-coding 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 screen.
  2. In the InfoObject field, specify the name of the dynamic geo-characteristic that you want to geocode (in this example: 0D_SOLD_TO.
  3. Choose Display. You reach the Display Characteristic 0D_SOLD_TO: Detail screen.
  4. Choose the Business Explorer tabpage. In the BEx Map area 0SOLD_TO is shown as a Dynamic geo-characteristic.
  5. Choose Geo Data Download (Everything).

    6. 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 we defined as geo-relevant. In this case, select both attributes: 0D_COUNTRY and 0D_REGION.
  7. Choose Transfer Selections.
  8. 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. You can change the file name and create a directory. If you do not specify a path, the file is save automatically in the SAP work directory.

Result

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