C_RSHResourceTimeSlice

DDL: C_RSHRESOURCETIMESLICE SQL: CRSHRESOURCESLC Type: view CONSUMPTION

RSH Resource Time Slice

C_RSHResourceTimeSlice is a Consumption CDS View that provides data about "RSH Resource Time Slice" in SAP S/4HANA. It reads from 1 data source (P_RSHResourceTimeSlice) and exposes 26 fields with key fields EmploymentInternalID, StartDate. It has 1 association to related views.

1 data source(s) 26 fields

Data Sources (1)

SourceAliasJoin Type
P_RSHResourceTimeSlice P_RSHResourceTimeSlice from

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_RSHManagerOfResource _Manager _Manager.PersonWorkAgreement = $projection.EmploymentInternalID

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CRSHRESOURCESLC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label RSH Resource Time Slice view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
VDM.private false view
VDM.viewType #CONSUMPTION view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY EmploymentInternalID EmploymentInternalID
KEY StartDate StartDate
EndDate EndDate
CompanyCode CompanyCode
CostCenter CostCenter
Job Job
OrganizationalUnit OrganizationalUnit
PersonWorkAgrmtAuthznGrpg PersonWorkAgrmtAuthznGrpg
Person Person
PersonExternalID PersonExternalID
FirstName FirstName
LastName LastName
MiddleName MiddleName
AdditionalLastName AdditionalLastName
PersonFullName PersonFullName
BusinessPartnerUUID BusinessPartnerUUID
AuthorizationGroup AuthorizationGroup
IsBusinessPurposeCompleted IsBusinessPurposeCompleted
ServiceCostLevel _ServiceCostLevel ServiceCostLevel
_CompanyCode _CompanyCode
_CostCenter _CostCenter
_Manager _Manager
_OrganizationalUnitText _OrganizationalUnitText
_PersonWorkAgrmtJobText _PersonWorkAgrmtJobText
_ServiceOrganization _ServiceOrg
_WorkforcePersonImageUrl _WorkforcePersonImageUrl 
@AbapCatalog.sqlViewName: 'CRSHRESOURCESLC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'RSH Resource Time Slice'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #XL
@VDM.private: false
@VDM.viewType: #CONSUMPTION

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

Name:                       Interface RSH View for Resource Time Slices
Specification:              This view returns all relevant key data of resources for time slices according the organizational resource data
Requires:                   n/a
Ensures:                    Usage in C-View compared to the P-View used within this one
Owners:                     JS
Contributors:               JS
Unit Test required Y/N:     No
Additional comments

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

define view C_RSHResourceTimeSlice
  as select from P_RSHResourceTimeSlice

  association [0..1] to C_RSHManagerOfResource as _Manager on _Manager.PersonWorkAgreement = $projection.EmploymentInternalID

{

      //P_RSHResourceTimeSlice

  key EmploymentInternalID,
  key StartDate,
      EndDate,
      CompanyCode,
      CostCenter,
      Job,
      OrganizationalUnit,
      @Consumption.hidden: true
      PersonWorkAgrmtAuthznGrpg,
      Person,
      @EndUserText: { label : 'External Resource ID', quickInfo: 'External Resource ID' }
      PersonExternalID,
      FirstName,
      LastName,
      MiddleName,
      AdditionalLastName,
      PersonFullName,
      @Consumption.hidden: true
      BusinessPartnerUUID,
      @Consumption.hidden: true
      AuthorizationGroup,
      @Consumption.hidden: true
      IsBusinessPurposeCompleted,
      _ServiceCostLevel.ServiceCostLevel,
      //PersonnelNumber,

      /* Associations */
      //P_RSHResourceTimeSlice

      _CompanyCode,
      _CostCenter,
      _Manager,
      _OrganizationalUnitText,
      _PersonWorkAgrmtJobText,
      _ServiceOrg as _ServiceOrganization,
      // _Skilltags as _WorkforcePersonSkillTags,

      _WorkforcePersonImageUrl

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PERSONWORKAGRMTSRVCCOSTLEVEL",
"P_RSHRESOURCETIMESLICE"
],
"ASSOCIATED":
[
"C_RSHMANAGEROFRESOURCE",
"I_COMPANYCODE",
"I_COSTCENTER",
"I_ORGANIZATIONALUNITTEXT",
"I_PERSONWORKAGRMTJOBTEXT",
"I_RSHRESOURCESERVICEORG",
"I_WORKFORCEPERSONIMAGEURL"
],
"BASE":
[
"P_RSHRESOURCETIMESLICE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More