Show TOC

 Activities

Technical Name: 0CRM_SALES_ACT_1

Technical Data

DataSource Type

Transactional Data (Transaction Data)

Application Components

CRM Activity Management (CRM-BTX-ACT)

Available as from OLTP Release

CRM 2.0C

Available as from PlugIn Release

N/A

RemoteCube-Capable

 

Use

This DataSource contains the fields necessary for extracting information from the CRM activity to the equivalent BW InfoSource (CRM Activities in Flat Structure) .

Delta Update

You can run an initial, complete, and delta upload for this DataSource.

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

PARTNER

PARTNER_NO

ACTUAL_FROM

Actual start date

APPOINTMENT

ORDERADM_H_GUID

ACTUAL_TO

Actual end date

APPOINTMENT

ORDERADM_H_GUID

ACT_CATEGORY

Activity category (communication medium)

ACTIVITY_H

CATEGORY

ACT_DIRECTION

Activity direction

ACTIVITY_H

DIRECTION

ACT_REASON_CAT

Activity reason (catalog)

SRV_SUBJECT

GUID_REF

ACT_REASON_CODE

Activity reason (code)

SRV_SUBJECT

GUID_REF

ACT_REASON_GROUP

Activity reason (code group)

SRV_SUBJECT

GUID_REF

BEGIN_DATE

Start date

APPOINTMENT

APPT_TYPE

BWSTONESYS0

BW status

STATUS

STATUS

BWSTONESYS1

BW status

STATUS

STATUS

CALDAY

Calendar day

APPOINTMENT

ORDERADM_H_GUID

CATEGORY

Category

ACTIVITY_H

CATEGORY

CLIENT

Client

ORDERADM_H

CLIENT

CODE

Code

SRV_SUBJECT

GUID_REF

CODEGRUPPE

Code group

SRV_SUBJECT

GUID_REF

CONTACT_PERSON

Contact person

PARTNER

PARTNER_NO

COUNTER

Counter (number of activities)

ACTIVITY_H

GUID

DESCRIPTION_UC

Transaction description in upper case

ORDERADM_H

DESCRIPTION_UC

DESCR_LANGUAGE

Language of description

ORDERADM_H

DESCR_LANGUAGE

DIRECTION

Activity direction

ACTIVITY_H

DIRECTION

DIS_CHANNEL

Distribution channel

ORGMAN

DIS_CHANNEL

DIVISION

Division

ORGMAN

DIVISION

DURATION

Duration

APPOINTMENT

APPT_TYPE

DURATION

 

APPOINTMENT

DURATION

DURATION

Actual duration

APPOINTMENT

IS_DURATION

DURATION

Time unit of duration

APPOINTMENT

TIME_UNIT

EXECUTING_CC

Executing interaction center

PARTNER

PARTNER_NO

FTF_DURATION

Face-to-face duration

APPOINTMENT

APPT_TYPE

FTF_DURATION

 

APPOINTMENT

DURATION

FTF_DURATION

Actual face-to-face duration

APPOINTMENT

IS_DURATION

FTF_DURATION

Time unit of face-to-face duration

APPOINTMENT

TIME_UNIT

GUID

Transaction GUID

ORDERADM_H

ORDERADM_H_GUID

GUID_OPPORTUNITY

Opportunity GUID

DOC_FLOW

ORDERADM_H_GUID

KATALOGART

Catalog type

SRV_SUBJECT

GUID_REF

LEAD_CREATED_AT

Date on which lead was created

ORDERADM_H

CREATED_AT

LOGICAL_SYSTEM

Logical system

ORDERADM_H

LOGICAL_SYSTEM

LOGSYS_PRED

Logical system of preceding document

DOC_FLOW

LOGSYS_A

MKT_ELEMENT

Marketing plan element

DOC_FLOW

ORDERADM_H_GUID

OBJECTIVE

Goal of activity

ACTIVITY_H

OBJECTIVE

OBJECT_ID

Transaction number

ORDERADM_H

OBJECT_ID

OBJECT_TYPE

Transaction type

ORDERADM_H

OBJECT_TYPE

OPPT_CREATED_AT

Date on which opportunity was created

ORDERADM_H

CREATED_AT

PERSON_RESP

Employee responsible

PARTNER

PARTNER_NO

PLANNED_FROM

Planned start date

APPOINTMENT

ORDERADM_H_GUID

PLANNED_TO

Planned end date

APPOINTMENT

ORDERADM_H_GUID

PREDEC_OBJKEY

Object key of preceding document

DOC_FLOW

OBJKEY_A

PREDEC_OBJTYPE

Object type of preceding document

DOC_FLOW

OBJTYPE_A

PRED_ACT_GUID

GUID of preceding activity

ACTIVITY_H

GUID

PRED_LEAD_GUID

GUID of preceding lead

DOC_FLOW

OBJKEY_A

PRED_OPPT_GUID

GUID of preceding opportunity

DOC_FLOW

OBJKEY_A

PRIORITY

Activity priority

ACTIVITY_H

PRIORITY

PROCESS_CATALOG

Catalog

SRV_SUBJECT

KATALOGART

PROCESS_CATEGORY

Category

ACTIVITY_H

CATEGORY

PROCESS_CODE

Code

SRV_SUBJECT

CODE

PROCESS_CODEGR

Code group

SRV_SUBJECT

CODEGRUPPE

PROCESS_OBJTYPE

Object type of preceding document

DOC_FLOW

OBJKEY_A

PROCESS_TYPE

Business transaction type

ORDERADM_H

PROCESS_TYPE

PURCH_GROUP

Purchasing group

ORGMAN

PURCH_GROUP

PURCH_ORG

Purchasing organization

ORGMAN

PURCH_ORG

PURCH_ORG_RESP

Responsible purchasing organization

ORGMAN

PURCH_ORG_RESP

QUOTATION_GUID

GUID of quotation

DOC_FLOW

OBJKEY_A

QUOT_VALID_FROM

Quotation valid-from date

APPOINTMENT

TIMESTAMP_FROM

RECORDMODE

Delta procedure: update mode

ORDERADM_H

TASK

SALES_EMPLOYEE

Sales employee

PARTNER

PARTNER_NO

SALES_GROUP

Sales group

ORGMAN

SALES_GROUP

SALES_OFFICE

Sales office

ORGMAN

SALES_OFFICE

SALES_ORG

Sales organization

ORGMAN

SALES_ORG

SALES_ORG_RESP

Responsible sales organization

ORGMAN

SALES_ORG_RESP

SERVICE_ORG

Service organization

ORGMAN

SERVICE_ORG

SERVICE_ORG_RESP

Responsible service organization

ORGMAN

SERVICE_ORG_RESP

STATUS_SYSTEM

System status

STATUS

ACTIVE

STATUS_SYSTEM

System status

STATUS

STATUS

STSMA

Status profile

SRV_OSSET

ORDERADM_H_GUID

STSMA

Status profile

SRV_OSSET

PROFILE_TYPE

STSMA

Status profile

SRV_OSSET

REF_GUID

STSMA

Status profile

SRV_OSSET

REF_KIND

STSMA

Status profile

SRV_OSSET

SUBJECT_PROFILE

STSMA

Status profile

STATUS

ACTIVE

STSMA

Status profile

STATUS

STATUS

STSMA

Status profile

STATUS

USER_STAT_PROC

USSTAT

User status

STATUS

ACTIVE

USSTAT

User status

STATUS

STATUS

USSTAT

User status

STATUS

USER_STAT_PROC