SAP ABAP View V_ADRTWSHP (Township search help view)

Hierarchy

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

Basic Data

View Type	D	Database View
Database View	V_ADRTWSHP
Short Description	Township search help view
Root table	ADRTOWNSHIPT	Township (long texts)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ADRTOWNSHIPT	ADRTOWNSHIPT
2	ADRTOWNSHIP
3	ADRCOUNTYT
4	ADRCOUNTY

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	ADRTOWNSHIP	CLIENT	JL	EQ				0	0
2	ADRTOWNSHIPT	CLIENT	JR	EQ			AND	0	0
3	ADRTOWNSHIP	COUNTRY	JL	EQ				0	0
4	ADRTOWNSHIPT	COUNTRY	JR	EQ			AND	0	0
5	ADRTOWNSHIP	REGION	JL	EQ				0	0
6	ADRTOWNSHIPT	REGION	JR	EQ			AND	0	0
7	ADRTOWNSHIP	TOWNSHIP_CODE	JL	EQ				0	0
8	ADRTOWNSHIPT	TOWNSHIP_CODE	JR	EQ			AND	0	0
9	ADRTOWNSHIP	COUNTY_CODE	JL	EQ				0	0
10	ADRTOWNSHIPT	COUNTY_CODE	JR	EQ			AND	0	0
11	ADRCOUNTY	CLIENT	JL	EQ				0	0
12	ADRTOWNSHIPT	CLIENT	JR	EQ			AND	0	0
13	ADRCOUNTY	COUNTRY	JL	EQ				0	0
14	ADRTOWNSHIPT	COUNTRY	JR	EQ			AND	0	0
15	ADRCOUNTY	REGION	JL	EQ				0	0
16	ADRTOWNSHIPT	REGION	JR	EQ			AND	0	0
17	ADRCOUNTY	COUNTY_CODE	JL	EQ				0	0
18	ADRTOWNSHIPT	COUNTY_CODE	JR	EQ			AND	0	0
19	ADRCOUNTY	CLIENT	JL	EQ				0	0
20	ADRCOUNTYT	CLIENT	JR	EQ			AND	0	0
21	ADRCOUNTY	COUNTRY	JL	EQ				0	0
22	ADRCOUNTYT	COUNTRY	JR	EQ			AND	0	0
23	ADRCOUNTY	REGION	JL	EQ				0	0
24	ADRCOUNTYT	REGION	JR	EQ			AND	0	0
25	ADRCOUNTY	COUNTY_CODE	JL	EQ				0	0
26	ADRCOUNTYT	COUNTY_CODE	JR	EQ			AND	0	0
27	ADRTOWNSHIPT	LANGU	JL	EQ				0	0
28	ADRCOUNTYT	LANGU	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	ADRTOWNSHIPT	CLIENT		☐	MANDT	☐	Client
2	LANGU	ADRTOWNSHIPT	LANGU		☐	LANGU	☐	Language Key
3	COUNTRY	ADRTOWNSHIPT	COUNTRY		☐	LAND1	☐	Country Key
4	REGION	ADRTOWNSHIPT	REGION		☐	REGIO	☐	Region (State, Province, County)
5	COUNTY_CODE	ADRTOWNSHIPT	COUNTY_CODE		☐	CNTY_CODE	☐	County code for county
6	TOWNSHIP_CODE	ADRTOWNSHIPT	TOWNSHIP_CODE		☐	TWSHP_CODE	☐	Township code for Township
7	LANGU2	ADRCOUNTYT	LANGU		☐	LANGU	☐	Language Key
8	TOWNSHIP	ADRTOWNSHIPT	TOWNSHIP		☐	AD_TOWNSHIP	☐	Township
9	MC_TOWNSHIP	ADRTOWNSHIPT	MC_TOWNSHIP		☐	AD_MC_TWSHP	☐	Township name in upper case for search help
10	COUNTY	ADRCOUNTYT	COUNTY		☐	AD_COUNTY	☐	County
11	MC_COUNTY	ADRCOUNTYT	MC_COUNTY		☐	AD_MC_COUNTY	☐	County name in upper case for search help

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	20141013
SAP Release Created in	732