Show TOC

  Activity Items

Technical Name: 0CRM_SALES_ACT_I

Technical Data

DataSource Type

Transactional Data

Application Components

CRM Sales (CRM_SALES)

Available as from OLTP Release

CRM 4.0

Available as from PlugIn Release

n/a

RemoteCube-Capable

No

Prerequisites

You must make the standard BW-Adapter settings in Customizing. For more information, see the IMG for Customer Relationship Management under Start of the navigation path Integration with Other mySAP Components Next navigation step Data Transfer to Business Information Warehouse. End of the navigation path

Use

This DataSource enables you to extract activityitem information from the CRM system to the Business Information Warehouse.

Users can enter item information in business activities so that they can record which products they have been working with and describe product-related information or activities in the activity journal. In the Business Warehouse system, you can then run product-related activity analyses to see, for example, how many samples were distributed in a certain time period, or the number of activities and items per activity partner. This kind of information is particularly relevant for the pharmaceuticals and the consumer products industries.

This DataSource contains information about the items in the business activity. It includes fields that are relevant for:

  • Standard items

  • Individual objects

  • Products and product variants

  • Activity journals

  • Product placings

  • Sample distribution

Delta Update

This DataSource contributes to the delta update process.

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

ACTIVITY_PARTNER

Activity partner

Calculated from

CRM_REPORT_PARTNERS_GET

ACTUAL_FROM

Actual date from

Calculated in date set

ACTUAL_TO

Actual date to

Calculated in date set

APRICE

Promotion price in branch

CRMD_ACTIVITY_I

APRICE

BASE_QTY_UNIT

Base quantity unit of measure

CRMD_PRODUCT_I

BASE_QTY_UNIT

BATCH_ID

Batch ID

CRMD_PRODUCT_I

BATCH_ID

BREIT

Width of product or product packaging

CRMD_ACTIVITY_I

BREIT

CALDAY

Calendar day

ACTUAL_DATEPLANNED_DATEPOSTING_DATE

CATEGORY

Activity category (communication medium)

CRMD_ACTIVITY_H

CATEGORY

CATEGORY_GUID

Product category GUID

Read from product master data

CATEGORY_ID

Product category ID

CRMD_PRODUCT_I

PROD_HIEARCHY

CONFPROD_GUID

Internal unique product ID

Only filled if configurable items are used (read from product master or document)

CONFPROD_ID

Product ID

Only filled if configurable items are used (read from product master or document)

CONTACT_PERSON

Contact person at customer

Calculated from CRM_REPORT_PARTNERS_GET

CREATED_AT

Time on which transaction was created

CRMD_ORDERADM_H

CREATED_AT (conversion of time stamp in date)

DEKOTP

Decoration type

CRMD_ACTIVITY_I

DEKOTP

DESCRIPTION_UC

Transaction description (upper case)

CRMD_ORDERADM_H

DESCRIPTION_UC

DIRECTION

Activity direction (why is it here twice)

CRMD_ACTIVITY_H

DIRECTION

DISCUSS

Product discussed

CRMD_ACTIVITY_I

DISCUSS

DIS_CHANNEL

Distribution channel

CRMD_ORGMAN

DIS_CHANNEL

DIVISION

Division

CRMD_ORGMAN

DIVISION

ECROPT

Shelf optimization within ECR (?) agreement

CRMD_ACTIVITY_I

ECROPT

EXECUTING_CC

Executing call center

Calculated from CRM_REPORT_PARTNERS_GET

EXPONENT10

10x exponent for conversion

10x exponent for quantity conversion

FACDEP

Facing depth

CRMD_ACTIVITY_I

FACDEP

FACLEN

Facing length

CRMD_ACTIVITY_I

FACLEN

FACUNIT

Unit of quantity for product

CRMD_ACTIVITY_I

FACUNIT

FACWID

Facing width

CRMD_ACTIVITY_I

FACWID

GROSS_WEIGHT

Gross weight

CRMD_PRODUCT_I

GROSS_WEIGHT

GUID

Transaction GUID

CRMD_ORDERADM_H

GUID

HOEHE

Height of product or product packaging

CRMD_ACTIVITY_I

HOEHE

IOBJECT_GUID

Internal unique product ID

Only filled if individual objects are used

(read from product master or document)

IOBJECT_ID

Product ID

Only filled if individual objects are used

(read from product master or document)

ITEM_CHANGED_AT

Time of last change to item

CRMD_ORDERADM_I

