CRM Service Processes: Detailed Controlling

Technical Name: 0CRM_SRV_COSTS

Technical Data

DataSource Type	Transactional Data (movement data)
Application Components	SAP CO-PC
Available as from OLTP Release	CRM 4.0, R/3 4.6C
Available as from PlugIn Release	2004_1_46C
RemoteCube-Capable	No

Prerequisites

Single Object controlling for CRM service orders is set in SAP R/3 that is connected to the SAP CRM system.

Use

This DataSource extracts costs and revenues of CRM service contracts, service orders, service confirmations, for assigned internal orders in SAP R/3. This extraction is independent of Customizing settings at the controlling level (transaction or item level).

Cumulated header records that contain costs and revenues of CRM items are created within the extractor. This is applicable for line items assigned to internal orders of CRM items in SAP R/3 (FI-CO). This ensures revenue and cost controlling in the SAP Business Information Warehouse for all service documents independent of the customized settings at controlling level.

This DataSource also provides information about the cost element and accounting indicator of extracted line items.

Delta Update

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

Fields of Origin for the Extract Structure

Fields in the Extract Structure	Description of the Field in the Extract Structure
AUFNR	Order number
BELNR	Document number
BEMOT	Accounting Indicator
BLDAT	Document date
BUDAT	Posting date
BUKRS	Company code
BUZEI	Line item
CURTYPE	Currency type
EBETRAG	Service revenue total (actual)
EBETRAG_CUM	Service revenue total (actual)
EMENGE	Quantity for service revenue (actual)
FISCPER	Fiscal year or period
FISCVAR	Fiscal year variant
FKBER	Functional area
GSBER	Business area
HEADER_GUID	Technical key for an external object
HEADER_OBJ_TYPE	Object Type for CRM Transaction Type or Item Category
HIERARCHY_LEVEL	Hierarchy Level of Object
HRKFT	Origin Group as Subdivision of Cost Element
ITEM_GUID	Technical key for an external object
ITEM_NUMBER	Item number
ITEM_OBJ_TYPE	Object Type for CRM Transaction Type or Item Category
ITEM_TYPE	Item type
KBETRAG	Total Service Costs (Actual)
KBETRAG_CUM	Total Service Costs (Actual)
KMENGE	Quantity for Service Revenue (Actual)
KOKRS	Controlling area
KOKRS_WAERS	Currency Key
KSTAR	Cost element
KTOPL	Chart of accounts
KUNNR	Customer number
LIFNR	Account number of the vendor or creditor
MANDT	Client
MATNR	Material number
MEASTYPE	Key figure category
MEINH	Unit of measure
OBJECT_ID	Transaction
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 Technician Organization or Team
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

Particular Features of the Extractor

Data extraction occurs through a function module using an internal extractor from controlling for overhead costs. This determines line items for internal orders that are represented by CRM service orders.

Cost and revenue values are converted into the following key figures:

Costs
Revenues
Costs (Cumulated)
Revenues (Cumulated)

The cumulative values are used for reporting independent of the customized settings at controlling level. The non-cumulative values are used to represent the current state of the assignment of line items to internal orders in FI-CO.

In SAP Business Information Warehouse these key figures provide information about account-based quantities and value flow of CRM service orders. This information is used in relation to process-related key figures extracted from the CRM System.

This DataSource replaces the former FI-CO DataSources 0CRM_SERVICE_COSTS and 0CRM_SRV_C_ITEM.