CRM Service Order Items: Actual Costs Using Delta Extraction

Technical name: 0CRM_SRV_C_ITEM

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

The DataSource only delivers data if single-object controlling for the CRM service order items is set in the R/3 system, which is connected to the CRM system.

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
ITEM_NUMBER	Item
ITEM_TYPE	Item category
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)
SERVICE_TECH_ORG	Service employee organization/group
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 in turn 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 order items.

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, the key figures mentioned above, which provide information about the account-based quantities and value flow of the CRM service order items, can be used in relation to the process-related key figures extracted from the CRM system.