Show TOC

Function documentationDeleting External Lists in SAP NetWeaver BI Locate this document in the navigation structure

 

After completion of the agreed usage duration for an external list, or after the contractually allowed number of contacts has been reached, the data for the business partners who were not contacted must be deleted.

Features

  • It is currently not possible to delete master data physically in SAP NetWeaver BI if it is used in other objects (for example, InfoCubes). For this reason, the data in 0ELM_GUID_H and 0ELM_GUID_I is made anonymous, which means that the content is overwritten with blank spaces if it cannot be deleted.

  • If an address list was created in SAP NetWeaver BI and then transferred to SAP CRM during segmentation, this address list is also available in SAP CRM.

    If an address list was created in SAP CRM and then extracted to SAP NetWeaver BI, it is also available in SAP NetWeaver BI.

    If you exchange address lists between SAP NetWeaver BI and SAP CRM, you must delete the address lists in both systems.

    We recommend deleting the address list in SAP CRM first and then in SAP NetWeaver BI.

    The address data is stored in master data objects 0ELM_GUID_H and 0ELM_GUID_I. If business partners are created in SAP CRM and extracted to SAP NetWeaver BI, then this business partner data is stored in master data object 0BPARTNER.

    When deleting an address list, only the data from 0ELM_GUID_H and 0ELM_GUID_I is deleted.

  • If the addresses are only rented, then the business partners are indicated as rented. These business partners must also be deleted in 0BPARTNER.

    To do this, you must delete the list in SAP CRM. The rented business partners in SAP CRM are physically deleted and the business partner data for the BI extraction is filled with blank spaces in the delta update. During the extraction to SAP NetWeaver BI, the rented business partners in 0BPARTNER are overwritten with blank spaces.

Activities

To delete an address list, open it using the External List Management interface. Choose Delete and enter the start date for the background job.