SAP ABAP Table /1CRMES/CRM_IBASE_Q (/1CRMES/CRM_IBASE_Q)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-ES (Application Component) Enterprise Search OneOrder
     ⤷ /1CRMES/ES_GEN_APPL (Package) Generated structures for CRM Enterprise Search - Application

Basic Data

Table Category	INTTAB	Structure
Structure	/1CRMES/CRM_IBASE_Q	Table Relationship Diagram
Short Description	/1CRMES/CRM_IBASE_Q

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	ALL_ATTRIBUTES_SEARCH_STRING	☐	CRM_ES_STRING		STRG	0	0	String for Node Name
2	BUILHEADER_ACCOUNT_NAME	☐			CHAR	50	0
3	BUILHEADER_ACCOUNT_NAME001	☐			CHAR	50	0
4	BUILHEADER_BP_CATEGORY	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
5	BUILHEADER_BP_CATEGORY001	☐	BU_TYPE	BU_TYPE	CHAR	1	0	Business partner category
6	BUILHEADER_BP_NUMBER	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
7	BUILHEADER_BP_NUMBER001	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
8	BUILHEADER_CITY	☐			CHAR	40	0
9	BUILHEADER_CITY001	☐			CHAR	40	0
10	BUILHEADER_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
11	BUILHEADER_COUNTRY001	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
12	BUILHEADER_CP_PROGRAM	☐	CHM_PARTNER_PROGRAM	CHM_PARTNER_PROGRAM	CHAR	4	0	Channel Management - Channel Partner Programm	*
13	BUILHEADER_CP_PROGRAM001	☐	CHM_PARTNER_PROGRAM	CHM_PARTNER_PROGRAM	CHAR	4	0	Channel Management - Channel Partner Programm	*
14	BUILHEADER_CP_STATUS	☐	CHM_PARTNER_STATUS	CHM_PARTNER_STATUS	CHAR	4	0	Channel Management - Channel Partner Status	*
15	BUILHEADER_CP_STATUS001	☐	CHM_PARTNER_STATUS	CHM_PARTNER_STATUS	CHAR	4	0	Channel Management - Channel Partner Status	*
16	BUILHEADER_CP_TYPE	☐	CHM_PARTNER_TYPE	CHM_PARTNER_TYPE	CHAR	4	0	Channel Management - Channel Partner Type	*
17	BUILHEADER_CP_TYPE001	☐	CHM_PARTNER_TYPE	CHM_PARTNER_TYPE	CHAR	4	0	Channel Management - Channel Partner Type	*
18	BUILHEADER_CRITERION_DESCRI001	☐			CHAR	30	0
19	BUILHEADER_CRITERION_DESCRI002	☐			CHAR	30	0
20	BUILHEADER_EMAIL_SRCH	☐			CHAR	20	0
21	BUILHEADER_EMAIL_SRCH001	☐			CHAR	20	0
22	BUILHEADER_E_MAIL	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
23	BUILHEADER_E_MAIL001	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
24	BUILHEADER_E_MAIL001001	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
25	BUILHEADER_E_MAIL002	☐	AD_SMTPADR	AD_SMTPADR	CHAR	241	0	E-Mail Address
26	BUILHEADER_FIRSTNAME	☐			CHAR	40	0
27	BUILHEADER_FIRSTNAME001	☐			CHAR	40	0
28	BUILHEADER_FIRST_NAME	☐	CRM_ICM_BP_AID_NAME	TEXT80	CHAR	80	0	ICM BP Alternative Identity - Name (Other name or Last name)
29	BUILHEADER_FIRST_NAME001	☐	CRM_ICM_BP_AID_NAME	TEXT80	CHAR	80	0	ICM BP Alternative Identity - Name (Other name or Last name)
30	BUILHEADER_HOUSE_NO	☐			CHAR	10	0
31	BUILHEADER_HOUSE_NO001	☐			CHAR	10	0
32	BUILHEADER_IDENTIFICATIONNU001	☐			CHAR	60	0
33	BUILHEADER_IDENTIFICATIONNU002	☐			CHAR	60	0
34	BUILHEADER_IDENTIFICATIONTY001	☐	BU_ID_TYPE	BU_ID_TYPE	CHAR	6	0	Identification Type	*
35	BUILHEADER_IDENTIFICATIONTY002	☐	BU_ID_TYPE	BU_ID_TYPE	CHAR	6	0	Identification Type	*
36	BUILHEADER_LASTNAME	☐			CHAR	40	0
37	BUILHEADER_LASTNAME001	☐			CHAR	40	0
38	BUILHEADER_NAME001	☐	CRM_ICM_BP_AID_NAME	TEXT80	CHAR	80	0	ICM BP Alternative Identity - Name (Other name or Last name)
39	BUILHEADER_NAME001001	☐	CRM_ICM_BP_AID_NAME	TEXT80	CHAR	80	0	ICM BP Alternative Identity - Name (Other name or Last name)
40	BUILHEADER_NAME1	☐			CHAR	40	0
41	BUILHEADER_NAME1001	☐			CHAR	40	0
42	BUILHEADER_NAME2	☐			CHAR	40	0
43	BUILHEADER_NAME2001	☐			CHAR	40	0
44	BUILHEADER_PARTNERROLE	☐			CHAR	6	0
45	BUILHEADER_PARTNERROLE001	☐			CHAR	6	0
46	BUILHEADER_PARTNERROLECATEG001	☐			CHAR	6	0
47	BUILHEADER_PARTNERROLECATEG002	☐			CHAR	6	0
48	BUILHEADER_POSTL_COD1	☐			CHAR	10	0
49	BUILHEADER_POSTL_COD1001	☐			CHAR	10	0
50	BUILHEADER_RATING_TEXT	☐			CHAR	40	0
51	BUILHEADER_RATING_TEXT001	☐			CHAR	40	0
52	BUILHEADER_REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
53	BUILHEADER_REGION001	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
54	BUILHEADER_SEARCHTERM1	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
55	BUILHEADER_SEARCHTERM1001	☐	BU_SORT1	BU_SORT1	CHAR	20	0	Search term 1 for business partner
56	BUILHEADER_STEXT	☐			CHAR	40	0
57	BUILHEADER_STEXT001	☐			CHAR	40	0
58	BUILHEADER_STREET	☐			CHAR	60	0
59	BUILHEADER_STREET001	☐			CHAR	60	0
60	BUILHEADER_TDLINE	☐			STRG	0	0
61	BUILHEADER_TDLINE001	☐			STRG	0	0
62	BUILHEADER_TEL_NO	☐			CHAR	30	0
63	BUILHEADER_TEL_NO001	☐			CHAR	30	0
64	BUILHEADER_TEL_NO001001	☐			CHAR	30	0
65	BUILHEADER_TEL_NO002	☐			CHAR	30	0
66	BUILHEADER_TEL_NO002001	☐			CHAR	30	0
67	BUILHEADER_TEL_NO003	☐			CHAR	30	0
68	BUILHEADER_URI	☐	AD_URISCR	AD_URISCR	CHAR	132	0	URI, e.g. Homepage or ftp Address
69	BUILHEADER_URI001	☐	AD_URISCR	AD_URISCR	CHAR	132	0	URI, e.g. Homepage or ftp Address
70	BUILHEADER_URI001001	☐	AD_URISCR	AD_URISCR	CHAR	132	0	URI, e.g. Homepage or ftp Address
71	BUILHEADER_URI002	☐	AD_URISCR	AD_URISCR	CHAR	132	0	URI, e.g. Homepage or ftp Address
72	BUILHEADER_VALUE_DESCRIPTIO001	☐			CHAR	90	0
73	BUILHEADER_VALUE_DESCRIPTIO002	☐			CHAR	90	0
74	CITY1	☐			CHAR	40	0
75	CITY1001	☐			CHAR	40	0
76	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
77	COUNTRY001	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
78	COUNTRY_LANDX50	☐			CHAR	50	0
79	DESCR	☐			CHAR	40	0
80	DESCR_COMP	☐			CHAR	40	0
81	DEVICEID	☐	IB_DEVICEID	IB_DEVICEID	CHAR	40	0	IB: Identification
82	EXTID	☐			CHAR	30	0
83	HOUSE_NUM1	☐			CHAR	10	0
84	HOUSE_NUM1001	☐			CHAR	10	0
85	IBASE	☐			NUMC	18	0
86	IBTYP	☐	IB_IBTYP	IB_IBTYP	CHAR	2	0	IB: Installed Base Category	*
87	IBTYP_DESCR	☐			CHAR	30	0
88	INSTANCE	☐	IB_INSTANCE	IB_INSTANCE	NUMC	18	0	IB: Component (instance)
89	NAME1	☐			CHAR	40	0
90	NAME1001	☐			CHAR	40	0
91	OBJECT_ALTID_TYPE	☐			CHAR	16	0
92	OBJECT_ALTID_VALUE	☐			CHAR	255	0
93	OBJECT_CATEGORY_GUID	☐			RAW	16	0
94	OBJECT_CATEGORY_GUID001	☐			RAW	16	0
95	OBJECT_CATEGORY_ID001	☐			CHAR	20	0
96	OBJECT_CITY	☐			CHAR	40	0
97	OBJECT_CONC_LINES	☐			STRG	0	0
98	OBJECT_COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
99	OBJECT_DNSSUFFIX	☐	CRMT_IT_DNS_SUFFIX_UI	CRMT_IT_DNS_SUFFIX_UI	CHAR	40	0	DNS Suffix
100	OBJECT_DOM	☐	CRMT_IT_DOMAIN_UI	CRMT_IT_DOMAIN_UI	CHAR	15	0	Domain
101	OBJECT_GATEWAY	☐	CRMT_IT_GATEWAY_UI	CRMT_IT_GATEWAY_UI	CHAR	15	0	Gateway
102	OBJECT_HOSTNAME	☐	CRMT_IT_HOSTNAME_UI	CRMT_IT_HOSTNAME_UI	CHAR	15	0	Host Name
103	OBJECT_HOUSE_NO	☐			CHAR	10	0
104	OBJECT_IMPACT	☐	CRMT_IT_IMPACT_UI	CRM_SRQM_IMPACT	NUMC	2	0	Impact	*
105	OBJECT_IPADDR	☐	CRMT_IT_IP_ADDRESS_UI	CRMT_IT_IP_ADDRESS_UI	CHAR	15	0	IP Address
106	OBJECT_MAC_ADDR	☐	CRMT_IT_MAC_ADDRESS_UI	CRMT_IT_MAC_ADDRESS_UI	CHAR	17	0	MAC Address
107	OBJECT_NAME001	☐			CHAR	40	0
108	OBJECT_NAME002	☐	PSIC_OTHERNAME_UI	PSIC_OTHERNAME_UI	CHAR	40	0	Other Name
109	OBJECT_OBJECT_FAMILY	☐			CHAR	4	0
110	OBJECT_OPSYS	☐	CRMT_IT_OS_UI	CHAR4	CHAR	4	0	Operating System (OS)
111	OBJECT_OPSYS_V	☐	CRMT_IT_OS_VERSION_UI	CRMT_IT_OS_VERSION_UI	CHAR	4	0	Operating System Version
112	OBJECT_POSTL_COD1	☐			CHAR	10	0
113	OBJECT_PRODUCT_ID	☐			CHAR	40	0
114	OBJECT_PRODUCT_TYPE	☐			CHAR	2	0
115	OBJECT_R3LIC_NO	☐	CRMT_IT_LICENSENO_UI	CRMT_IT_LICENSENO_UI	CHAR	50	0	License Number
116	OBJECT_REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
117	OBJECT_SHORT_TEXT	☐			CHAR	40	0
118	OBJECT_SORT1	☐			CHAR	20	0
119	OBJECT_SORT2	☐			CHAR	20	0
120	OBJECT_STREET	☐			CHAR	60	0
121	OBJECT_SUBNET	☐	CRMT_IT_SUBNET_MASK_UI	CRMT_IT_SUBNET_MASK_UI	CHAR	15	0	Subnet Mask
122	OBJECT_TYPE002	☐	PSIC_NAMETYPE_UI	CRM_ICM_LOC_OTHNTYPE	CHAR	4	0	Other Name Type	*
123	POST_CODE1	☐			CHAR	10	0
124	POST_CODE1001	☐			CHAR	10	0
125	PRODUCT_ALTID_TYPE	☐			CHAR	16	0
126	PRODUCT_ALTID_VALUE	☐			CHAR	255	0
127	PRODUCT_CATEGORY001	☐	CRMT_WTY_CATEGORY_UI	CRMT_WTY_CATEGORY_UI	CHAR	1	0	Warranty Category
128	PRODUCT_CATEGORY_GUID	☐			RAW	16	0
129	PRODUCT_CATEGORY_GUID001	☐			RAW	16	0
130	PRODUCT_CATEGORY_ID001	☐			CHAR	20	0
131	PRODUCT_CONC_LINES	☐			STRG	0	0
132	PRODUCT_DURA	☐	CRMT_WTY_DURATION_UI	CRMT_WTY_DURATION_UI	DEC	13	0	Warranty Period
133	PRODUCT_PRODUCT_ID	☐			CHAR	40	0
134	PRODUCT_PRODUCT_TYPE	☐			CHAR	2	0
135	PRODUCT_REFERENCE	☐	CRMT_WTY_REFERENCE_UI	CRMT_WTY_REFERENCE_UI	CHAR	1	0	Warranty Basis
136	PRODUCT_SHORT_TEXT	☐			CHAR	40	0
137	SORT1	☐			CHAR	20	0
138	SORT1001	☐			CHAR	20	0
139	SORT2	☐			CHAR	20	0
140	SORT2001	☐			CHAR	20	0
141	STREET	☐			CHAR	60	0
142	STREET001	☐			CHAR	60	0
143	T005T_LANDX50	☐			CHAR	50	0
144	TEL_NUMBER	☐			CHAR	30	0
145	TEL_NUMBER001	☐			CHAR	30	0

History

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