SAP Table ADRSTRTYPE

Street type

ADRSTRTYPE (Street type) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link ADRSTRTYPE to other SAP tables.

ADRSTRTYPE table fields

Field		Data element	Checktable	Datatype	Length
CLIENT	Client	MANDT	T000	CLNT	3
COUNTRY	Country Key	LAND1	T005	CHAR	3
STRTYPEAB	Street type abbreviation	STRTYPEAB		CHAR	2

ADRSTRTYPE foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table		Check field
ADRSTRTYPE	CLIENT	ADRSTRTYPE	CLIENT	T000	Clients	MANDT
ADRSTRTYPE	COUNTRY	ADRSTRTYPE	CLIENT	T005	Countries	MANDT
ADRSTRTYPE	COUNTRY	ADRSTRTYPE	COUNTRY	T005	Countries	LAND1