SAP ABAP Table CRMT_BSP_SERVOBJ_SEAREQ (Search Structure for Telco Service Objects)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IT-BTX (Application Component) Business Transaction
     ⤷ CRM_IST_CONTRACT (Package) IS-T Contracts

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BSP_SERVOBJ_SEAREQ	Table Relationship Diagram
Short Description	Search Structure for Telco Service 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	SO_SPARTE	☐	SPART	SPART	CHAR	2	0	Division	ECRM_ISU_TSPA
38	SO_SPARTE_DESC	☐	ECRM_ISU_PD_SPARTE	DDTEXT	CHAR	60	0	Division
39	ADDRESS	☐	ECRM_IST_ADDRESS	ECRM_IST_ADDRESS	CHAR	100	0	IS-T Address Search With Regular Expression
40	PARTNER_NO	☐	CRMT_PARTNER_NUMBER	CRM_PARTNER_NUMBER	CHAR	20	0	Partner Number for Use Outside Partner Processing
41	PARTNER_FCT	☐	CRMT_PARTNER_FCT	COM_PARTNER_FCT	CHAR	8	0	Partner Function
42	DEV_SERNR	☐	GERNR	GERNR	CHAR	18	0	Serial Number
43	SO_SERV_ID	☐	CRMT_IST_EXT_UI	EUI_EXT_UI	CHAR	50	0	Identification Number
44	SO_VDEW_LAND	☐	LANDL_ISO	INTCA	CHAR	2	0	Supplier country ISO code
45	SO_VDEW_NETZ	☐	CRM_IST_UI_NETZ	CRM_IST_UI_NETZ	CHAR	6	0	IS-T Network Operator Number for Point of Delivery ID
46	SO_VDEW_LFDN	☐	CRM_IST_UI_LFDN	CRM_IST_UI_LFDN	CHAR	20	0	IS-T Sequence Number of Point of Delivery
47	SO_OUTL_CONT	☐	CRMT_OUTL_CONTRACT_FLAG	CRMT_OUTL_CONT_FLAG	CHAR	1	0	Point of Delivery Use
48	COUNTRY_DESCRIPTION	☐	LANDX	TEXT15	CHAR	15	0	Country Name
49	UP_TO_ROWS	☐	SYDBCNT	SYST_LONG	INT4	10	0	Processed Database Table Rows

Foreign Keys

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

History

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