CDS Views for ADR2 table
Overview
ADR2 is a standard SAP S/4HANA table that stores Telephone Numbers (Business Address Services) data. The following is a list of CDS Views for ADR2 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.
ADR2 CDS Views
The following table gives you an overview of the released standard CDS views for ADR2 table in S/4HANA 2020.
| CDS View Name | SQL View Name | Description |
|---|---|---|
| FISVD_ADR2_MPHONE | FISV_ADR2_MPHONE | Default Mobile Phone Number in different languages |
| FISVD_ADR2_PHONE | FISV_ADR2_PHONE | Defaultnumbers in different languages |
| FNDEI_ADR2_BLOCKINGINFO | FNDEIBADR2 | Filter View for table ADR2 |
| FNDEI_ADR2_FILTER | FNDEIFADR2 | Filter View for table ADR2 |
| I_ADDRESSCONTACTCARD | IADDRESSCC | Address Contact Card |
| I_ADDRESSINDEPENDENTMOBILE | IADDRINDMOB | Core View Addr Indp Mobile |
| I_ADDRESSINDEPENDENTPHONE | IADDRINDPHONE | Core view for address independent phone details |
| I_ADDRESSPHONENUMBER | IADDRPHONENUMBER | Address Phone Number |
| 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_SUPLRCONTACTCARD | ISUPLRCC | Supplier Contact Card |
| I_USERCONTACTCARD | IUSERCTC | User Contact Card |
| P_CONTACTCARDPERSON | PCONTACTCARDPERS | ContactCard of Person (Address) |
| P_EMPLPRIVCOMMDATA | PEMPLPRVCOMMDATA | Employee Private Communication Data |
| P_FRCELMNTORGADDRPHONENUMBER | PFEORGADDRPHNUM | Basic Private View for Force Element Org Addr Phone Number |
| P_MOBILENUMBERS | PMOBILENUMBERS | Mobile Numbers |
| P_TELEPHONENUMBERS | PTELNUMBERS | Telephone Numbers |
| P_BPCONTACTS_MOBILEPHONE | P_MD_BPC_MTEL | Mobile Phone of Contacts |
| P_BPCONTACTS_TELEPHONE | P_MD_BPC_TEL | Telephone Number of Contacts |
| FCLM_BM_ADDRESS | VFCLM_BM_ADDRESS | Address data for bank master and business partner |