Show TOC

 CRM Service Orders: Actual Costs Using Delta Extraction

Technical name: 0CRM_SERVICE_COSTS

Technical Data

Type of DataSource

Transaction data (movement data)

Application Component

CO-OM

Available from OLTP Release

CRM 3.0, R/3 4.6B

Available from Plug-In Release

1999_1_46B

RemoteCube-Compatible

No

Prerequisites

Single-object controlling for CRM service orders must be set in the R/3 system, which is connected to the CRM system, so that the DataSource can extract data.

Use

The DataSource ensures that the costs and revenue for CRM service orders, or associated internal orders can be analyzed in the R/3 system. This ensures revenue and cost controlling for service orders from the CRM system.

Delta Update

The DataSource supports additive extraction using extractors, that is, the only data records extracted are those that have been added since the last extraction.

Fields of Origin in the Extract Structure

Field in Extract Structure

Description of Field in the Extract Structure

AUFNR

Order number

BELNR

Document number

BLDAT

Document date

BUDAT

Posting date

BUKRS

Company code

BUZEI

Line item

CLIENT

Client

CURTYPE

Currency type

EBETRAG

Service revenue total (actual)

EMENGE

Quantity for service costs (actual)

EXT_OBJECT_ID

Technical key for an external object

FISCPER

Fiscal year/period

FISCVAR

Fiscal year variant

FKBER

Functional area

GSBER

Business area

KBETRAG

Service costs total (actual)

KMENGE

Quantity for service revenue (actual)

KOKRS

Controlling area

KTOPL

Chart of accounts

KUNNR

Customer number

LIFNR

Account number of the vendor or creditor

MATNR

Material number

MEASTYPE

Key figure category

MEINH

Unit of measure

OBJECT_ID

Transaction

OBJECT_TYPE

Object type for CRM transaction type/item category

PBUKRS

Partner company code

PERNR

Personnel number

PFKBER

Partner functional area

PROCESS_TYPE

Business transaction type

RSAUXACCTYPE

Auxiliary account assignment object type

RSAUXACCVAL

Auxiliary account assignment object

RSPAROBVAL

Specification of a partner InfoObject

RSPOBART

Partner InfoObject (4-characters)

SAKNR

G/L account number

SERVICE_ORG

Service organization

SERVICE_ORG_RESP

Owner organizational unit (Service)

SGTXT

Segment text

VALUTYP

Valuation view

VERSN

Version

VTDETAIL

Value type detail

VTSTAT

Statistics indicator for value type

VTYPE

Value type for reporting

WAERS

Currency key

WERKS

Plant

Features of Extractor

The data extraction occurs using a function module, which uses an internal extractor (function module) from controlling for overhead costs to determine the line items for the internal orders which are represented by the CRM service orders.

The data for the controlling of overhead costs is added to the known data in the R/3 system and the quantities and values for line items are converted into the following key figures:

  • Service costs total (actual)

  • Quantity for service costs (actual)

  • Service revenue total (actual)

  • Quantity for service revenue (actual)

In the Business Information Warehouse, these key figures, which provide information about the account-based quantities and value flow of the CRM service orders, can be used in relation to the process-related key figures extracted from the CRM system.