SAP ABAP Table CRMT_IBASE_IL_SEARCHALL_ADVQS (IBase: Structure includes all possible search attributes)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-INB (Application Component) Installed Bases
     ⤷ CRM_IBASEIL (Package) Interaction Layer for IBase

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_IBASE_IL_SEARCHALL_ADVQS	Table Relationship Diagram
Short Description	IBase: Structure includes all possible search 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	IBASE	☐	CRMT_IBASE_CHAR_ID	CHAR18	CHAR	18	0	IBase: Character Field for IBase Number in IC WebClient
2	EXTID	☐	IB_EXTID	CHAR30	CHAR	30	0	IB: External Name/ID of Installed Base
3	DESCR	☐	IB_IBASE_DESCR	TEXT40	CHAR	40	0	IB: IBase Short Text/Description
4	IBTYP	☐	IB_IBTYP	IB_IBTYP	CHAR	2	0	IB: Installed Base Category	*
5	PARTNER_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
6	PARTNER_NO	☐	CRMT_PARTNER_NUMBER	CRM_PARTNER_NUMBER	CHAR	20	0	Partner Number for Use Outside Partner Processing
7	INSTANCE	☐	CRMT_INSTANCE_CHAR_ID	CHAR18	CHAR	18	0	IBase: Character Field for Instance Number in IC WebClient
8	DEVICEID	☐	IB_DEVICEID	IB_DEVICEID	CHAR	40	0	IB: Identification
9	NAME1	☐	AD_MC_NAME	CHAR25	CHAR	25	0	Name (field NAME1) in upper case for matchcode
10	CITY1	☐	AD_MC_CITY	CHAR25	CHAR	25	0	City name in upper case for search help
11	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
12	STREET	☐	AD_MC_STRT	CHAR25	CHAR	25	0	Street name in upper case for search help
13	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
14	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
15	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
16	SORT1	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
17	SORT2	☐	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2
18	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
19	OBJECT_FAMILY	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family	*
20	DESCRIPTION	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
21	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
22	HIERARCHY_ID	☐	COMT_HIERARCHY_ID	COM_HIERARCHY_ID	CHAR	10	0	Category Hierarchy ID
23	ALTID_TYPE	☐	COMT_ALTID_TYPE	CHAR16	CHAR	16	0	ID Type for Alternative IDs
24	ALTID_VALUE	☐	COMT_ALTID_VALUE_UI	COM_ALTID_VALUE_SHORT	CHAR	54	0	Value of a Product ID or Individual Object
25	LOGSYS	☐	COMT_LOGSYS	LOGSYS	CHAR	10	0	Original System	*
26	PARTNER	☐	COMT_BSP_BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
27	PARTNER_FUNCTION	☐	COMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
28	REF_PRODUCT	☐	COMT_REF_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Reference Product ID
29	PRODUCT_TYPE	☐	COMT_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
30	CONFIG	☐	COMT_PRODUCT_CONFIGURABLE	COM_PRODUCT_CONFIGURABLE	CHAR	1	0	Determines Whether a Product Is Configurable	*
31	SALES_ORG_SHORT	☐	CRMT_SALES_ORG_SHORT	TEXT12	CHAR	12	0	Sales Organization: Description of Department
32	DISTR_CHAN	☐	CRMT_DISTRIBUTION_CHANNEL	CRM_DISTRIBUTION_CHANNEL	CHAR	2	0	Distribution Channel	*

History

Last changed by/on	SAP	20131122
SAP Release Created in	510