Opportunity Item

Technical Name: 0CRM_OPPT_I

Technical Data

DataSource Type	Transactional Data (Transaction Data)
Application Components	CRM Opportunity Management (CRM-BTX-OPPT)
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 sales opportunity items to the equivalent BW InfoSource ( CRM Opportunities Item Data ).

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
ACT_REASON_CAT	Activity reason (catalog)	SRV_SUBJECT	KATALOGART
ACT_REASON_CODE	Activity reason (code)	SRV_SUBJECT	CODE
ACT_REASON_GROUP	Activity reason (code group)	SRV_SUBJECT	CODEGRUPPE
BASE_QTY_UNIT	Base unit of measure for product	PRODUCT_I	BASE_QTY_UNIT
BWSTONESYS0	BW status	STATUS	STATUS
BWSTONESYS4	BW status	STATUS	STATUS
BWSTTECSYS2	BW status	STATUS	STATUS
CALDAY	Calendar day	ORDERADM_H	CREATED_AT
CATEGORY_ID	Product category ID	PRODUCT_I	PROD_HIERARCHY
CHANGED_AT	Time on which last change was made to opportunity	ORDERADM_H	CHANGED_AT
CHANGED_BY	Person by whom last change was made to opportunity	ORDERADM_H	CHANGED_BY
CODE	Code	SRV_SUBJECT	CODE
CODEGRUPPE	Code group	SRV_SUBJECT	CODEGRUPPE
COMPETITOR	Competitor	PARTNER	PARTNER_NO
CONTACT_PERSON	Contact person	PARTNER	PARTNER_NO
CONTROL_PHASE	Analysis phase	OPPORT_H	CURR_PHASE
CONTROL_PHASE	Current phase	OPPORT_H	SALESCYCLE
CREATED_AT	Date on which opportunity was created	ORDERADM_H	CREATED_AT
CREATED_BY	User by whom opportunity was created	ORDERADM_H	CREATED_BY
CURRENCY	Currency	PRICING	CURRENCY
CURR_PHASE	Current phase	OPPORT_H	CURR_PHASE
DESCRIPTION_UC	Transaction description (in upper case)	ORDERADM_H	DESCRIPTION_UC
DIS_CHANNEL	Distribution channel	ORGMAN	DIS_CHANNEL
DIVISION	Division	ORGMAN	DIVISION
EXCHG_DATE	Exchange rate date	PRICING	EXCHG_DATE
EXCHG_RATE	Exchange rate	PRICING	EXCHG_RATE
EXCHG_TYPE	Exchange rate type	PRICING	EXCHG_TYPE
EXECUTING_CC	Executing interaction center	PARTNER	PARTNER_NO
EXPECT_END	Expected closing date of opportunity	OPPORT_H	EXPECT_END
EXPONENT10	10x exponent for quantity conversion	PRODUCT_I	EXPONENT10
FREIGHT	Freight	PRICING_I	FREIGHT
GUID	Opportunity GUID	ORDERADM_H	ORDERADM_H_GUID
IMPORTANCE	Priority of opportunity	OPPORT_H	IMPORTANCE
ITEM_CHANGED_AT	Date on which item was changed	ORDERADM_I	CHANGED_AT
ITEM_CHANGED_BY	User by whom item was changed	ORDERADM_I	CHANGED_BY
ITEM_CREATED_AT	Date on which item was created	ORDERADM_I	CREATED_AT
ITEM_CREATED_BY	User by whom item was created	ORDERADM_I	CREATED_BY
ITEM_GUID	Item GUID	ORDERADM_I	GUID
ITEM_OBJECT_TYPE	Item object type	ORDERADM_I	OBJECT_TYPE
ITM_TYPE	Item type	ORDERADM_I	ITM_TYPE
KATALOGART	Catalog type	SRV_SUBJECT	KATALOGART
LOGICAL_SYSTEM	Logical system	ORDERADM_H	LOGICAL_SYSTEM
LOGSYS_PRED	Logical system of preceding document	DOC_FLOW	LOGSYS_A
MATERIAL	Match of CRM product with R/3 material	ORDERADM_I	PRODUCT
MKT_ELEMENT	Marketing plan element	DOC_FLOW	ORDERADM_H_GUID
NET_VALUE	Net value	PRICING_I	NET_VALUE
NET_VALUE_MAN	Total expected net value of products in document currency. This value is entered manually by user.	PRICING_I	NET_VALUE_MAN
NUMBER_INT	Item number in document	ORDERADM_I	NUMBER_INT
OBJECT_ID	Transaction number	ORDERADM_H	OBJECT_ID
OBJECT_TYPE	Business transaction object type	ORDERADM_H	OBJECT_TYPE
ORDER_DATE	Posting date (into BW)	ORDERADM_I	ORDER_DATE
ORDER_QTY	CRM order quantity	SCHEDLIN	QUANTITY
PERSON_RESP	Employee responsible	PARTNER	PARTNER_NO
PHASE_SINCE	Phase start date	OPPORT_H	PHASE_SINCE
POSTING_DATE	Posting date of document	ORDERADM_H	POSTING_DATE
PREDEC_OBJKEY	Object key of preceding document	DOC_FLOW	OBJKEY_A
PREDEC_OBJTYPE	Object type of preceding document	DOC_FLOW	OBJTYPE_A
PRED_OPPT_GUID	Preceding document GUID	DOC_FLOW	OBJKEY_A
PRICE_DATE	Pricing date	PRICING	PRICE_DATE
PROCESS_QTY_DEN	Denominator for converting product quantity in transaction to base unit of measure	PRODUCT_I	PROCESS_QTY_DEN
PROCESS_QTY_NUM	Numerator for converting product quantity in transaction to base unit of measure	PRODUCT_I	PROCESS_QTY_NUM
PROCESS_QTY_UNIT	Sales unit of measure	PRODUCT_I	PROCESS_QTY_UNIT
PROCESS_TYPE	Business transaction type	ORDERADM_H	PROCESS_TYPE
PRODUCT_GUID	Product GUID	ORDERADM_I	PRODUCT
PRODUCT_ID	Product ID	ORDERADM_I	PRODUCT
PROSPECT	Prospect	PARTNER	PARTNER_NO
RECORDMODE	Delta procedure: update mode	ORDERADM_H	TASK
REF_CURRENCY	Reference currency	PRICING	REF_CURRENCY
SALESCYCLE	Sales cycle	OPPORT_H	SALESCYCLE
SALESPARTNER	Sales partner	PARTNER	PARTNER_NO
SALES_EMPLOYEE	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
SHORT_TEXT_UC	Product description in upper case	ORDERADM_I	DESCRIPTION_UC
SOURCE	Source of opportunity	OPPORT_H	SOURCE
STARTDATE	Opportunity start date	OPPORT_H	STARTDATE
STATUS_OPPT	Opportunity status	STATUS	STATUS
STATUS_SINCE	Status start date	OPPORT_H	STATUS_SINCE
SUBTOTAL1- SUBTOTAL6	Condition subtotals 1 -6 from pricing procedure	PRICING_I	SUBTOTAL1-6
TAX_AMOUNT	Tax amount in document currency	PRICING_I	TAX_AMOUNT
TYPE	Opportunity group	OPPORT_H	TYPE