SAP ABAP View EQUI_ADDR (Address view for collective search help EQUI)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ IEQM (Package) Application Develoment R/3 Equipment Management

Basic Data

View Type	D	Database View
Database View	EQUI_ADDR
Short Description	Address view for collective search help EQUI
Root table	ADRC	Addresses (Business Address Services)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ADRC	ADRC
2	ILOA
3	EQUZ	EQUZ
4	EQKT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	ILOA	MANDT	JL	EQ				0	0
2	ADRC	CLIENT	JR	EQ			AND	0	0
3	ILOA	ADRNR	JL	EQ				0	0
4	ADRC	ADDRNUMBER	JR	EQ			AND	0	0
5	EQUZ	MANDT	JL	EQ				0	0
6	ILOA	MANDT	JR	EQ			AND	0	0
7	EQUZ	ILOAN	JL	EQ				0	0
8	ILOA	ILOAN	JR	EQ			AND	0	0
9	EQKT	MANDT	JL	EQ				0	0
10	EQUZ	MANDT	JR	EQ			AND	0	0
11	EQKT	EQUNR	JL	EQ				0	0
12	EQUZ	EQUNR	JR	EQ			AND	0	0
13	ADRC	ADDR_GROUP		EQ	'PM01'		AND	0	0
14	ILOA	OWNER		EQ	' '		AND	0	0
15	EQUZ	DATBI		EQ	'99991231'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	ADRC	CLIENT		☐	MANDT	☐	Client
2	EQUNR	EQUZ	EQUNR		☐	EQUNR	☐	Equipment Number
3	ADDRNUMBER	ADRC	ADDRNUMBER		☐	AD_ADDRNUM	☐	Address number
4	NAME1	ADRC	NAME1		☐	AD_NAME1	☐	Name 1
5	NAME2	ADRC	NAME2		☐	AD_NAME2	☐	Name 2
6	NAME_TEXT	ADRC	NAME_TEXT		☐	AD_NAMETXT	☐	Converted name field (with form of address)
7	CITY1	ADRC	CITY1		☐	AD_CITY1	☐	City
8	POST_CODE1	ADRC	POST_CODE1		☐	AD_PSTCD1	☐	City postal code
9	STREET	ADRC	STREET		☐	AD_STREET	☐	Street
10	HOUSE_NUM1	ADRC	HOUSE_NUM1		☐	AD_HSNM1	☐	House Number
11	ADDR_GROUP	ADRC	ADDR_GROUP		☐	AD_GROUP	☐	Address Group (Key) (Business Address Services)
12	SORT1	ADRC	SORT1		☐	AD_SORT1	☐	Search Term 1
13	SORT2	ADRC	SORT2		☐	AD_SORT2	☐	Search Term 2
14	MC_NAME1	ADRC	MC_NAME1		☐	AD_MC_NAME	☐	Name (field NAME1) in upper case for matchcode
15	MC_CITY1	ADRC	MC_CITY1		☐	AD_MC_CITY	☐	City name in upper case for search help
16	MC_STREET	ADRC	MC_STREET		☐	AD_MC_STRT	☐	Street name in upper case for search help
17	ABCKZ	ILOA	ABCKZ		☐	ABCKZ	☐	ABC Indicator for Technical Object
18	EQFNR	ILOA	EQFNR		☐	EQFNR	☐	Sort Field
19	SWERK	ILOA	SWERK		☐	SWERK	☐	Maintenance Plant
20	STORT	ILOA	STORT		☐	PMLOC	☐	Location of maintenance object
21	MSGRP	ILOA	MSGRP		☐	RAUMNR	☐	Room
22	BEBER	ILOA	BEBER		☐	BEBER	☐	Organizational Area
23	KOSTL	ILOA	KOSTL		☐	KOSTL	☐	Cost Center
24	BUKRS	ILOA	BUKRS		☐	BUKRS	☐	Company Code
25	ANLNR	ILOA	ANLNR		☐	ANLN1	☐	Main Asset Number
26	ANLUN	ILOA	ANLUN		☐	ANLN2	☐	Asset Subnumber
27	VKORG	ILOA	VKORG		☐	VKORG	☐	Sales Organization
28	VTWEG	ILOA	VTWEG		☐	VTWEG	☐	Distribution Channel
29	SPART	ILOA	SPART		☐	SPART	☐	Division
30	OWNER	ILOA	OWNER		☐	ILOM_OWNER	☐	Object reference indicator
31	DATBI	EQUZ	DATBI		☐	DATBI	☐	Valid To Date
32	IWERK	EQUZ	IWERK		☐	IWERK	☐	Maintenance Planning Plant
33	INGRP	EQUZ	INGRP		☐	INGRP	☐	Planner Group for Customer Service and Plant Maintenance
34	KUND1	EQUZ	KUND1		☐	KUND1	☐	Customer No.
35	KUND2	EQUZ	KUND2		☐	KUND2	☐	End customer number
36	KUND3	EQUZ	KUND3		☐	KUND3	☐	Operator
37	SPRAS	EQKT	SPRAS		☐	SPRAS	☐	Language Key
38	EQKTX	EQKT	EQKTX		☐	KTX01	☐	Description of technical object
39	TXASP	EQKT	TXASP		☐	KZMLA	☐	Primary language indicator for text segment
40	EQKTU	EQKT	EQKTU		☐	EQKTU	☐	Equipment description in capital letters

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20140121
SAP Release Created in