SAP ABAP Table CRMST_QUERY_R_PROVCON_BTIL (Bus. Transaction IL Structure for Provider Con - Result List)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IC-PRV (Application Component) Provider Transactions in Interaction Center
     ⤷ CRM_PROVIDER_BTIL (Package) Provider Contracts/Provider Contract Request: GenIL

Basic Data

Table Category	INTTAB	Structure
Structure	CRMST_QUERY_R_PROVCON_BTIL	Table Relationship Diagram
Short Description	Bus. Transaction IL Structure for Provider Con - Result List

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	Reporting Structure for Ext. ORDERADM_I
2	.INCLUDE	☐				0	0	Business Transaction Item
3	.INCLUDE	☐				0	0	One Order: Key Fields
4	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
5	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
6	.INCLUDE	☐				0	0	Item: Structure of System Fields
7	.INCLUDE	☐				0	0	Time and User of Last Transaction Processing
8	CREATED_AT	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
9	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
10	CHANGED_AT	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
11	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
12	OBJECT_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS_ITM_DB	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type	*
13	DESCRIPTION_UC	☐	CRMT_PRSHTEXTG_DB	CRM_PRSHTEXTG40_DB	CHAR	40	0	Product Short Text in Upper Case for F4 Help
14	.INCLUDE	☐				0	0	Item: Structre of External Fields
15	HEADER	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
16	PARENT	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
17	ALTERNATIVE	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
18	PRODUCT	☐	CRMT_PRODUCT_GUID_DB	SYSUUID	RAW	16	0	Internal Unique ID of Product
19	PRODUCT_SRC_SYS	☐	CRMT_PRODUCT_SRC_SYS	LOGSYS	CHAR	10	0	Logical System from Which Product Originates	*
20	ORDERED_PROD	☐	CRMT_ORDERED_PROD_DB	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
21	PARTNER_PROD	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
22	DESCRIPTION	☐	CRMT_PRSHTEXTX_DB	CRM_PRSHTEXT40_DB	CHAR	40	0	Product Short Text
23	ITM_LANGUAGE	☐	CRMT_ITEM_LANGU	SYLANGU	LANG	1	0	Short Text Language for an Item
24	NUMBER_INT	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
25	NUMBER_EXT	☐	CRMT_ITEM_NO_EXT		NUMC	10	0	External Item Number
26	ITM_TYPE	☐	CRMT_ITEM_TYPE_DB	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
27	ORDER_DATE	☐	CRMT_ORDER_DATE	BCOS_TSTMP	DEC	15	0	Posting Date
28	SUBST_REASON	☐	CRMT_ITEM_SUBSTITUTION	CRM_ITEM_SUBSTITUTION	CHAR	4	0	Reason for Product Substitution	*
29	ITM_USAGE	☐	CRMT_ITEM_USAGE	CRM_ITEM_USAGE	CHAR	2	0	Usage of Higher-Level Item
30	ITM_TYPE_USAGE	☐	CRMT_IT_TYPE_USAGE	CRM_IT_TYPE_USAGE	CHAR	4	0	Item Category Usage	*
31	PRODUCT_KIND	☐	CRMT_PRODUCT_KIND	CRM_PRODUCT_KIND	CHAR	1	0	Technnical Type of Product
32	LOG_SYSTEM_EXT	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
33	.INCLUDE	☐				0	0	EEW Extension
34	ORDERADM_I_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
35	.INCLUDE	☐				0	0
36	.INCLU--AP	☐				0	0	Additional Fields in ORDERADM_I_EXT
37	ALTID_TYPE	☐	COMT_ALTID_TYPE	CHAR16	CHAR	16	0	ID Type for Alternative IDs
38	PARENT_IN_COMP_TX	☐	CRMT_COMP_TX_PARENT_GUID	SYSUUID	RAW	16	0	Higher-Level Item Number in Composite Transaction
39	NUMBER_INT_COMP_TX	☐	CRMT_COMP_TX_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Composite Transaction-Specific Item Number
40	CONCATSTAT_I	☐	J_STEXT	TEXT40	CHAR	40	0	System status line
41	CONCATSTATUSER_I	☐	J_ATEXT	TEXT40	CHAR	40	0	User Status Line
42	.INCLUDE	☐				0	0	Shared adm_h Part During Item Selection
43	OBJECT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
44	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
45	HD_DESCRIPTION	☐	CRMT_PROCESS_DESCRIPTION	CRM_PROCESS_DESCRIPTION	CHAR	40	0	Transaction Description
46	ITM_TYPE_TEXT	☐	CRMT_ITM_TYPE_DESC	TEXT40	CHAR	40	0	Item Category Text
47	SOLD_TO_PARTY_LIST	☐	CRMT_SOLD_TO_PART_LIST	TEXT80	CHAR	80	0	Sold-To Party
48	SOLD_TO_PARTY	☐	CRMT_SOLD_TO_PART	BU_PARTNER	CHAR	10	0	Sold-To Party	*
49	DATE_CONTSTART	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
50	TZONE_CONTSTART	☐	CRMT_TIMEZONE_FROM	TZNZONE	CHAR	6	0	Time Zone for a Start Time	*
51	DATE_CONTEND	☐	CRMT_DATE_TIMESTAMP_FROM	BCOS_TSTMP	DEC	15	0	Time Stamp (Date and Time) of a Date/Duration
52	TZONE_CONTEND	☐	CRMT_TIMEZONE_FROM	TZNZONE	CHAR	6	0	Time Zone for a Start Time	*
53	VALID_FROM	☐	CRMT_DATES_START_DATE	DATUM	DATS	8	0	Start Date
54	VALID_TO	☐	CRMT_DATES_END_DATE	DATS	DATS	8	0	End Date
55	.INCLUDE	☐				0	0	Provider Order Item Reporting Extension
56	.INCLUDE	☐				0	0	Provider Order Item Extension: Query Result relevant data
57	A3SELTYPE	☐	IST_SELECTION_TYPE	IST_SELECTION_TYPE	CHAR	1	0	Product Selection Type
58	A3EXTREF	☐	CRMT_IST_EXT_REF_TEXT	CRMT_IST_EXT_REF_TEXT	CHAR	40	0	IS-T Contract Number
59	MA_PROD_ID	☐	CRMT_ISX_PRVMA_PROD_ID	CRMT_ISX_PRVMA_PROD_ID	CHAR	40	0	Custom Specific ID for Product or Product Range
60	LEAD_TR_OBJ_ID	☐	CRMT_LEADING_TECH_RES_ID	CRM_TC_TECH_RES_ID	CHAR	50	0	ID of leading technical resource in a Provider Contract
61	TR_TYPE	☐	CRMT_TC_TR_TYPE	CRM_TC_TR_TYPE	CHAR	2	0	Technical Resource Type	*
62	TR_TYPE_DESC	☐	CRMT_TR_TYPE_DESC		CHAR	40	0	Technical Resource Type Description
63	BUAG_ID	☐	CRMT_BUAG_ID	CRMT_BUAG_ID	CHAR	12	0	Number of Business Agreement
64	MR_ELEMENT_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
65	.INCLUDE	☐				0	0	EEW Include Provider Order Result
66	EEW_R_PROVORD_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
67	.INCLUDE	☐				0	0

History

Last changed by/on	SAP	20140802
SAP Release Created in	703