Data Model (SAP Library - SAP CRM: Business Scenario and Business Process Configuration)

Data Model

The data in the address lists is stored in the following master data objects.

An address list consists of administrative data (header data) and the actual addresses (item data).

0ELM_GUID_H

The administrative data for the address lists is saved in this master data object.

0ELM_GUID_H	HEX	16	GUID for an address list
0ELM_LISTID	CHAR	28	ID for an address list
0LOGSYS	CHAR	10	Logical system in which the list was created
0ELM_ORIGIN	CHAR	6	Origin of an address list
0ELM_TYPE	CHAR	2	Type of an address list
0ELM_COSTS	CURR	9	Costs of an address list
0ELM_CURR	CUKY	5	Currency of the costs
0ELM_MUSAGE	NUMC	4	Allowed usage number
0ELM_MUDATE	DATS	8	Allowed maximum usage date
0ELM_VDATE	DATS	8	Recommended maximum usage date
0ELM_NOGROS	INT	4	Gross number
0ELM_DEL_L	CHAR	1	Indicator that an address list has been deleted
0CRM_CRD_AT	DATS	8	Creation date of the address list
0CRM_CRD_BY	CHAR	12	User who created the address list
0CRM_CHD_AT	DATS	8	Last change date of the address list
0CRM_CHD_BY	CHAR	12	User who last changed the address list
0ELM_LOADED	CHAR	1	Addresses loaded

0ELM_GUID_I

The addresses are stored in these master data objects.

0ELM_GUID_I	HEX	16	GUID for an item in an address list
0ELM_GUID_H	HEX	16	GUID for an address list
0ELM_LISTID	CHAR	28	ID for an address list
0BPARTNER	CHAR	10	ID of a business partner
0ELM_BPFILL	CHAR	1	Filled business partner
0ELM_INCADR	CHAR	1	Indicator that the postal information for an address is incorrect
0ELM_DUPLIC	CHAR	1	Indicator that an address is duplicated
0ELM_SUCOAC	CHAR	1	Indicator that an address has reacted positively
0ELM_WONCUS	CHAR	1	Indicator that an address has been won as a customer

0COUNTRYISO	CHAR	2	Address - country key in ISO format
0COUNTRY	CHAR	3	Address - country key
0REGION	CHAR	3	Address - region
0CITY_1	CHAR	40	Address - city
0POSTALCODE	CHAR	10	Address - city ZIP code
0STREET60	CHAR	60	Address - street
0HOUSE_NUM1	CHAR	10	Address - house number
0POBOX	CHAR	10	Address - PO box
0POBOX_LOC	CHAR	40	Address - location of PO box
0POSTCD_BOX	CHAR	10	Address - ZIP code of PO box
0ELM_NATION	CHAR	1	Address - indicator for international address version

0BP_ID_NUM	CHAR	60	Identification number for an address / a business partner (e.g. social security number)

0ELM_ORG_TK	CHAR	4	Organization - form of address key
0NAME_ORG1	CHAR	40	Organization - name 1
0NAME_ORG2	CHAR	40	Organization - name 2
0NAME_ORG3	CHAR	40	Organization - name 3
0ELM_OFDATE	DATS	8	Organization - foundation date
0LEGALFORM	CHAR	2	Organization - legal form
0ELM_ORGURL	CHAR	60	Organization - website
0TEL_NUMBER	CHAR	30	Organization - telephone number (area code + extension)
0TEL_EXTENS	CHAR	10	Organization - telephone number (extension)
0FAX_NUMBER	CHAR	30	Organization - fax number (area code + extension)
0FAX_EXTENS	CHAR	10	Organization - fax number (extension)

0ELM_PERS_T	CHAR	4	Person - form of address key
0BP_ACTITL1	CHAR	4	Person - academic title (key)
0BP_FSTNAME	CHAR	40	Person - first name
0BP_MDLNAME	CHAR	40	Person - middle name
0BP_LSTNAME	CHAR	40	Person - last name
0BIRTHDAY	DATS	8	Person - birth date
0GENDER	CHAR	1	Person - gender
0BP_MAR_STA	CHAR	1	Person - marital status
0ELM_TELNR	CHAR	30	Person - telephone number (area code + extension)
0ELM_TELEXT	CHAR	10	Person - telephone number (extension)
0ELM_FAXNR	CHAR	30	Person - fax number (area code + extension)
0ELM_FAXEXT	CHAR	10	Person - fax number (extension)
0EMAIL_ADDR	CHAR	60	Person - e-mail address
0ELM_PAGER	CHAR	30	Person - pager number (e.g. mobile telephone)
0ELM_FCTN	CHAR	40	Person - function description, if person is contact person for the organization
0ELM_NETCOU	INT	4	Net number addresses

If you change the master data objects (e.g. by adding further attributes), you must inform the following functions of these fields:

· Interface and API’s

Create your own implementation of Business Add-In (BadI) ELM_MAPPING. In the SAP standard, a default implementation is used, in which the fields can be mapped from the master data objects to the internal structures (and vice versa).

· Postal check

If you want to use the new fields in the check, you must create your own implementation for das Business Add-In ELM_CHECK.

· Duplicate check

If you want to use teh new fields in the check, you must create your own implementation for das Business Add-In ELM_CHECK.

· Delete

· InfoSet ELM_INFOSET

Copy InfoSet ELM_INFOSET and maintain the coding of the read program accordingly, so that the new fields can be read.

In the SAP CRM system, you must create your own implentation for Business Add-In CRM_MKTLIST_BW_FIELD.