ADR6
E-Mail Addresses (Business Address Services)
ADR6 is an SAP database table in S/4HANA. E-Mail Addresses (Business Address Services). It contains 17 fields. 24 CDS views read from this table.
CDS Views using this table (24)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| Fclm_Bm_Address | view | left_outer | Address data for bank master and business partner | |
| fiscds_adr6_email | view | from | User Email Data | |
| FNDEI_ADR6_BLOCKINGINFO | view | from | Blocking View for table ADR6 | |
| fndei_adr6_filter | view | from | Filter View for table ADR6 | |
| I_AddressEmailAddress | view | from | BASIC | Email Address |
| I_AddressEmailAddress_2 | view_entity | from | BASIC | Email Address |
| I_Addressindependentemail | view | from | BASIC | Core view Addr Indep Email |
| I_BPCntctPersnEmailAddrGov | view_entity | inner | TRANSACTIONAL | Base Union WplcAddr Email |
| I_MRPControllerEmail | view | left_outer | BASIC | MRP Controller Email Address |
| I_PrmtHbCreatorContactCard | view | inner | BASIC | Creator Data for Contact Card |
| I_PrmtHbSupplierContactCard | view | inner | BASIC | Supplier Data for Contact Card |
| I_SADL_GW_CPLUSER | view | inner | User details in system | |
| 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_BPUsrEEWASmtpSrch | view | inner | BASIC | Business User Workplace Address Smtp Srch |
| P_BPUsrEEWASmtpSrchInitial | view | left_outer | BASIC | Business User Workplace Address SmtpSrch Initial |
| P_BPUsrEEWASmtpSrchNonUniSub | view | from | BASIC | Business User Workplace Address SmtpSrch NonUnique Subview |
| P_DDMRPController | view | left_outer | BASIC | |
| P_FrcElmntOrgEmailAddress | view | from | BASIC | |
| TSI_CONTACT_entry | view | left_outer | ||
| VFCP_DDL_BCM | view | left_outer |
Fields (17)
| 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 | |
| flgdefault | AD_FLGDFAD | ||
| flg_nouse | AD_FLNOUSE | ||
| home_flag | AD_FLGHOME | ||
| smtp_addr | AD_SMTPADR | ||
| smtp_srch | AD_SMTPAD2 | ||
| dft_receiv | AD_DFTRCAD | ||
| r3_user | AD_R3_USER | ||
| encode | AD_ENCODE | ||
| tnef | AD_TNEF6 | ||
| valid_from | AD_VALFROM | ||
| valid_to | AD_VALTO | ||
| _dataaging | DATA_TEMPERATURE |