Downloading BW Master Data into a dBase File 

Use

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 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 tabstrip. In the BEx Map area 0DSOLD_TO is shown as a dynamic geo-characteristic.

       5.      Choose Geo data download (everything).

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.      Transfer the file name suggested by the system and choose Transfer.

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 saved automatically in the SAP work directory.

Result

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