SAP Table DIADR

Address

DIADR (Address) 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 DIADR to other SAP tables.

DIADR table fields

Field		Data element	Checktable	Datatype	Length
MANDT	Client	MANDT	T000	CLNT	3
NAME1	Name 1	AD_NAME1		CHAR	40
NAME2	Name 2	AD_NAME2		CHAR	40
NAME3	Name 3	AD_NAME3		CHAR	40
NAME4	Name 4	AD_NAME4		CHAR	40
CITY1	City	AD_CITY1		CHAR	40
CITY2	District	AD_CITY2		CHAR	40
POST_CODE1	City postal code	AD_PSTCD1		CHAR	10
POST_CODE2	PO Box Postal Code	AD_PSTCD2		CHAR	10
COUNTRY	Country Key	LAND1	T005	CHAR	3
REGION	Region (State, Province, County)	REGIO	T005S	CHAR	3
STREET	Street	AD_STREET		CHAR	60
PO_BOX	PO Box	AD_POBX		CHAR	10
LANGU	Language Key	SPRAS	T002	LANG	1
TEL_NUMBER	First telephone no.: dialling code+number	AD_TLNMBR1		CHAR	30
FAX_NUMBER	First fax no.: dialling code+number	AD_FXNMBR1		CHAR	30
TLX_NUMBER	Telex number	AD_TLXNMBR		CHAR	30
TTX_NUMBER	Teletex number	AD_TTXNMBR		CHAR	30
SORT1	Search Term 1	AD_SORT1		CHAR	20
NAME_LIST	Name for list displays	I_NAME_LST		CHAR	35
REMARK	Address notes	AD_REMARK1		CHAR	50
TZONSP	Time Zone for Partner	TZONSP	TTZZ	CHAR	6
DATUM	System Date	SYDATUM		DATS	8
UZEIT	System Time	SYUZEIT		TIMS	6
HOUSE_NUM1	House Number	AD_HSNM1		CHAR	10

DIADR foreign key relationships

Table	Field	Foreign key table	Foreign key field	Check table		Check field
DIADR	COUNTRY	DIADR	MANDT	T005	Countries	MANDT
DIADR	COUNTRY	DIADR	COUNTRY	T005	Countries	LAND1
DIADR	LANGU	DIADR	LANGU	T002	Language Keys (Component BC-I18)	SPRAS
DIADR	MANDT	DIADR	MANDT	T000	Clients	MANDT
DIADR	REGION	DIADR	MANDT	T005S	Taxes: Region (Province) Key	MANDT
DIADR	REGION	DIADR	COUNTRY	T005S	Taxes: Region (Province) Key	LAND1
DIADR	REGION	DIADR	REGION	T005S	Taxes: Region (Province) Key	BLAND
DIADR	TZONSP	DIADR	MANDT	TTZZ	Time zones	CLIENT
DIADR	TZONSP	DIADR	TZONSP	TTZZ	Time zones	TZONE