SAP ABAP Table CRMT_BSP_SEARES_COB_PRM (ISU: Screen Structure for BSP Application Read-Methods)

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_PRM	Table Relationship Diagram
Short Description	ISU: Screen Structure for BSP Application Read-Methods

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BSP_SEARES_COB_PRM	PD_SPARTE	ECRM_ISU_TSPA	SPART
2	CRMT_BSP_SEARES_COB_PRM	PD_UITYPE	ECRM_ISU_EUITYP	UITYPE
3	CRMT_BSP_SEARES_COB_PRM	VS_VBSART	ECRM_ISU_TE102	VBSART

History

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