Show TOC

Marketing Permissions Locate this document in the navigation structure

DataSource Attributes DataSource Attributes: 0CRM_MKT_PERM

 

This DataSource extracts the time intervals during which you can send unsolicited marketing material to an account or contact, and the communication channels that you can use for sending unsolicited marketing material. This is indicated by the Contact Permission ID with the value Y (Yes) in the corresponding extraction record.

Note Note

Communication channels in this document refer to the communication channels that are defined in Customizing Start of the navigation path Customer Relationship Management Next navigation step Master Data Next navigation step Define Settings for Marketing Permissions Next navigation step Define Communication Channels End of the navigation path and are maintained in the Marketing Permission assignment block (AB).

End of the note.

The start dates and end dates of these time-intervals are determined from the following:

  • The values maintained in the Date of Consent in the Marketing Permission AB of the account or contact

  • The address(es) of the account or the organization of the contact, as well as their valid from and valid to dates

  • The Customizing settings in the activity Start of the navigation path Customer Relationship Management Next navigation step Master Data Next navigation step Business Partner Next navigation step Define Settings for Marketing Permissions Next navigation step Define Opt-In Settings Next navigation step Define Country-Specific Opt-In Settings End of the navigation path

Example Example

In the Marketing Permission AB, the following information is available for Account 5432:

  • Consent is Given

  • Communication Channel is E-Mail

  • Date of Consent is 01.07.2010

On the date of consent the account is resident in country A where an opt-in identifier of 12 months applies (as defined in the Customizing activity Define Country-Specific Opt-In Settings). On 15/10/2012, the account becomes resident in country B for which no opt-in identifiers are defined in Customizing.

Based on this information, the Datasource extracts the following records for account 5432 for the communication channel E-mail:

Record 1: Contact Permission ID with the value Y from 01.07.2010–30.6.2011.

Record 2: Contact Permission ID with the value Y from 15.10.2012–31.12.9999.

End of the example.

When there is no time interval during which an account or contact can be contacted via a specific communication channel, the DataSouce extracts a record with the time interval 01.01.0001–31.12.9999, and a Contact Permission ID with the value N (No) for the respective communication channel.

Technical Data

Application Component

CRM Marketing Master Data (0CRM_MKT)

Available as of Release

SAP CRM 7.0 EHP2.0

Shipment

SAP NW BI Content 7.01 BI Content 7.05 SP06

Content Versions

No content versions exist

RemoteCube-Capable

No

Delta-Capable

Yes

Extraction from Archives

No

Verifiable

No

Prerequisites

You have activated the business function Marketing Permission and maintained the Customizing activities in Customizing for Start of the navigation path Customer Relationship Management Next navigation step Master Data Next navigation step Business Partner Next navigation step Define Settings for Marketing Permissions End of the navigation path.

Data Modeling

Delta Update

The DataSource provides deltas when the following applies:

  • The account or contact address data is changed.

  • A marketing permission is deleted.

  • A new marketing permission is created.

  • A new relationship between an account and contact is created.

  • A relationship between an account and contact is deleted.

Fields of Origin for the Extract Structure

Fields in the Extract Structure

Description of the Field in the Extract Structure

Table of Origin

Field in the Table of Origin

LOGICAL_SYSTEM

Source system

-

-

ACCOUNT_ID

Business Partner Number

-

-

CONTACT_ID

Business Partner Number

-

-

CHANNEL

Business Partner Number

-

-

PERMISSION

Contact Permission ID

-

-

PERMISSION_FROM

Field of type DATS

-

-

PERMISSION_TO

Field of type DATS

-

-

ACCOUNT_CURR_CTY

Country Key

-

-

ACCOUNT_CURR_REG

Region (State, Province, County)

-

-

RECORDMODE

BW Delta Process: Record Mode

-

-