back to top

SAP ADR12 Table – FTP and URL (Business Address Services)

The ADR12 table in SAP ERP or S/4HANA stores FTP and URL (Business Address Services) data. There are total 14 fields in ADR12 table. The FTP and URL (Business Address Services) table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of ADR12 table. It is in SAP Technology – Business Services: Address Management (SZAD) ABAP package and is part of the Address Management/Business Address (BC-SRV-ADR) module.

SAP ADR12 Table Fields

Following is the list of fields that are available in SAP ADR12 table. The primary key fields of the table are CLIENT (Client), ADDRNUMBER (Address Number), PERSNUMBER (Person Number), DATE_FROM (Valid-from date – in current Release only 00010101 possible), CONSNUMBER (Sequence Number).

Field Description Data Element Check Table Data Type
CLIENT Client MANDT T000 CLNT (3)
ADDRNUMBER Address Number AD_ADDRNUM ADRC CHAR (10)
PERSNUMBER Person Number AD_PERSNUM ADRP CHAR (10)
DATE_FROM Valid-from date – in current Release only 00010101 possible AD_DATE_FR DATS (8)
CONSNUMBER Sequence Number AD_CONSNUM NUMC (3)
FLGDEFAULT Flag: this address is the default address AD_FLGDFAD CHAR (1)
FLG_NOUSE Flag: This Communication Number is Not Used AD_FLNOUSE CHAR (1)
HOME_FLAG Recipient address in this communication type (mail sys.grp) AD_FLGHOME CHAR (1)
URI_TYPE URI type flag AD_URITYPE CHAR (3)
URI_SRCH URI address search field AD_URI2 CHAR (50)
DFT_RECEIV Flag: Recipient is standard recipient for this address AD_DFTRCAD CHAR (1)
_DATAAGING Data Filter Value for Data Aging DATA_TEMPERATURE DATS (8)
URI_LENGTH URI field length AD_URILNG INT2 (5)
URI_ADDR Universal Resource Identifier (URI) AD_URI LCHR (2048)