CDS Views for ADRC table
Overview
ADRC is a standard SAP S/4HANA table that stores Addresses (Business Address Services) data. The following is a list of CDS Views for ADRC 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.
ADRC CDS Views
The following table gives you an overview of the released standard CDS views for ADRC table in S/4HANA 2020.
| CDS View Name | SQL View Name | Description |
|---|---|---|
| C_BPUSRRELSHPBPORGVH | CBPUSRELBPORGVH | Business User - Value Help for Company Relationship |
| C_PURDOCLISTSUPPADDR | CDOCLSUPADDR | Supplier Address |
| CRMS4_IU_P_ADDRESS | CRMS4VIUPADDRESS | I_Address + additional fields from ADRC |
| ESH_N_COMPANY_ADDRESS_ADDRESS | ESH_L_COMPA_RESS | Node COMPANY_ADDRESS of search model COMPANY_ADDRESS_H |
| FAC_AUDIT_Z3_TAX_GROUP | FAC_AUDTAXGRP | Tax Group |
| FNDEI_ADRC_BLOCKINGINFO | FNDEIBADRC | Filter View for table ADRC |
| FNDEI_ADRC_FILTER | FNDEIFADRC | Filter View for table ADRC |
| I_ADDRESS | IADDRESS | Address |
| I_ADDRESSCONTACTCARD | IADDRESSCC | Address Contact Card |
| 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_LCMUSERADDRESS | ILCMUSERADDRESS | Address |
| I_OILBUSINESSLOCATION | IOILBUSLOC | TSW Business Location |
| I_PMCONTACTCARDUSER | IPMCONTACTCARD | Contact Card User |
| I_SCRIPTEDADDRESS | ISCRPTEDADDR | Interational Address Version |
| I_SCRIPTEDORGANIZATIONADDRESS | ISCRPTORGADDR | Interational Address Version |
| I_SCRIPTEDPERSONADDRESS | ISCRPTPRSNADDR | Interational Address Version for Persons |
| I_TRDGCONTRPARTADDRESSDETS | ITCPARTADDET | Interface view for Trading Contract Partner Address details |
| I_VISUALLOCATIONS | IVISUALLOC | Location Master Data |
| I_VISUALNOMINATIONS | IVISUALNOM | Visual Nominations |
| I_VISUALSIMULATION | IVISUSIM | IPW Simulation in Visualization |
| P_CN_CADEADDRESSID | PCADEADDRID | CADE Fetch max address ID for BP |
| P_CN_CADEORGANIZATIONNAME | PCADEORGNAME | CADE Organization Name |
| P_CONTACTCARDPERSON | PCONTACTCARDPERS | ContactCard of Person (Address) |
| P_EMPLPRIVPOSTADDR | PEMPLPRVPOSTADDR | Employee Postal Address |
| P_FRCELMNTORGBUSINESSADDRESS | PFEORGBUSADDR | Basic Private View for Force Element Org Business Address |
| P_KR_BUSINESSPLACE | PKRBUPLA | KR ACR: Business Place Information temp view |
| P_NZ_HEADERDATA | PNZHEADDATA | Header data integration with master data |
| P_ORGANIZATIONADDRESS | PORGADDR | Address Info |
| P_ORGANIZATIONADDRESSCONSUM | PORGADDRCONS | Address Info |
| P_USERADDRESS002 | PUSADDR002 | User Address for All Users Including Business Partner |
| P_USER002 | PUSER002 | User Address for All Users Including Business Partner |
| P_USER_ADDR | PUSER_ADDR | F4 Search Help for Users |
| SHSM_M_EKUNP | SHSMMEKUNP | Business Partner by Postal Code Search Help |
| SHSM_V_BUT020 | SHSMVBUT020 | Substitute for V_BUT020 in Search Help |
| SHSM_V_BUT020_I | SHSMVBUT020I | Substitute for V_BUT020_I |
| UPO_INT_V_DN_UOM | UPOS_PR_DN_UOM | Delivery Network(UOM) |
| UPO_INT_V_MP_UOM | UPOS_PR_MP_UOM | Measurement Point (UOM) |
| UPO_INT_V_WC_UOM | UPOS_PR_WC_UOM | UOM : Well completion |
| FCLM_BM_ADCP | VFCLM_BM_ADCP | Linkage for adcp and adrc |
| FCLM_BM_ADDRESS | VFCLM_BM_ADDRESS | Address data for bank master and business partner |
| V_SD_CI_ITEM_PARTY | V_SD_ITEM_PARTY | Customer Invoice Item Party |
| V_SD_CI_PARTY | V_SD_PARTY | Party information of Customer Invoices |
| V_TSI_CONTACT_DDL | V_TSI_CONTACT | My Vendor Invoices: Contact |