SAP Table ADR13S
Shadow Table: Pager (Business Address Services)
ADR13S (Shadow Table: 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 ADR13S to other SAP tables.
ADR13S table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CLIENT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| TRKORR | Request/Task | TRKORR | CHAR | 20 | 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 |
Possible values
|
||||||
| FLG_NOUSE | Flag: This Communication Number is Not Used | AD_FLNOUSE | CHAR | 1 | 0 |
Possible values
|
||||||
| HOME_FLAG | Recipient address in this communication type (mail sys.grp) | AD_FLGHOME | CHAR | 1 | 0 |
Possible values
|
||||||
| 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 | |||||||
ADR13S foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| ADR13S | ADDRNUMBER | ADR13S | CLIENT | ADRC | Addresses (Business Address Services) | CLIENT |
| ADR13S | ADDRNUMBER | ADR13S | ADDRNUMBER | ADRC | Addresses (Business Address Services) | ADDRNUMBER |
| ADR13S | ADDRNUMBER | * | ADRC | Addresses (Business Address Services) | DATE_FROM | |
| ADR13S | ADDRNUMBER | * | ADRC | Addresses (Business Address Services) | NATION | |
| ADR13S | CLIENT | ADR13S | CLIENT | T000 | Clients | MANDT |
| ADR13S | COUNTRY | ADR13S | COUNTRY | T005 | Countries | LAND1 |
| ADR13S | COUNTRY | ADR13S | CLIENT | T005 | Countries | MANDT |
| ADR13S | PAGER_SERV | ADR13S | CLIENT | TSAPD | Pager Services (Business Address Services) | CLIENT |
| ADR13S | PAGER_SERV | ADR13S | PAGER_SERV | TSAPD | Pager Services (Business Address Services) | PAGER_SERV |
| ADR13S | PERSNUMBER | ADR13S | CLIENT | ADRP | Persons (Business Address Services) | CLIENT |
| ADR13S | PERSNUMBER | ADR13S | PERSNUMBER | ADRP | Persons (Business Address Services) | PERSNUMBER |
| ADR13S | PERSNUMBER | * | ADRP | Persons (Business Address Services) | DATE_FROM | |
| ADR13S | PERSNUMBER | * | ADRP | Persons (Business Address Services) | NATION | |