CHANGED_AT (conversion of time stamp in date)

ITEM_CHANGED_BY

User who last changed item

CRMD_ORDERADM_I

CHANGED_BY

ITEM_CREATED_AT

Time of item creation

CRMD_ORDERADM_I

CREATED_AT (conversion of time stamp in date)

ITEM_CREATED_BY

User who created item

CREATED_AT

CREATED_BY

ITEM_GUID

Item GUID

CRMD_ORDERADM_I

GUID

ITEM_OBJECT_TYPE

CRM item object category

CRMD_ORDERADM_I

OBJECT_TYPE

ITM_TYPE

Item category

CRMD_ORDERADM_I

ITM_TYPE

JOURNAL_GUID

GUID of CRM order object (activity journal?)

CRMD_ACTIVITY_I

JOURNAL_GUID

KVCURR1

Currency

CRMD_ACTIVITY_I

KVCURR1

KV_DEKO

Decoration material

CRMD_ACTIVITY_I

KV_DEKO

KV_RESULT

Result (activity result?)

CRMD_ACTIVITY_I

KV_RESULT

KV_STOCK

Number of products in stock/on inventory

CRMD_ACTIVITY_I

KV_STOCK

KV_ZPANZ

Number of second placings

CRMD_ACTIVITY_I

KV_ZPANZ

KV_ZPAVA

Second placing available

CRMD_ACTIVITY_I

KV_ZPAVA

LAENG

Length of product or product packaging

CRMD_ACTIVITY_I

LAENG

LBVAL

Sample value

CRMD_ACTIVITY_I

LBVAL

LOGICAL_SYSTEM

Logical system

CRMD_ORDERADM_H

LOGICAL_SYSTEM

LOGSYS_PRED

Logical system of preceding document

Is determined from CRM_BW_DOCFLOW_DETERMINE_I function module

MEABM

Unit of measurement for product length/width/height

CRMD_ACTIVITY_I

MEABM

MKT_ELEMENT

Marketing element

Is determined from CRM_BW_DOCFLOW_DETERMINE_I function module

NET_WEIGHT

Net weight

CRMD_PRODUCT_I

NET_WEIGHT

NRMSHF

Number of products in main shelf

CRMD_ACTIVITY_I

NRMSHF

NROFFAC

Number of facings

CRMD_ACTIVITY_I

FROFFAC

NRPSHF

Number of products in promotion shelf

CRMD_ACTIVITY_I

NRPSHF

NUMBER_INT

Item number in document

CRMD_ORDERADM_I

NUMBER_INT

NUMBER_OF_I

Number of order items

Counter: one is counted for each item

OBJECTIVE

Activity goal

CRMD_ACTIVITY_H

OBJECTIVE

OBJECT_ID

Transaction number

CRMD_ORDERADM_H

OBJECT_ID

OBJECT_TYPE

Business transaction category

CRMD_ORDERADM_H

OBJECT_TYPE

OPRICE

Ordering price at branch

CRMD_ACTIVITY_I

OPRICE

ORDER_DATE

Posting date

CRMD_ORDERADM_I

ORDER_DATE (conversion of time stamp to date)

ORDER_QTY (not in DataSource in Q4C)

CRM order quantity

CRMD_SCHEDLIN

QUANTITY

PATH_GUID

Territory path GUID

The territory path for the first employee responsible named in the business transaction (CRMM_TERRSTRUCT)

PERSON_RESP

Employee responsible

Calculated from CRM_REPORT_PARTNERS_GET

PHREFNR

Pharmaceutical reference number

CRMD_ACTIVITY_I

PHREFNR

PLANNED_FROM

Planned from date

Calculated in date set

PLANNED_TO

Planned to date

Calculated in date set

POSHOR

Horizontal shelf position

CRMD_ACTIVITY_I

POSHOR

POSLOC

Main placing

CRMD_ACTIVITY_I

POSLOC

POSQLI

Qualification of shelf position

CRMD_ACTIVITY_I

POSQLI

POSTING_DATE

Posting date of transaction

CRMD_ORDERADM_H

POSTING_DATE

POSVER

Vertical shelf position

CRMD_ACTIVITY_I

POSVER

PRAVA

Product available after cash desk

CRMD_ACTIVITY_I

PRAVA

PRAVB

Product available before cash desk

CRMD_ACTIVITY_I

PRAVB

PREDEC_OBJKEY

GUID of preceding business transaction

Is determined from CRM_BW_DOCFLOW_DETERMINE_I function module

