ADR6
E-Mail-Adressen (Business Address Services)
ADR6 is an SAP database table in S/4HANA. E-Mail-Adressen (Business Address Services). It contains 17 fields. 25 CDS views read from this table.
CDS Views using this table (25)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| /SAM4U/BTL_L_USER | view | left_outer | User | |
| 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 |