SAP ABAP Table ECRM_ISU_PCT_PREMISE_READ (IS-U: Premise Data for iView)

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	ECRM_ISU_PCT_PREMISE_READ	Table Relationship Diagram
Short Description	IS-U: Premise Data for iView

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	VS_VSTELLE	☐	EUI_VSTELLE_UI		CHAR	10	0	Premise
2	GUID_COMPC	☐	ECRM_ISU_GUID_COMPC_S	SYSUUID_C	CHAR	32	0	Premise
3	CITY1	☐	ECRM_ISU_AD_CITY1	TEXT40	CHAR	40	0	City
4	CITY2	☐	ECRM_ISU_AD_CITY2	TEXT40	CHAR	40	0	District
5	CITY_CODE	☐	ECRM_ISU_AD_CITYNUM	CITY_CODE	CHAR	12	0	City code for city/street file	*
6	CITYP_CODE	☐	ECRM_ISU_AD_CITYPNM	CITYP_CODE	CHAR	8	0	District code for City and Street file	*
7	HOME_CITY	☐	ECRM_ISU_AD_CITY3	TEXT40	CHAR	40	0	City (different from postal city)
8	REGIOGROUP	☐	ECRM_ISU_REGIOGROUP	REGIOGROUP	CHAR	8	0	Regional structure grouping	*
9	POST_CODE1	☐	ECRM_ISU_AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
10	POST_CODE2	☐	ECRM_ISU_AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
11	POST_CODE3	☐	ECRM_ISU_AD_PSTCD3	CHAR10	CHAR	10	0	Company postal code (for large customers)
12	PO_BOX	☐	ECRM_ISU_AD_POBX	CHAR10	CHAR	10	0	PO Box
13	PO_BOX_NUM	☐	ECRM_ISU_AD_POBXNUM	XFELD	CHAR	1	0	Flag: PO Box without number
14	PO_BOX_LOC	☐	ECRM_ISU_AD_POBXLOC	TEXT40	CHAR	40	0	PO Box city
15	PO_BOX_REG	☐	ECRM_ISU_AD_POBXREG	REGIO	CHAR	3	0	Region for PO Box (Country, State, Province, ...)	*
16	PO_BOX_CTY	☐	ECRM_ISU_AD_POBXCTY	LAND1	CHAR	3	0	PO box country	*
17	POSTALAREA	☐	ECRM_ISU_AD_PSTLAR	TEXT15	CHAR	15	0	Post delivery district
18	STREET	☐	ECRM_ISU_AD_STREET	TEXT60	CHAR	60	0	Street
19	STREETABBR	☐	ECRM_ISU_AD_STRABBR	STRTYPEAB	CHAR	2	0	Abbreviation of street name (e.g in Spain)	*
20	HOUSE_NUM1	☐	ECRM_ISU_AD_HSNM1	TEXT10	CHAR	10	0	House number
21	HOUSE_NUM2	☐	ECRM_ISU_AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
22	HOUSE_NUM3	☐	ECRM_ISU_AD_HSNM3	TEXT10	CHAR	10	0	House number range
23	STR_SUPPL1	☐	ECRM_ISU_AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
24	STR_SUPPL2	☐	ECRM_ISU_AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
25	STR_SUPPL3	☐	ECRM_ISU_AD_STRSPP3	TEXT40	CHAR	40	0	Street 4
26	LOCATION	☐	ECRM_ISU_AD_LCTN	TEXT40	CHAR	40	0	Location
27	BUILDING	☐	ECRM_ISU_AD_BLDNG	TEXT20	CHAR	20	0	Building (number or code)
28	FLOOR	☐	ECRM_ISU_AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
29	ROOMNUMBER	☐	ECRM_ISU_AD_ROOMNUM	TEXT10	CHAR	10	0	Room or appartment number
30	COUNTRY	☐	ECRM_ISU_LAND1	LAND1	CHAR	3	0	Country key	T005
31	REGION	☐	ECRM_ISU_REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
32	REMARK	☐	ECRM_ISU_AD_REMARK1	TEXT50	CHAR	50	0	Address notes
33	VS_LGZUSATZ	☐	EUI_LGZUSATZ_UI		CHAR	40	0	Additional Information on Location
34	VS_VBSART	☐	ECRM_ISU_VBSART	ECRM_ISU_VBSART	CHAR	8	0	IS-U Premise Type	ECRM_ISU_TE102
35	VS_VBSART_DESC	☐	COMT_ATTR_VAL_TEXT	DDTEXT	CHAR	60	0	Description of Single Value
36	ICON	☐	ECRM_ISU_ICON	URL_PATH	CHAR	120	0	Status Icon

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ECRM_ISU_PCT_PREMISE_READ	COUNTRY	T005	LAND1
2	ECRM_ISU_PCT_PREMISE_READ	REGION	T005S	BLAND
3	ECRM_ISU_PCT_PREMISE_READ	VS_VBSART	ECRM_ISU_TE102	VBSART

History

Last changed by/on	SAP	20130604
SAP Release Created in	310