SAP ABAP Table CRMT_BSP_SEARES_COB (Connection Object: Results of Search by Address)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IU-S (Application Component) Utilities Industry: Sales
     ⤷ CRM_BSP_MODEL_IL_PRM (Package) CRM_BSP_MODEL_IL_PRM for Utilities

Basic Data

Table Category	INTTAB	Structure
Structure	CRMT_BSP_SEARES_COB	Table Relationship Diagram
Short Description	Connection Object: Results of Search by Address

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	OBJECT_KEY	☐	CRMT_BSP_OBJECTKEY		CHAR	100	0	Object Key
2	.INCLUDE	☐				0	0	IS-U: Premise Data for iView
3	VS_VSTELLE	☐	EUI_VSTELLE_UI		CHAR	10	0	Premise
4	GUID_COMPC	☐	ECRM_ISU_GUID_COMPC_S	SYSUUID_C	CHAR	32	0	Premise
5	CITY1	☐	ECRM_ISU_AD_CITY1	TEXT40	CHAR	40	0	City
6	CITY2	☐	ECRM_ISU_AD_CITY2	TEXT40	CHAR	40	0	District
7	CITY_CODE	☐	ECRM_ISU_AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	*
8	CITYP_CODE	☐	ECRM_ISU_AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file	*
9	HOME_CITY	☐	ECRM_ISU_AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
10	REGIOGROUP	☐	ECRM_ISU_REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping	*
11	POST_CODE1	☐	ECRM_ISU_AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
12	POST_CODE2	☐	ECRM_ISU_AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
13	POST_CODE3	☐	ECRM_ISU_AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
14	PO_BOX	☐	ECRM_ISU_AD_POBX	CHAR10	CHAR	10	0	PO Box
15	PO_BOX_NUM	☐	ECRM_ISU_AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
16	PO_BOX_LOC	☐	ECRM_ISU_AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
17	PO_BOX_REG	☐	ECRM_ISU_AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)	*
18	PO_BOX_CTY	☐	ECRM_ISU_AD_POBXCTY	LAND1	CHAR	3	0	PO box country	*
19	POSTALAREA	☐	ECRM_ISU_AD_PSTLAR	TEXT15	CHAR	15	0	Post delivery district
20	STREET	☐	ECRM_ISU_AD_STREET	TEXT60	CHAR	60	0	Street
21	STREETABBR	☐	ECRM_ISU_AD_STRABBR	STRTYPEAB	CHAR	2	0	Abbreviation of street name (e.g in Spain)	*
22	HOUSE_NUM1	☐	ECRM_ISU_AD_HSNM1	TEXT10	CHAR	10	0	House number
23	HOUSE_NUM2	☐	ECRM_ISU_AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
24	HOUSE_NUM3	☐	ECRM_ISU_AD_HSNM3	TEXT10	CHAR	10	0	House number range
25	STR_SUPPL1	☐	ECRM_ISU_AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
26	STR_SUPPL2	☐	ECRM_ISU_AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
27	STR_SUPPL3	☐	ECRM_ISU_AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
28	LOCATION	☐	ECRM_ISU_AD_LCTN	TEXT40	CHAR	40	0	Location
29	BUILDING	☐	ECRM_ISU_AD_BLDNG	TEXT20	CHAR	20	0	Building (number or code)
30	FLOOR	☐	ECRM_ISU_AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
31	ROOMNUMBER	☐	ECRM_ISU_AD_ROOMNUM	TEXT10	CHAR	10	0	Room or appartment number
32	COUNTRY	☐	ECRM_ISU_LAND1	LAND1	CHAR	3	0	Country key	T005
33	REGION	☐	ECRM_ISU_REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
34	REMARK	☐	ECRM_ISU_AD_REMARK1	TEXT50	CHAR	50	0	Address notes
35	VS_LGZUSATZ	☐	EUI_LGZUSATZ_UI		CHAR	40	0	Additional Information on Location
36	VS_VBSART	☐	ECRM_ISU_VBSART	ECRM_ISU_VBSART	CHAR	8	0	IS-U Premise Type	ECRM_ISU_TE102
37	VS_VBSART_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
38	ICON	☐	ECRM_ISU_ICON	URL_PATH	CHAR	120	0	Status Icon
39	VS_ANZPERS	☐	EUI_ANZPERS_UI		NUMC	3	0	Number of Persons in a Premise
40	CT_BUPA_NR	☐	BU_PARTNER	BU_PARTNER	CHAR	10	0	Business Partner Number	*
41	INSTANCE	☐	IB_INSTANCE	IB_INSTANCE	NUMC	18	0	IB: Component (instance)
42	PD_EXT_UI	☐	EUI_EXT_UI_UI	EUI_EXT_UI	CHAR	50	0	Point of Delivery ID
43	PD_SPARTE	☐	SPART	SPART	CHAR	2	0	Division	ECRM_ISU_TSPA
44	PD_SPARTE_DESC	☐	ECRM_ISU_PD_SPARTE_DESC	CHAR60	CHAR	60	0	Division
45	PD_UITYPE	☐	ECRM_ISU_UITYPE	ECRM_ISU_UITYPE	CHAR	4	0	IS-U Point of Delivery Type	ECRM_ISU_EUITYP
46	PD_UITYPE_DESC	☐	ECRM_ISU_PD_UITYPE_DESC	CHAR60	CHAR	60	0	Point of Delivery Type
47	PD_SHTXT	☐	EUI_SHTXT_UI	TEXT40	CHAR	40	0	Description
48	PD_SHTXT_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
49	OBJECT_GUID	☐	IB_OBJNR_GUID16	SYSUUID	RAW	16	0	IB: Reference to Object as GUID X16
50	PD_GRID_LTYP	☐	EUI_GRID_LEVEL_TYPE	EUI_GRID_LEVEL_TYPE	CHAR	4	0	Grid Level Type
51	PD_GRID_LTYP_DESC	☐	CRM_ISUT_GLT_NAME	TEXT40	CHAR	40	0	Grid Level Category Description
52	PD_GRID_LEVL	☐	EUI_GRID_LEVEL	EUI_GRID_LEVEL	CHAR	10	0	Grid Level
53	PD_GRID_LEVL_DESC	☐	CRM_ISUT_GL_NAME	TEXT40	CHAR	40	0	Grid Level Description
54	PD_GRID_ID	☐	EUI_GRID_ID	EUI_GRID_ID	CHAR	10	0	Grid
55	PD_GRID_ID_DESC	☐	CRM_ISUT_GRID_NAME	TEXT40	CHAR	40	0	Distribution Grid Name
56	PD_OUTL_CONT	☐	EUI_OUTL_CONTRACT	EUI_OUTL_CONTRACT	CHAR	1	0	Outline Contract Indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BSP_SEARES_COB	COUNTRY	T005	LAND1
2	CRMT_BSP_SEARES_COB	PD_SPARTE	ECRM_ISU_TSPA	SPART
3	CRMT_BSP_SEARES_COB	PD_UITYPE	ECRM_ISU_EUITYP	UITYPE
4	CRMT_BSP_SEARES_COB	REGION	T005S	BLAND
5	CRMT_BSP_SEARES_COB	VS_VBSART	ECRM_ISU_TE102	VBSART

History

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