SAP ABAP Table ADDR2_FIND (Search parameter for person with private address)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-SRV-ADR (Application Component) Address Management/Business Address
     ⤷ SZAD (Package) SAP Technology - Business Services: Address Management

Basic Data

Table Category	INTTAB	Structure
Structure	ADDR2_FIND	Table Relationship Diagram
Short Description	Search parameter for person with private 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	NAME_FIRST	☐	AD_MC_NMFI	CHAR25	CHAR	25	0	First name in upper case for search help
2	NAME_LAST	☐	AD_MC_NMLA	CHAR25	CHAR	25	0	Last name in upper-case for search help
3	SORT1_P	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
4	SORT2_P	☐	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2
5	CITY1	☐	AD_MC_CITY	CHAR25	CHAR	25	0	City name in upper case for search help
6	CITY2	☐	AD_CITY2	TEXT40	CHAR	40	0	District
7	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
8	POST_CODE2	☐	AD_PSTCD2	CHAR10	CHAR	10	0	PO Box postal code
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	COUNTRY	☐	LAND1	LAND1	CHAR	3	0	Country Key	T005
14	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
15	SORT1	☐	AD_SORT1	CHAR20	CHAR	20	0	Search Term 1
16	SORT2	☐	AD_SORT2	CHAR20	CHAR	20	0	Search Term 2
17	PERSNUMBER	☐	AD_PERSNUM	AD_PERSNUM	CHAR	10	0	Person number	*
18	ADDRNUMBER	☐	AD_ADDRNUM	AD_ADDRNUM	CHAR	10	0	Address number	*
19	NAME_F_LNG	☐	AD_NAMEFIR	TEXT40	CHAR	40	0	First name
20	NAME_L_LNG	☐	AD_NAMELAS	TEXT40	CHAR	40	0	Last name
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

Foreign Keys

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

History

Last changed by/on	SAP	20141013
SAP Release Created in