Telephone Numbers (Business Address Services) — the per-communication-type child of ADRC holding phone numbers for a given ADDRNUMBER, one of the sibling tables (with ADR3 fax, ADR6 e-mail) that ADRC's DEFLT_COMM/FLAGCOMM2 flags point at. SAP's real ADR2 carries all its fields; this definition carries the table complete, as it is a small check/detail table.
Hover a canonical name to see the legacy SAP field name
| Canonical name | Concept | Description | Data element | Type | Check table |
|---|---|---|---|---|---|
| CLI key | cliens | Client | MANDT | CLNT 3 | T000 |
| DML_NUM key | domicilium numerus | Address number | AD_ADDRNUM | CHAR 10 | ADRC |
| PSN_NUM key | persona numerus | Person number | AD_PERSNUM | CHAR 10 | ADRP |
| VLA_DIE_EMS key | validus ab dies emissio | Valid-from date - in current Release only 00010101 possible | AD_DATE_FR | DATS 8 | — |
| ORD_NUM key | ordo numerus | Sequence Number | AD_CONSNUM | NUMC 3 | — |
| PTR_TEL_NUM | patria telephonum numerus | Country for telephone/fax number | AD_COMCTRY | CHAR 3 | T005 |
| NRM_DML_GEN | norma domicilium genus | Standard Sender Address in this Communication Type | AD_FLGDFNR | CHAR 1 | — |
| SGN_NUM | signum numerus | Flag: This Communication Number is Not Used | AD_FLNOUSE | CHAR 1 | — |
| DML_GEN | domicilium genus | Recipient address in this communication type (mail sys.grp) | AD_FLGHOME | CHAR 1 | — |
| TEL_COD_NUM | telephonum codex numerus | Telephone no.: dialling code+number | AD_TLNMBR | CHAR 30 | — |
| TEL | telephonum | Telephone no.: Extension | AD_TLXTNS | CHAR 10 | — |
| NUM_COD | numerus codex | Complete number: dialling code+number+extension | AD_TELNRLG | CHAR 30 | — |
| TEL_NUM | telephonum numerus | Telephone number for determining caller | AD_TELNRCL | CHAR 30 | — |
| IDX_TEL | index telephonum | Indicator: Telephone is SMS-Enabled | AD_FLGSMS | CHAR 1 | — |
| IDX_TEL2 | index telephonum | Indicator: Telephone is a Mobile Telephone | AD_FLGMOB | CHAR 1 | — |
| VLA | validus ab | Communication Data: Valid From (YYYYMMDDHHMMSS) | AD_VALFROM | CHAR 14 | — |
| VLD | validus ad | Communication Data: Valid To (YYYYMMDDHHMMSS) | AD_VALTO | CHAR 14 | — |
Foreign keys
| Field | Check table | Check field |
|---|---|---|
CLIENT | T000 | MANDT |
ADDRNUMBER | ADRC | ADDRNUMBER |
PERSNUMBER | ADRP | PERSNUMBER |
COUNTRY | T005 | LAND1 |