SAP ABAP Table M_STRTA (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	M_STRTA	Table Relationship Diagram
Short Description	Generated Table for View

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	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
5	CITY_CODE	☑	CITY_CODE	CITY_CODE	CHAR	12	0	City Code for City/Street File	ADRCITY
6	LANGU2	☑	LANGU	SPRAS	LANG	1	0	Language Key	T002
7	MC_STREET	☐	AD_MC_STRT	CHAR25	CHAR	25	0	Street name in upper case for search help
8	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
9	REGION	☐	REGIO	REGIO	CHAR	3	0	Region (State, Province, County)	T005S
10	CITY_NAME	☐	AD_CITY1	TEXT40	CHAR	40	0	City
11	MC_CITY	☐	AD_MC_CITY	CHAR25	CHAR	25	0	City name in upper case for search help
12	CITY_EXT	☐	CITY_EXT	TEXT30	CHAR	30	0	City name extension

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	M_STRTA	CITY_CODE	ADRCITY	CITY_CODE	REF	1	CN
2	M_STRTA	CLIENT	T000	MANDT	KEY	1	CN
3	M_STRTA	COUNTRY	T005	LAND1	KEY	1	CN
4	M_STRTA	LANGU	T002	SPRAS	KEY	1	CN
5	M_STRTA	LANGU2	T002	SPRAS	KEY	1	CN
6	M_STRTA	REGION	T005S	BLAND	REF

History

Last changed by/on	SAP	20130604
SAP Release Created in