CDS Views for ADR6 table
Overview
ADR6 is a standard SAP S/4HANA table that stores E-Mail Addresses (Business Address Services) data. The following is a list of CDS Views for ADR6 table.
A CDS view is a CDS entity that implements a view and is defined in a CDS data definition. They are defined for existing database tables, views, or other non-abstract CDS entities.
Using CDS views, you can rearrange and rename table fields to meet application-specific requirements. They are used to define rich semantic data models.
ADR6 CDS Views
The following table gives you an overview of the released standard CDS views for ADR6 table in S/4HANA 2020.
| CDS View Name | SQL View Name | Description |
|---|---|---|
| FISVD_ADR6_EMAIL | FISV_ADR6_EMAIL | Default Email Address in different languages |
| FNDEI_ADR6_BLOCKINGINFO | FNDEIBADR6 | Blocking View for table ADR6 |
| FNDEI_ADR6_FILTER | FNDEIFADR6 | Filter View for table ADR6 |
| I_ADDRESSEMAILADDRESS | IADDREMAILADDR | Email Address |
| I_ADDRESSCONTACTCARD | IADDRESSCC | Address Contact Card |
| I_ADDRESSINDEPENDENTEMAIL | IADDRINDEMAIL | Core view Addr Indep Email |
| I_CMMDTYDRVTVORDERUSERDETAILS | ICMMDTYUSRDET | Basic View for User Details |
| ICM_BP_ADDRESS_INDEPENDENT | ICM_BP_ADDRINDP | Business Partner (Address-Independent) |
| ICM_EMPLOYEE | ICM_EMPLOYEE | Duplicate check for employee |
| ICM_PARTNER_CONTACT | ICM_PARTNER_CONT | Duplicate check for BP-contact |
| ICM_PARTNER_ORGANIZATION | ICM_PARTNER_ORG | Duplicate check for BP-organization |
| ICM_PARTNER_PERSON | ICM_PARTNER_PERS | Duplicate check for BP-person |
| I_WORKPLACEADDRESS | IEMPWPADDR | Employee Workplace Address |
| I_MRPCONTROLLEREMAIL | IMRPCONTEMAIL | MRP Controller Email Address |
| I_PMCONTACTCARDUSER | IPMCONTACTCARD | Contact Card User |
| I_SUPLRCONTACTCARD | ISUPLRCC | Supplier Contact Card |
| I_USERCONTACTCARD | IUSERCTC | User Contact Card |
| I_SADL_GW_CPLUSER | IV_SADL_CPLUSER | User details in system |
| P_BCMITEM | PBCMITEM | Analyze Payment Detail BCM Item |
| P_BPUSREEWASMTPSRCHNONUNISUB | PBPUEEWASMTPNUS | Business User Workplace Address SmtpSrch NonUnique Subview |
| P_BPUSREEWASMTPSRCH | PBPUEEWASMTPSRCH | Business User Workplace Address Smtp Srch |
| P_BPUSRASSIGNMENT | PBPUSRASSIGN | Business User - User Assignment |
| P_CONTACTCARDPERSON | PCONTACTCARDPERS | ContactCard of Person (Address) |
| P_DDMRPCONTROLLER | PDDMRPCONT | MRP Controller Details |
| P_EMPLPRIVCOMMDATA | PEMPLPRVCOMMDATA | Employee Private Communication Data |
| P_FRCELMNTORGEMAILADDRESS | PFEORGEMAILADDR | Basic Private View for Force Element Org Email Address |
| P_USERADDRESS002 | PUSADDR002 | User Address for All Users Including Business Partner |
| P_USER002 | PUSER002 | User Address for All Users Including Business Partner |
| P_BPCONTACTS_ADDRESS | P_MD_BPC_ADR | Address Data of BP Contacts |
| FCLM_BM_ADDRESS | VFCLM_BM_ADDRESS | Address data for bank master and business partner |
| FCLM_CP_BCM | VFCP_BCM | BCM Detail Information |
| V_TSI_CONTACT_DDL | V_TSI_CONTACT | My Vendor Invoices: Contact |