Show TOC Start of Content Area

Object documentationMapping Fields

Definition

Target fields to which the external data can be mapped. Depending on the mapping format type selected, the target fields can be one or more of the following types: Person, Organization, Attributes, Leads, Activities, Surveys.

Note

If the following conditions are satisfied, you can update business partner data directly instead of using the cleansing tool:

         The  columns containing numbers representing business partners in the external file are mapped to the fields PER_NO and ORG_NO in the target structure.

         The data is known to be completely accurate and up-to-date.

Structure

        In a Business-to-Business (B2B) scenario, the data of the organization and person must be in a single record in the file.  

        The table below lists details of Organization- and Person-related mapping fields.

        The column BP table contains a list of table names where mapped entries are stored during business partner maintenance.

        The fields ORG_ID_NUMBER and PERS_ID_NUMBER contain additional identification numbers of the business partner, such as the social security number or the Dun & Bradstreet number. For more information, see Customizing for Customer Relationship Management and choose Marketing External List Management Define List Origin.

 

Category

Mapping Field

Description

BP table

BP Field

Organization

ORG_TITLE_KEY

Title of the Business Partner

BUT000

TITLE

 

ORG_NAME1

Name 1 of the Business Partner

BUT000

NAME_ORG1

 

ORG_NAME2

Name 2 of the Business Partner

BUT000

NAME_ORG2

 

ORG_NAME3

Name 3 of the Business Partner

BUT000

NAME_ORG3

 

ORG_LEGALFORM

BP: Legal Form of the Business Partner

BUT000

LEGAL_ENTY

 

ORG_FOUND_DATE

Found Date of the Organization

BUT000

FOUND_DAT

 

ORG_TELEPHONE

Telephone no.: dialing code number of the Business Partner

ADRC

TEL_NUMBER

 

ORG_TEL_EXT

Telephone no.: Extension of the Business Partner

ADRC

TEL_EXTENS

 

ORG_FAX

Fax number: dialing code number of the Business Partner

ADRC

FAX_NUMBER

 

ORG_FAX_EXT

Fax no.: Extension of the Business Partner

ADRC

FAX_EXTENS

 

ORG_URI

URI, e.g. Homepage or ftp Address of the Business Partner

ADR12

URI_SRCH

 

ORG_LANGUAGE

Language of the Business Partner

BUT000

BU_LANGU

 

ORG_URI_TYPE

URI type flag

ADR12

URI_TYPE

Organization Address

ORG_CITY

City of the Business Partner

ADRC

CITY1

 

ORG_POSTL_COD1

City Postal Code of the Business Partner

ADRC

POST_CODE1

 

ORG_POSTL_COD2

PO Box Postal Code of the Business Partner

ADRC

POST_CODE2

 

ORG_PO_BOX

PO Box of the Business Partner

ADRC

PO_BOX

 

ORG_PO_BOX_CIT

PO Box city of the Business Partner

ADRC

PO_BOX_ LOC

 

ORG_STREET

Street of the Business Partner

ADRC

STREET

 

ORG_HOUSE_NO

House Number of the Business Partner

ADRC

HOUSE_NUM1

 

ORG_COUNTRYISO

Country ISO code of the Business Partner

ADRC

COUNTRY

 

ORG_REGION

Region (State, Province, County) of the Business Partner

ADRC

REGION

 

ORG_ID_NUMBER

Identification Number of the Business Partner

BUT0ID

IDNUMBER

 

ORG_NATION

International address version ID of the Business Partner

ADRC

NATION

Person

PERS_TITLE_KEY

Title of the Business Partner

BUT000

TITLE

 

PERS_FIRSTNAME

First Name of Business Partner

BUT000

NAME_FIRST

 

PERS_LASTNAME

Last Name of Business Partner

BUT000

NAME_LAST

 

PERS_INITIAL

Middle Name or Second Forename of the Person

BUT000

INITIALS

 

PERS_TITLE_ACA1

Academic Title: Key of the Business Partner (organization)

BUT000

TITLE_ACA1

 

PERS_BIRTHDATE

Date of Birth of Business Partner

BUT000

BIRTHDT

 

PERS_SEX

Gender of Business Partner

BUT000

XSEXM, XSEXF, XSEXU

 

PERS_MARITALSTAT

Marital Status of Business Partner 

BUT000

MARST

 

PERS_TELEPHON

Telephone no.: dialing code number of the Business Partner

BUT051 (B2B)

ADRC (B2C)

TEL_ NUMBER

 

PERS_TEL_EXT

Telephone no.: Extension of the Business Partner

BUT051 (B2B)

ADRC (B2C)

TEL_ EXTENS

 

PERS_FAX

Fax number: dialing code number of the Business Partner

BUT051 (B2B)

ADRC (B2C)

FAX_NUMBER

 

PERS_FAX_EXT

Fax no.: Extension of the Business Partner

BUT051 (B2B)

ADRC (B2C)

FAX_EXTENS

 

PERS_E_MAIL

E-Mail Address of the Business Partner

BUT051 (B2B)

ADR6    (B2C)

SMTP_ADDRESS

SMTP_ADDR

 

PERS_PAGER

Pager information stored as telephone number with an SMS flag 

ADR13

