P_RSHRESOURCE

CDS View

RSH Resource

P_RSHRESOURCE is a CDS View in S/4HANA. RSH Resource. It contains 2 fields. 20 CDS views read from this table.

Used by 20 CDS view(s) 2 fields

CDS Views using this table (20)

ViewTypeJoinVDMDescription
C_RSHBscRsceCapKPITiles view inner CONSUMPTION Resource Capacity KPI Tiles
C_RSHCompareSkillsMatch view from CONSUMPTION Compare skills match for resources
C_RSHGanttCalendar view from CONSUMPTION Calendar for Resources
C_RSHGanttTimeInterval view left_outer CONSUMPTION Time Interval for Resources
C_RSHJobText view inner CONSUMPTION Job Text
C_RSHOrgUnit view inner CONSUMPTION Organizational Unit
C_RSHResourceBooking view left_outer CONSUMPTION Resource Booking Data
C_RSHResourceCapacityKPITiles view from CONSUMPTION Resource Capacity KPI Tiles
P_RSHBscRsceUtilization view from CONSUMPTION Resource Availability and Utilization
P_RSHBscStaffReqSupplyCalc view left_outer CONSUMPTION Calculate and Distribute Daily Assignments for CPM Supply
P_Rshresource2monthsavail view from CONSUMPTION 2 Months Availability of resource
P_Rshresource4monthsavail view inner CONSUMPTION Availability and Staffed next 4 month
P_RSHResourceCapacityKPIs view inner COMPOSITE Resource Capacity KPIs
P_RSHResourceKPI view from COMPOSITE Resource KPIs
P_RSHResourceList view from COMPOSITE Resource List
P_RSHRsceMonthlyUtilznCmplt view from COMPOSITE Resource monthly utilization in period
P_RSHSuitableRequests view inner COMPOSITE Suitable Requests
P_RSHSuitableResources view from COMPOSITE Suitable Resources
P_RSHSuitableResourcesProj view from COMPOSITE P view for Suitable resource for CPM
P_RSHSuitableResourcesTotal view from COMPOSITE Suitable Resources Match with Total Matching

Fields (2)

KeyField CDS FieldsUsed in Views
CompanyCode CompanyCode 1
CostCenter CostCenter 1 
@AbapCatalog.sqlViewName: 'PRSHRESOURCE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE


/*
CONTRACT**********************************************************************************************************************

Name:                       THE Central RSH Resource View
Specification:              This view returns all relevant key data of resources, based on the first employment of the given time period
Requires:                   Parameters Start and EndDate
Ensures:                    All key and base resource data is returned.
Owners:                     TR
Contributors:               TR
Unit Test required Y/N:     Yes
Additional comments         None

END OF CONTRACT***************************************************************************************************************
*/

define view P_RSHResource
  with parameters
    P_StartDate : syst_datum,
    P_EndDate   : syst_datum

  as select from           P_RSHResourceData( P_StartDate: $parameters.P_StartDate, P_EndDate: $parameters.P_EndDate )

    inner join             I_WorkforcePerson                                                                                      as Person                    on Person.Person = P_RSHResourceData.Person

  association [0..1] to P_RSHResourceSkilltags        as _Skilltags        on $projection.Person = _Skilltags.Person
  association [0..1] to I_RSHResourceServiceOrg       as _serviceorg       on $projection.CostCenter = _serviceorg.AssignedOrganisation and _serviceorg.CompanyCode = $projection.CompanyCode

{

      //P_RSHResourceData

  key P_RSHResourceData.EmploymentInternalID,
      P_RSHResourceData.StartDate,
      P_RSHResourceData.EndDate,
      P_RSHResourceData.WorkAgreementStatus,
      P_RSHResourceData.CompanyCode,
      P_RSHResourceData.CostCenter,
      P_RSHResourceData.Job,
      P_RSHResourceData.OrganizationalUnit,
      P_RSHResourceData.PersonWorkAgrmtAuthznGrpg,
      //Person

      Person.Person,
      PersonExternalID,
      FirstName,
      LastName,
      MiddleName,
      AdditionalLastName,
      PersonFullName,
      BusinessPartnerUUID,
      AuthorizationGroup,
      IsBusinessPurposeCompleted,

      /* Associations */
      //P_RSHResourceData

      _CompanyCode,
      _CostCenter,
      _OrganizationalUnitText,
      _PersonWorkAgrmtJobText,
      //Person

      _BusinessPartner,

      _PersonWorkAgreement_1 as _PersonWorkAgreement,
      _ServicePerformerToSupplier,
      _WorkplaceAddress,
      _Skilltags,
      _serviceorg

}

Learn More