SAP ABAP Table CRM_IU_ORDER_ITEM_ENTITY_FLTR (Item Filter Query Attributes)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IU-S-CI (Application Component) Utilities Industry: Commercial and Industrial Customers
     ⤷ CRM_IU_CI_BTX (Package) Utilities Business Transactions

Basic Data

Table Category	INTTAB	Structure
Structure	CRM_IU_ORDER_ITEM_ENTITY_FLTR	Table Relationship Diagram
Short Description	Item Filter Query Attributes

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	Attribute der Utilities Servicevertragsposition
2	ISUCONTRACT_ID	☐	ISUCONTRACT	ISUCONTRACT	CHAR	10	0	IS-U Contract
3	HAS_SERVOBJ	☐	FLAG	FLAG	CHAR	1	0	General Flag
4	EXT_CONTRACT_ID	☐	ECRM_ISU_EXTCONTRACT	CHAR12	CHAR	12	0	Contract Number
5	CONTSTART	☐	ECRM_ISU_CONTSTART	DATUM	DATS	8	0	Start of Supply
6	CONTEND	☐	ECRM_ISU_CONTEND	DATUM	DATS	8	0	End of Supply
7	VALIDTO	☐	VALID_TO	DATS	DATS	8	0	To
8	VALIDFROM	☐	DATUM	DATUM	DATS	8	0	Date
9	CANCDATE	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
10	CANCRECEIVE	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
11	CANCREQUEST	☐	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
12	DIVISION	☐	CRM_ISU_DIVISION	CRM_ISU_DIVISION	CHAR	2	0	Division	*
13	DIVISION_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
14	DIVISION_POD	☐	CRM_ISU_DIVISION	CRM_ISU_DIVISION	CHAR	2	0	Division	*
15	DIVISION_POD_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
16	DIVISION_PROD	☐	CRM_ISU_DIVISION	CRM_ISU_DIVISION	CHAR	2	0	Division	*
17	DIVISION_PROD_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
18	IS_FIRST_TIMESLICE	☐	FLAG	FLAG	CHAR	1	0	General Flag
19	IS_LAST_TIMESLICE	☐	FLAG	FLAG	CHAR	1	0	General Flag
20	IS_POD_OBLIGATORY	☐	FLAG	FLAG	CHAR	1	0	General Flag
21	IS_QUOTATION	☐	FLAG	FLAG	CHAR	1	0	General Flag
22	IS_CANCELED	☐	FLAG	FLAG	CHAR	1	0	General Flag
23	ISUSUPSTART	☐	ECRM_ISU_ISUSUPSTART	DATUM	DATS	8	0	Start of Supply
24	ISURQCONTSRT	☐	ECRM_ISU_ISURQCONTSRT	DATUM	DATS	8	0	Desired Contract Start Date
25	ISURQCONTEND	☐	ECRM_ISU_ISURQCONTEND	DATUM	DATS	8	0	Desired Contract End Date
26	ISU_PL_CTEND	☐	ECRM_ISU_ISUPLCONTEND	DATUM	DATS	8	0	Planned Contract End
27	MARKET_RULE_ID	☐	CHAR2	CHAR2	CHAR	2	0	Version Number Component
28	EXT_SECURITY_DEP_RQ_AMOUNT	☐	ECRM_SEC_RQ_AMOUNT	ECRM_SEC_RQ_AMOUNT	CURR	11	2	Requested Security Deposit Amount
29	EXT_SECURITY_DEP_RQ_CURR	☐	ECRM_SEC_RQ_AMOUNT_C	WAERS	CUKY	5	0	Requested Security Deposit Amount	*
30	EXT_SECURITY_DEP_REASON	☐	ECRM_SEC_DEP_REASON	ECRM_SEC_DEP_REASON	CHAR	4	0	Request Reason
31	EXT_SECURITY_DEP_WAIVEREASON	☐	ECRM_SEC_WAIVEREASON	ECRM_SEC_WAIVEREASON	CHAR	4	0	Reason for Exemption from Security Deposit
32	STATUS_ICON	☐	ECRM_STATUS_ICON	STRING	STRG	0	0	Status Icon (URL)
33	STATUS_TXT	☐	J_TXT30	TEXT30	CHAR	30	0	Object status
34	STATUS_ID	☐	J_STATUS	J_STATUS	CHAR	5	0	Object status
35	ACTIVATION_MESSAGE	☐	ECRM_ACT_MSG	ECRM_ACT_MSG	CHAR	22	0	Activation Message (Dereg)
36	ACTIVATION_SWTCDOC	☐	ECRM_ACT_SWTCDOC	ECRM_ACT_SWTCDOC	CHAR	20	0	Activation Switch Document
37	DEACTIVATION_MESSAGE	☐	ECRM_DEACT_MSG	ECRM_DEACT_MSG	CHAR	22	0	Deactivation Message (Dereg)
38	DEACTIVATION_SWTCDOC	☐	ECRM_DEACT_SWTCDOC	ECRM_DEACT_SWTCDOC	CHAR	20	0	Deactivation Switch Document
39	BUAG_GUID	☐	CRMT_BUAG_GUID	SYSUUID	RAW	16	0	GUID of the Business Agreement
40	BUAG_ID	☐	CRMT_BUAG_ID	CRMT_BUAG_ID	CHAR	12	0	Number of Business Agreement
41	POD_GUID	☐	CRM_ISU_POD_GUID	CRM_ISU_POD_GUID	CHAR	22	0	Point of Delivery GUID
42	SELECTED	☐	CHECKBOX	FUNC	CHAR	1	0	Checkbox in Reporting
43	PREV_ITEM	☐	CRM_ISU_PREVITEMGUID	CRM_ISU_PREVITEMGUID	RAW	16	0	Next Contract Item
44	NEXT_ITEM	☐	CRM_ISU_NEXTITEMGUID	CRM_ISU_NEXTITEMGUID	RAW	16	0	Previous Contract Item
45	PROD_PROP_RESULT_GUID	☐	GUID_32	SYSUUID_C	CHAR	32	0	GUID in 'CHAR' Format in Uppercase
46	OUTL_CONTRACT	☐	CRMT_ITEM_GUID	SYSUUID	RAW	16	0	Item GUID for a CRM Document
47	OUTL_CONTRACT_ID	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
48	IS_APPOINTMENT_INHERITED	☐	FLAG	FLAG	CHAR	1	0	General Flag
49	IS_PRICING_INHERITED	☐	FLAG	FLAG	CHAR	1	0	General Flag
50	IS_CONFIG_INHERITED	☐	FLAG	FLAG	CHAR	1	0	General Flag
51	IS_BUAG_INHERITED	☐	FLAG	FLAG	CHAR	1	0	General Flag
52	IS_STATUS_INHERITED	☐	FLAG	FLAG	CHAR	1	0	General Flag
53	IS_PRODUCT_INHERITED	☐	FLAG	FLAG	CHAR	1	0	General Flag
54	IS_PACKAGE_COMPONENT	☐	FLAG	FLAG	CHAR	1	0	General Flag
55	IS_PACKAGE	☐	FLAG	FLAG	CHAR	1	0	General Flag
56	PACKAGE_COMPONENT_SORT	☐	CRM_SC_INST_SORT	CRM_SCD_SORT	NUMC	4	0	Solution Configurator: Instance Sorting
57	PACKAGE_COMPONENT_HAS_ALTERN	☐	CRM_SC_BOOLEAN	COM_BOOLEAN	CHAR	1	0	Solution Configurator: Boolean Value
58	PACKAGE_COMPONENT_INST_GROUP	☐	CRM_SC_INST_GROUP	CRM_SCD_GROUP	CHAR	20	0	Solution Configurator: Instance Group
59	IS_ISU_ITEM	☐	FLAG	FLAG	CHAR	1	0	General Flag
60	SORT_INT	☐	CRMT_NUMBER_INT		NUMC	10	0	Item Number
61	POD_SHORT_WITH_STREET	☐	COMT_PARTNER_ADDRESS_W_STREET	CHAR80S	CHAR	80	0	Partner Address With Street
62	POD_PD_EXT_UI	☐	EUI_EXT_UI	EUI_EXT_UI	CHAR	50	0	Point of Delivery ID
63	.INCLUDE	☐				0	0	Transaction Item - Fields
64	.INCLUDE	☐				0	0	Item: Structure of Work Area and Object Buffer
65	.INCLUDE	☐				0	0	Business Transaction Item
66	.INCLUDE	☐				0	0	One Order: Key Fields
67	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
68	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
69	.INCLUDE	☐				0	0	Item: Structure of System Fields
70	.INCLUDE	☐				0	0	Time and User of Last Transaction Processing
71	CREATED_AT	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
72	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
73	CHANGED_AT	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
74	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
75	OBJECT_TYPE	☐	CRMT_SWO_OBJTYP_PROCESS_ITM_DB	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type	*
76	DESCRIPTION_UC	☐	CRMT_PRSHTEXTG_DB	CRM_PRSHTEXTG40_DB	CHAR	40	0	Product Short Text in Upper Case for F4 Help
77	.INCLUDE	☐				0	0	Item: Structre of External Fields
78	HEADER	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
79	PARENT	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
80	ALTERNATIVE	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
81	PRODUCT	☐	CRMT_PRODUCT_GUID_DB	SYSUUID	RAW	16	0	Internal Unique ID of Product
82	PRODUCT_SRC_SYS	☐	CRMT_PRODUCT_SRC_SYS	LOGSYS	CHAR	10	0	Logical System from Which Product Originates	*
83	ORDERED_PROD	☐	CRMT_ORDERED_PROD_DB	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
84	PARTNER_PROD	☐	CRMT_ITEM_DESCR_PARTNER	PRSHTEXT40	CHAR	40	0	Product Number of Business Partner
85	DESCRIPTION	☐	CRMT_PRSHTEXTX_DB	CRM_PRSHTEXT40_DB	CHAR	40	0	Product Short Text
86	ITM_LANGUAGE	☐	CRMT_ITEM_LANGU	SYLANGU	LANG	1	0	Short Text Language for an Item
87	NUMBER_INT	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
88	NUMBER_EXT	☐	CRMT_ITEM_NO_EXT		NUMC	10	0	External Item Number
89	ITM_TYPE	☐	CRMT_ITEM_TYPE_DB	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
90	ORDER_DATE	☐	CRMT_ORDER_DATE	BCOS_TSTMP	DEC	15	0	Posting Date
91	SUBST_REASON	☐	CRMT_ITEM_SUBSTITUTION	CRM_ITEM_SUBSTITUTION	CHAR	4	0	Reason for Product Substitution	*
92	ITM_USAGE	☐	CRMT_ITEM_USAGE	CRM_ITEM_USAGE	CHAR	2	0	Usage of Higher-Level Item
93	ITM_TYPE_USAGE	☐	CRMT_IT_TYPE_USAGE	CRM_IT_TYPE_USAGE	CHAR	4	0	Item Category Usage	*
94	PRODUCT_KIND	☐	CRMT_PRODUCT_KIND	CRM_PRODUCT_KIND	CHAR	1	0	Technnical Type of Product
95	LOG_SYSTEM_EXT	☐	CRMT_LOGSYS	LOGSYS	CHAR	10	0	Logical System	*
96	.INCLUDE	☐				0	0	EEW Extension
97	ORDERADM_I_DUMMY	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
98	.INCLUDE	☐				0	0
99	.INCLU--AP	☐				0	0	Additional Fields in ORDERADM_I_EXT
100	ALTID_TYPE	☐	COMT_ALTID_TYPE	CHAR16	CHAR	16	0	ID Type for Alternative IDs
101	PARENT_IN_COMP_TX	☐	CRMT_COMP_TX_PARENT_GUID	SYSUUID	RAW	16	0	Higher-Level Item Number in Composite Transaction
102	NUMBER_INT_COMP_TX	☐	CRMT_COMP_TX_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Composite Transaction-Specific Item Number
103	.INCLUDE	☐				0	0	Item: Dynamic Fields
104	ITEM_CHANGED	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
105	PREDECESSOR_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
106	CREATE_SUBITEMS	☐	CRMT_BOOLEAN	CRM_BOOLEAN	CHAR	1	0	Logical Variable
107	.INCLUDE	☐				0	0	Item: Dynamic Communication Fields
108	NUMBER_PARENT	☐	CRMT_ITEM_NO_PARENT	CRM_ITEM_NO	NUMC	10	0	Higher-Level Item Number in Transaction
109	NUMBER_ALTERN	☐	CRMT_ITEM_NO_ALTERNATIVE	CRM_ITEM_NO	NUMC	10	0	Item for Which This Item is an Alternative in the Document
110	PREVIOUS_HANDLE	☐	CRMT_HANDLE		NUMC	10	0	Handle
111	PREVIOUS_GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
112	ITM_PROC_IDENT	☐	CRMT_ITM_PROC_IDENT	CRM_ITM_PROC_IDENT	CHAR	4	0	Process Identifier
113	MULTIPLICITY	☐	PRCT_MULTIPLICITY	INT4	INT4	10	0	Multiplier for Pricing Item
114	GROUPING_ITEM	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
115	NUMBER_PARENT_COMP_TX	☐	CRMT_COMP_TX_ITEM_NO_PARENT	CRM_ITEM_NO	NUMC	10	0	Higher-Level Item Number in Composite Transaction
116	MODE	☐	CRMT_MODE	CRM_MODE	CHAR	1	0	Processing Mode of Transaction
117	ITEM_TYPE_DESCR	☐	CRMT_ITM_TYPE_DESC_20	TEXT20	CHAR	20	0	Item Category Text(20 character)
118	SUBSTITUTED_PROD	☐	CRMT_ORDERED_PROD	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
119	CREATED_AT_DATE	☐	CREATED_DATE	DATUM	DATS	8	0	Created on
120	BP_NUMBER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
121	FILTERSTRING	☐	CRMT_ISU_TEXT80	CRM_ISU_TEXT80	CHAR	80	0	General Text Element for Sales Integration

History

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