ADR2
Telephone Numbers (Business Address Services)
ADR2 is an SAP database table in S/4HANA. Telephone Numbers (Business Address Services). It contains 18 fields. 23 CDS views read from this table.
CDS Views using this table (23)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /SCMTMS/CV_LocQuByPhysAdd | view | left_outer | Helper View for Query By Phys. Address | |
| Fclm_Bm_Address | view | left_outer | Address data for bank master and business partner | |
| fiscds_adr2_mphone | view | inner | User Mobile Phone Numbers | |
| fiscds_adr2_phone | view | inner | User Phone Numbers | |
| FNDEI_ADR2_BLOCKINGINFO | view | from | Filter View for table ADR2 | |
| fndei_adr2_filter | view | from | Filter View for table ADR2 | |
| I_AddressPhoneNumber | view | from | BASIC | Address Phone Number |
| I_AddressPhoneNumber_2 | view_entity | from | BASIC | Phone Number |
| I_BPContactPersonMblNumberGov | view_entity | inner | TRANSACTIONAL | Base Union for Workplace Mbl Number |
| I_BPContactPersonTelNumberGov | view_entity | inner | TRANSACTIONAL | Base Union for Workplace Tel Number |
| I_PrmtHbCreatorContactCard | view | inner | BASIC | Creator Data for Contact Card |
| I_PrmtHbSupplierContactCard | view | inner | BASIC | Supplier Data for Contact Card |
| ICM_BP_ADDR_INDP | view | left_outer | BusinessPartner_Address_Indep | |
| ICM_EMPLOYEE_CONTACT | view | left_outer | Employee | |
| ICM_PARTNER_CONTACT | view | left_outer | BusinessPartner_contact | |
| ICM_PARTNER_ORGANIZATION | view | left_outer | BusinessPartner_Organization | |
| ICM_PARTNER_PERSON | view | left_outer | BusinessPartner_person | |
| P_Bpcontacts_Mobilephone | view | from | BASIC | |
| P_Bpcontacts_Telephone | view | from | BASIC | |
| P_DDMRPController | view | left_outer | BASIC | |
| P_FrcElmntOrgAddrPhoneNumber | view | from | BASIC | |
| P_MobileNumbers | view | from | BASIC | |
| P_TelephoneNumbers | view | from | BASIC |
Fields (18)
| Key | Field | Data Element | Description |
|---|---|---|---|
| KEY | client | MANDT | |
| KEY | addrnumber | AD_ADDRNUM | |
| KEY | persnumber | AD_PERSNUM | |
| KEY | date_from | AD_DATE_FR | |
| KEY | consnumber | AD_CONSNUM | |
| country | AD_COMCTRY | ||
| flgdefault | AD_FLGDFNR | ||
| flg_nouse | AD_FLNOUSE | ||
| home_flag | AD_FLGHOME | ||
| tel_number | AD_TLNMBR | ||
| tel_extens | AD_TLXTNS | ||
| telnr_long | AD_TELNRLG | ||
| telnr_call | AD_TELNRCL | ||
| dft_receiv | AD_FLGSMS | ||
| r3_user | AD_FLGMOB | ||
| valid_from | AD_VALFROM | ||
| valid_to | AD_VALTO | ||
| _dataaging | DATA_TEMPERATURE |