SAP Table ADR13

Pager (Business Address Services)

ADR13 (Pager (Business Address Services)) 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 ADR13 to other SAP tables.

Source: ADR13 (Pager (Business Address Services))

ADR13 table fields

Field Data element Checktable Datatype Length Decimals
CLIENT Client MANDT T000 CLNT 3 0
ADDRNUMBER Address number AD_ADDRNUM ADRC CHAR 10 0
PERSNUMBER Person number AD_PERSNUM ADRP CHAR 10 0
DATE_FROM Valid-from date - in current Release only 00010101 possible AD_DATE_FR DATS 8 0
CONSNUMBER Sequence Number AD_CONSNUM NUMC 3 0
COUNTRY Country for telephone/fax number AD_COMCTRY T005 CHAR 3 0
FLGDEFAULT Flag: this address is the default address AD_FLGDFAD CHAR 1 0
X Yes
NULL No
FLG_NOUSE Flag: This Communication Number is Not Used AD_FLNOUSE CHAR 1 0
X Yes
NULL No
HOME_FLAG Recipient address in this communication type (mail sys.grp) AD_FLGHOME CHAR 1 0
X Yes
NULL No
PAGER_SERV Pager Service AD_PAGSERV TSAPD CHAR 4 0
PAGER_NMBR Pager number AD_PAGNMBR CHAR 30 0
PAGER_LONG Normalized pager search field AD_PGNRLNG CHAR 30 0
PAGER_CALL Pager number for finding sender AD_PAGNRCL CHAR 30 0
DFT_RECEIV Encoded Reference to a Sequence Number AD_CONSREF CHAR 1 0
R3_USER Encoded Reference to a Sequence Number AD_CONSREF CHAR 1 0
VALID_FROM Communication Data: Valid From (YYYYMMDDHHMMSS) AD_VALFROM CHAR 14 0
VALID_TO Communication Data: Valid To (YYYYMMDDHHMMSS) AD_VALTO CHAR 14 0

ADR13 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
ADR13 ADDRNUMBER ADR13 CLIENT ADRC Addresses (Business Address Services) CLIENT
ADR13 ADDRNUMBER ADR13 ADDRNUMBER ADRC Addresses (Business Address Services) ADDRNUMBER
ADR13 ADDRNUMBER * ADRC Addresses (Business Address Services) DATE_FROM
ADR13 ADDRNUMBER * ADRC Addresses (Business Address Services) NATION
ADR13 CLIENT ADR13 CLIENT T000 Clients MANDT
ADR13 COUNTRY ADR13 CLIENT T005 Countries MANDT
ADR13 COUNTRY ADR13 COUNTRY T005 Countries LAND1
ADR13 PAGER_SERV ADR13 CLIENT TSAPD Pager Services (Business Address Services) CLIENT
ADR13 PAGER_SERV ADR13 PAGER_SERV TSAPD Pager Services (Business Address Services) PAGER_SERV
ADR13 PERSNUMBER ADR13 CLIENT ADRP Persons (Business Address Services) CLIENT
ADR13 PERSNUMBER ADR13 PERSNUMBER ADRP Persons (Business Address Services) PERSNUMBER
ADR13 PERSNUMBER * ADRP Persons (Business Address Services) DATE_FROM
ADR13 PERSNUMBER * ADRP Persons (Business Address Services) NATION