Opportunity Item Attributes

Technical Name: 0CRM_OPPT_ATTR_I

Technical Data

DataSource Type	Attributes (Master Data)
Application Components	CRM Sales (CRM-IO)
Available as from OLTP Release	CRM 4.0
Available as from PlugIn Release	n/a
RemoteCube-Capable

Use

This DataSource has been designed for using when planning opportunities in the mySAP SEM system.

Delta Update

The update process is triggered every time an opportunity item is changed.

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
ACT_REASON_CODE	Activity reason (code)	CRMD_PARTNER	PARTNER_NO
ACT_REASON_GROUP	Activity reason (code group)	CRMD_SRV_SUBJECT	CODEGRUPPE
BASE_QTY_UNIT	Base unit of measure	CRMD_PRODUCT_I	BASE_QTY_UNIT
BWSTONESYS0 and 4	BW status	V_CRMBWCRSYSTAT (view)	STONR
BWSTTECSYS2	BW status
CATEGORY_ID	Category ID	CRMD_PRODUCT_I	PROD_HIERARCHY
CHANGED_AT	Time of last change to transaction	CRMD_ORDERADMIN_H	CHANGED_AT
CHANGED_BY	User who last changed transaction	CRMD_ORDERADMIN_H	CHANGED_BY
CODE	Code	CRMD_SRV_SUBJECT	CODE
CODEGRUPPE	Code group	CRMD_SRV_SUBJECT	CODEGRUPPE
COMPETITOR	Competitor	CRMD_PARTNER	PARTNER_NO
COMPETITOR_PROD	Competitor product GUID	CRMD_ORDERADMIN_H	PRODUCT
CONTACT_PERSON	Contact person	CRMD_PARTNER	PARTNER_NO
CONTROL_PHASE	Analysis phase	CRMC_CYCPHASE	CONTROL_PHASE
CURRENCY	Currency	CRMD_PRICING	PRICING
CURR_PHASE	Opportunity phase	CRMD_OPPORT_H	CURR_PHASE
CUST_GROUP	Customer group	CRMD_PRICING	CUST_GROUP
DESCRIPTION_OPP	Opportunity description	CRMD_OPPORT_H	DESCRIPTION_OPP
DESCRIPTION_UC	Business transaction description (upper case)	CRMD_ORDERADMIN_H	DESCRIPTION_UC
DIS_CHANNEL	Distribution channel	CRMD_ORGMAN	DIS_CHANNEL
DIVISION	Division	CRMD_ORGMAN	DIVISION
EXECUTING_CC	Executing call center	CRMD_PARTNER	PARTNER_NO
EXPECT_END	Expected closing date of opportunity	CRMD_OPPORT_H	EXPECT_END
EXPONENT10	10x exponent for quantity conversion	CRMD_PRODUCT_I	EXPONENT10
FREIGHT	Shipment costs in document currency	CRMD_PRICING	FREIGHT
GUID	Business transaction GUID	CRMD_ORDERADM_H	GUID
IMPORTANCE	Opportunity/lead	CRMD_OPPORT_H	IMPORTANCE
ITEM_CHANGED_AT	Time at which item last changed	CRMD_ORDERADM_I	CHANGED_AT
ITEM_CHANGED_BY	User who last changed item	CRMD_ORDERADM_I	CHANGED_BY
ITEM_GUID	Item GUID	CRMD_ORDERADM_I	GUID
ITEM_OBJECT_TYPE	CRM item object type	CRMD_ORDERADM_I	OBJECT_TYPE
ITM_TYPE	Item category	CRMD_ORDERADM_I	ITM_TYPE
ITM_TYPE_USAGE	Item category usage	CRMD_ORDERADM_I	ITM_TYPE_USAGE
KATALOGART	Catalog	CRMD_SRV_SUBJECT	KATALOG
MASTEROPP_FLAG	Flag to indicate that opportunity is master opportunity	Filled in the extractor if opportunity is flagged as master opportunity
MATERIAL	Material	CRMD_ORDERADM_I	PRODUCT
MKT_ELEMENT	Marketing element	Filled from function module CRM_BW_DOCFLOW_DETERMINE_I
NUMBER_INT	Item number in document	CRMD_ORDERADM_I	NUMBER_INT
NUMBER_OF_I	Number of items	Filled as 1 (counter)
NUM_OF_HEAD	Order header number	Filled as 1 (counter)
OBJECT_ID	Business transaction number	CRMD_ORDERADM_H	OBJECT_ID
ORDER_DATE	Posting date	CRMD_ORDERADM_I	ORDER_DATE
PARENT_PRODUCT	Parent product	CRMD_ORDERADM_I	PARENT
PATH_GUID	Territory ID	CRMD_TERRITORY	PATH_GUID
PERSON_RESP	Employee responsible	CRMD_PARTNER	PARTNER_NO
PHASE_SINCE	Phase since	CRMD_OPPORT_H	PHASE_SINCE
PROCESS_QTY_UNIT	Unit of measure in which product is sold	CRMD_PRODUCT_I	PROCESS_QTY_UNIT
PROCESS_TYPE	Business transaction type	CRMD_ORDERADM_H	PROCESS_TYPE
PRODUCT_GUID	Product GUID	CRMD_ORDERADM_I (filled from COM_PRODUCT_ID_GET function module)	PRODUCT
PRODUCT_ID	Product ID	CRMD_ORDERADM_I (filled from COM_PRODUCT_ID_GET function module)	PRODUCT
PROSPECT	Prospect	CRMD_PARTNER	PROSPECT
REF_CURRENCY	Reference currency	CRMD_PRICING	REF_CURRENCY
SALESCYCLE	Sales cycle	CRMD_OPPORT_H	SALESCYCLE
SALESPARTNER	Sales partner	CRMD_PARTNER	PARTNER_NO
SALES_EMPLOYEE	Employee	CRMD_PARTNER	PARTNER_NO
SALES_GROUP	Sales group	CRMD_ORGMAN	SALES_GROUP
SALES_OFFICE	Sales office	CRMD_ORGMAN	SALES_OFFICE
SALES_ORG	Sales organization	CRMD_ORGMAN	SALES_ORG
SALES_ORG_RESP	Responsible sales organization	CRMD_ORGMAN	SALES_ORG_RESP
SERVICE_ORG	Service organization	CRMD_ORGMAN	SERVICE_ORG
SERVICE_ORG_RESP	Responsible service organization	CRMD_ORGMAN	SERVICE_ORG_RESP
SHORT_TEXT_UC	Product description in upper case	CRMD_ORDERADM_I	DESCRIPTION_UC
SOURCE	Origin of opportunity/lead	CRMD_OPPORT_H	SOURCE
STARTDATE	Opportunity start date	CRMD_OPPORT_H	STARTDATE
STATUS_OPPT	Opportunity status	CRM_JEST	STAT
STATUS_SINCE	Status since	CRMD_OPPORT_H	STATUS_SINCE
TYPE	Type	CRMD_OPPORT_H	TYPE