SAP table ADR13 (Pager (Business Address Services))
SAP table ADR13 has 5 primary key fields being CLIENT,ADDRNUMBER,PERSNUMBER,DATE_FROM,CONSNUMBER.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| CLIENT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| ADDRNUMBER | Address Number | CHAR | 10 | 0 | ADRC | AD_ADDRNUM | |
| PERSNUMBER | Person Number | CHAR | 10 | 0 | ADRP | AD_PERSNUM | |
| DATE_FROM | Valid-from date - in current Release only 00010101 possible | DATS | 8 | 0 | AD_DATE_FR | ||
| CONSNUMBER | Sequence Number | NUMC | 3 | 0 | AD_CONSNUM | ||
| COUNTRY | Country/Region for Telephone/Fax Number | CHAR | 3 | 0 | T005 | AD_COMCTRY | |
| FLGDEFAULT | Flag: this address is the default address | CHAR | 1 | 0 | AD_FLGDFAD | ||
| FLG_NOUSE | Flag: This Communication Number is Not Used | CHAR | 1 | 0 | AD_FLNOUSE | ||
| HOME_FLAG | Recipient address in this communication type (mail sys.grp) | CHAR | 1 | 0 | AD_FLGHOME | ||
| PAGER_SERV | Pager Service | CHAR | 4 | 0 | TSAPD | AD_PAGSERV | |
| PAGER_NMBR | Pager number | CHAR | 30 | 0 | AD_PAGNMBR | ||
| PAGER_LONG | Normalized pager search field | CHAR | 30 | 0 | AD_PGNRLNG | ||
| PAGER_CALL | Pager number for finding sender | CHAR | 30 | 0 | AD_PAGNRCL | ||
| DFT_RECEIV | Encoded Reference to a Sequence Number | CHAR | 1 | 0 | AD_CONSREF | ||
| R3_USER | Encoded Reference to a Sequence Number | CHAR | 1 | 0 | AD_CONSREF | ||
| VALID_FROM | Communication Data: Valid From (YYYYMMDDHHMMSS) | CHAR | 14 | 0 | AD_VALFROM | ||
| VALID_TO | Communication Data: Valid To (YYYYMMDDHHMMSS) | CHAR | 14 | 0 | AD_VALTO | ||
| _DATAAGING | Data Filter Value for Data Aging | DATS | 8 | 0 | DATA_TEMPERATURE |
ADR13 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 ADR13 | ADDRNUMBER | ADRC | Addresses (Business Address Services) | DATE_FROM |
| 0 ADR13 | ADDRNUMBER | ADRC | Addresses (Business Address Services) | NATION |
| 1 ADR13 | CLIENT | T000 | Clients | MANDT |
| 0 ADR13 | COUNTRY | T005 | Countries | MANDT |
| 0 ADR13 | COUNTRY | T005 | Countries | LAND1 |
| 1 ADR13 | PAGER_SERV | TSAPD | Pager Services (Business Address Services) | CLIENT |
| 1 ADR13 | PAGER_SERV | TSAPD | Pager Services (Business Address Services) | PAGER_SERV |
| 0 ADR13 | PERSNUMBER | ADRP | Persons (Business Address Services) | PERSNUMBER |
| 0 ADR13 | PERSNUMBER | ADRP | Persons (Business Address Services) | DATE_FROM |
| 0 ADR13 | PERSNUMBER | ADRP | Persons (Business Address Services) | NATION |