Show TOC

 Generic Extractor for Marketing Attribute Values

Technical name: 0CRM_MKTATTR_ATTR

Technical data

Type of DataSource

Attributes (Master Data)

Application Component

Master data CRM Marketing, 0CRM_MKT-IO

Available from OLTP release

SAP CRM 4.0

Available from Plug-In Release

Not relevant

RemoteCube Compatibility

No

Use

You can use this DataSource to extract the attribute values for SAP CRM marketing attributes to SAP BW. It is possible to extract multiple value attributes and intervals.

You can extract the texts for the attribute values with DataSource 0CRM_MKTATTR_TEXT .

You can extract the master data and texts for the marketing attributes (key component ATNAM for this DataSource) with DataSources 0CRM_MKTMETA_ATTR and 0CRM_MKTMETA_TEXT .

Delta Update

This DataSource is delta-compatible. The data is written to an ODS object.

The existing attribute values are first overwritten with an initial value. The following data records then update this initial value with the latest value provided from SAP CRM, if this existed. Otherwise, the initial value is retained.

Remember that this does not represent a true deletion. This solution may cause problems when attempting to distinguish between a deletion value and an actual value of 0 assigned by SAP CRM. It may be necessary to reprogram the update accordingly.

After being written to the ODS object, the data is normally updated in other data targets. This can create problems for the delta update, which must be processed by the different update rules.

For more information, see “Features of the Extractor”.

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

ANZDZ

Type description: number of decimal places for numerical values

CABN

ANZDZ

ANZST

Type description: number of places

CABN

ANZST

ATFLB

Lower interval limits in the internal format

AUSP

ATFLB

ATFLV

Upper interval limits in the internal format

AUSP

ATFLV

ATFOR

Data type in the ABAP Dictionary

CABN

ATFOR

ATNAM

Name of the marketing characteristic

Key fieldSelection field

CABN

ATNAM

ATWRT

Value in character format

AUSP

ATWRT

ATZHL

Sequential number for multiple value attributes

Key field

CAWN

ATZHL

DATEFROM

Not used

DATETO

Not used

MANDT

Client

Key field

MSEHI

Unit or currency key

CABN

MSEHI

PARTNER

Business partner

Selection field

Key field

BUT000

PARTNER

Features of Extractor

ODS object 0ATR_DS01 is provided as the data target. It’s structure should be based on that of the extract structure. Further data targets can be updated from this object.

Including the name of marketing attribute ATZHL in the key of this DataSource makes it also possible to extract multiple value marketing attributes into SAP BW. Fields ATFLV and ATFLB also make it possible to extract intervals. For multiple value intervals, remember that semantics such as inclusive or exclusive interval limits cannot be reflected in SAP BW. Also, problems can arise if, for multiple value intervals such as <10, <20, you enter 10–20, 20–30 etc., for the same marketing attribute. Where inconvenient constellations arise, it will not be possible to transfer all values to BW. You may have to adapt the update rules accordingly.

Remember that attributes that are not of type CHAR (in particular numerical fields, date fields, time fields, currencies, etc.), are saved internally as floating point numbers (fields ATFLB and ATFLV). When the data is updated to other data targets, you must use suitable update routines to convert the value stored in the internal floating-point format into the external representative.

SAP provides you with demo content that further explains the update by means of a demo business partner (0D_MPARTNER). You can find this content in the Administrator Workbench under Start of the navigation path SAP Demo Next navigation step SAP Demo CRM Marketing Attributes End of the navigation path .

The update can be performed in different ways:

Firstly, it can be performed in separate, newly created InfoObjects, that are compounded with the business partner (0BPARTNER) and which have the attribute values and attribute name as an attribute. The master data created in this way has the business partner and field ATZHL in the key, thereby enabling multiple value modeling.

Alternatively, the marketing attribute values – as previously possible using the extractors generated in SAP CRM – can be updated in business partner attributes. You can represent multiple value attributes by creating a separate attribute for every attribute value, (e.g. Swimming, Diving, Running, etc. for marketing attribute Sporting activities ). Each attribute receives a Boolean value with the meaning “Assignment exists / does not exist”. You can represent intervals in two attributes, you can represent multiple value intervals accordingly.