PAGER_NMBR

 

PERS_LANGUAGE

Business Partner: Language

BUT000

BU_LANGU

 

PERS_LANGU_CORR

Correspondence Language of the Business Partner

BUT000

LANGU_CORR

Person Address

PERS_CITY

City of the Business Partner

ADRC

CITY1

 

PERS_POSTL_COD1

City Postal Code of the Business Partner

ADRC

POST_CODE1

 

PERS_POSTL_COD2

PO Box Postal Code of the Business Partner

ADRC

POST_CODE2

 

PERS_PO_BOX

PO Box of the Business Partner

ADRC

PO_BOX

 

PERS_PO_BOX_CIT

PO Box city of the Business Partner

ADRC

PO_BOX_LOC

 

PERS_STREET

Street of the Business Partner

ADRC

STREET

 

PERS_HOUSE_NO

House Number of the Business Partner

ADRC

HOUSE_NUM1

 

PERS_COUNTRYISO

Country ISO code of the Business Partner

ADRC

COUNTRY

 

PERS_REGION

Region (State, Province, County) of the Business Partner

ADRC

REGION

 

PERS_ID_NUMBER

Identification Number of the Business Partner

BUT0ID (B2C)

IDNUMBER

 

PERS_NATION

International address version ID of the Business Partner

ADRC

NATION

Function Name

CP_FUNCTIONNAME

Function Name of the Business Partner

BUT051

FNCTN

 

CP_FUNCTIONKEY

Function Key

BUT051

PAFKT

 

        The table below lists details of activity-related mapping fields.

        The column Activity table contains a list of table names where mapped entries are stored during business transaction creation.

Category

Mapping Field

Description

Activity table

Field

Activity

TEMPLATE_ID

ID of Activity Template

CRMD_ORDERADM_H

 

OBJECT_ID

 

 

PROCESS_TYPE

Business Transaction Type

CRMD_ORDERADM_H

 

PROCESS_TYPE

 

 

DESCRIPTION

Transaction Description

CRMD_ORDERADM_H

 

DESCRIPTION

 

 

ACTUAL_DATE_FROM

Actual Date From

SCAPPT

 

DATE_FROM

 

ACTUAL_TIME_FROM

Actual Time From

 

SCAPPT

 

TIME_FROM

 

 

ACTUAL_DATE_TO

Actual Date To

 

SCAPPT

 

DATE_FROM

 

 

ACTUAL_TIME_TO

Actual Time To

 

SCAPPT

 

TIME_FROM

 

 

USER_STATUS

Object Status

 

CRM_JEST

 

STAT

 

 

PRIORITY

Activity Priority

 

CRMD_ACTIVITY_H

 

PRIORITY

 

CATEGORY

Activity Category (Communication Type)

CRMD_ACTIVITY_H

CATEGORY

 

        The table below lists details of lead-related mapping fields.

        The column Lead table contains a list of table names where mapped entries are stored during business transaction creation.

Category

Mapping Field

Description

Lead table

Field

Lead

TEMPLATE_ID

ID of Lead Template

CRMD_ORDERADM_H

OBJECT_ID

 

PROCESS_TYPE

Business Transaction Type

CRMD_ORDERADM_H

PROCESS_TYPE

 

DESCRIPTION

Transaction Description

CRMD_ORDERADM_H

DESCRIPTION

 

START_DATE

Lead Start Date

SCAPPT

DATE_FROM

 

EXP_END_DATE

Lead Expected End Date

SCAPPT

DATE_FROM

 

USER_STATUS

Object Status

CRM_JEST

STAT

 

LEAD_PRIORITY

Opportunity/Lead Priority

CRMD_LEAD_H

IMPORTANCE

 

LEAD_GROUP

Lead Group

CRMD_LEAD_H

LEAD_TYPE

 

MANUAL_QUAL_LEV

Lead Qualification Level (Manual)

CRMD_LEAD_H

QUAL_LEVEL_MAN

 

ORIGIN

Origin of Opportunity/Lead

CRMD_LEAD_H

SOURCE

 

 

        The table below lists details of response-related mapping fields.

        The column Table contains a list of table names where mapped entries are checked against the tables under Table and the fields under Field during data mapping.

 

Category

Mapping Field

Description

Table

Field

Response

PERS_RESP_CODE

CRM Marketing: ICRH - Personalized Response Code - character

CRMD_IM_ML_ITEM

PRC

 

COUPON_CODE

Coupon Code

CRMD_MKTPL_COUP

OFRCODE

 

CAMPAIGN_ELEMENT

Campaign Element

CGPL_TASK

EXTERNAL_ID

 

ORG_NUMBER

Business Partner Number of Organization

BUT000

PARTNER

 

PER_NUMBER

Business Partner Number of Person

BUT000

PARTNER

 

 

See also:

        For more information about enhancing structures with appended fields, see Structure Enhancement Using Appended Fields.

        For more information about creating an implementation of the Business Add-In for appended fields, see User Implementation of BAdI for Appended Fields.

        For an example on how to append fields to structures and how to create an implementation of the Business Add-In, see Example: Enhancements for Industry Sector and Industry System.

        For more information on External List Management, see External List Management in CRM.

 

End of Content Area