CRMS4D_OPPT_I - Item details of Opportunities and Leads

Item details of Opportunities and Leads information is stored in SAP table CRMS4D_OPPT_I.
It is part of development package CRMS4_ORDER in software component CRM-S4-BTX. This development package consists of objects that can be grouped under "One Order: Redesign of Persistence Layer".

Fields for table CRMS4D_OPPT_I

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.INCLUDE		X		CRMS4S_KEY_I	0
.INCLUDE		X		CRMS4S_KEY_H	0
CLIENT	Client	X	MANDT	CLNT	6	T000
OBJTYPE_H	Business Trans. Cat.	X	CRMT_SUBOBJECT_CATEGORY_DB	CHAR	20	CRMC_SUBOB_CAT
OBJECT_ID	Transaction ID	X	CRMT_OBJECT_ID_DB	CHAR	20
NUMBER_INT	Shortened Item Number in Document	X	CRMS4_NUMBER_INT	NUMC	12
.INCLUDE				CRMS4S_OPPT_I_AC_ASSIGN	0
.INCLUDE				CRMS4S_OPPT_C_AC_ASSIGN	0
AC_OBJECT_TYPE	Object Type for Settlement Account Assignment		CRMT_AC_OBJECT_TYPE	CHAR	4	CRMC_AC_ASSIGN
AC_ASSIGNMENT	Settlement Account Assignment		CRMT_AC_ASSIGN	CHAR	100
AC_PERCENTAGE	Percentage of Costs to Be Distributed		CRMT_AC_COST_PERCENTAGE	DEC	3
.INCLUDE				CRMS4S_OPPT_I_H	0
.INCLUDE				CRMS4S_OPPT_I_ORDERADM_H	0
PROCESS_TYPE	Business Transaction Type		CRMT_PROCESS_TYPE_DB	CHAR	8	CRMC_PROC_TYPE
POSTING_DATE	Posting Date for a Business Transaction		CRMT_POSTING_DATE	DATS	16
DESCRIPTION_H	Transaction Description		CRMT_PROCESS_DESCRIPTION	CHAR	80
DESCR_LANGUAGE	Language Key of Description		CRMT_PROCESS_DESCRIPTION_LANGU	LANG	2	T002
TEMPLATE_TYPE	Template Type of CRM Transaction		CRMT_TEMPLATE_TYPE_DB	CHAR	2
CREATED_AT_H	Created At (Output in User Time Zone)		COMT_CREATED_AT_USR	DEC	8
CREATED_BY_H	User that Created the Transaction		CRMT_CREATED_BY	CHAR	24
CHANGED_AT_H	Changed At (Output in User Time Zone)		COMT_CHANGED_AT_USR	DEC	8
CHANGED_BY_H	Transaction Last Changed By		CRMT_CHANGED_BY	CHAR	24
BTX_CLASS	CRM Business Transaction Classification		CRMT_TRANSACTION_CLASSIFICATN	CHAR	2	CRMC_TRANS_CLASS
AUTH_SCOPE	Authorization Scope		CRM_AUTH_SCOPE	NUMC	12	CRMC_AUTH_SCP
ARCHIVING_FLAG	Indicator Whether the Business Transaction Can Be Archived		CRMT_ARCHIVING_FLAG	CHAR	2
.INCLUDE				CRMS4S_OPPT_I_ORDERADM_I	0
ITEM_GUID	GUID of a CRM Order Object		CRMT_OBJECT_GUID	RAW	16
CREATED_AT_I	Created At (Output in User Time Zone)		COMT_CREATED_AT_USR	DEC	8
CREATED_BY_I	User that Created the Transaction		CRMT_CREATED_BY	CHAR	24
CHANGED_AT_I	Changed At (Output in User Time Zone)		COMT_CHANGED_AT_USR	DEC	8
CHANGED_BY_I	Transaction Last Changed By		CRMT_CHANGED_BY	CHAR	24
OBJTYPE_I	CRM Item Object Type		CRMT_SWO_OBJTYP_PROCESS_ITM_DB	CHAR	20	CRMC_SUBOB_CAT_I
HEADER_GUID	GUID of a CRM Order Object		CRMT_OBJECT_GUID	RAW	16
PARENT	GUID of a CRM Order Object		CRMT_OBJECT_GUID	RAW	16
ALTERNATIVE	GUID of a CRM Order Object		CRMT_OBJECT_GUID	RAW	16
PRODUCT	Internal Unique ID of Product		CRMT_PRODUCT_GUID_DB	RAW	16
ORDERED_PROD	Product Name Entered		CRMT_ORDERED_PROD_DB	CHAR	108
PARTNER_PROD	Product Number of Business Partner		CRMT_ITEM_DESCR_PARTNER	CHAR	80
DESCRIPTION_I	Product Description		CRMT_PRSHTEXTX_DB	CHAR	80
ITM_LANGUAGE	Short Text Language for an Item		CRMT_ITEM_LANGU	LANG	2
NUMBER_EXT	External Item Number		CRMT_ITEM_NO_EXT	NUMC	20
ITM_TYPE	Item Category		CRMT_ITEM_TYPE_DB	CHAR	8	CRMC_ITEM_TYPE
ORDER_DATE	Posting Date		CRMT_ORDER_DATE	DEC	8
ITM_USAGE	Usage of Higher-Level Item		CRMT_ITEM_USAGE	CHAR	4
ITM_TYPE_USAGE	Item Category Usage		CRMT_IT_TYPE_USAGE	CHAR	8	CRMC_IT_TYPE_US
PRODUCT_KIND	Product Technical Type		CRMT_PRODUCT_KIND	CHAR	2
REVACC_REFID	Revenue Accounting Reference ID		CRMT_REVACC_REFID	CHAR	60
REVACC_REFTYPE	Revenue Accounting Reference Type		CRMT_REVACC_REFTYPE	CHAR	6
REVACC_RELEVANT_TYPE	Revenue Accounting Type		CRMT_REVACC_RELEVANT_TYPE	CHAR	2
PRODUCT_ID	Product Number		PRODUCTNUMBER	CHAR	80
ITEM_GUID_CHAR	32 Character CRM Object GUID (Converted)		CRMT_OBJECT_GUID32	CHAR	64
.INCLUDE				CRMS4S_OPPT_I_ORGMAN	0
.INCLUDE				CRMS4S_OPPT_C_ORGMAN	0
DIS_CHANNEL	Distribution Channel		CRMT_DISTRIBUTION_CHANNEL	CHAR	4	TVTW
DIVISION	Division		CRMT_DIVISION	CHAR	4	TSPA
SERVICE_ORG_ORI	Origin Indicator: Service Organization		CRMT_SERVICE_ORG_ORIGIN	CHAR	2
SERVICE_ORGR_ORI	Origin Indicator: Service Scenario Organizational Unit		CRMT_SERVICE_ORG_RESP_ORIGIN	CHAR	2
SALES_ORG_ORI	Origin Indicator: Sales Organization		CRMT_SALES_ORG_ORIGIN	CHAR	2
DIS_CHANNEL_ORI	Origin Indicator: Distribution Channel		CRMT_DIS_CHANNEL_ORIGIN	CHAR	2
SALES_OFF_ORI	Origin Indicator: Sales Office		CRMT_SALES_OFFICE_ORIGIN	CHAR	2
SALES_GROUP_ORI	Origin Indicator: Sales Group		CRMT_SALES_GROUP_ORIGIN	CHAR	2
SALES_ORGR_ORI	Origin Indicator: Sales Scenario Organizational Unit		CRMT_SALES_ORG_RESP_ORIGIN	CHAR	2
DIVISION_ORI	Origin Flag: Division		CRMT_DIVISION_ORIGIN	CHAR	2
SALES_ORG	Sales Organization ID		CRMT_SALES_ORG	CHAR	28
SALES_OFFICE	Sales Office		CRMT_SALES_OFFICE	CHAR	28
SALES_GROUP	Sales Group		CRMT_SALES_GROUP	CHAR	28
SALES_ORG_RESP	Organizational Unit (Sales)		CRMT_SALES_ORG_RESP	CHAR	28
SERVICE_ORG	Service Organization		CRMT_SERVICE_ORG	CHAR	28
SERVICE_ORG_RESP	Organizational Unit (Service)		CRMT_SERVICE_ORG_RESP	CHAR	28
.INCLUDE				CRMS4S_ORGMAN_SALES_SD	0
SALES_ORG_SD	Sales Organization		VKORG	CHAR	8
SALES_OFFICE_SD	Sales office		VKBUR	CHAR	8	*
SALES_GROUP_SD	Sales group		VKGRP	CHAR	6	*
.INCLUDE				CRMS4S_OPPT_I_PARTNER	0
.INCLUDE				CRMS4S_OPPT_C_PARTNER	0
SALES_REP	Sales Rep		CRMS4_SALES_REP	CHAR	20	BUT000
PERSON_RESP	Employee Responsible		CRMT_PERSON_RESP	CHAR	20	BUT000
CONTACT_PERSON	Customer Contact Person		CRMT_CONTACT_PERSON	CHAR	20	BUT000
SALES_PROSPECT	Sales Prospect		CRMS4_SALES_PROSPECT	CHAR	20	BUT000
PAYER	Payer		CRMT_RP_PAYER	CHAR	20	BUT000
COMPETITOR	Competitor		CRMS4_COMPETITOR	CHAR	20	BUT000
.INCLUDE				CRMS4S_OPPT_I_PRICING	0
.INCLUDE				CRMS4S_OPPT_C_PRICING	0
EXCHG_TYPE	Exchange Rate Type		CRMT_EXCHG_TYPE	CHAR	8	TCURV
EXCHG_DATE	Exchange Rate Date		CRMT_EXCHG_DATE	DATS	16
TAXJURCODE	Tax Jurisdiction Code (Structure for tax calculation)		CRMT_TAXJURCODE	CHAR	30	TTXJ
CUST_PRIC_PROC	Customer Pricing Procedure		CRMT_CUST_PRIC_PROC	CHAR	4	TVKD
REF_CURRENCY	Reference Currency		CRMT_REF_CURRENCY	CUKY	10	TCURC
CURRENCY	Currency		CRMT_CURRENCY	CUKY	10	TCURC
PRICE_DATE	Pricing Date		CRMT_PRICE_DATE	DATS	16
PMNTTRMS	Terms of Payment		CRMT_PMNTTRMS	CHAR	8	T052
PRICE_GRP	Customer Price Group		CRMT_PRICE_GRP	CHAR	4	T188
CUST_GROUP	Customer Group		CRMT_CUST_GROUP	CHAR	4	T151
EXCHG_RATE	Exchange Rate		CRMT_EXCHG_RATE	DEC	5
TAX_DEST_CTY	Tax Destination Country/Region		CRMT_TAX_DEST_CTY	CHAR	6	T005
TAX_DEST_REG	Region (State, Province, County)		CRMT_REGION	CHAR	6	T005S
VAT_REG_NO	Sales tax registration number		CRMT_VAT_REG_NO	CHAR	40
AC_INDICATOR	Accounting Indicator		CRMT_AC_INDICATOR	CHAR	4	TBMOT
CUSTOMER_TYPE	Business Partner Type		CRMT_CUSTOMER_TYPE	CHAR	8	TB004
PAYMENT_METHOD	Payment Method		CRMT_BUAG_PAYMETH	CHAR	2	CRMC_BUAG_PAYM
.INCLUDE				CRMS4S_OPPT_I_PRICING_I	0
NET_VALUE_MAN_I	Total Expected Net Value Products in Document Currency		CRMT_NET_VALUE_MAN	CURR	8
COST_AMOUNT_MAN	Total Expected Cost Amount in Document Currency		CRMT_COST_AMOUNT_MAN	CURR	8
STATISTICAL	Statistical values		CRMT_STATISTICAL	CHAR	2
PRC_INDICATOR	Pricing indicator		CRMT_PRICING_INDICATOR	CHAR	2
NET_VALUE_I	Net Value		CRMT_NET_VALUE	CURR	8
NET_PRICE_I	Net Price		CRMT_NET_PRICE	CURR	8
TAX_AMOUNT_I	Tax amount in document currency		CRMT_TAX_AMOUNT	CURR	8
FREIGHT_I	Shipment costs in document currency		CRMT_FREIGHT	CURR	8
GROSS_VALUE_I	Gross Order Value in PO Currency		CRMT_GROSS_VALUE	CURR	8
NET_WO_FREIGHT_I	Item Net Value Exclusive Shipment		PRCT_NET_VALUE_WITHOUT_FREIGHT	CURR	8
SUBTOTAL1	Subtotal 1 from pricing procedure for condition		CRMT_SUBTOTAL1	CURR	8
SUBTOTAL2	Subtotal 2 from pricing procedure for condition		CRMT_SUBTOTAL2	CURR	8
SUBTOTAL3	Subtotal 3 from pricing procedure for condition		CRMT_SUBTOTAL3	CURR	8
SUBTOTAL4	Subtotal 4 from pricing procedure for condition		CRMT_SUBTOTAL4	CURR	8
SUBTOTAL5	Subtotal 5 from pricing procedure for condition		CRMT_SUBTOTAL5	CURR	8
SUBTOTAL6	Subtotal 6 from pricing procedure for condition		CRMT_SUBTOTAL6	CURR	8
CREDIT_INDICATOR	Credit Debit Indicator		CRMT_CREDIT_INDICATOR	CHAR	2
NETPR_PRIC_UNIT	Condition Pricing Unit		PRCT_COND_PRICING_UNIT	DEC	3
NETPR_UOM	Condition Unit		PRCT_COND_UOM	UNIT	6	T006
TOTAL_DISCOUNT_I	Price Determination: Condition Value		PRCT_COND_VALUE	CURR	8
.INCLUDE				CRMS4S_OPPT_I_PRODUCT_I	0
GROSS_WEIGHT_I	Gross Weight		CRMT_GROSS_WEIGHT	QUAN	8
NET_WEIGHT_I	Net Weight		CRMT_NET_WEIGHT	QUAN	8
WEIGHT_UNIT_I	Weight Unit		COMT_WEIGHT_UNIT	UNIT	6	T006
VOLUME_I	Volume Occupied by the Product per Volume Unit		CRMT_VOLUME	QUAN	8
VOLUME_UNIT_I	Unit for the Volume of a Product		COMT_VOLUME_UNIT	UNIT	6	T006
PRICE_PRODUCT	Pricing Reference Product Globally Unique Identifier		CRMT_PRICE_PRODUCT	RAW	16
PROCESS_QTY_NUM	Numerator (factor) for conversion trans. quantity in BME		CRMT_PROCESS_QTY_NUM	INT4	4
PROCESS_QTY_DEN	Denominator (factor) for conversion trans. quantity in BME		CRMT_PROCESS_QTY_DEN	INT4	4
EXPONENT10	10 Exponent for Quantity Conversion		CRMT_EXPONENT10	INT2	2
PROCESS_QTY_UNIT	Unit of Measure in Which the Product Is Sold		CRMT_PROCESS_QTY_UNIT	UNIT	6	T006
COMM_GROUP	Commission Group		CRMT_COMM_GROUP	CHAR	4	*
REBATE_GROUP	Volume Rebate Group		CRMT_REBATE_GROUP	CHAR	4	*
CASH_DISC	Specifies Whether a Cash Discount Can Be Given for the Prod.		CRMT_CASH_DISC	CHAR	2
PROD_PR_GROUP	Product Group		CRMT_PROD_PR_GROUP	CHAR	4	*
PRC_GROUP1	Product Group 1		CRMT_PRC_GROUP1	CHAR	6	*
PRC_GROUP2	Product Group 2		CRMT_PRC_GROUP2	CHAR	6	*
PRC_GROUP3	Product Group 3		CRMT_PRC_GROUP3	CHAR	6	*
PRC_GROUP4	Product Group 4		CRMT_PRC_GROUP4	CHAR	6	*
PRC_GROUP5	Product Group 5		CRMT_PRC_GROUP5	CHAR	6	*
PROD_HIERARCHY	Product Category		CRMT_PROD_HIERARCHY	CHAR	40
BASE_QTY_UNIT	Base Unit of Measure of Product		COMT_PRODUCT_BASE_UOM	UNIT	6	T006
PLANT	Plant		WERKS_D	CHAR	8	T001W
.INCLUDE				CRMS4S_OPPT_I_SALES	0
.INCLUDE				CRMS4S_OPPT_C_SALES	0
REGION	Region (State, Province, County)		CRMT_REGION	CHAR	6	T005S
INDUSTRY	Industry Sector		CRMT_INDUSTRY	CHAR	8	T016
CUST_GROUP1	Customer Group 1		CRMT_CUST_GROUP1	CHAR	6	TVV1
CUST_GROUP2	Customer Group 2		CRMT_CUST_GROUP2	CHAR	6	TVV2
CUST_GROUP3	Customer Group 3		CRMT_CUST_GROUP3	CHAR	6	TVV3
CUST_GROUP4	Customer Group 4		CRMT_CUST_GROUP4	CHAR	6	TVV4
CUST_GROUP5	Customer Group 5		CRMT_CUST_GROUP5	CHAR	6	TVV5
PO_NUMBER_SOLD	Sold-To Party's External Reference Number		CRMT_PO_NUMBER_SOLD	CHAR	70
PO_DATE_SOLD	Reference Document Date		CRMT_PO_DATE_SOLD	DATS	16
YOUR_REF_SOLD	Sold-to Party Reference		CRMT_YOUR_REFERENCE_SOLD	CHAR	24
PO_NUMBER_SHIP	Ship-To Party's External Reference Number		CRMT_PO_NUMBER_SHIP	CHAR	70
PO_DATE_SHIP	Ship-To Party's Reference Document Date		CRMT_PO_DATE_SHIP	DATS	16
YOUR_REF_SHIP	Ship-To Party Reference		CRMT_YOUR_REFERENCE_SHIP	CHAR	24
USAGE_TYPE	Usage Indicator		CRMT_USAGE	CHAR	6	TVLV
SUBMISSION	Collective Number for Quotations		CRMT_SUBMISSION	CHAR	20
REJECTION	Cancellation Reason Code		CRMT_REJECTION_CODE	CHAR	4	TVAG
PROBABILITY	Order Probability		CRMT_ORDER_PROBABILITY	NUMC	6
DATE_QTY_FIXED	Fixed Date and Quantity		CRMT_DATE_QTY_FIXED	CHAR	2
REQ_DLV_DATE_H	Requested Delivery Date Header		CRMT_REQ_DLV_DATE	DEC	8
REQ_TIMEZONE_H	Time Zone Requested Delivery Date Header		CRMT_REQ_DATE_TIMEZONE	CHAR	12	TTZZ
RULE_REQ_DATE_H	Rule Reqested Delivery Date Header		CRMT_RULE_REQ_DATE	RAW	16	TIMERULEH
.INCLUDE				CRMS4S_OPPT_I_STATUS	0
.INCLUDE				CRMS4S_OPPT_C_STATUS	0
STAT_LIFECYCLE	Life Cycle Status		CRMS4_STAT_LIFECYCLE	CHAR	8
STAT_LIFECYCLE_OPPT	Opportunity Lifecycle Status		CRMS4_STAT_LIFECYCLE_OPPT	CHAR	8
STAT_ERROR	Error Status		CRMS4_STAT_ERROR	CHAR	2
STAT_ARCHIVABLE	Archivable		CRMS4_STAT_ARCHIVABLE	CHAR	2
STAT_ARCHIVED	Archived		CRMS4_STAT_ARCHIVED	CHAR	2
STAT_OPEN	Status "Open"		CRMS4_STAT_OPEN	CHAR	2
.INCLUDE				CRMS4S_OPPT_I_SCHEDLIN_I	0
ORDER_QTY	CRM: Order Quantity		CRMT_QTY_ORDER	QUAN	7
FIRST_REQ_DATE	First Requested Delivery Date for an Item		CRMS4_FIRST_REQ_DATE	DEC	8
.INCLUDE				CRMS4S_ITEM_SET_FIELDS	0
ITEM_NO_APPT	Shortened Item Number in Document		CRMS4_NUMBER_INT	NUMC	12
ITEM_NO_PARTNER	Shortened Item Number in Document		CRMS4_NUMBER_INT	NUMC	12
ITEM_NO_QUALIF	Shortened Item Number in Document		CRMS4_NUMBER_INT	NUMC	12
ITEM_NO_REFOBJ	Shortened Item Number in Document		CRMS4_NUMBER_INT	NUMC	12
ITEM_NO_SUBJECT	Shortened Item Number in Document		CRMS4_NUMBER_INT	NUMC	12
ITEM_NO_SURVEY	Shortened Item Number in Document		CRMS4_NUMBER_INT	NUMC	12
ITEM_NO_BILLPLAN	Shortened Item Number in Document		CRMS4_NUMBER_INT	NUMC	12
ITEM_NO_PAYPLAN	Shortened Item Number in Document		CRMS4_NUMBER_INT	NUMC	12
.INCLUDE				CRMS4S_OPPT_I_INCL_EEW_PS	0
OPPT_I_DUMMY_PS	Single-Character Flag		CHAR1	CHAR	2