SAP ABAP Table CRMT_BSP_TECHOBJ_SEAREQ (Search Structure: Technical Objects)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IU-S (Application Component) Utilities Industry: Sales
     ⤷ CRM_BSP_MODEL_IL_TECH_OBJ (Package) Utilities: Technical Objects

Basic Data

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

History

Last changed by/on	SAP	20141013
SAP Release Created in	400