CRMS4D_OPPT_H - Header details of Opportunities and Leads

Header details of Opportunities and Leads information is stored in SAP table CRMS4D_OPPT_H.
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_H

Field Name	Description	Is Key	Data Element	Data Type	Length	Check Table
.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
.INCLUDE				CRMS4S_OPPT_H_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_H_CUMULAT_H	0
GROSS_WEIGHT_H	Gross Weight for Total Document		CRMT_GROSS_WEIGHT_CUM	QUAN	8
NET_WEIGHT_H	Net Weight of Total Document		CRMT_NET_WEIGHT_CUM	QUAN	8
WEIGHT_UNIT_H	Weight Unit		COMT_WEIGHT_UNIT	UNIT	6	T006
VOLUME_H	Total Volume of Document		CRMT_VOLUME_CUM	QUAN	8
VOLUME_UNIT_H	Unit for the Volume of a Product		COMT_VOLUME_UNIT	UNIT	6	T006
GROSS_VALUE_H	Total Gross Value of Document in Document Currency		CRMT_GROSS_VALUE_CUM	CURR	8
NET_VALUE_H	Total Net Value of Document in Document Currency		CRMT_NET_VALUE_CUM	CURR	8
NET_VALUE_MAN_H	Expected Total Net Value of Products in Document Currency		CRMT_NET_VALUE_MAN_CUM	CURR	8
TAX_AMOUNT_H	Total Tax Amount in Document Currency		CRMT_TAX_AMOUNT_CUM	CURR	8
FREIGHT_H	Shipment Costs for Document in Total Document Currency		CRMT_FREIGHT_CUM	CURR	8
NET_WO_FREIGHT_H	Header sums: Net value without freight		CRMT_NET_WO_FREIGHT_CUM	CURR	8
NUMBER_ITEMS	Number of items in an order		CRMT_NUMBER_ITEMS	INT2	2
.INCLUDE				CRMS4S_OPPT_H_LEAD_H	0
LEAD_TYPE	Lead Group		CRMT_LEAD_TYPE	CHAR	8	CRMC_LEAD_TYPE
QUAL_LEVEL_MAN	Lead Qualification Level		CRMT_LEAD_QUAL_LEVEL_MAN	CHAR	4	CRMC_LEAD_QL
QUAL_LEVEL_AUTO	Lead Qualification Level (Automatic)		CRMT_LEAD_QUAL_LEVEL_AUTO	CHAR	4	CRMC_LEAD_QL
QUAL_LEVEL_SVY	Questionnaire that Q-Level Sets (Automatically)		CRMT_LEAD_QUAL_LEVEL_AUTO_SVY	CHAR	64
.INCLUDE				CRMS4S_OPPT_H_LEAD_H_DATES	0
LEAD_END	End Date		CRMS4_LEAD_END	DEC	8
LEAD_START	Start Date		CRMS4_LEAD_START	DEC	8
.INCLUDE				CRMS4S_OPPT_H_OPPORT_H	0
EXP_REVENUE	Expected Sales Revenue		CRMT_REPORT_EXP_REVENUE	CURR	8
BUDGET_BP	Budget Prospect		CRMT_BUDGET_BP	CURR	8
STARTDATE	Opportunity Start Date		CRMT_STARTDATE	DATS	16
EXPECT_END	Expected Closing Date		CRMT_EXPECT_END	DATS	16
CURR_PHASE	Sales Stage		CRMT_CURR_PHASE	CHAR	6	CRMC_PHASE
PHASE_SINCE	Sales Stage Since		CRMT_PHASE_SINCE	DATS	16
SOURCE	Origin of Opportunity/Lead		CRMT_SOURCE	CHAR	6	CRMC_SOURCE
PRIORITY	Activity Priority		CRMT_PRIORITY	NUMC	2	SCPRIO
SALESCYCLE	Sales Cycle		CRMT_SALESCYCLE	CHAR	10	CRMC_CYCLE
TYPE	Opportunity Type		CRMT_OPPORT_TYPE	CHAR	8	CRMC_OPPT_TYPE
STATUS_SINCE	Status Since		CRMT_STATUS_SINCE	DATS	16
SYS_PROBABILITY	Chance of Success of Opportunity - Calculated by System		CRMT_SYSTEM_PROBABILITY	NUMC	6
.INCLUDE				CRMS4S_OPPT_H_ORDERADM_H	0
HEADER_GUID	GUID of a CRM Order Object		CRMT_OBJECT_GUID	RAW	16
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
HEAD_CHANGED_AT	Time of Last Change to the Transaction		CRMT_CHANGED_AT	DEC	8
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
OBJECT_ID_OK	Indicator That Transaction ID Is Correct		CRMT_OBJECT_ID_OK	CHAR	2
VERIFY_DATE	Time Period of Last Archiving Attempt		CRMT_VERIFY_DATE	DEC	8
PRICING_DOCUMENT	Number of the Document Condition		KNUMV	CHAR	20	PRCD_ELEMENTS
PRICING_PROCEDURE	Procedure (Pricing, Output Control, Acct. Det., Costing,...)		KALSM_D	CHAR	12	T683
HEADER_GUID_CHAR	32 Character CRM Object GUID (Converted)		CRMT_OBJECT_GUID32	CHAR	64
SDM_STATUS_DURA	SDM status of duration migration		CRMS4_SDM_STATUS_DURA	CHAR	4
.INCLUDE				CRMS4S_OPPT_H_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_H_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_INBOX_PARTNER	0
INBOX_ASSIGNED_TO	Employee Responsible		CRMT_PERSON_RESP	CHAR	20	BUT000
INBOX_GROUP_ASSIGNED	Responsible Group		CRMT_RESPONSIBLE_GROUP	CHAR	20	BUT000
INBOX_ACCOUNT	Sales Partners		CRMT_SALESPARTNER	CHAR	20	BUT000
INBOX_CONTACT_PERSON	Customer Contact Person		CRMT_CONTACT_PERSON	CHAR	20	BUT000
.INCLUDE				CRMS4S_OPPT_H_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_H_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_H_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
STAT_DUPLICATE	Duplicate		CRMS4_STAT_DUPLICATE	CHAR	2
INBOX_STATUS	Status of Agent Inbox Item		CRMT_AUI_STATUS	NUMC	8
STAT_NOTIF_REQUIRED	Status 'Lead Deduplication Notification Required'		CRMS4_STAT_NOTIF_REQUIRED	CHAR	2
.INCLUDE				CRMS4S_OPPT_H_INCL_EEW_PS	0
OPPT_H_DUMMY_PS	Single-Character Flag		CHAR1	CHAR	2