SAP ABAP Table CRMT_BW_LEAD_H (BW: Datasource for CRM Leads, Header Data)

Hierarchy

☛

BBPCRM (Software Component) BBPCRM
⤷

CRM-BTX-ANA-RFW (Application Component) Reporting Framework
⤷

CRM_REPORT (Package) Operative Reporting in CRM

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BW_LEAD_H	Table Relationship Diagram
Short Description	BW: Datasource for CRM Leads, Header Data

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE				0	0	ORDERADM_H Data for BW DataSources
2	CLIENT	MANDT	MANDT	CLNT	3	0	Client	*
3	GUID	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
4	OBJECT_ID	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
5	PROCESS_TYPE	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
6	POSTING_DATE	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
7	DESCRIPTION_UC	CRMT_PROCESS_DESCRIPTION_UC	CRM_PROCESS_DESCRIPTION_UC	CHAR	40	0	Transaction Description (Upper Case)
8	DESCR_LANGUAGE	CRMT_PROCESS_DESCRIPTION_LANGU	SPRAS	LANG	1	0	Language Key of Description	*
9	LOGICAL_SYSTEM	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
10	OBJECT_TYPE	CRMT_SUBOBJECT_CATEGORY	CRM_OJ_NAME_PROCESS	CHAR	10	0	Business Transaction Category	CRMC_SUBOB_CAT
11	CREATED_AT	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
12	CREATED_BY	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
13	CHANGED_AT	CRMT_OPPT_CHANGED_AT	DATUM	DATS	8	0	Time of Last Change to the Transaction
14	CHANGED_BY	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
15	RECORDMODE	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
16	NUM_OF_HEAD	CRMT_NUMBER_OF_H	INT4	INT4	10	0	Order Header Number
17	OCCURRENCE	CRMT_OCC_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
18	SCENARIO	CRMT_SCENARIO	CRM_SCENARIO	CHAR	10	0	Scenario Identity
19	TEMPLATE_TYPE	CRMT_TEMPLATE_TYPE_DB	CRM_TEMPLATE_TYPE	CHAR	1	0	Template Type of CRM Transaction
20	OCCURR_QUOT	CRMT_QUO_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
21	OCCURR_CONT	CRMT_CON_AT_LEAST_ONCE	CRM_BOOLEAN	CHAR	1	0	Counter: Document Cat. Appears at Least Once in Document
22	REF_UPDATE	CRMT_FLG_REF_UPDATE_BW	XFELD	CHAR	1	0	Flag: Ref. Update (Extract Structure Only Partially Filled)
23	INPUT_CHANNEL	CRMT_INPUT_CHANNEL	CRM_INPUT_CHANNEL	CHAR	3	0	Input channel
24	CREATED_TS	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
25	CHANGED_TS	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
26	.INCLUDE				0	0	LEAD_H Data for BW Datasources
27	LEAD_GUID	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
28	TYPE	CRMT_LEAD_TYPE	CRM_LEAD_TYPE	CHAR	4	0	Lead Group	*
29	STATUS_LEAD	CRM_J_STATUS	CRM_J_STATUS	CHAR	5	0	Object Status
30	STATUS_SINCE	CRMT_STATUS_SINCE	DATUM	DATS	8	0	Status Since
31	IMPORTANCE	CRMT_IMPORTANCE	CRM_IMPORTANCE	CHAR	1	0	Opportunity/Lead Priority	*
32	SOURCE	CRMT_SOURCE	CRM_SOURCE	CHAR	3	0	Origin of Opportunity/Lead	*
33	QUAL_LEVEL	CRMT_LEAD_QUAL_LEVEL	CRM_LEAD_QUAL_LEVEL	CHAR	2	0	Lead Qualification Level	*
34	QUAL_LEVEL_INIT	CRMT_LEAD_QUAL_LEVEL	CRM_LEAD_QUAL_LEVEL	CHAR	2	0	Lead Qualification Level	*
35	NUMBER_OF_H	CRMT_NUMBER_OF_H	INT4	INT4	10	0	Order Header Number
36	DUR_LEAD	CRMT_DUR_LEAD	INT4	INT4	10	0	Duration of Lead in Days
37	EXP_DUR_LEAD	CRMT_DUR_LEAD	INT4	INT4	10	0	Duration of Lead in Days
38	NUMBER_CHDLEV	CRMT_NUMBER_CHDLEV	INT4	INT4	10	0	Number of Changes in Qualification Level for Lead
39	NUMBER_OF_LACT	CRMT_NUMBER_LACT	INT4	INT4	10	0	Number of Activities for a Lead
40	WON_LEADS	CRMT_WON_LEADS	INT4	INT4	10	0	Number of Leads Won
41	QUANTITY	CRMT_SCHEDLIN_QUAN	MENG13	QUAN	13	3	CRM Schedule Line Quantity
42	PRIME_LEAD_GUID	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
43	.INCLUDE				0	0	PARTNER (General) Data for BW DataSoures
44	SALES_EMPLOYEE	CRMT_SALES_EMPLOYEE	BU_PARTNER	CHAR	10	0	Employee	*
45	PERSON_RESP	CRMT_PERSON_RESP	BU_PARTNER	CHAR	10	0	Employee Responsible	*
46	CONTACT_PERSON	CRMT_CONTACT_PERSON	BU_PARTNER	CHAR	10	0	Customer Contact Person	*
47	SALESPARTNER	CRMT_SALESPARTNER	BU_PARTNER	CHAR	10	0	Sales Partners	*
48	RESP_GROUP_RFW	CRMT_RESPONSIBLE_GROUP	BU_PARTNER	CHAR	10	0	Responsible Group	*
49	PLANNING_ACCOUNT	CRMT_PLANNING_ACCOUNT	BU_PARTNER	CHAR	10	0	Planning Account	*
50	.INCLUDE				0	0	PARTNER (Locator) Various Partner Functions
51	INSTALL_AT	CRMT_INSTALL_AT_PART	BU_PARTNER	CHAR	10	0	Installed At	*
52	INSTALL_AT_LIST	CRMT_INSTALL_AT_LIST	CHAR80	CHAR	80	0	Installed At - Name
53	RESPONS_AT_PARTNER	CRMT_RESPONSIBLE_AT_PARTNER	BU_PARTNER	CHAR	10	0	Person Responsible at Partners (Channel Management)	*
54	END_CUSTOMER	CRMT_END_CUSTOMER	BU_PARTNER	CHAR	10	0	End Customer (Channel Management)	*
55	RESP_AT_PART	CRMT_RESPONSIBLE_AT_PARTNER	BU_PARTNER	CHAR	10	0	Person Responsible at Partners (Channel Management)	*
56	.INCLUDE				0	0	PARTNER (Opportunity/Activity) Data for BW DataSoures
57	COMPETITOR	CRMT_COMPETITOR	BU_PARTNER	CHAR	10	0	Competitors	*
58	PROSPECT	CRMT_PROSPECT	BU_PARTNER	CHAR	10	0	Prospect	*
59	ACTIVITY_PARTNER	CRMT_ACTIVITY_PARTNER	BU_PARTNER	CHAR	10	0	Activity Partner	*
60	.INCLUDE				0	0	ORGMAN Data for BW DataSources
61	SALES_ORG_RESP	OBJEKTID	NUM08	NUMC	8	0	Object ID
62	SALES_ORG	OBJEKTID	NUM08	NUMC	8	0	Object ID
63	SALES_OFFICE	OBJEKTID	NUM08	NUMC	8	0	Object ID
64	SALES_GROUP	OBJEKTID	NUM08	NUMC	8	0	Object ID
65	DIS_CHANNEL	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
66	DIVISION	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
67	SERVICE_ORG_RESP	OBJEKTID	NUM08	NUMC	8	0	Object ID
68	SERVICE_ORG	OBJEKTID	NUM08	NUMC	8	0	Object ID
69	PURCH_ORG_RESP	OBJEKTID	NUM08	NUMC	8	0	Object ID
70	PURCH_ORG	OBJEKTID	NUM08	NUMC	8	0	Object ID
71	PURCH_GROUP	OBJEKTID	NUM08	NUMC	8	0	Object ID
72	IC_BD_CCODE	CRM_IC_BD_CCODE	BUKRS	CHAR	4	0	Company Code for a Business Transaction	*
73	IC_BD_LOGSYS	CRM_IC_BD_LOGSYS	LOGSYS	CHAR	10	0	Logical System for a Business Transaction	*
74	.INCLUDE				0	0	SRV_OSSET Data for BW DataSources
75	KATALOGART	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
76	CODEGRUPPE	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
77	CODE	QCODE	QCODE	CHAR	4	0	Code	*
78	ACT_REASON_CAT	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
79	ACT_REASON_GROUP	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
80	ACT_REASON_CODE	QCODE	QCODE	CHAR	4	0	Code	*
81	EXT_REFOBJ	CRMT_EXT_REFOBJ	CHAR40	CHAR	40	0	External Reference Object
82	.INCLUDE				0	0	Time Characteristics for BW Reporting
83	CALDAY	SMOCALDAY	DATUM	DATS	8	0	Calendar Day
84	CALDAY_TS	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
85	.INCLUDE				0	0	DOC_FLOW Data for BW DataSources
86	PREDEC_OBJKEY	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
87	PREDEC_OBJTYPE	CRMT_PRED_OBJECT_TYPE	OJ_NAME	CHAR	10	0	Object Type of a Preceding Document	*
88	LOGSYS_PRED	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
89	MKT_ELEMENT	CRM_MKTPL_MKT_PLAN_TASKID	CGPL_EXTID	CHAR	24	0	Marketing Plan Element
90	PRED_LEAD_GUID	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
91	LEAD_CREATED_AT	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
92	PRED_OPPT_GUID	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
93	OPPT_CREATED_AT	CRMT_OPPT_CREATED_AT	DATUM	DATS	8	0	Transaction Was Created at This Time
94	PRED_ACT_GUID	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
95	ACT_CATEGORY	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
96	ACT_DIRECTION	CRMT_DIRECTION	CRM_DIRECTION	CHAR	1	0	Direction of an Activity
97	QUOTATION_GUID	CRMT_PROCESS_GUID_32	SYSUUID_C	CHAR	32	0	GUID for a Transaction
98	QUOT_VALID_FROM	CRMT_VALID_FROM_DATE	CRM_RPRTNG_DATE	DATS	8	0	Quotation Valid from Date
99	PROCESS_CATEGORY	CRMT_ACTIVITY_CATEGORY	CRM_ACTIVITY_CATEGORY	CHAR	3	0	Activity Category (Communication Type)	*
100	PROCESS_CATALOG	COMT_CATALOG	COM_CATALOG	CHAR	2	0	Catalog	*
101	PROCESS_CODEGR	QCODEGRP	QCODEGRP	CHAR	8	0	Code Group	*
102	PROCESS_CODE	QCODE	QCODE	CHAR	4	0	Code	*
103	PROCESS_OBJTYPE	CRMT_PRED_OBJECT_TYPE	OJ_NAME	CHAR	10	0	Object Type of a Preceding Document	*
104	PO_NUMBER	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
105	PO_ITEM_NUMBER	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
106	LEAD_CREATED_TS	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
107	OPPT_CREATED_TS	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
108	QUOT_VALID_TS	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
109	.INCLUDE				0	0	DATES Data for BW DataSources
110	REQUESTED_DATE	CRMT_REQUESTED_DATE	CRM_RPRTNG_DATE	DATS	8	0	Order Date
111	CONFIRMED_DATE	CRMT_CONFIRMED_DATE	CRM_RPRTNG_DATE	DATS	8	0	Latest Confirmation Date for Item Schedule Line
112	BEGIN_DATE	CRMT_BEGIN_DATE	CRM_RPRTNG_DATE	DATS	8	0	Contract Start Date
113	ENDING_DATE	CRMT_ENDING_DATE	CRM_RPRTNG_DATE	DATS	8	0	Contract End Date
114	START_OF_BILLING	CRMT_START_OF_BILLING	CRM_RPRTNG_DATE	DATS	8	0	Start Date of Billing Plan
115	VALID_FROM_DATE	CRMT_VALID_FROM_DATE	CRM_RPRTNG_DATE	DATS	8	0	Quotation Valid from Date
116	VALID_TO_DATE	CRMT_VALID_TO_DATE	CRM_RPRTNG_DATE	DATS	8	0	Quotation: Valid to Date
117	BW_POST_DATE	CRMT_BW_POST_DATE	CRM_RPRTNG_DATE	DATS	8	0	Posting Date for BW Reporting
118	PLANNED_TS_FROM	CRMT_PLANNED_TS_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp: Planned Date/Time from
119	PLANNED_TS_TO	CRMT_PLANNED_TS_TO	BCOS_TSTMP	DEC	15	0	Time Stamp: Planned Date/Time to
120	ACTUAL_TS_FROM	CRMT_ACTUAL_TS_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp: Actual Date/Time from
121	ACTUAL_TS_TO	CRMT_ACTUAL_TS_TO	BCOS_TSTMP	DEC	15	0	Time Stamp: Actual Date/Time to
122	PLANNED_FROM	CRMT_PLANNED_FROM	CRM_RPRTNG_DATE	DATS	8	0	Planned Date from
123	PLANNED_TO	CRMT_PLANNED_TO	CRM_RPRTNG_DATE	DATS	8	0	Planned Date to
124	ACTUAL_FROM	CRMT_ACTUAL_FROM	CRM_RPRTNG_DATE	DATS	8	0	Actual Date from
125	ACTUAL_TO	CRMT_ACTUAL_TO	CRM_RPRTNG_DATE	DATS	8	0	Actual Date to
126	EARLIEST_CONFIRM	CRMT_EARLIEST_CONFIRMED	CRM_RPRTNG_DATE	DATS	8	0	Earliest Confirmation Date Still Not Delivered
127	DURA	CRMT_BW_DURATION	TIMEDURA	DEC	13	0	Duration of Contract/Quotation
128	DURA_FULLFILL	CRMT_BW_DURA_FULLFILL	TIMEDURA	DEC	13	0	Duration Until Fulfillment of Contract
129	DURA_UNIT	CRMT_BW_DURA_UNIT	TIMEUNITNA	CHAR	12	0	Time Unit for Duration of Contract/Quotation in Days	*
130	BEGIN_TO_COMPLET	CRMT_BW_BEGIN_TO_COMPLETE	TIMEDURA	DEC	13	0	Duration Start to Conversion or Cancellation of a Quotation
131	COMPLETE_TO_END	CRMT_BW_COMPLETE_TO_END	TIMEDURA	DEC	13	0	Duration Conversion or Cancellation Before End of Quotation
132	REL_TO_BEGIN	CRMT_BW_REL_TO_BEGIN		DEC	7	2	Time Relation: Time to Completion / Validity Interval
133	REL_BEFORE_END	CRMT_BW_REL_BEFORE_END		DEC	5	2	Time Relation: Time Completed Before End / Validity Interval
134	REQ_DLV_DATE	CRMT_REQ_DELIVERY_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Required Delivery Date
135	LAST_DLV_DATE	CRMT_LAST_DELIVERY_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Delivery Date
136	LAST_QI_ACT_DATE	CRMT_LAST_QI_ACTUAL_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Actual Goods Issue Data
137	LAST_REQ_AVA_DAT	CRMT_LAST_REQ_AVAILABLE_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Material Availability Date (Requested)
138	LAST_CONF_AV_DAT	CRMT_LAST_CONF_AVAILABLE_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Material Availability Date (Confirmed)
139	LAST_REQ_QI_PLDA	CRMT_LAST_REQ_QI_PLANNED_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Planned Goods Issue Date (Requested)
140	LAST_CONF_QI_PLD	CRMT_LAST_CONF_QI_PLANNED_DATE	BCOS_TSTMP	DEC	15	0	Time Stamp: Last Planned Goods Issue Date (Confirmed)
141	CONFIRMED_TS	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
142	ACTUAL_FROM_TS	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
143	EARLIEST_CON_TS	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
144	REQUESTED_TS	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
145	VALID_FROM_TS	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
146	VALID_TO_TS	CRMT_DATE_TIMESTAMP_TO	BCOS_TSTMP	DEC	15	0	Time stamp (Date and Time) until a Date/Duration
147	.INCLUDE				0	0	STATUS GROUPS Data for BW Datasources
148	BWSTONESYS0	CRMBWST	J_STONR	NUMC	2	0	BW Status
149	BWSTONESYS1	CRMBWST	J_STONR	NUMC	2	0	BW Status
150	BWSTONESYS2	CRMBWST	J_STONR	NUMC	2	0	BW Status
151	BWSTONESYS3	CRMBWST	J_STONR	NUMC	2	0	BW Status
152	BWSTONESYS4	CRMBWST	J_STONR	NUMC	2	0	BW Status
153	BWSTONESYS5	CRMBWST	J_STONR	NUMC	2	0	BW Status
154	BWSTONESYS6	CRMBWST	J_STONR	NUMC	2	0	BW Status
155	BWSTONESYS7	CRMBWST	J_STONR	NUMC	2	0	BW Status
156	BWSTONESYS8	CRMBWST	J_STONR	NUMC	2	0	BW Status
157	BWSTONESYS9	CRMBWST	J_STONR	NUMC	2	0	BW Status
158	BWSTONESYSA	CRMBWST	J_STONR	NUMC	2	0	BW Status
159	BWSTTECSYS0	CRMBWST	J_STONR	NUMC	2	0	BW Status
160	BWSTTECSYS1	CRMBWST	J_STONR	NUMC	2	0	BW Status
161	BWSTTECSYS2	CRMBWST	J_STONR	NUMC	2	0	BW Status
162	BWSTLOCSYS0	CRMBWST	J_STONR	NUMC	2	0	BW Status
163	BWSTLOCSYS1	CRMBWST	J_STONR	NUMC	2	0	BW Status
164	BWSTLOCSYS2	CRMBWST	J_STONR	NUMC	2	0	BW Status
165	BWSTONESYSB	CRMBWST	J_STONR	NUMC	2	0	BW Status
166	BWSTONESYSC	CRMBWST	J_STONR	NUMC	2	0	BW Status
167	.INCLUDE				0	0	Territory Data for BW Data Sources (Partner Attribute)
168	PATH_GUID	CRMT_PATH_GUID_32	SYSUUID_C	CHAR	32	0	Path GUID of Territory 32
169	TERR_GUID	CRMT_TERR_GUID_32	SYSUUID_C	CHAR	32	0	Territory GUID 32
170	.INCLUDE				0	0	Specific Lead Header Fields for BW DataSource
171	BWSTONELEAD	CRMBWST	J_STONR	NUMC	2	0	BW Status