CRM External List Management: Contact Counter

Technical name: 0CRM_ELM_CC

Technical data

Type of DataSource	Transaction data
Application component	External List Management (CRM-MKT-EAL)
Available from OLTP release	CRM 4.0
Available from Plug-In release	Not relevant
RemoteCube Compatibility	No

Prerequisites

Use

You can use this DataSource to determine how often a business partner was contacted. On the one hand, this makes it possible to check whether the contractually permitted number of uses has been exceeded. On the other hand, reporting on the number of contacts is required in order to find out how many contacts were needed in order to gain the address as a business partner (or at least as a prospect).

Delta Update

Delta update is not supported for this DataSource.

Fields of Origin in the Extract Structure

Field in Extract Structure	Description of Field in the Extract Structure	Table of Origin	Field in Table of Origin
CLIENT	Client
LIST_GUID	CRM marketing: GUID for an address list	CRMD_MKTLIST_I	LIST_GUID
ITEM_GUID	CRM marketing:line GUID for anaddress list item	CRMD_MKTLIST_I	ITEM_GUID
LIST_ID	CRM marketing: ID for an address list	CRMD_MKTLIST_H	LIST_ID
GUID	32-digit GUID (converted) for a CRM object	CRMD_IM_ML_ITEM	ELM_ITEM_GUID
GUID_LIST	CRM marketing: GUID (32 character) for an address list	CRMD_IM_ML_ITEM	LIST_GUID
NUM_CONT	Number of outbound contacts	Determined