PREDEC_OBJTYPE

Object category of preceding business transaction

Is determined from CRM_BW_DOCFLOW_DETERMINE_I function module

PRED_ACT_GUID

GUID of preceding activity

Is determined from CRM_BW_DOCFLOW_DETERMINE_I function module

PRED_LEAD_GUID

GUID of preceding lead

Is determined from CRM_BW_DOCFLOW_DETERMINE_I function module

PRED_OPPT_GUID

GUID of preceding opportunity

Is determined from CRM_BW_DOCFLOW_DETERMINE_I function module

PRIORITY

Activity priority

CRMD_ACTIVITY_H

PRIORITY

PROCESS_QTY_DEN

Denominator for converting transaction quantity into base units of measure

CRMD_PRODUCT_I

PROCESS_QTY_DEN

PROCESS_QTY_NUM

Numerator for converting transaction quantity into base units of measure

CRMD_PRODUCT_I

PROCESS_QTY_NUM

PROCESS_QTY_UNIT

Unit of measure in which product is sold

CRMD_PRODUCT_I

PROCESS_QTY_UNIT

PROCESS_TYPE (not in DataSource in Q4C)

Business transaction type

CRMD_ORDERADM_H

PROCESS_TYPE

PRODUCT_GUID

Product GUID

CRMD_ORDERADM_I

PRODUCT

PRODUCT_ID

Product ID

Taken from field in mapping function module

PROD_OBJ_FAM

Object family

Taken from field in mapping function module

PRPRIO

Product priority

CRMD_ACTIVITY_I

PRPRIO

PURCH_GROUP

Purchase group ID

CRMD_ORGMAN

PURCH_GROUP

PURCH_ORG

Purchasing organization

CRMD_ORGMAN

PURCH_ORG

PURCH_ORG_RESP

Responsible purchasing organization

CRMD_ORGMAN

PURCH_ORG_RESPO

RECORDMODE

BW delta procedure: update mode

Is set to D in the mapping function module for deleted objects

RESREAS

Result reason

CRMD_ACTIVITY_I

RESREAS

SALES_EMPLOYEE

Sales employee

Calculated from CRM_REPORT_PARTNERS_GET

SALES_GROUP

Sales group

CRMD_ORGMAN

SALES_GROUP

SALES_OFFICE

Sales office

CRMD_ORGMAN

SALES_OFFICE

SALES_ORG

Sales organization

CRMD_ORGMAN

SALES_ORG

SALES_ORG_RESP

Responsible sales organization

CRMD_ORGMAN

SALES_ORG_RESP

SAMPLE

Sample indicator

Only filled if samples are used

SAMPLE_QTY_ALLOW

Number of samples allowed

Taken from Customizing table CRMC_SAMPLES

SAMPLE_SPEC

Sample status: given, requested, returned

Only filled if samples are used

SERVICE_ORG

Service organization

CRMD_ORGMAN

SERVICE_ORG

SERVICE_ORG_RESP

Responsible service organization

CRMD_ORGMAN

SERVICE_ORG_RESP

SHORT_TEXT_UC

Product description in upper case

CRMD_ORDERADM_I

DESCRIPTION_UC

SPRICE

Sales price at branch

CRMD_ACTIVITY_I

SPRICE

START_OF_BILLING

Start date of billing plan

STATUS

Status of documented product

CRMD_ACTIVIT

STATUS

STORNO

Indicates that data should be cancelled

CRMD_ACTIVITY_I

STORNO

SUBJECTA

Free text regarding A

CRMD_ACTIVITY_I

SUBJECTA

SUBJECTB

Free text regarding B

CRMD_ACTIVITY_I

SUBJECTB

TERR_GUID

Territory GUID

Territory GUID of employee responsible, calculated in mapping module

VOLUME

Volume that product unit requires

CRMD_PRODUCT_I

VOLUME

VOLUME_UNIT

Unit of volume for product

CRMD_PRODUCT_I

VOLUME

WEIGHT_UNIT

Unit of weight

CRMD_PRODUCT_I

WEIGHT_UNIT

Particular Features of the Extractor

Note that the consumer products fields are only contained in the DataSource if the Customer Include CI_ACT_REP_ADD_FIELDS is included in the CRMD_ACTIVITY_I table. For more information about defining customer-specific fields in the activity journal, see the IMG for Start of the navigation path Customer Relationship Management under Business Transactions Next navigation step Settings for Activities Next navigation step Activity Journal. End of the navigation path