CDS Views for Cross-Application HCM Objects in S/4HANA (CA-HR-S4)

CDS View NameDescriptionSQL View Name
C_EMPLOYMENTConsumption View EmploymentCEMPLOYMENT
C_EMPLOYMENTSEARCHOPEmployeesCEMPLYMNTSRCHOP
C_PERSNWRKAGRMTCTRLGFOROPGPerson Work Agreement Controlling Details for Object PageCPERSWKAGRMTCTRL
C_PERSNWRKAGRMTDETFOROPGPerson Work Agreement Details for Object PageCPERSWKAGRMTOBJ
C_PERSNWRKAGRMTFOROPGPerson Work Agreement Details for Object PageCPERSWKAGRMTMAIN
C_PERSNWRKAGRMTORGFOROPGPerson Work Agreement Organization Details for Object PageCPERSWKAGRMTORG
C_PERSNWRKAGRMTPROJFOROPGPerson Work Agreement Project Details for Object PageCPERSWKAGRMTPROJ
C_PERSNWRKAGRMTTAGFOROPGPerson Work Agreement Tag Details for Object PageCPERSWKAGRMTTAG
C_PERSONWORKAGRMTSRVCCOSTLEVELWork Agreement Service Cost Level for EmploymentCPERSWKAGRMTSCLV
C_WORKFORCEPERSONPAYTFOROPGWorkforce Person Payment Details for Object PageCWFPERSONPAYOPG
C_WRKORDFOROPGWork Order Details for Object PageCWRKORDDET
I_ACTIVEEMPLOYEEActive EmployeesIACTIVEEMPLOYEES
I_ACTIVEEMPLOYEEPERIODActive Employees in time periodIACTIVEMPPERIOD
I_BPROLETEXTBusinessPartner role textIBPROLETEXT
I_CONTINGENTWORKERContingent WorkerICONTWORKER
I_EMPFACTSHEET_CONTRINFOEmployee Factsheet CDS - Controlling InformationIEMPFSCI
I_EMPLHOMEADDRESSEmployee Home AddressIEMPLHOMEADDRESS
I_EMPLOYDETCLEmployment details for CloudIEMPLOYDETCL
I_EMPLOYDETOPEmployment details for OnPremiseIEMPLOYDETOP
I_EMPLOYEEEmployeeIEMPLOYEE
I_EMPLOYEEDETAILSEmployee DetailsIEMPLOYEEDETAILS
I_EMPLOYEEHOMEADDRESSEmployee Home AddressIEMPLHOMEADDRSS
I_EMPLOYEEHOMEADDRESSDETAILSEmployee Home Address DetailsIEMPLHOMEADDRD
I_EMPLOYEELINEMANAGEREmployee Line ManagerILINEMANAGER
I_EMPLOYEEOPEmployee CDS view for OPIEMPLOYEEOP
I_EMPLOYEEPAYMENTEmployee Payment InformationIEMPLOYEEPAYMENT
I_EMPLOYEEPOSITIONOPEmployee Position for OnPremiseIEMPPOSOP
I_EMPLOYEESHLPSearch Help for EmployeeIEMPLOYEESHLP
I_EMPLOYEESKILLTAGSEmployee Skill TagsIEMPLSKILLTGS
I_EMPLOYEETIMEOVERVIEWEmployee Time OverviewIEMPLTIMEOV
I_EMPLOYEEWORKPLACEADDRESSEmployee Workplace AddressIEMPLOYEEWPADDR
I_EMPLOYMENTEmploymentIEMPLOYMENT
I_EMPLOYMENTCOSTLEVELEmployment Service Cost LevelIEMPLOYCLEVEL
I_EMPLOYMENTDETAILSEmployment DetailsIEMPLOYMENTDET
I_EMPLOYMENTDETAILSCURRENTCurrent Employment DetailsIEMPLOYDETCUR
I_EMPLOYMENTDETAILSFORKEYDATEEmployment details for key dateIEMPLDETFORKDATE
I_EMPLOYMENTMANAGERManager related to EmploymentIEMPLOYMENTMGR
I_EMPLOYMENTMANAGERCLEmployment Manager for CloudIEMPLOYMENTMGRCL
I_EMPLOYMENTMANAGERFORKEYDATEEmployment ManagerIEMPLMGRFORKDATE
I_EMPLOYMENTMANAGEROPEmployment Manager for OnPremiseIEMPLMANAGEROP
I_EMPLOYMENTSEARCHOPEmployee SearchIEMPLYMNTSRCHOP
I_EMPLOYMENTSHLPSearch Help for Personnel Assignments of EmployeeIEMPLOYMENTSHLP
I_EMPLOYMENTSTATUSTEXTEmployment StatusIEMPLSTATTEXT
I_EMPLOYMTSOFEEEmployments of EmployeeIEMPLOYMTSOFEE
I_EMPLOYORGDETEmployment organization detailsIEMPLOYORGDET
I_EMPLOYORGDETCLEmployee OrgDetail for CloudIEMPLOYORGDETCL
I_EMPLOYORGDETOPEmployment org details for onPremiseIEMPLOYORGDETOP
I_EMPLOYSTATDETEmployment statusIEMPLOYSTATDET
I_EMPLOYWSDETEmployment working time detailsIEMPLOYWSDET
I_EMPLPARENTORGMANAGEROPEmployment Parent OrgUnit Manager for OnPremiseIEMPLPARORGMGROP
I_EMPLREPORTINGSTRUCTUREOPEmployment Reporting Structure for OnPremiseIEMPLREPSTROP
I_FAMILYNAMEPREFIXTEXTFamily Name Prefix TextIFAMNENAMPREFIXT
I_GENDERGenderIGENDER
I_GENDERTEXTGenderIGENDERTEXT
I_HRPERSWRKAGRMTInternal for HCM : Donot UseIHRPERSWRKAGRMT
I_HRRELATIONRead HRP1001 relation tableIHRRELATN
I_JOBTEXTJob textIJOBTEXT
I_JOBTEXTOPJob text for OnPremiseIJOBTEXTOP
I_ORGANIZATIONALUNITTEXTText Table for Organizational UnitsIORGUNITTXT
I_ORGUNITOrganizationalUnitIORGNUNIT
I_ORGUNITTEXTOrganizationUnit textIORGUNITTEXT
I_PERSNWRKAGRMTCTRLGFOROPGPerson Work Agreement Controlling Details for Object PageIPERSWKAGRMTCTRL
I_PERSNWRKAGRMTPLNDWRKGTMECPYWork Agreement Planned Working timeIPERWKAGRPLWTIM
I_PERSNWRKAGRMTROLEFOROPGPerson Work Agreement Role Details for Object PageIPERSWKAGRMTROLE
I_PERSNWRKAGRMTSRVCCOSTLVLCPYWork Agreement Service Cost LevelIPRWKAGRSVCSTL
I_PERSONFORMOFADDRESSForm of AddressIPFORMOFADDRESS
I_PERSONFORMOFADDRTForm of AddressIPFORMOFADDRT
I_PERSONWORKAGREEMENTRetrieve the work agreements of the PersonIPERSWKAGRMT
I_PERSONWORKAGREEMENTTYPEPerson Work Agreement TypeIPERSWKAGRTYPE
I_PERSONWORKAGREEMENT_1Person Work Agreement DetailsIPERSWKAGRMT1
I_PERSONWORKAGRMTFORKEYDATEPerson WorkAgreement Details for key dateIPERWKAGRKEYDATE
I_PERSONWORKAGRMTJOBTEXTPerson Work Agreement Job TextIPERWKAGRJBTXT
I_PERSONWORKAGRMTJOBTEXTCPYPerson Work Agreement Job TextIPERWRKAGRJBTX
I_PERSONWORKAGRMTORGLDETAILSPerson Work Agreement Organization DetailsIPERWKAGRORGDET
I_PERSONWORKAGRMTORGLDETSCPYPerson Work Agreement Organization DetailsIPERWKAGRORGDT
I_PERSONWORKAGRMTPLNDWRKGTIMEWork Agreement Planned Working timeIPERWKAGRPLWTIME
I_PERSONWORKAGRMTSRVCCOSTLEVELWork Agreement Service Cost LevelIPERWKAGRSVCSTL
I_PERSONWORKAGRMTSTATUSWork Agreement StatusIPERWKAGRSTATUS
I_PERSONWORKAGRMTSTATUSCPYWork Agreement StatusIPRWKAGRSTATUS
I_PERSONWORKAGRMTSTATUSTEXTPerson Work Agreement Status TextIPERWKAGRSTTXT
I_PERSONWORKAGRMTTOECIDInternal view to get the ECUS IDIPERWKAGRECID
I_PERSONWORKAGRMTTOEXTERNALIDMapping between Work agrrement internal and External IDsIPERWKAGREXT
I_PERSWRKAGRMTALLSRCHHELPSearch Help for all WorkAgreementsIPERSWKAGRASHLP
I_PERSWRKAGRMTMANAGERFORKEYDTERetrieve manager for given dateIPERSWRKAGRMTMGR
I_PERSWRKAGRMTMINFOROPGPerson Work Agreement Details for Object PageIPERSWKAGROBJ
I_PERSWRKAGRMTPOSDETPerson Work Agreement Details with PositionIPERSWRKAGRMTPOS
I_PERSWRKAGRMTPOSTOMGRPOSITIONRelation between position and manager positionIPOSTOMGRPOSTN
I_PERSWRKAGRMTSRCHHELPSearch Help for WorkAgreementsIPERSWKAGRMTSHLP
I_PERSWRKAGRMTSRCHHELP_1Search Help for WorkAgreementsIPERSWKAGRMTSHP1
I_PERSWRKAGRMTTOPARTNERInternal for HCM : Donot UseIPERSWRKAGRMTPT
I_SERVICEPERFORMERFORService PerformerISERVPERFORMER
I_SERVICEPERFORMERTOSUPLRService Performer to SupplierISERVPERFTOSUPP
I_WORKFORCEPERSONWorkforce Person DetailsIWFPERSON
I_WORKFORCEPERSONDETERMINEROLEWorkforce person current or future roleIWFPERSONDETROLE
I_WORKFORCEPERSONIMAGEURLWorkforce person Image URLIWFPERSIMG
I_WORKFORCEPERSONMINROLEWorkforce person minimum roleIWFPERSONMINROLE
I_WORKFORCEPERSONPASTMINROLEWorkforce person past minimum roleIWFPERSNPASTROLE
I_WORKFORCEPERSONPAYTWorkforce Person Payment Details for Object PageIWFPERSONPAYOPG
I_WORKFORCEPERSONSKILLTAGSWorkforce Person Skill TagsIWFPERSSKILLTAGS
I_WORKFORCEPERSONSRCHHELPSearch Help for Workforce PersonIWFPERSONSHLP
I_WORKFORCEPERSONVHWorkforce Person Association TargetIWFPERSONVH
P_ACTIVEEMPLOYEEActive EmployeePACTIVEEMPLOYEE
P_COSTLEVELTEXTCost level textPCOSTLEVELTXT
P_EMPCONSUMPTIONEmployee Consumption ViewPEMPCONSUMPTION
P_EMPDETAILSCURRENTPrivate view for Current Employment detailsPEMPDETCUR
P_EMPFACTSHEET_CONTRINFOEmployee Factsheet CDS - Controlling InformationPEMPFSCI
P_EMPFACTSHEET_EMPLOYEEEmployee Factsheet CDS - EmployeePEMPFSEMPLOYEE
P_EMPFACTSHEET_EMPLOYMENTSEmployee Factsheet CDS - EmploymentsPEMPFSEMPLOY
P_EMPFACTSHEET_MINPERNROPMain Employment with Active Status for Employee FactsheetPEMPFSMINPER
P_EMPFACTSHEET_PROJECTSEmployee Factsheet CDS - ProjectsPEMPFSPROJ
P_EMPFACTSHEET_TAGSEmployee Factsheet CDS - TagsPEMPFSTAG
P_EMPLOYEEALLATTRIBSEmployee All AttributesPEMPLOYEEALLATTR
P_EMPLOYEECLEmployee view for CloudPEMPLOYEECL
P_EMPLOYEEKEYMAPPINGEmployee Key MappingPEMPKEYMAPPING
P_EMPLOYEEOPEmployee view for OnPremisePEMPLOYEEOP
P_EMPLOYEEORGDETExtension of I_EMPLOYORGDETPEMPLOYEEORGDET
P_EMPLOYEESTATUSEmployment Status of EmployeePEMPLOYEESTATUS
P_EMPLOYEESYSOFRECORDEmployee System of RecordPEMPSYSOFRECORD
P_EMPLOYEEUNIONEmployee union viewPEMPLOYEEUNION
P_EMPLOYMENTCLEmployment view for CloudPEMPLOYMENTCL
P_EMPLOYMENTDETAILSCURRENTCurrent Employment Details with cost levelPEMPLOYDETCUR
P_EMPLOYMENTDETAILSUNIONEmployment details unionPEMPLOYDETUNION
P_EMPLOYMENTDETOPEmployment details OPPEMPLOYMNTDETOP
P_EMPLOYMENTKEYMAPPINGKeymapping for EmploymentsPEMPNTKEYMAPPING
P_EMPLOYMENTMANAGEREmployment ManagerPEMPLOYMENTMGR
P_EMPLOYMENTMANAGERUNIONEmployment ManagerPEMPLMGRUNION
P_EMPLOYMENTMINPERNRMinimum Active Employment InformationPEMPLMINPERNR
P_EMPLOYMENTMINPERNROPEmployment minimum Pernr for OnPremisePEMPLMINPERNROP
P_EMPLOYMENTMINPERNRSTOPMain Employment with Active StatusPEMPLMINPERSTOP
P_EMPLOYMENTOPEmployment for OnPremisePEMPLOYMENTOP
P_EMPLOYMENTUNIONEmployment unionPEMPLOYMENTUNION
P_EMPLOYMENT_ALL_INTERNALAll Employments , also logical deletedPEMPLOMENTALLINT
P_EMPLOYORGDETEmployment organization detailsPEMPLOYORGDET
P_EMPLOYSTATUSOPEmployee Status for OnPremisePEMPLOYSTATUSOP
P_EMPLOYSTDETCLEmployment status for CloudPEMPLOYSTDETCL
P_EMPLOYSTDETOPEmployment status detail view for OnPremisePEMPLOYSTDETOP
P_EMPLPRIVCOMMDATAEmployee Private Communication DataPEMPLPRVCOMMDATA
P_EMPLPRIVPOSTADDREmployee Postal AddressPEMPLPRVPOSTADDR
P_EMPPROJECTSProjects of an EmployeePEMPPROJECTS
P_EMPSTATUSUNIONEmployee Status UnionPEMPSTATUSUNION
P_ETDETAILSOFEEEmployment Details of EmployeePETDETAILSOFEE
P_EXTERNALEMPLOYMENTKEYMAPPINGExternal Employment Key MappingPEXTEMPNTKEYMAP
P_MAINETMGRMain Employment ManagerPMAINETMGR
P_PDOBJECTPD ObjectPPDOBJECT
P_PDOBJECTRELATIONPD Object with relationPDOBJECTRELATION
P_PDRELATIONPD RelationPPDRELATION
P_PHOTOURLMINPERNRMin PERNR in Photo URL tablePPHOTOMINPERNR
P_SERVICECOSTLEVELCost rate levelPSERVICECOSTLVL
P_TODAYDATEToday DatePTODAYDATE
P_WFPERSONIDENTIFICATIONPersonnel Identification NumberPPERSONID

Other CDS Views