SAP ABAP View V_T001W_EXT_ADR (View of ADRC and T001W_EXT for External Plants)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA (Application Component) Cross-Application Components
     ⤷ AIPLOC (Package) Cross-System Flow of Goods (Plants)

Basic Data

View Type	D	Database View
Database View	V_T001W_EXT_ADR
Short Description	View of ADRC and T001W_EXT for External Plants
Root table	T001W_EXT	Plants (Company's Own and External)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	T001W_EXT	T001W_EXT
2	ADRC

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	T001W_EXT	MANDT	JL	EQ				0	0
2	ADRC	CLIENT	JR	EQ			AND	0	0
3	T001W_EXT	ADRNR	JL	EQ				0	0
4	ADRC	ADDRNUMBER	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	T001W_EXT	MANDT		☐	MANDT	☐	Client
2	SORT2	ADRC	SORT2		☐	AD_SORT2	☐	Search Term 2
3	SORT1	ADRC	SORT1		☐	AD_SORT1	☐	Search Term 1
4	POST_CODE1	ADRC	POST_CODE1		☐	AD_PSTCD1	☐	City postal code
5	CITY1	ADRC	CITY1		☐	AD_CITY1	☐	City
6	MC_CITY1	ADRC	MC_CITY1		☐	AD_MC_CITY	☐	City name in upper case for search help
7	NAME2	ADRC	NAME2		☐	AD_NAME2	☐	Name 2
8	NAME1	ADRC	NAME1		☐	AD_NAME1	☐	Name 1
9	MC_NAME1	ADRC	MC_NAME1		☐	AD_MC_NAME	☐	Name (field NAME1) in upper case for matchcode
10	NATION	ADRC	NATION		☐	AD_NATION	☐	Version ID for International Addresses
11	WERKS	T001W_EXT	WERKS		☐	WERKS_D_EXT	☐	Plant for Cross-System Flows of Goods
12	LOGSYS	T001W_EXT	LOGSYS		☐	LOGSYS	☐	Logical system

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	N	Display/Maintenance Not Allowed

History

Last changed by/on	SAP	20140121
SAP Release Created in	470