SAP Table ADRS

Address formating function module transfer structure

ADRS (Address formating function module transfer structure) 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 ADRS to other SAP tables.

ADRS table fields

Field		Data element	Datatype	Length
ANRED	Title	ANRED	CHAR	15
NAME1	Name 1 of an address	NAME1_ADRS	CHAR	40
NAME2	Name 2 of an address	NAME2_ADRS	CHAR	40
NAME3	Name 3 of an address	NAME3_ADRS	CHAR	40
NAME4	Name 4 of an address	NAME4_ADRS	CHAR	40
STRAS	House number and street	STRAS_GP	CHAR	35
PFACH	PO box	PFACH_BAS	CHAR	10
PSTL2	PO Box postal code	PSTL2_BAS	CHAR	10
PFORT	PO Box city	PFORT_ADRS	CHAR	40
LAND1	Country Key	LAND1	CHAR	3
PSTLZ	Postal code	PSTLZ_BAS	CHAR	10
ORT01	City	ORT01_GP	CHAR	35
ORT02	City	ORT01_GP	CHAR	35
REGIO	Region (State, Province, County)	REGIO	CHAR	3
SPRAS	Language Key	SPRAS	LANG	1
INLND	Country Key	LAND1	CHAR	3
ANZZL	Number of lines in address	ANZEI	DEC	2
PRIOR	Address lines priority	PRITY_ADRS	CHAR	9
WAREN	Delivery address ID	WAREN	CHAR	1
LINE0	Address line	LINES	CHAR	80
LINE1	Address line	LINES	CHAR	80
LINE2	Address line	LINES	CHAR	80
LINE3	Address line	LINES	CHAR	80
LINE4	Address line	LINES	CHAR	80
LINE5	Address line	LINES	CHAR	80
LINE6	Address line	LINES	CHAR	80
LINE7	Address line	LINES	CHAR	80
LINE8	Address line	LINES	CHAR	80
LINE9	Address line	LINES	CHAR	80
LINEK	Address line	LINES	CHAR	80
LINED	Address line	LINES	CHAR	80
LINED0	Address line	LINES	CHAR	80
PO_BOX_LOBBY	PO Box Lobby	AD_PO_BOX_LBY	CHAR	40
DELI_SERV_TYPE	Type of Delivery Service	AD_DELIVERY_SERVICE_TYPE	CHAR	4
DELI_SERV_NUMBER	Number of Delivery Service	AD_DELIVERY_SERVICE_NUMBER	CHAR	10
COUNTY	County	AD_COUNTY	CHAR	40
TOWNSHIP	Township	AD_TOWNSHIP	CHAR	40