ADR2
Telefonnummern (Business Address Services)
ADR2 is an SAP database table in S/4HANA. Telefonnummern (Business Address Services). It contains 18 fields. 24 CDS views read from this table.
CDS Views using this table (24)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /SAM4U/BTL_L_USER | view | left_outer | User | |
| /SCMTMS/VE_LocQuByPhysAdd | view_entity | left_outer | BOPF: Location Query By Physical Address | |
| CUAN_TG_TEAM_MEMBER_SEARCH | view | left_outer | AT_TG_TEAM_MEMBER_SEARCH | |
| cuan_user_search | view | left_outer | User Search | |
| 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_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 | Mobile Phone of Contacts |
| P_Bpcontacts_Telephone | view | from | BASIC | Telephone Number of Contacts |
| P_DDMRPController | view_entity | left_outer | BASIC | MRP Controller Details |
| P_MobileNumbers | view | from | BASIC | Mobile Numbers |
| P_TelephoneNumbers | view | from | BASIC | Telephone Numbers |
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 |