SAP ABAP Table CRM_IU_IC_OBJ_SEARCH_ID_BRF_TO (Search Criteria (Technical Objects))

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IU-IC (Application Component) Utilities Industry: Interaction Center
     ⤷ CRM_IU_IC_OBJOVW (Package) Utilities: IC WebClient - Object Overview

Basic Data

Table Category	INTTAB	Structure
Structure	CRM_IU_IC_OBJ_SEARCH_ID_BRF_TO	Table Relationship Diagram
Short Description	Search Criteria (Technical 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	Search Structure: Technical Objects
2	.INCLUDE	☐				0	0	Address search parameter
3	NAME1	☐	AD_MC_NAME	CHAR25	CHAR	25	0	Name (field NAME1) in upper case for matchcode
4	NAME2	☐	AD_NAME2	TEXT40	CHAR	40	0	Name 2
5	CITY1	☐	AD_MC_CITY	CHAR25	CHAR	25	0	City name in upper case for search help
6	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
7	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
8	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
9	POST_CODE3	☐	AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
10	PO_BOX_LOC	☐	AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
11	STREET	☐	AD_MC_STRT	CHAR25	CHAR	25	0	Street name in upper case for search help
12	HOUSE_NUM1	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
13	HOUSE_NUM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
14	HOUSE_NUM3	☐	AD_HSNM3	TEXT10	CHAR	10	0	(Not supported) House Number Range
15	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
16	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
17	SORT1	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
18	SORT2	☐	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2
19	SORT_PHN	☐	AD_SRTPHN	CHAR20	CHAR	20	0	(Not Supported) Phonetic Search Sort Field
20	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
21	NAME1_LNG	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
22	CITY1_LNG	☐	AD_CITY1	TEXT40	CHAR	40	0	City
23	STREET_LNG	☐	AD_STREET	TEXT60	CHAR	60	0	Street
24	PO_BOX_LOBBY	☐	AD_PO_BOX_LBY	TEXT40	CHAR	40	0	PO Box Lobby
25	DELI_SERV_TYPE	☐	AD_DELIVERY_SERVICE_TYPE	AD_DELIVERY_SERVICE_TYPE	CHAR	4	0	Type of Delivery Service	*
26	DELI_SERV_NUMBER	☐	AD_DELIVERY_SERVICE_NUMBER	CHAR10	CHAR	10	0	Number of Delivery Service
27	COUNTY	☐	AD_MC_COUNTY	CHAR25	CHAR	25	0	County name in upper case for search help
28	TOWNSHIP	☐	AD_MC_TWSHP	CHAR25	CHAR	25	0	Township name in upper case for search help
29	COUNTY_LNG	☐	AD_COUNTY	TEXT40	CHAR	40	0	County
30	TOWNSHIP_LNG	☐	AD_TOWNSHIP	TEXT40	CHAR	40	0	Township
31	.INCLUDE	☐				0	0	Structure of Premise Address Data
32	VS_FLOOR	☐	AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
33	VS_ROOMNUMBER	☐	AD_ROOMNUM	TEXT10	CHAR	10	0	Room or Appartment Number
34	VS_STR_SUPPL1	☐	AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
35	VS_STR_SUPPL3	☐	AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
36	VS_HOUSE_NUM2	☐	AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
37	BU_PARTNER_NUMBER	☐	ECRM_ISU_VPARTNER	BU_PARTNER	CHAR	10	0	Contract Partner Number	*
38	PD_SPARTE	☐	SPART	SPART	CHAR	2	0	Division	ECRM_ISU_TSPA
39	PD_SPARTE_DESC	☐	ECRM_ISU_PD_SPARTE	DDTEXT	CHAR	60	0	Division
40	ADDRESS	☐	ECRM_ISU_ADDRESS	ECRM_ISU_ADDRESS	CHAR	100	0	IS-U Address Search with Regular Print-Out
41	PARTNER_NO	☐	ECRM_ISU_PARTNER	BU_PARTNER	CHAR	10	0	Partner Number (direct linkage)	*
42	PARTNER_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
43	DEV_SERNR	☐	CRM_ISU_GERNR	CRM_ISU_GERNR	CHAR	18	0	Serial Number
44	PD_FLAT_UI	☐	EUI_EXT_UI	EUI_EXT_UI	CHAR	50	0	Point of Delivery ID
45	PD_VDEW_LAND	☐	LANDL_ISO	INTCA	CHAR	2	0	Supplier country ISO code
46	PD_VDEW_NETZ	☐	ECRM_ISU_UI_NETZ	ECRM_ISU_UI_NETZ	CHAR	6	0	IS-U Number of Distributor for Point of Delivery Description
47	PD_VDEW_PLZ	☐	ECRM_ISU_UI_PLZ	ECRM_ISU_UI_PLZ	CHAR	5	0	IS-U Postal Code for Point of Delivery Description
48	PD_VDEW_LFDN	☐	ECRM_ISU_UI_LFDN	ECRM_ISU_UI_LFDN	CHAR	20	0	IS-U Sequence Number of Point of Delivery
49	PD_OUTL_CONT	☐	CRMT_OUTL_CONTRACT_FLAG	CRMT_OUTL_CONT_FLAG	CHAR	1	0	Point of Delivery Use
50	COUNTRY_DESCRIPTION	☐	LANDX	TEXT15	CHAR	15	0	Country Name
51	UP_TO_ROWS	☐	SYDBCNT	SYST_LONG	INT4	10	0	Processed Database Table Rows
52	CT_ISU_NUMBER	☐	CRMT_OBJECT_ID	CRM_OBJECT_ID	CHAR	10	0	Transaction ID

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRM_IU_IC_OBJ_SEARCH_ID_BRF_TO	PD_SPARTE	ECRM_ISU_TSPA	SPART
2	CRM_IU_IC_OBJ_SEARCH_ID_BRF_TO	REGION	T005S	BLAND	REF	C	CN

History

Last changed by/on	SAP	20141013
SAP Release Created in