CDS Views for Business Logic in Workforce Domain (CA-WFD-BL)

CDS View NameDescriptionSQL View Name
C_ASSIGNMENTSEARCHWorkforce Assignment SearchCASSIGNMENTSRCH
ESH_N_ASSGMTSRCHAnchor view -ASSGMTSRCHESH_L_ASSGMTSRCH
ESH_S_ASSGMTSRCHSearch view -ASSGMTSRCHESH_U_ASSGMTSRCH
E_WORKFORCEASSIGNMENTExtended view for workforce assignment detailsEWORKFORCEASGMNT
E_WORKFORCEASSIGNMENTDETAILSExtended view for workforce assignment detailsEWRKFORCEASGMTDT
I_ASSIGNMENTSEARCHWorkforce SearchIASSIGNMENTSRCH
I_WORKERSEARCHWorkforce CDS view for OPIWORKERSEARCH
I_WORKFORCEASSGMTSTATUSTEXTWorkforce assignment status textIWRKASGMTSTATXT
I_WORKFORCEASSIGNMENTWorkforce AssignmentIWORKFORCEASSGMT
I_WORKFORCEASSIGNMENTDETAILSWorkforce Assignment DetailsIWRKFCASSGMTDETS
I_WORKFORCEASSIGNMENTSTATUSWorkforce Assignment StatusIWFASSGMSTATUS
N_PERSONWORKAGREEMENT_1aux viewNPERSWKAGRMT1
P_EMPLOYEELINEMANAGEREmployee Line ManagerPLINEMANAGER
P_EMPLOYEEPOSITIONOPEmployee Position for OnPremisePEMPPOSOP
P_EMPLOYMENTMANAGEROPEmployment Manager for OnPremisePEMPLMANAGEROP
P_EMPLOYMENTMINPERNRSTOP_001Main Employment with Active StatusPEMPLMINPERSTOP1
P_EMPLOYMENTOP_001Employment for OnPremisePEMPLOYMENTOP001
P_EMPLOYORGDETOPEmployment org details for onPremisePEMPLOYORGDETOP
P_EMPLOYSTATDETEmployment statusPEMPLOYSTATDET
P_EMPLOYWSDETEmployment working time detailsPEMPLOYWSDET
P_EMPLREPORTINGSTRUCTUREOPEmployment Reporting Structure for OnPremisePEMPLREPSTROP
P_HRPERSWRKAGRMTInternal to HCM : Donot usePHRPERSWRKAGRMT
P_HRRELATIONRead HRP1001 relation table and wfd_d_keymap tablePHRRELATN
P_HRRELATION_CP_PRead HRP1001 relation table and wfd_d_keymap tablePHRRELATNCPP
P_HRRELATION_P_CPRead HRP1001 relation table and wfd_d_keymap tablePHRRELATNPCP
P_J_PDOBJECTPD ObjectPJPDOBJECT
P_N_EMPLOYDETOPEmployment details for OnPremisePNEMPLOYDETOP
P_N_EMPLOYEEEmployeePNEMPLOYE
P_N_EMPLOYEEOPEmployee view for OnPremisePNEMPLOYEEOP
P_N_EMPLOYMENTEmploymentPNEMPLOYMENT
P_N_EMPLOYMENTCOSTLEVELEmployment Service Cost LevelPNEMPLOYCLEVEL
P_N_EMPLOYMENTMANAGERManager related to EmploymentPNEMPLOYMENTMGR
P_N_EMPLOYMENTMGRFORKEYDATEEmployment ManagerPNEMPLMGRFORKDAT
P_N_EMPLOYMENTMINPERNRMain EmploymentPNEMPLMINPERNR
P_N_EMPLOYORGDETOPEmployment org details for onPremisePNEMPLOYORGDETOP
P_N_EMPLOYSTATDETEmployment statusPNEMPLOYSTATDET
P_N_EMPLOYWSDETEmployment working time detailsPNEMPLOYWSDET
P_N_HRPERSWRKAGRMTInternal for HCM : Donot UsePNHRPERSWRKAGRMT
P_N_PERSONWORKAGREEMENTRetrieve the work agreements of the PersonPNPERSWKAGRMT
P_N_PERSONWORKAGREEMENT_1Person Work Agreement DetailsPNPERSWKAGRMT1
P_N_PERSWRKAGRMTMGRFORKEYDTERetrieve manager for given datePNPERWRKAGRMTMGR
P_N_PERSWRKAGRMTPOSDETPerson Work Agreement Details with PositionPNPERSWRKAGRMTPS
P_N_PERSWRKAGRMTTOPARTNERInternal for HCM : Donot UsePNPERSWRKAGRMTPT
P_O_EMPLOYDETOPEmployment details for OnPremisePOEMPLOYDETOP
P_O_EMPLOYEEEmployeePOEMPLOYE
P_O_EMPLOYEEOPEmployee view for OnPremisePOEMPLOYEEOP
P_O_EMPLOYMENTEmployment OldPOEMPLOYMENT
P_O_EMPLOYMENTCOSTLEVELEmployment Service Cost LevelPOEMPLOYCLEVEL
P_O_EMPLOYMENTMANAGERManager related to EmploymentPOEMPLOYMENTMGR
P_O_EMPLOYMENTMGRFORKEYDATEEmployment ManagerPOEMPLMGRFORKDAT
P_O_EMPLOYORGDETOPEmployment org details for onPremisePOEMPLOYORGDETOP
P_O_EMPLOYSTATDETEmployment statusPOEMPLOYSTATDET
P_O_EMPLOYWSDETEmployment working time detailsPOEMPLOYWSDET
P_O_HRPERSWRKAGRMTInternal for HCM, search view N_PERSONWORKAGREEMENT_1POHRPERSWRKAGRMT
P_O_PERSONWORKAGREEMENTRetrieve the work agreements of the PersonPOPERSWKAGRMT
P_O_PERSONWORKAGREEMENT_1Person Work Agreement DetailsPOPERSWKAGRMT1
P_O_PERSWRKAGRMTMGRFORKEYDTERetrieve manager for given datePOPERWRKAGRMTMGR
P_O_PERSWRKAGRMTPOSDETPerson Work Agreement Details with PositionPOPERSWRKAGRMTPS
P_O_PERSWRKAGRMTTOPARTNERInternal for HCM, search view N_PERSONWORKAGREEMENT_1POPERSWRKAGRMTPT
P_PDOBJECT_001PD ObjectPPDOBJECT001
P_PDRELATION_001PD RelationPPDRELATION001
P_PERSNWRKAGRMTCTRLGFOROPGPerson Work Agreement Controlling Details for Object PagePPERSWKAGRMTCTRL
P_PERSNWRKAGRMTROLEFOROPGPerson Work Agreement Role Details for Object PagePPERSWKAGRMTROLE
P_PERSONWORKAGREEMENTTYPEPerson Work Agreement TypePPERSWKAGRTYPE
P_PERSONWORKAGRMTJOBTEXTPerson Work Agreement Job TextPPERWKAGRJBTXT
P_PERSONWORKAGRMTORGLDETAILSPerson Work Agreement Organization DetailsPPERWKAGRORGDET
P_PERSONWORKAGRMTPLNDWRKGTIMEWork Agreement Planned Working timePPERWKAGRPLWTIME
P_PERSONWORKAGRMTSTATUSWork Agreement StatusPPERWKAGRSTATUS
P_PERSONWORKAGRMTSTATUSTEXTPerson Work Agreement Status TextPPERWKAGRSTTXTB
P_PERSONWORKAGRMTTOECIDInternal view to get the ECUS IDPPERWKAGRECID
P_PERSONWORKAGRMTTOEXTERNALIDMapping Wrk agrmnt internal&External IDsPPERWKAGREXT
P_PERSWRKAGRMTMINFOROPGPerson Work Agreement Details for Object PagePPERSWKAGROBJ
P_PERSWRKAGRMTPOSDETPerson Work Agreement Details with PositionPPERSWRKAGRMTPOS
P_PERSWRKAGRMTTOPARTNERInternal to HCM : Do not usePPERSWRKAGRMTPT
P_U_EMPLOYDETOPEmployment details for OnPremisePUEMPLOYDETOP
P_U_EMPLOYEEEmployeePUEMPLOYE
P_U_EMPLOYEEOPEmployee view for OnPremisePUEMPLOYEEOP
P_U_EMPLOYMENTtestPUEMPLOYMENT
P_U_EMPLOYMENTCOSTLEVELEmployment Service Cost LevelPUEMPLOYCLEVEL
P_U_EMPLOYMENTMANAGERManager related to EmploymentPUEMPLOYMENTMGR
P_U_EMPLOYMENTMGRFORKEYDATEEmployment ManagerPUEMPLMGRFORKDAT
P_U_EMPLOYORGDETOPEmployment org detailsPUEMPLOYORGDETOP
P_U_EMPLOYSTATDETEmployment statusPUEMPLOYSTATDET
P_U_EMPLOYWSDETEmployment working time detailsPUEMPLOYWSDET
P_U_PERSONWORKAGREEMENTRetrieve the work agreements of the PersonPUPERSWKAGRMT
P_U_PERSONWORKAGREEMENT_1Person Work Agreement DetailsPUPERSWKAGRMT1
P_U_PERSWRKAGRMTMGRFORKEYDTERetrieve manager for given datePUPERWRKAGRMTMGR
P_U_PERSWRKAGRMTPOSDETPerson Work Agreement Details with PositionPUPERSWRKAGRMTPS
P_WFD_D_ASSGMTDETSRead wfd_d_assgmtdets tablePWFDDASSGMTDETS
P_WORKFORCEASSIGNMENTPrivate view for workforce assignmentPWORKFORCEASSGMT
P_WORKFORCEASSIGNMENTDETAILSPrivate view for workforce assignment detailsPWRKFCASSGMTDETS
P_WORKFORCEKEYMAPPINGPrivate view for key mapping detailsPWRKFRCKEYMAPPG
P_WORKFORCEPERSONIMAGEURLWorkforce person Image URLPWFPERSIMG
WFD_WORKFORCEASSIGNMENTWorkforce Domain - AssignmentsWFD_ASSGMT

Other CDS Views