C_RSHTableBasedTreeProperties

DDL: C_RSHTABLEBASEDTREEPROPERTIES SQL: CRSHTBLTREEPRP Type: view CONSUMPTION

View for additional tree properties

C_RSHTableBasedTreeProperties is a Consumption CDS View that provides data about "View for additional tree properties" in SAP S/4HANA. It reads from 2 data sources (I_RSHProjectAssignment, P_RSHResourceTimeSlice) and exposes 10 fields with key field EmploymentInternalID.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
I_RSHProjectAssignment Draft left_outer
P_RSHResourceTimeSlice P_RSHResourceTimeSlice from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CRSHTBLTREEPRP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
EndUserText.label View for additional tree properties 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 EmploymentInternalID P_RSHResourceTimeSlice EmploymentInternalID
EmployeeRowId
EmployeeParentRowId P_RSHResourceTimeSlice EmploymentInternalID
EmployeeRowLevel 1
EmployeeRowType
EmployeeIsExpanded
ProjAssignmentDurationUnit
JobName _PersonWorkAgrmtJobText JobName
DraftUUID I_RSHProjectAssignment ProjAssignmentUUID
ResIsStaffedForSelRequest 
@AbapCatalog.sqlViewName: 'CRSHTBLTREEPRP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'View for additional tree properties'
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #XL
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED

define view C_RSHTableBasedTreeProperties
  as select from    P_RSHResourceTimeSlice
    left outer join I_RSHProjectAssignment as Draft on  Draft.EmploymentInternalID = '00000000' // all we need is a field with type sysuuid_x

                                                    and Draft.EmploymentInternalID = P_RSHResourceTimeSlice.EmploymentInternalID

{
  key P_RSHResourceTimeSlice.EmploymentInternalID                          as EmploymentInternalID,
      cast(P_RSHResourceTimeSlice.EmploymentInternalID as abap.char( 12 )) as EmployeeRowId,
      P_RSHResourceTimeSlice.EmploymentInternalID                          as EmployeeParentRowId,

      1                                                                    as EmployeeRowLevel,
      '01'                                                                 as EmployeeRowType,
      cast('leaf' as abap.char( 8 ) )                                      as EmployeeIsExpanded,
      cast ('H' as co_meinh)                                               as ProjAssignmentDurationUnit,
      _PersonWorkAgrmtJobText.JobName                                      as JobName,
      Draft.ProjAssignmentUUID                                             as DraftUUID,
      cast('' as boolean)                                                  as ResIsStaffedForSelRequest 
}
group by
  P_RSHResourceTimeSlice.EmploymentInternalID,
  Draft.ProjAssignmentUUID,
  _PersonWorkAgrmtJobText.JobName
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PERSONWORKAGRMTJOBTEXT",
"I_RSHPROJECTASSIGNMENT",
"P_RSHRESOURCETIMESLICE"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More