SAP ABAP Table CRM_ISU_PRM_SEARCH_ADDR (Search Structure for premises by address)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-IU-MD-TO (Application Component) Utilities Industry: Technical Objects
     ⤷ CRM_IU_IL_TEC (Package) Utilities: Generic IL Implementation

Basic Data

Table Category	INTTAB	Structure
Structure	CRM_ISU_PRM_SEARCH_ADDR	Table Relationship Diagram
Short Description	Search Structure for premises 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	.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	T005
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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	CRM_ISU_PRM_SEARCH_ADDR	COUNTRY	T005	LAND1	REF	C	CN
2	CRM_ISU_PRM_SEARCH_ADDR	REGION	T005S	BLAND	REF	C	CN

History

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