Name: SAP Table ADRC |Field Definitions and Relationships
Creator: QueryViz.io

fields (21)

field	type	length	key	description
`ADDRNUMBER`	char	10	pk	address number (primary key, referenced by adrnr in other tables)
`DATE_FROM`	dats	8	pk	validity start date for address
`MANDT`	clnt	3	pk	client
`NATION`	char	1	pk	version id for international addresses (blank=standard, int=international format)
`CITY1`	char	40		city name
`CITY2`	char	40		district or township
`COUNTRY`	char	3		country key (2-letter iso code, e.g., us, de, gb)
`DATE_TO`	dats	8		validity end date for address
`FAX_NUMBER`	char	30		fax number
`HOUSE_NUM1`	char	10		house number (may be separate from street in some locales)
`LANGU`	lang	1		language of address data
`NAME1`	char	40		name line 1 (company or person name)
`NAME2`	char	40		name line 2 (c/o, department, etc.)
`NAME3`	char	40		name line 3
`POST_CODE1`	char	10		city postal code (zip code)
`REGION`	char	3		state / province / county code
`SMTP_ADDR`	char	241		email address
`STR_SUPPL1`	char	40		street supplement 1 (additional address line)
`STR_SUPPL2`	char	40		street supplement 2
`STREET`	char	60		street and house number
`TEL_NUMBER`	char	30		telephone number (primary)

relationships (3)

master lookup

reference to master data

references

referenced by

configuration

reference to config tables

references

field	type	length	key	description
`ADDRNUMBER`	char	10	pk	address number (primary key, referenced by adrnr in other tables)
`DATE_FROM`	dats	8	pk	validity start date for address
`MANDT`	clnt	3	pk	client
`NATION`	char	1	pk	version id for international addresses (blank=standard, int=international format)
`CITY1`	char	40		city name
`CITY2`	char	40		district or township
`COUNTRY`	char	3		country key (2-letter iso code, e.g., us, de, gb)
`DATE_TO`	dats	8		validity end date for address
`FAX_NUMBER`	char	30		fax number
`HOUSE_NUM1`	char	10		house number (may be separate from street in some locales)
`LANGU`	lang	1		language of address data
`NAME1`	char	40		name line 1 (company or person name)
`NAME2`	char	40		name line 2 (c/o, department, etc.)
`NAME3`	char	40		name line 3
`POST_CODE1`	char	10		city postal code (zip code)
`REGION`	char	3		state / province / county code
`SMTP_ADDR`	char	241		email address
`STR_SUPPL1`	char	40		street supplement 1 (additional address line)
`STR_SUPPL2`	char	40		street supplement 2
`STREET`	char	60		street and house number
`TEL_NUMBER`	char	30		telephone number (primary)

master lookup

reference to master data

references

referenced by

configuration

reference to config tables

references