CDS Views for ADRP table

Overview

ADRP is a standard SAP S/4HANA table that stores Persons (Business Address Services) data. The following is a list of CDS Views for ADRP 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.

ADRP CDS Views

The following table gives you an overview of the released standard CDS views for ADRP table in S/4HANA 2020.

CDS View NameSQL View NameDescription
M_V_M2S_PD_ITMCDS_M_M2S_PD_ITMME2STAR: Purchasing Document Item
M_V_M2S_PR_ITMCDS_M_M2S_PR_ITMME2STAR: CDS View for Purchase Requisition
P_SAPOFFICEUSERSEARCHESD_ADCPOCDSP_SapOfficeUserSearch
ESH_LIMITATIONS_DISTINCTESHDISTINCTSView with select distinct
ESH_LIMITATIONS_GRPBYESHGRPBYView with group by
ESH_N_USER_USER_NAMEESH_L_USER_NAMENode USER_NAME of search model USER_H
FACVD_CLRIT_05FACV_CLRIT_05Open items of incoming payment for manual clearing
FACVD_CLRIT_06FACV_CLRIT_06Open items of outgoing payment for manual clearing
FISVD_ADRP_OFFICEFISV_ADRPOffice Data of an User
FISVD_BKPF_USRFISV_BKPF_USRDocument Header
FIS_CDS_USERFIS_SQL_USERUser Data for User Name
I_BUSPARTPERSONFULLNAMEIBPPERSONADDRPerson data of business partner
I_INTERCOMPANYEMAILTMPLICAICOETMPLICA Intercompany Email Template
I_CMMDTYDRVTVORDERUSERDETAILSICMMDTYUSRDETBasic View for User Details
I_CONTACTPERSONICONTACTPERSONCustomer contact person data
I_DOCUMENTINFORECORDUSERVHICVDOCUSRVHDocument Info Record User Value Help
I_DFS_MAINTUSERDETAILSBASICIDFSUSERDETLUser Details Basic View
I_GHOUSERNAMEIGHOUSERNAMEUser Resp for Chg Log of Prodn Ntwk Link
I_LCMPERSONILCMPERSONPerson
I_MPATTACHMENTIMPATTACHMENTMaster Project Attachment
I_NOMINATIONSCHEDULEUSERTEXTINOMSCHEDUSERTTrip created by user value help
I_PMCONTACTCARDUSERIPMCONTACTCARDContact Card User
I_SCRIPTEDADDRESSISCRPTEDADDRInterational Address Version
I_SCRIPTEDPERSONADDRESSISCRPTPRSNADDRInterational Address Version for Persons
I_USERCONTACTCARDIUSERCTCUser Contact Card
I_ACMCONTRACTUSERTRADERIDIUSERTRDRIDGet Contract User Trader Id
I_SADL_GW_CPLUSERIV_SADL_CPLUSERUser details in system
P_BCMITEMPBCMITEMAnalyze Payment Detail BCM Item
P_BPUSRPERSONPBPUPERSONBusiness Partner of Type Person - BUM
P_BPUSRASSIGNMENTPBPUSRASSIGNBusiness User - User Assignment
P_USERCONTACTCARD_FSPCONTACTCARDFSPrivate Factsheet - User Name
P_CONTACTCARDPERSONPCONTACTCARDPERSContactCard of Person (Address)
P_DDMRPCONTROLLERPDDMRPCONTMRP Controller Details
P_ON_DEMAND_PRICE_ORDERPONDEMANDPRCODRFetch Price Details for tracking number of hits
P_PERSONADDRESSPPERSONADDRAddress Info for Person
P_CN_CADEPERSONNAMEPPERSONNAMEPerson Name
P_REASON_CODE_TRACEPREASONCODETRACEFetching and Process of Reason Code Tracing
P_USERADDRESS002PUSADDR002User Address for All Users Including Business Partner
P_USER002PUSER002User Address for All Users Including Business Partner
P_USER_INFOPUSERINFOInteface view for user information
P_USER_ADDRPUSER_ADDRF4 Search Help for Users
RV_P_USERRVPUSERUser
SHSM_USR21SHSUSR21CDS View Checkbook purchase by value help
FCLM_BAM_BPUSERNAMEVFCLMBPUSERNMUser name for Business Partner
FCLM_BAM_USERNAMEVFCLMUSERNMVWUser full name view
FCLM_CP_BCMVFCP_BCMBCM Detail Information
FCLM_CP_FIVFCP_FIPayment Details Document Number
FCLM_CP_MEMOVFCP_MEMOPayment Details Memo Record
FCLM_CP_MEMO_BASEVFCP_MEMO_BASEMemo Record
FCLM_CP_TRMVFCP_TRMPayment Details TRM
V_TSI_CONTACT_DDLV_TSI_CONTACTMy Vendor Invoices: Contact