SAP ABAP Table CRM_ISU_QUERY_R_SRC_ITEM_BTIL (BTIL Structure for Serv. Contr. Items: Search Res. Criteria)

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_ISU_QUERY_R_SRC_ITEM_BTIL	Table Relationship Diagram
Short Description	BTIL Structure for Serv. Contr. Items: Search Res. Criteria

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	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	PARTNER	☐	CRM_ISU_PARTNER_NO	CRM_ISU_PARTNER_NO	CHAR	10	0	Partner Number
3	OBJECT_ID	☐	CRMT_OBJECT_ID_DB	CRM_OBJECT_ID	CHAR	10	0	Transaction ID
4	ISUCONTRACT	☐	CRM_ISU_CONTRACT	CRM_ISU_CONTRACT	CHAR	10	0	IS-U Contract
5	CONTSTART	☐	CRM_ISU_CONTSTART	CRM_ISU_CONTSTART	DATS	8	0	IS-U Contract Start
6	CONTEND	☐	CRM_ISU_CONTEND	CRM_ISU_CONTEND	DATS	8	0	IS-U Contract End
7	QUOTATION	☐	CRM_ISU_QUOTATION	CRM_ISU_QUOTATION	CHAR	1	0	Quotation
8	CANCELLED	☐	CRM_ISU_CANCELLED	CRM_ISU_CANCELLED	CHAR	1	0	Cancelled
9	PARTNER_GUID	☐	CRM_ISU_PARTNER_GUID	CRM_ISU_PARTNER_GUID	RAW	16	0	GUID
10	ORDERED_PROD	☐	CRMT_ORDERED_PROD_DB	CRM_ORDERED_PROD	CHAR	54	0	Product Name Entered
11	ITM_TYPE	☐	CRMT_ITEM_TYPE_DB	CRM_ITEM_TYPE	CHAR	4	0	Item Category	*
12	BLOCKED	☐	CRM_ISU_BLOCKED	CRM_ISU_BLOCKED	CHAR	1	0	Distribution Locked
13	GUID	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
14	CREATED_AT	☐	COMT_CREATED_AT_USR	COM_TSTMP	DEC	15	0	Created At (Output in User Time Zone)
15	CREATED_BY	☐	CRMT_CREATED_BY	UNAME	CHAR	12	0	User that Created the Transaction
16	CHANGED_AT	☐	COMT_CHANGED_AT_USR	COM_TSTMP	DEC	15	0	Changed At (Output in User Time Zone)
17	CHANGED_BY	☐	CRMT_CHANGED_BY	UNAME	CHAR	12	0	Transaction Last Changed By
18	OBJECT_TYPE_I	☐	CRMT_SWO_OBJTYP_PROCESS_ITM_DB	CRM_OJ_NAME_PROCESS_ITEM	CHAR	10	0	CRM Item Object Type	*
19	DESCRIPTION_UC	☐	CRMT_PRSHTEXTG_DB	CRM_PRSHTEXTG40_DB	CHAR	40	0	Product Short Text in Upper Case for F4 Help
20	HEADER	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
21	PARENT	☐	CRMT_OBJECT_GUID	SYSUUID	RAW	16	0	GUID of a CRM Order Object
22	PRODUCT	☐	CRMT_PRODUCT_GUID_DB	SYSUUID	RAW	16	0	Internal Unique ID of Product
23	DESCRIPTION	☐	CRMT_PRSHTEXTX_DB	CRM_PRSHTEXT40_DB	CHAR	40	0	Product Short Text
24	NUMBER_INT	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
25	POD_GUID	☐	CRM_ISU_POD_GUID	CRM_ISU_POD_GUID	CHAR	22	0	Point of Delivery GUID
26	ISULOGSYS	☐	CRM_ISU_LOGSYS	CRM_ISU_LOGSYS	CHAR	10	0	Logical System for IS-U Contract
27	BUAG_GUID	☐	CRM_ISU_BUAGGUID	CRM_ISU_BUAGGUID	RAW	16	0	BUAG GUID
28	PROCESS_TYPE	☐	CRMT_PROCESS_TYPE_DB	CRM_PROCESS_TYPE	CHAR	4	0	Business Transaction Type	*
29	OBJECT_TYPE_H	☐	CRMT_SUBOBJECT_CATEGORY_DB	CRM_OJ_NAME_PROCESS	CHAR	10	0	Business Trans. Cat.	*
30	VALIDTO	☐	CRM_ISU_VALIDTO	CRM_ISU_VALIDTO	DATS	8	0	Quotation Valid To
31	VALIDFROM	☐	CRM_ISU_VALIDFROM	CRM_ISU_VALIDFROM	DATS	8	0	Quotation Valid From
32	RELPREV	☐	CRM_ISU_RELKINDPREV	CRM_ISU_RELKINDPREV	CHAR	2	0	Relationship to Previous Item
33	RELNEXT	☐	CRM_ISU_RELKINDNEXT	CRM_ISU_RELKINDNEXT	CHAR	2	0	Relationship to Next Item
34	RELITEM	☐	CRM_ISU_RELITEMGUID	CRM_ISU_RELITEMGUID	RAW	16	0	With Reference to Contract Item
35	PREVITEM	☐	CRM_ISU_NEXTITEMGUID	CRM_ISU_NEXTITEMGUID	RAW	16	0	Previous Contract Item
36	NEXTITEM	☐	CRM_ISU_PREVITEMGUID	CRM_ISU_PREVITEMGUID	RAW	16	0	Next Contract Item
37	DIVISION	☐	CRM_ISU_POD_DIVISION	SPART	CHAR	2	0	Point of Delivery Division
38	CONTDUR	☐	CRM_ISU_CONTDUR	CRM_ISU_CONTDUR	DATS	8	0	Duration End
39	TYPE	☐	CRM_ISU_TYPE	CRM_ISU_TYPE	CHAR	1	0	Utilities Item Type
40	NUMBER_INT_MAIN	☐	CRMT_ITEM_NO	CRM_ITEM_NO	NUMC	10	0	Item Number in Document
41	ACTIVE_ICON	☐	CRM_ISU_ACTIVE	STRING	STRG	0	0	IS-U Contract Active?
42	STATUS_TXT	☐	COMT_STATUS_TEXT	COMT_STATUS_TEXT	CHAR	40	0	BSP UI: Short Text for Status
43	DIVISION_DESC	☐	CRMT_DIVISION_DESC	CRMT_DIVISION_DESC	CHAR	40	0	Division Description
44	ISU_PL_CTEND	☐	ECRM_ISU_ISUPLCONTEND	DATUM	DATS	8	0	Planned Contract End

History

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