SAP ABAP Table CRMST_QUERY_R_ISXMSG_BTIL (ISX Message BOL entity query result structure)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IT-BTX (Application Component) Business Transaction
     ⤷ CRM_ISX_BTX_MSG_DIST_API (Package) Convergent Customer Care - BTX: Document Distribution API

Basic Data

Table Category	INTTAB	Structure
Structure	CRMST_QUERY_R_ISXMSG_BTIL	Table Relationship Diagram
Short Description	ISX Message BOL entity query result 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	DISTREC_STATE	☐	CRM_ISX_MSG_AGGR_DIST_STATE	CRM_ISX_MSG_AGGR_DIST_STATE	CHAR	1	0	Aggregated Document Distribution Status
2	DISTREC_STATE_ICON	☐	ECRM_STATUS_ICON	STRING	STRG	0	0	Status Icon (URL)
3	MSG_STEP	☐	CRM_ISX_MSG_DIST_STEP	CRM_ISX_MSG_DIST_STEP	NUMC	3	0	Document Distribution Step Sequence
4	MSG_STATE_ICON	☐	ECRM_STATUS_ICON	STRING	STRG	0	0	Status Icon (URL)
5	OBJECT_ID	☐	CRMT_OBJECT_ID_DB	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
6	.INCLUDE	☐				0	0	database part of extension isx_msg
7	MSG_TYPE	☐	CRM_ISX_MSG_DIST_TYPE	CRM_ISX_MSG_DIST_TYPE	CHAR	4	0	Document Distribution Step Type	*
8	MSG_CATEGORY	☐	CRM_ISX_MSG_DIST_CATEGORY	CRM_ISX_MSG_DIST_CATEGORY	CHAR	2	0	Document Distribution Step Category	*
9	MSG_STATE	☐	CRM_ISX_MSG_DIST_STATE	CRM_ISX_MSG_DIST_STATE	CHAR	1	0	Document Distribution Step Status
10	MSG_PLANNED_TS	☐	CRM_ISX_MSG_ACTION_DIST_TS	COM_TSTMP	DEC	15	0	Timestamp : next execution
11	MSG_EXECUTED_TS	☐	CRM_ISX_MSG_DIST_EXE_TS	COM_TSTMP	DEC	15	0	Timestamp Execution Time
12	MSG_COMPLTD_TS	☐	CRM_ISX_MSG_DIST_CMP_TS	COM_TSTMP	DEC	15	0	Document distribution step completion date
13	MSG_SCHEMA	☐	CRM_ISX_MSG_DIST_SCHEMA	CRM_ISX_MSG_DIST_SCHEMA	CHAR	4	0	Document Distribution Schema	*
14	MSG_REF_TYPE	☐	CRM_ISX_MSG_DIST_REF_TYPE	CRM_ISX_MSG_DIST_REF_TYPE	CHAR	2	0	Document Distribution Step Reference Type
15	MSG_REFERENCE	☐	CRM_ISX_MSG_DIST_REFERENCE	CRM_ISX_MSG_DIST_REFERENCE	CHAR	40	0	Document Distribution Step Reference
16	MSG_STEP_ID	☐	CRM_ISX_MSG_DIST_STEP_ID	CRM_ISX_MSG_DIST_STEP_ID	CHAR	4	0	Document Distribution Step ID
17	MSG_CREATED_TS	☐	CRM_ISX_MSG_DIST_CREATED_TS	COM_TSTMP	DEC	15	0	Timestamp Creation Time
18	.INCLUDE	☐				0	0	Business Transaction Item
19	.INCLUDE	☐				0	0	One Order: Key Fields
20	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
21	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
22	.INCLUDE	☐				0	0	Item: Structure of System Fields
23	.INCLUDE	☐				0	0	Time and User of Last Transaction Processing
24	CREATED_AT	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
25	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
26	CHANGED_AT	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
27	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
28	OBJECT_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS_ITM_DB	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type	*
29	DESCRIPTION_UC	☐	CRMT_PRSHTEXTG_DB	CRM_PRSHTEXTG40_DB	CHAR	40	0	Product Short Text in Upper Case for F4 Help
30	.INCLUDE	☐				0	0	Item: Structre of External Fields
31	HEADER	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
32	PARENT	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
33	ALTERNATIVE	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
34	PRODUCT	☐	CRMT_PRODUCT_GUID_DB	SYSUUID	RAW	16	0	Internal Unique ID of Product
35	PRODUCT_SRC_SYS	☐	CRMT_PRODUCT_SRC_SYS	LOGSYS	CHAR	10	0	Logical System from Which Product Originates	*
36	ORDERED_PROD	☐	CRMT_ORDERED_PROD_DB	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
37	PARTNER_PROD	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
38	DESCRIPTION	☐	CRMT_PRSHTEXTX_DB	CRM_PRSHTEXT40_DB	CHAR	40	0	Product Short Text
39	ITM_LANGUAGE	☐	CRMT_ITEM_LANGU	SYLANGU	LANG	1	0	Short Text Language for an Item
40	NUMBER_INT	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
41	NUMBER_EXT	☐	CRMT_ITEM_NO_EXT		NUMC	10	0	External Item Number
42	ITM_TYPE	☐	CRMT_ITEM_TYPE_DB	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
43	ORDER_DATE	☐	CRMT_ORDER_DATE	BCOS_TSTMP	DEC	15	0	Posting Date
44	SUBST_REASON	☐	CRMT_ITEM_SUBSTITUTION	CRM_ITEM_SUBSTITUTION	CHAR	4	0	Reason for Product Substitution	*
45	ITM_USAGE	☐	CRMT_ITEM_USAGE	CRM_ITEM_USAGE	CHAR	2	0	Usage of Higher-Level Item
46	ITM_TYPE_USAGE	☐	CRMT_IT_TYPE_USAGE	CRM_IT_TYPE_USAGE	CHAR	4	0	Item Category Usage	*
47	PRODUCT_KIND	☐	CRMT_PRODUCT_KIND	CRM_PRODUCT_KIND	CHAR	1	0	Technnical Type of Product
48	LOG_SYSTEM_EXT	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
49	.INCLUDE	☐				0	0	EEW Extension
50	ORDERADM_I_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
51	.INCLUDE	☐				0	0
52	.INCLU--AP	☐				0	0	Additional Fields in ORDERADM_I_EXT
53	ALTID_TYPE	☐	COMT_ALTID_TYPE	CHAR16	CHAR	16	0	ID Type for Alternative IDs
54	PARENT_IN_COMP_TX	☐	CRMT_COMP_TX_PARENT_GUID	SYSUUID	RAW	16	0	Higher-Level Item Number in Composite Transaction
55	NUMBER_INT_COMP_TX	☐	CRMT_COMP_TX_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Composite Transaction-Specific Item Number
56	CONTRACT_NUMBER	☐	IST_EXT_REF	IST_EXT_REF	CHAR	20	0	IS-T Contract Number

History

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