SAP ABAP Table CRMT_CSDR_DREG_EXEC (Design registration: Design win update Execution structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IHT-PDP (Application Component) Partner Design Projects
     ⤷ CRM_CSDR_PROJ (Package) Design Registration project object

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_CSDR_DREG_EXEC	Table Relationship Diagram
Short Description	Design registration: Design win update Execution structure

Delivery and Maintenance

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

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	One Order: Key Fields
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
4	.INCLUDE	☐				0	0	Design Registration: ORDERADM_H extension
5	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
6	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
7	POSTING_DATE	☐	CRMT_POSTING_DATE		DATS	8	0	Posting Date for a Business Transaction
8	DESCRIPTION	☐	CRMT_PROCESS_DESCRIPTION	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Transaction Description
9	DESCR_LANGUAGE	☐	CRMT_PROCESS_DESCRIPTION_LANGU	SPRAS	LANG	1	0	Language Key of Description	*
10	LOGICAL_SYSTEM	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
11	OBJECT_TYPE	☐	CRMT_SUBOBJECT_CATEGORY	CRM_OJ_NAME_PROCESS	CHAR	10	0	Business Transaction Category	*
12	.INCLUDE	☐				0	0	Design Registration: ORDERADM_I extension
13	ITEM_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
14	PRODUCT	☐	COMT_PRODUCT_GUID	SYSUUID	RAW	16	0	Internal Unique ID of Product
15	ORDERED_PROD	☐	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
16	DESCRIPTION_I	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
17	ITM_LANGUAGE	☐	CRMT_ITEM_LANGU	SYLANGU	LANG	1	0	Short Text Language for an Item
18	NUMBER_INT	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
19	ITM_TYPE	☐	CRMT_ITEM_TYPE	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
20	.INCLUDE	☐				0	0	Header Data Opportunity - Structure of External Fields
21	EXP_REVENUE	☐	CRMT_REPORT_EXP_REVENUE	WERTV8	CURR	15	2	Expected Sales Revenue
22	BUDGET_BP	☐	CRMT_BUDGET_BP	WERTV8	CURR	15	2	Budget Prospect
23	STARTDATE	☐	CRMT_STARTDATE	DATUM	DATS	8	0	Opportunity Start Date
24	EXPECT_END	☐	CRMT_EXPECT_END	DATUM	DATS	8	0	Expected Closing Date
25	CURR_PHASE	☐	CRMT_CURR_PHASE	CRM_PHASE	CHAR	3	0	Sales Stage	CRMC_PHASE
26	PHASE_SINCE	☐	CRMT_PHASE_SINCE	DATUM	DATS	8	0	Sales Stage Since
27	PROBABILITY	☐	CRMT_PROBABILITY	CRM_PROBABILITY	NUMC	3	0	Chance of Success
28	FORECAST_REL	☐	CRMT_FORECAST_REL	CRM_FORECAST_REL	CHAR	1	0	Forecast Relevance
29	SOURCE	☐	CRMT_SOURCE	CRM_SOURCE	CHAR	3	0	Origin of Opportunity/Lead	CRMC_SOURCE
30	IMPORTANCE	☐	CRMT_IMPORTANCE	CRM_IMPORTANCE	CHAR	1	0	Opportunity/Lead Priority	CRMC_OPPIMPOR
31	SALESCYCLE	☐	CRMT_SALESCYCLE	CRM_SALESCYCLE	CHAR	5	0	Sales Cycle	CRMC_CYCLE
32	ADDRESS_NO	☐	CRMT_OPP_ADDRESS	AD_ADDRNUM	CHAR	10	0	Opportunity Address	*
33	TYPE	☐	CRMT_OPPORT_TYPE	CRM_OPPORT_TYPE	CHAR	4	0	Opportunity Type	CRMC_OPPT_TYPE
34	STATUS_SINCE	☐	CRMT_STATUS_SINCE	DATUM	DATS	8	0	Status Since
35	SYS_PROBABILITY	☐	CRMT_SYSTEM_PROBABILITY	CRM_SYSTEM_PROBABILITY	NUMC	3	0	Chance of Success of Opportunity - Calculated by System
36	DESCRIPTION_OPP	☐	CRMT_DESCRIPTION_OPP	TEXT40	CHAR	40	0	Opportunity Description
37	DESCR_OPP_UC	☐	CRMT_DESCRIPTION_OPP_UC	TEXT40	CHAR	40	0	Opportunity Description in UC
38	CUSTOMER_STATUS	☐	CRMT_CUSTSTAT	CRM_CUSTSTAT	CHAR	4	0	Design Registration Project Phase	*
39	.INCLUDE	☐				0	0	EEW Include
40	OPPORT_H_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
41	.INCLUDE	☐				0	0
42	.INCLUDE	☐				0	0	Design Registration: PRODUCT_I extension
43	PROCESS_QTY_UNIT	☐	CRMT_PROCESS_QTY_UNIT	MEINS	UNIT	3	0	Unit of Measure in Which the Product Is Sold	*
44	PROD_HIERARCHY	☐	CRMT_PROD_HIERARCHY	COM_CATEGORY_ID	CHAR	20	0	Product Category
45	BASE_QTY_UNIT	☐	COMT_PRODUCT_BASE_UOM	MEINS	UNIT	3	0	Base Unit of Measure of Product	*
46	.INCLUDE	☐				0	0	Design Registration: SCHEDLIN extension
47	QUANTITY	☐	CRMT_SCHEDLIN_QUAN	MENG13	QUAN	13	3	CRM Schedule Line Quantity
48	.INCLUDE	☐				0	0	Design Registration: Partners extension
49	CHANNEL_PARTNER	☐	CRMT_PARTNER_NO	CRM_PARTNER_NO	CHAR	32	0	Partner Number
50	OEM	☐	CRMT_PARTNER_NO	CRM_PARTNER_NO	CHAR	32	0	Partner Number
51	SALES_MANAGER	☐	CRMT_PARTNER_NO	CRM_PARTNER_NO	CHAR	32	0	Partner Number
52	SALES_REPRESENTATIVE	☐	CRMT_PARTNER_NO	CRM_PARTNER_NO	CHAR	32	0	Partner Number
53	EMPLOYEE_RESP	☐	CRMT_PARTNER_NO	CRM_PARTNER_NO	CHAR	32	0	Partner Number
54	CONTACT_PERSON	☐	CRMT_PARTNER_NO	CRM_PARTNER_NO	CHAR	32	0	Partner Number
55	OEM_DES_LOCATION	☐	CRMT_PARTNER_NO	CRM_PARTNER_NO	CHAR	32	0	Partner Number
56	CHNL_PARTNER_FAE	☐	CRMT_PARTNER_NO	CRM_PARTNER_NO	CHAR	32	0	Partner Number
57	OEM_PROD_LOCATION	☐	CRMT_PARTNER_NO	CRM_PARTNER_NO	CHAR	32	0	Partner Number
58	ESTAT	☐	J_ESTAT	J_ESTAT	CHAR	5	0	User Status	*
59	.INCLUDE	☐				0	0	Orgdata Set: Structure with External Fields
60	.INCLUDE	☐				0	0	organizational Data Sales Part 2
61	DIS_CHANNEL	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*
62	DIVISION	☐	CRMT_DIVISION	CRM_DIVISION	CHAR	2	0	Division	*
63	.INCLUDE	☐				0	0	Source Organizational Data for Service
64	SERVICE_ORG_ORI	☐	CRMT_SERVICE_ORG_ORIGIN	CRM_ORIGIN	CHAR	1	0	Origin Indicator: Service Organization
65	SERVICE_ORGR_ORI	☐	CRMT_SERVICE_ORG_RESP_ORIGIN	CRM_ORIGIN	CHAR	1	0	Origin Indicator: Service Scenario Organizational Unit
66	.INCLUDE	☐				0	0	Source Organizational Data Sales
67	SALES_ORG_ORI	☐	CRMT_SALES_ORG_ORIGIN	CRM_ORIGIN	CHAR	1	0	Origin Indicator: Sales Organization
68	DIS_CHANNEL_ORI	☐	CRMT_DIS_CHANNEL_ORIGIN	CRM_ORIGIN	CHAR	1	0	Origin Indicator: Distribution Channel
69	SALES_OFF_ORI	☐	CRMT_SALES_OFFICE_ORIGIN	CRM_ORIGIN	CHAR	1	0	Origin Indicator: Sales Office
70	SALES_GROUP_ORI	☐	CRMT_SALES_GROUP_ORIGIN	CRM_ORIGIN	CHAR	1	0	Origin Indicator: Sales Group
71	SALES_ORGR_ORI	☐	CRMT_SALES_ORG_RESP_ORIGIN	CRM_ORIGIN	CHAR	1	0	Origin Indicator: Sales Scenario Organizational Unit
72	DIVISION_ORI	☐	CRMT_DIVISION_ORIGIN	CRM_ORIGIN	CHAR	1	0	Origin Flag: Division
73	.INCLUDE	☐				0	0	Sales Organization Data Part 1
74	SALES_ORG	☐	CRMT_SALES_ORG	HROBJEC_14	CHAR	14	0	Sales Organization ID
75	SALES_OFFICE	☐	CRMT_SALES_OFFICE	HROBJEC_14	CHAR	14	0	Sales Office
76	SALES_GROUP	☐	CRMT_SALES_GROUP	HROBJEC_14	CHAR	14	0	Sales Group
77	SALES_ORG_RESP	☐	CRMT_SALES_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Sales)
78	HOSTING_ORG	☐	CRMT_HOSTING_ORG	HROBJEC_14	CHAR	14	0	Hosting Org. Unit
79	.INCLUDE	☐				0	0	Organizational Data (Service)
80	SERVICE_ORG	☐	CRMT_SERVICE_ORG	HROBJEC_14	CHAR	14	0	Service Organization
81	SERVICE_ORG_RESP	☐	CRMT_SERVICE_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Service)
82	.INCLUDE	☐				0	0	Purchasing Organizational Data
83	PURCH_ORG	☐	CRMT_PURCH_ORG	HROBJEC_14	CHAR	14	0	Purchasing Organization
84	PURCH_GROUP	☐	CRMT_PURCH_GROUP	HROBJEC_14	CHAR	14	0	Purchasing Group
85	PURCH_ORG_RESP	☐	CRMT_PURCH_ORG_RESP	HROBJEC_14	CHAR	14	0	Organizational Unit (Purchasing)
86	.INCLUDE	☐				0	0	Source Purchasing Organizational Data
87	PURCH_ORG_ORI	☐	CRMT_PURCH_ORG_ORIGIN	CRM_ORIGIN	CHAR	1	0	Source flag: Purchasing Organization
88	PURCH_GROUP_ORI	☐	CRMT_PURCH_GROUP_ORIGIN	CRM_ORIGIN	CHAR	1	0	Source flag: Purchasing Group
89	PURCH_ORGR_ORI	☐	CRMT_PURCH_ORG_RESP_ORIGIN	CRM_ORIGIN	CHAR	1	0	Source Flag: Purchasing Scenario Organizational Unit
90	.INCLUDE	☐				0	0	Company code and Logical system for Business Document.
91	IC_BD_CCODE	☐	CRM_IC_BD_CCODE	BUKRS	CHAR	4	0	Company Code for a Business Transaction	*
92	IC_BD_LOGSYS	☐	CRM_IC_BD_LOGSYS	LOGSYS	CHAR	10	0	Logical System for a Business Transaction	*
93	.INCLUDE	☐				0	0	EEW Include
94	ORGMAN_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
95	.INCLUDE	☐				0	0

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_CSDR_DREG_EXEC	CURR_PHASE	CRMC_PHASE	PHASE
2	CRMT_CSDR_DREG_EXEC	IMPORTANCE	CRMC_OPPIMPOR	IMPORTANCE
3	CRMT_CSDR_DREG_EXEC	SALESCYCLE	CRMC_CYCLE	SALESCYCLE
4	CRMT_CSDR_DREG_EXEC	SOURCE	CRMC_SOURCE	SOURCE
5	CRMT_CSDR_DREG_EXEC	TYPE	CRMC_OPPT_TYPE	TYPE

History

Last changed by/on	SAP	20130604
SAP Release Created in	400