SAP ABAP Table CRMT_PRIL_QUERY_ADVSEARCH_IOBJ (Advanced Search for Individual Objects)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-MD-PRO (Application Component) Products
     ⤷ CRM_PRODIL_QUERIES (Package) Methods for product queries

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_PRIL_QUERY_ADVSEARCH_IOBJ	Table Relationship Diagram
Short Description	Advanced Search for Individual Objects

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	Extensibility Search Query Product - Object
2	QUERY_PROD_OBJ	☐	DUMMY	DUMMY	CHAR	1	0	Dummy function in length 1
3	.INCLUDE	☐				0	0	Specific search attributes for investigative case management
4	EMPLOYEE_RESP	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
5	.INCLUDE	☐				0	0	ICM Combined Search Attributes
6	LOCATION_COMB	☐	CRM_ICM_IL_REL_LOC_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search for Related Locations
7	CASE_COMB	☐	CRM_ICM_IL_REL_CMG_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search for Related Cases
8	LEAD_COMB	☐	CRM_ICM_IL_REL_LEAD_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search for Related Leads
9	INCIDENT_COMB	☐	CRM_ICM_IL_REL_INC_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search for Related Incidents
10	BP_COMB	☐	CRM_ICM_IL_REL_BP_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search for Related Business Partners
11	OBJECT_COMB	☐	CRM_ICM_IL_REL_OBJ_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search for Related Objects
12	OPERATION_COMB	☐	CRM_ICM_IL_REL_ACT_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search for Related Activities
13	STAFF_UNITS_COMB	☐	CRM_ICM_IL_REL_SFU_SEARCH	CRM_ICM_IL_REL_COMB_SEARCH	CHAR	130	0	ICM Combined Search Field for Staff and Units
14	REL_TYPE_ID	☐	CRM_ICM_REL_TYPE_ID		CHAR	4	0	CRM ICM Relationship Type ID
15	REL_VALID_FROM	☐	CRM_ICM_REL_DATE	SYDATS	DATS	8	0	ICM Relationship: Dates
16	REL_VALID_TO	☐	CRM_ICM_REL_DATE	SYDATS	DATS	8	0	ICM Relationship: Dates
17	.INCLUDE	☐				0	0	General Parameters for Search
18	MAX_ROWS	☐	BAPIMAXROW	SYST_LONG	INT4	10	0	Maximum number of lines of hits
19	.INCLUDE	☐				0	0	Search Structure with General Product Attributes
20	PRODUCT_ID	☐	COMT_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Product ID
21	PRODUCT_TYPE	☐	COMT_PRODUCT_TYPE	COM_PRODUCT_TYPE	CHAR	2	0	Product Type	*
22	CONFIG	☐	COMT_PRODUCT_CONFIGURABLE	COM_PRODUCT_CONFIGURABLE	CHAR	1	0	Determines Whether a Product Is Configurable	*
23	XNOSEARCH	☐	COMT_PRODUCT_XNOSEARCH	COM_BOOLEAN	CHAR	1	0	Product Is Not Relevant for Search Help
24	OBJECT_FAMILY	☐	COMT_PRODUCT_OBJECT_FAMILY	COM_PRODUCT_OBJECT_FAMILY	CHAR	4	0	Object Family	*
25	BATCH_DEDICATED	☐	COMT_BATCH_DEDICATED	COM_BOOLEAN	CHAR	1	0	Specifies Whether Batches Are Maintained for Product
26	COMPETITOR_PROD	☐	COMT_PR_COMP	COM_COMPETITOR_PRODUCT	CHAR	1	0	Indicates Product Is a Competitor Product
27	LOGSYS	☐	COMT_LOGSYS	LOGSYS	CHAR	10	0	Original System	*
28	DESCRIPTION	☐	COMT_PRSHTEXTX	PRSHTEXT40	CHAR	40	0	Product Description
29	CATEGORY_ID	☐	COMT_CATEGORY_ID	COM_CATEGORY_ID	CHAR	20	0	Category ID
30	CAT_SUBTREE	☐	COMT_BOOLEAN	COM_BOOLEAN	CHAR	1	0	Logical Variable
31	HIERARCHY_ID	☐	COMT_HIERARCHY_ID	COM_HIERARCHY_ID	CHAR	10	0	Category Hierarchy ID
32	CATEGORY_DESC	☐	COMT_CATEGORY_TEXT	TEXT80	CHAR	80	0	Category Description
33	CREATED_BY	☐	SYUNAME	SYCHAR12	CHAR	12	0	User Name
34	CREATED_ON	☐	SYDATE	SYDATS	DATS	8	0	Date data element for SYST
35	DESC_FUZZY	☐	COM_SEARCH_TV_MODE_FUZZY	X	CHAR	1	0	Option Fuzzy Mode
36	ALTID_TYPE	☐	COMT_ALTID_TYPE	CHAR16	CHAR	16	0	ID Type for Alternative IDs
37	ALTID_VALUE	☐	COMT_ALTID_VALUE_UI	COM_ALTID_VALUE_SHORT	CHAR	54	0	Value of a Product ID or Individual Object
38	STATUS	☐	CHAR14	CHAR14	CHAR	14	0	Text field length 14
39	PARTNER	☐	COMT_BSP_BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
40	PARTNER_FUNCTION	☐	COMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
41	REF_PRODUCT	☐	COMT_REF_PRODUCT_ID	COM_PRODUCT_ID	CHAR	40	0	Reference Product ID
42	WITH_PRODUCTS	☐	COMT_BOOLEAN	COM_BOOLEAN	CHAR	1	0	Logical Variable
43	.INCLUDE	☐				0	0	Structure for Location Search for Individual Object
44	NAME1	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
45	NAME2	☐	AD_NAME2	TEXT40	CHAR	40	0	Name 2
46	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
47	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
48	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
49	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
50	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
51	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
52	SORT1	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
53	SORT2	☐	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2
54	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
55	HOUSE_NUM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
56	HOUSE_NUM3	☐	AD_HSNM3	TEXT10	CHAR	10	0	(Not supported) House Number Range
57	STR_SUPPL1	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
58	STR_SUPPL2	☐	AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
59	STR_SUPPL3	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
60	ADDR_LOCATION	☐	AD_LCTN	TEXT40	CHAR	40	0	Street 5
61	.INCLU--AP	☐				0	0	Search for FS Attributes of Objects
62	OBJ_STATE	☐	COM_INDOBJ_STATE	COM_INDOBJ_STATE	CHAR	20	0	Individual Object - Internal Status
63	.INCLU--AP	☐				0	0	Append for Loyalty Card attributes in Search for products
64	CARD_ID	☐	CRM_LOY_CARD_ID	CRM_LOY_CARD_ID	CHAR	16	0	Loyalty Card ID
65	.INCLU--AP	☐				0	0	Append for Object Settype Attributes for Searching Objects
66	.INCLUDE	☐				0	0	Object Settype Attributes for Searching Objects
67	OBJ_R3SER_NO	☐	R3SERIAL_NO	R3SERIAL_NO	CHAR	18	0	Serial Number
68	.INCLU--AP	☐				0	0	IT Objects specific search attributes
69	IMPACT	☐	CRMT_IT_IMPACT_UI	CRM_SRQM_IMPACT	NUMC	2	0	Impact	*
70	OPSYS	☐	CRMT_OS_KEY	CHAR4	CHAR	4	0	Operating System
71	OPSYS_V	☐	CRMT_IT_OS_VER_KEY	CHAR4	CHAR	4	0	Operating System Version
72	.INCLU--AP	☐				0	0	Manufacturing specific search attributes for objects
73	MANUFACTURER_ID	☐	MANUFACTURER_ID_UI	MANUFACTURER_ID_UI	CHAR	40	0	Manufacturer
74	MANUFACT_COUNTRY	☐	MANUFACT_COUNTRY_UI	LAND1	CHAR	3	0	Country of Manufacture	*
75	MANUFACT_REGION	☐	MANUFACT_REGION_UI	MANUFACT_REGION_UI	CHAR	3	0	Manufacturer Region
76	MANUFACT_MODEL	☐	MANUFACT_MODEL_UI	MANUFACT_MODEL_UI	CHAR	40	0	Model Number
77	MANUFACT_PART	☐	MANUFACT_PART_UI	MANUFACT_PART_UI	CHAR	40	0	Manufacturer Part Number
78	MANUFACT_SERIALNO	☐	MANUFACT_SERIALNO_UI	MANUFACT_SERIALNO_UI	CHAR	40	0	Manufacturer Serial Number
79	CONSTRUCTION_DATE	☐	CONSTRUCTION_DATE_UI	CONSTRUCTION_DATE_UI	DATS	8	0	Date of Manufacture
80	.INCLU--AP	☐				0	0	vehicle specific search attributes for objects
81	LPNO	☐	ISAM_LICENSEPLATE_NO	ISAM_LICENSEPLATE_NO	CHAR	15	0	Vehicle Licence Plate Number
82	VIN	☐	ISAM_VIN	ISAM_VIN	CHAR	35	0	Vehicle Identification Number
83	EXTVEHNO	☐	ISAM_EXTERNAL_VEH_NO	ISAM_EXTERNAL_VEH_NO	CHAR	35	0	External Vehicle Number
84	INTVEHNO	☐	ISAM_INTERNAL_VEH_NO	ISAM_INTERNAL_VEH_NO	CHAR	10	0	Internal Vehicle Number
85	MODEL	☐	ISAM_MODEL	ISAM_MODEL	CHAR	40	0	Vehicle Model
86	.INCLU--AP	☐				0	0	Attributes for Location
87	OTHERNAME	☐	PSIC_OTHERNAME	PSIC_OTHERNAME	CHAR	40	0	Other Name
88	.INCLU--AP	☐				0	0	Main enhanced attributes for Investigative Case Objects
89	MISSING	☐	MISSING	MISSING	CHAR	1	0	Missing

History

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