CDS Views for Resource Scheduling for Project-based Service (CA-RSH-PS)

CDS View NameDescriptionSQL View Name
C_RSHAVAILMATCHANALYZEAvail Match Total and Monthly AnalysisCRSHAVAILMATANLZ
C_RSHBSCRSCECAPKPITILESResource Capacity KPI TilesCRSHBSCRESCPTLS
C_RSHBSCSTAFFREQTILESStaffing Request KPIsCRSHBSCREQTILES
C_RSHCALENDARMONTHSBTWNDATESCalendar Month between start & end dateCRSHCALMNTHBTWDT
C_RSHCALENDARWEEKSBETWEENDATESCalendar Weeks Between DatesCRSHCALWKBTWNDT
C_RSHCOMPARERESOURCESCompare ResourcesCRSHCMPRES
C_RSHCOMPARERESOURCESKILLSCompare resource skillsCRSHCMPRSCESKILL
C_RSHCOMPARESKILLSMATCHCompare skills match for resourcesCRSHCMPSKILLMAT
C_RSHCOUNTRYF4 help for countryCRSHCOUNTRY
C_RSHCUSTOMERSList of customers for value listCRSHCUSTOMERS
C_RSHGANTTASSIGNMENTPERDAYAssignments per resource per dayCRSHGANTTASGNPD
C_RSHGANTTASSIGNMENTSProject AssignmentsCRSHGANTTASG
C_RSHGANTTCALENDARCalendar for ResourcesCRSHGANTTCAL
C_RSHGANTTNONWORKINGTIMENon working time for ResourcesCRSHGANTTNWT
C_RSHGANTTRESOURCESResouces for the Gantt ChartCRSHGANTTRES
C_RSHGANTTSETTINGSGantt SettingsCRSHGANTSETTINGS
C_RSHGANTTTIMEINTERVALTime Interval for ResourcesCRSHGANTTTI
C_RSHGANTTUTILIZATIONUtilization nodes for resourcesCRSHGANTTUTILZN
C_RSHJOBTEXTJob TextCRSHJOBTEXT
C_RSHMANAGEROFRESOURCEManagerCRSHMGROFRES
C_RSHORGUNITOrganizational UnitCRSHORGUNIT
C_RSHPROJASSGMTCHANGEDOCSChange docs for C_RSHProjectAssignmentsCRSHPROJASGCD
C_RSHPROJECTASSIGNMENTProject AssignmentCRSHPROJASG
C_RSHPROJECTASSIGNMENTCAPKPIProject Assignment Capacity KPICRSHPRASGCAPKPI
C_RSHPROJECTASSIGNMENTKPIProject Assignment KPICRSHPROJASGKPI
C_RSHPROJECTASSIGNMENTPERDAYProject Assignment Per DayCRSHPROJASGPD
C_RSHPROJECTASSIGNMENTPERMONTHProject Assignment Per MonthCRSHASGNPMONTH
C_RSHPROJECTASSIGNMENTPERWEEKAssignments aggregated per weekCRSHASGNPWEEK
C_RSHPROJECTAUTHORIZATIONAuthorization for projectsCRSHPROJAUTH
C_RSHPROJECTMANAGERProject ManagerCRSHPROJMGR
C_RSHRESOURCE4MONTHSUTILAverage Utilization next 4 monthsCRSHRES4MUTIL
C_RSHRESOURCEASSIGNMENTSAll assignments of a resourceCRSHRSCEASGN
C_RSHRESOURCEBOOKINGResource Booking DataCRSHRESBOOK
C_RSHRESOURCECAPACITYKPISResource Capacity KPIsCRSHRESCAPKPIS
C_RSHRESOURCECAPACITYKPITILESResource Capacity KPI TilesCRSHRESCAPTILES
C_RSHRESOURCECOSTCENTERcost centerCRSHRESCOSTCTR
C_RSHRESOURCEKPIONBENCHResources with free capacityCRSHRESKPIBENCH
C_RSHRESOURCEKPIOVERBOOKOver booked resourceCRSHRESKPIOVERBK
C_RSHRESOURCEKPISResource KPIsCRSHRESKPIS
C_RSHRESOURCELISTResourceCRSHRESLIST
C_RSHRESOURCEMANAGERNAMEName of resource managerCRSHMRGRESNAME
C_RSHRESOURCENAMECDS for resource name F4CRSHRESNAME
C_RSHRESOURCEOVERBOOKOver booked resourceCRSHRESOVERBOOK
C_RSHRESOURCEROLETXTCheck table for vlaue help for role textCRHSRESBPTXT
C_RSHRESOURCESERVICECOSTCheck table for value help for service costCRSHRESSERCOST
C_RSHRESOURCESERVICEORGService organization for a cost centerCRSHRESSERORG
C_RSHRESOURCESKILLTAGSVHValue Help - Resource SkilltagsCRSHRESSKILLSVH
C_RSHRESOURCESTATUSVHValue Help for Resource StatusCRSHRESSTATUSVH
C_RSHRESOURCETIMESLICERSH Resource Time SliceCRSHRESOURCESLC
C_RSHRESOURCEWITHFREECAPACITYResources with free capacityCRSHRESFREECAP
C_RSHRSCEASSGMTFORCUSTOMERAll resource assignment for a customerCRSHRSCASGNCUST
C_RSHRSCEASSGMTFORINDUSTRYAll resource assignment for a industryCRSHRSCASGNINDT
C_RSHRSCEASSGMTFORROLEAll resource assignment for a roleCRSHRSCASGNROLE
C_RSHSERVICEORGANIZATIONService OrganizationsCRSHSRVORG
C_RSHSTAFFINGREQFORSITNResource RequestCRSHSTAFFREQSITN
C_RSHSTAFFINGREQOPENNEXT4MNTHSOpen Staffing Req UUIDs next 4 MonthsCRSHREQOPN4M
C_RSHSTAFFINGREQUESTBYROLEStaffing requests by roleCSTAFFINGREQ
C_RSHSTAFFINGREQUESTCOSTCTRTXTStaffing Request Cost Center TextCRSHSTAFFREQCCTX
C_RSHSTAFFINGREQUESTCOSTCTRVHStaffing Request Cost Center ValHelpCRSHSTAFFREQCCVH
C_RSHSTAFFINGREQUESTCOUNTCount Staffing Requests by Staff.-StatusCRSHREQCNT
C_RSHSTAFFINGREQUESTDATAStaffing Request Data without ParametersCRSHREQDATA
C_RSHSTAFFINGREQUESTDETAILSResource RequestCRSHSTAFFREQDET
C_RSHSTAFFINGREQUESTEFFORTDemand Effort Distribution Per yearCRSHREQEFFORT
C_RSHSTAFFINGREQUESTFORRESStaffing Request for ResourceCRSHREQFORRES
C_RSHSTAFFINGREQUESTLISTResource RequestCRSHSTAFFREQLIST
C_RSHSTAFFINGREQUESTRESOURCEResource based on Staffing RequestsCRSHREQRES
C_RSHSTAFFINGREQUESTSKILLSVHValue Help - Staffing Request SkilltagsCRSHSTREQSKILLVH
C_RSHSTAFFINGREQUESTTEAMStaffing Request TeamCSTAFFREQTEAM
C_RSHSTAFFINGREQUESTTILESStaffing Request KPIs and Data for TilesCRSHREQTILES
C_RSHSTAFFINGROLERequest RolesCRSHREQROLE
C_RSHSTAFFREQKPISTATUSCOUNTStaffing Request Status Count (UI)CRSHSTREQKSTC
C_RSHSUITABLEREQUESTSSuitable RequestsCRSHSUITREQS
C_RSHSUITABLERESOURCESGet suitable resources for a requestCRSHSUITABLERES
C_RSHSUITABLERESOURCESPROJResourceCRSHSUITRESPROJ
C_RSHTABLEBASEDPROJASSIGNMENTView to return assignments for table UICRSHTBPROJASGN
C_RSHTABLEBASEDTREEPROPERTIESView for additional tree propertiesCRSHTBLTREEPRP
C_RSHTABLEBSDRSCEMONTHLYUTILZNMonthly utilization for resourceCRSHTBRESMUTIL
C_RSHTABLEBSDRSCEWEEKLYUTILZNWeekly utilization for resourceCRSHTBRESWUTIL
I_RSHASSIGNMENTDRAFTSDraft assignment for session userIRSHASGNDRUSR
I_RSHGANTTUSERSETTINGSTPInterface for Gantt SettingsIRSHGANTTUSERSET
I_RSHPREFRESTEXTPreferred / Requested Resource TextIRSHPREFRESTXT
I_RSHPROJASSGMTALLOWEDITCheck if Assignment Edit are allowed from APIIRSHPSASGALLOW
I_RSHPROJECTASSGMTPERMONTHTPProject Assignment Per Month TPIRSHPRJASGPMTP
I_RSHPROJECTASSGMTPERWEEKTPProject Assignment Per Week TPIRSHPRJASGWTP
I_RSHPROJECTASSIGNMENTProject AssignmentIRSHPROJASG
I_RSHPROJECTASSIGNMENTCAPKPIProject Assignment Capacity KPIIRSHPRASGCAPKPI
I_RSHPROJECTASSIGNMENTCAPKPITPProject Assignment Capacity KPI TPIRSHPRASGCKPITP
I_RSHPROJECTASSIGNMENTDAILYAssignment details at a daily levelIRSHPROJASGDAILY
I_RSHPROJECTASSIGNMENTDAILYHRSResource Assignments per DayIRSHPRJASGPDH
I_RSHPROJECTASSIGNMENTHRSResource AssignmentsIRSHPRJASGPHR
I_RSHPROJECTASSIGNMENTKPIProject Assignment KPIIRSHPROJASGKPI
I_RSHPROJECTASSIGNMENTKPITPProject Assignment KPI TPIRSHPROJASGKPITP
I_RSHPROJECTASSIGNMENTPERDAYProject Assignment Per DayIRSHPROJASGPD
I_RSHPROJECTASSIGNMENTPERDAYTPProject Assignment Per Day TPIRSHPROJASGPDTP
I_RSHPROJECTASSIGNMENTPERMONTHProject Assignment Per MonthIRSHPRJASGPMN
I_RSHPROJECTASSIGNMENTPERWEEKProject Assignment Per WeekIRSHPRJASGPWK
I_RSHPROJECTASSIGNMENTTPProject Assignment TPIRSHPROJASGTP
I_RSHPROJECTFORCPDACTIVEIs Resource Scheduling Staffing active?IRSHPSCPDACTV
I_RSHRESOURCESERVICEORGService organization for a cost centerIRSHRESSERORG
I_RSHSTAFFINGREQCATEGORYTEXTProject TypeIRSHSTAFREQCATTX
I_RSHSTAFFINGREQUESTSTATUSStaffing Request StatusIRSHSTFREQSTATXT
I_RSHSTAFFINGREQUESTVISIBILITYStaffing Request VisibilityIRSHPROJVIS
I_RSHSTAFFINGREQVISIBLETEXTPublic VisibilityIRSHSTAFREQVISTX
P_RSHASGNSUMMARYPERREQUESTAggregated Assginment Summary per Resource RequestPRSHASGSUMPR
P_RSHASSGMTWITHDRAFTPERMONTHAssignment Monthly aggregated with DraftPRSHMASGDR
P_RSHASSIGNMENTAssignment HeaderPRSHASSIGN
P_RSHASSIGNMENTPERDAYAssignment per DayPRSHASSIGNPERDAY
P_RSHASSIGNMENTPERDAYACTIVEActive Assignment Per DayPRSHASGNPDA
P_RSHASSIGNMENTPERDAYDRAFTSPer day assigmment draftsPRSHASSGMTPDD
P_RSHASSIGNMENTWITHDRAFTPer Day Assignment details with draftPRSHASGNPDDR
P_RSHAVAILMATCHMONTHLYMonthly match for suitable resourcesPRSHAVAILMM
P_RSHAVAILMATCHMONTHLYCALCAgg of open hours for monthly matchingPRSHAVMONCALC
P_RSHAVAILMONTHLYFULFILLEDMonthly match for suitable resourcesPRSHAVAILFULL
P_RSHAVAILPERSUPPLYITEMAvail check per supply item from CPMPRSHAVAILPERITEM
P_RSHBSCASSGMTPERDAYAssignment Per DayPRSHBSCASSGMTPD
P_RSHBSCRSCECAPACITYKPISResource Capacity KPIsPRSHBSCRESCAPKPI
P_RSHBSCRSCEMONTHLYUTILIZATNResource Monthly Utilization InformationPRSHBSCRESMTHLUT
P_RSHBSCRSCEUTILIZATIONResource Availability and UtilizationPRSHBSCRSCEUTIL
P_RSHBSCSTAFFREQStaffing Request Master DataPRSHBSCSTFREQ
P_RSHBSCSTAFFREQDATAStaffing Request Data DistributedPRSHBSCSTFREQDT
P_RSHBSCSTAFFREQDETAILConsolidated Request DetailsPRSHBSCREQDET
P_RSHBSCSTAFFREQSUPPLYStaffing Request Supply Data from CPMPRSHBSCSTFREQSUP
P_RSHBSCSTAFFREQSUPPLYCALCCalculate and Distribute Daily Assignments for CPM SupplyPRSHBSCSTFSPLCAL
P_RSHBSCSTAFFREQSUPPLYDATAStaffing Request Supply Data from CPMPRSHBSCSTFSPDT
P_RSHMONTHLYAGGRGDASSGMTACTIVEMonthly aggregated active assignmentPRSHMTLYAGGASG
P_RSHMONTHLYAGGRGDASSGMTDRAFTSMonthly aggregated assignment draftsPRSHMTLYAGGASGD
P_RSHPROJASSGMTALLOWEDITAllow editing Assignment?PRSHPSASGALLOW
P_RSHPROJASSGMTCHANGEDOCSChange documents for C_RSHProjectAssignmentsPRSHPROJASGCD
P_RSHPROJECTASGCHANGEDOCHEADERChange document headers for AMDP functionPRSHPROJASGCDHDR
P_RSHREQASSGMTSUMMARYPERMONTHRequest assign. duration aggr.per monthPRSHREQASGNSUMPM
P_RSHREQMONTHLYOPENDURNMonthly open duration per requestPRSHMONOPENDUR
P_RSHREQUESTTOTALOPENDURATIONMonthly open duration per requestPRSHTOTOPENDUR
P_RSHRESOURCERSH ResourcePRSHRESOURCE
P_RSHRESOURCE2MONTHKPIKPI for 2months utilizationPRSHRESKPI
P_RSHRESOURCE2MONTHSAVAIL2 Months Availability of resourcePRSHRESAVAIL2
P_RSHRESOURCE2MONTHSUTIL2 Month resource utilizationPRSHRESUTIL2
P_RSHRESOURCE2MONTHUTILAGRAggregation of utilization for 2monthsPRSHRESAGR
P_RSHRESOURCE2MONTHUTILAVGAggregation of utilization for 2monthsPRSHRESAVG
P_RSHRESOURCE4MONTHSAVAILAvailability and Staffed next 4 monthPRSHRES4MAVAIL
P_RSHRESOURCE4MONTHSUTILResource Utilization next 4 monthPRSHRES4MUTIL
P_RSHRESOURCEAUTHDATAResource Data like Cost Center assignntPRSHRESAUTHDATA
P_RSHRESOURCEAVAILABILITYResource AvailabilityPRSHRESAVAIL
P_RSHRESOURCEAVAILABILITYMATCHResource Availability MatchingPRSHRESAVMATCH
P_RSHRESOURCEAVAILSUMMARYResource availabilityPRSHRESAVAILSUM
P_RSHRESOURCEBPROLEBP Role of ResourcePRSHRESBPROLE
P_RSHRESOURCECAPACITYKPISResource Capacity KPIsPRSHRESCAPKPIS
P_RSHRESOURCEDATAResource Data like Cost Center assignntPRSHRESDATA
P_RSHRESOURCEKPIResource KPIsPRSHRESOURCEKPI
P_RSHRESOURCELISTResource ListPRSHRESLIST
P_RSHRESOURCEMONTHLYUTILIZATNReosurce Monthly Utilization InformationPRSHRESMNTHLYUTL
P_RSHRESOURCEPERREQUESTResource Per RequestPRSHRESPERREQ
P_RSHRESOURCEROLECOUNTCount of Resource RolePRSHRESROLECNT
P_RSHRESOURCEROLESRoles a Resource was staffed forPRSHRESROLES
P_RSHRESOURCESERVICECOSTLEVELRSH Resource Service Cost LevelPRSHRESSRVCCOST
P_RSHRESOURCESKILLMATCHINGCALCCalculate Total Skill MatchingPRSHSKILLMCALC
P_RSHRESOURCESKILLSCOMPAREResource skillset comparisonPRSHSKILLSCMP
P_RSHRESOURCESKILLSFROMASGResource Skills from existing AssignmentPRSHRESSKILLASG
P_RSHRESOURCESKILLTAGSResource SkilltagsPRSHRESSKILLS
P_RSHRESOURCESKILLTAGUNIQUEReturns the Skill Tag for ResourcePRSHRESSKILLUNIQ
P_RSHRESOURCESRVCCOSTLVLSLICEResource Service Cost Level Time SlicePRSHRESSRVCSTSL
P_RSHRESOURCESTATUSStatus of Work Agreement of a resourcePRSHRESSTATUS
P_RSHRESOURCETIMESLICERSH Resource Time SlicePRSHRESOURCESLC
P_RSHRESOURCEUTILIZATIONResource Availability and UtilizationPRSHRESUTIL
P_RSHRESOURCEUTILIZATIONPERREQResource Utilization Per RequestPRSHRESUTILPREQ
P_RSHRESOURCEUTILZNWITHDRAFTResource Utilization with DraftsPRSHRESUTIDR
P_RSHRESOURCEWEEKLYUTILIZATIONResource Weekly Utilization InformationPRSHRESWEEKLYUTL
P_RSHRESOURCEWORKAGREEMENTRSH Resource Work AgreementPRSHWRKAGRMENT
P_RSHRSCEASSGMTCUSTOMERResource assignments for a customerPRSHRESASGNCUST
P_RSHRSCEASSGMTFORCUSTOMERCNTResource assignment count for customerPRSHASGNCUSTCNT
P_RSHRSCEASSGMTFORINDSTRYCNTResource assignment count for industryPRSHASGNIDTRYCNT
P_RSHRSCEASSGMTINDUSTRYResource assignments for an industryPRSHRESASGINDSTY
P_RSHRSCEASSGMTREQCUSTOMERRequest details for resource assignmentsPRSHRESASGREQCUS
P_RSHRSCEASSGMTREQDETAILSRequest details for resource assignmentsPRSHRESASGREQDET
P_RSHRSCEASSGMTROLEResource assignments for a given rolePRSHRESASGROLE
P_RSHRSCEMONTHLYUTILZNCMPLTResource monthly utilization in periodPRSHRESMNTLYUTLC
P_RSHRSCEUTILZNPERMNTHWTHDRFTUtil with Draft aggregated per monthPRSHRESMNTHUTLDR
P_RSHSTAFFINGREQASSGMTHOURSStaffing request and the durationPRSHREQASGNHR
P_RSHSTAFFINGREQSTATUSCOUNTStaffing Request Status CountPRSHSTFREQSTC
P_RSHSTAFFINGREQUESTStaffing Request incl. consolidationsPRSHSTAFFREQ
P_RSHSTAFFINGREQUESTCOSTCENTERStaffing Request Cost CenterPRSHSTAFFREQCC
P_RSHSTAFFINGREQUESTCOUNTCount Staffing Requests by Staff.-StatusPRSHREQCNT
P_RSHSTAFFINGREQUESTDATAStaffing Request Data without consolidationsPRSHSTAFFREQDATA
P_RSHSTAFFINGREQUESTDATEPERIODMinimum Start date and Maximum End date of Staffing RequestPRSHSTAFFPERIOD
P_RSHSTAFFINGREQUESTDATESMinimum Start date and Maximum End date of Staffing REquestPRSHMINMAXSTAFF
P_RSHSTAFFINGREQUESTDETAILSStaffing Request Details consolidatedPRSHSTAFFREQDET
P_RSHSTAFFINGREQUESTEFFORTDISTDemand Effort DistibutionPRSHREQEFFDIST
P_RSHSTAFFINGREQUESTFORINDStaffing Request details for IndustryPRSHSTAFFREQIND
P_RSHSTAFFINGREQUESTLISTStaffing Request Status ListPRSHSTAFFREQLIST
P_RSHSTAFFINGREQUESTSKILLTAGSStaffing Request SkilltagsPRSHSTREQSKILLS
P_RSHSTAFFINGREQUESTSUPPLYDATAStaffing request Supply Data from CPMPRSHSTAFSUPLDATA
P_RSHSTAFFREQDUEPERIODSTODAYSDue Periods to Due DaysPRSHSTFREQDUTDAY
P_RSHSUITABLEREQUESTSSuitable RequestsPRSHSUITABLEREQS
P_RSHSUITABLERESOURCESSuitable ResourcesPRSHSUITABLERES
P_RSHSUITABLERESOURCESPROJP view for Suitable resource for CPMPRSHSUITRESPROJ
P_RSHSUITABLERESOURCESTOTALSuitable Resources Match with Total MatchingPRSHSUITABLERTM

Other CDS Views