List Creation and Maintenance in SAP BW 

Purpose

You can create and maintain external address lists in SAP BW  using this process. You acquire data (addresses and business partner details) from the external providers and use this data to acquire new business partners.

Prerequisites

Before creating and maintaining lists, make the following customizing settings for External List Management:

·          Define List Type

·          Define List Origin

Process Flow

1.       Maintain administration data for list

You enter the file name and path and maintain the basic details of the address list such as the list ID, list description, origin of the data, type of address list, the gross number of data records, the costs and permitted or recommended number of usages or duration of usages. A new list is created.

2.       Maintain format for mapping

Before the address data is imported from the file to the BW System, the structure of the file must be known to the system. For this, a new DataSource must be defined. The source system is a PC file.

3.       Upload list in SAP BW

After the DataSource has been defined with the structure of the file, the content of the file can be imported to the master data object 0ELM_GUID_I

4.       Check for postal correctness

You check the address data for postal correctness. The system scans through the address data and if the postal data is found to be incorrect or incomplete, the data is marked as erroneous and is not used for the creation of business partners.

5.       Check for duplicates

You check for duplicate business partners using the third party tool. The system scans through the data and if duplicates are found, the data is marked as erroneous and is not used for the creation of business partners.

6.       Select business partners in for target group

You create business partners within the Segment Builder if you create a target group which uses data from a list in SAP BW. If the data from this list is rented, the business partners created from this list get an appropriate flag (Rented). The flag is used later when you delete the list.

7.       Create target group

The target group is created in the Segment Builder.

8.       Delete list in SAP BW

The definition of a successful contact is usually set down in the contractual agreement. After the usage duration agreed in the contract lapses,  you delete the business partners who are marked as rented and were not successfully contacted.