SAP ABAP Table ADRSTREETT (Streets (long texts))

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

Table Category	TRANSP	Transparent table
Transparent table	ADRSTREETT	Table Relationship Diagram
Short Description	Streets (long texts)

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	LANGU	☑	LANGU	SPRAS	LANG	1	0	Language Key	T002
3	COUNTRY	☑	LAND1	LAND1	CHAR	3	0	Country Key	T005
4	STRT_CODE	☑	STRT_CODE	STRT_CODE	CHAR	12	0	Street Number for City/Street File	ADRSTREET
5	CITY_CODE	☐	CITY_CODE	CITY_CODE	CHAR	12	0	City Code for City/Street File	ADRCITY
6	.INCLUDE	☐				0	0	Data part of the table ADRSTREETT
7	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
8	MC_STREET	☐	AD_MC_STRT	CHAR25	CHAR	25	0	Street name in upper case for search help
9	STREET_SHR	☐	STREET_SHR	TEXT22	CHAR	22	0	Long abbreviation of street name (22 chars)
10	STREET_S15	☐	STREET_S15	TEXT15	CHAR	15	0	Short abbreviation of street name (15 chars)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ADRSTREETT	CITY_CODE	ADRCITY	CITY_CODE	REF	1	CN
2	ADRSTREETT	CLIENT	T000	MANDT	KEY	1	CN
3	ADRSTREETT	COUNTRY	T005	LAND1	KEY	1	CN
4	ADRSTREETT	LANGU	T002	SPRAS	KEY	1	CN
5	ADRSTREETT	STRT_CODE	ADRSTREET	STRT_CODE	TEXT	1	CN

History

Last changed by/on	SAP	20130604
SAP Release Created in