C_RSHManagerOfResource

DDL: C_RSHMANAGEROFRESOURCE SQL: CRSHMGROFRES Type: view CONSUMPTION

Manager

C_RSHManagerOfResource is a Consumption CDS View that provides data about "Manager" in SAP S/4HANA. It reads from 1 data source (I_PersWrkAgrmtManagerForKeyDte) and exposes 10 fields with key field PersonWorkAgreement.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_PersWrkAgrmtManagerForKeyDte I_PersWrkAgrmtManagerForKeyDte from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CRSHMGROFRES view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Manager view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY PersonWorkAgreement PersonWorkAgreement
ManagerPersonWorkAgreement ManagerPersonWorkAgreement
PersonExternalID
FirstName
LastName
MiddleName
AdditionalLastName
PersonFullName
AuthorizationGroup _ManagerPersonWorkAgreement_1 AuthorizationGroup
IsBusinessPurposeCompleted 
@AbapCatalog.sqlViewName: 'CRSHMGROFRES'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Manager'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XL
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
/*
CONTRACT**********************************************************************************************************************

Name:                       Manager of Resources
Specification:              This View returns the names of the resource managers
Ensures:                    Resource manager names are returned
Owners:                     TR
Contributors:               -
Unit Test required Y/N:     No
Additional comments         None

END OF CONTRACT***************************************************************************************************************
*/
define view C_RSHManagerOfResource
  as select from I_PersWrkAgrmtManagerForKeyDte( P_KeyDate: $session.system_date ) as Manager

{
      @UI.hidden: true
  key PersonWorkAgreement,
      @Consumption.hidden: true
      ManagerPersonWorkAgreement,
      @UI.hidden: true
      _ManagerPersonWorkAgreement_1._WorkforcePerson.PersonExternalID,
      @Consumption.hidden: true
      _ManagerPersonWorkAgreement_1._WorkforcePerson.FirstName,
      @Consumption.hidden: true
      _ManagerPersonWorkAgreement_1._WorkforcePerson.LastName,
      @Consumption.hidden: true
      _ManagerPersonWorkAgreement_1._WorkforcePerson.MiddleName,
      @Consumption.hidden: true
      _ManagerPersonWorkAgreement_1._WorkforcePerson.AdditionalLastName,

      @EndUserText: {label: 'Manager'}
      _ManagerPersonWorkAgreement_1._WorkforcePerson.PersonFullName,

      @Consumption.hidden: true
      _ManagerPersonWorkAgreement_1.AuthorizationGroup,

      @Consumption.hidden: true
      _ManagerPersonWorkAgreement_1._WorkforcePerson.IsBusinessPurposeCompleted


}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PERSONWORKAGREEMENT_1",
"I_PERSWRKAGRMTMANAGERFORKEYDTE",
"I_WORKFORCEPERSON"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More