SAP ABAP Table CRMT_BSP_SEAREQ_PREMISE (Premise: Address Search)

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_SEAREQ_PREMISE	Table Relationship Diagram
Short Description	Premise: Address Search

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	NAME1	☐	CRMT_BSP_NAME1	BU_NAME	CHAR	40	0	Name 1 (Search Help Field 1)
2	NAME2	☐	CRMT_BSP_NAME2	BU_NAME	CHAR	40	0	Name 2 (Search Help Field 2)
3	CITY1	☐	ECRM_ISU_AD_CITY1	TEXT40	CHAR	40	0	City
4	POST_CODE1	☐	ECRM_ISU_AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
5	STREET	☐	ECRM_ISU_AD_STREET	TEXT60	CHAR	60	0	Street
6	HOUSE_NUM1	☐	ECRM_ISU_AD_HSNM1	TEXT10	CHAR	10	0	House number
7	HOUSE_NUM2	☐	ECRM_ISU_AD_HSNM2	TEXT10	CHAR	10	0	House number supplement
8	STR_SUPPL1	☐	ECRM_ISU_AD_STRSPP1	TEXT40	CHAR	40	0	Street 2
9	STR_SUPPL2	☐	ECRM_ISU_AD_STRSPP2	TEXT40	CHAR	40	0	Street 3
10	FLOOR	☐	ECRM_ISU_AD_FLOOR	TEXT10	CHAR	10	0	Floor in building
11	ROOMNUMBER	☐	ECRM_ISU_AD_ROOMNUM	TEXT10	CHAR	10	0	Room or appartment number
12	REGION	☐	ECRM_ISU_REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	*
13	LOCATION	☐	ECRM_ISU_AD_LCTN	TEXT40	CHAR	40	0	Location
14	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
15	BU_PARTNER_NUMBER	☐	ECRM_ISU_VPARTNER	BU_PARTNER	CHAR	10	0	Contract Partner Number	*
16	PD_SPARTE	☐	SPART	SPART	CHAR	2	0	Division	ECRM_ISU_TSPA
17	PD_SPARTE_DESC	☐	ECRM_ISU_PD_SPARTE	DDTEXT	CHAR	60	0	Division
18	ADDRESS	☐	ECRM_ISU_ADDRESS	ECRM_ISU_ADDRESS	CHAR	100	0	IS-U Address Search with Regular Print-Out

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRMT_BSP_SEAREQ_PREMISE	COUNTRY	T005	LAND1
2	CRMT_BSP_SEAREQ_PREMISE	PD_SPARTE	ECRM_ISU_TSPA	SPART

History

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