I_RSHASSIGNMENTDRAFTS

CDS View

Draft assignment for session user

I_RSHASSIGNMENTDRAFTS is a CDS View in S/4HANA. Draft assignment for session user. It contains 5 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 5 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_RSHAssignmentWithDraft view left_outer COMPOSITE
P_RSHAssignmentWithDraft view inner COMPOSITE

Fields (5)

KeyField CDS FieldsUsed in Views
ProjAssignmentDate ProjAssignmentDate 1
ProjAssignmentDuration ProjAssignmentDraftDuration,ProjAssignmentDuration 1
ProjAssignmentDurationInHours ProjAssignmentDurationInHours 1
ProjAssignmentDurationUnit ProjAssignmentDurationUnit 1
ProjAssignmentUUID ProjAssignmentUUID 1 
@AbapCatalog.sqlViewName: 'IRSHASGNDRUSR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #S
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Draft assignment for session user'

/*
CONTRACT**********************************************************************************************************************
Name:                       Per Day draft assignment per User
Specification:              This View returns Draft assignment record for the session user
Requires:                   No
Ensures:                    Prepares draft assignment data for aggregation and utilization calculation in TBUI
Owners:                     MY
Unit Test required Y/N:     Covered in Hierarchy test of P_RSHAssgmtWithDraftPerMonth & P_RSHResourceUtilznWithDraft
Additional comments         None
END OF CONTRACT***************************************************************************************************************
*/

define view I_RSHAssignmentDrafts

  as select from rsh_d_projasg_d  as _Header
    join         rsh_d_projasgpdd as _PerDay on _PerDay.projassignmentuuid = _Header.projassignmentuuid

{

  key _Header.projassignmentuuid            as DraftUUID,
  key _PerDay.projassignmentperdayuuid      as ProjAssignmentPerDayUUID,
      _Header.activeuuid                    as ProjAssignmentUUID,
      _Header.employmentinternalid          as EmploymentInternalID,
      _PerDay.projassignmentdate            as ProjAssignmentDate,
      _PerDay.projassignmentduration        as ProjAssignmentDuration,
      _PerDay.projassignmentdurationunit    as ProjAssignmentDurationUnit,
      _PerDay.projassignmentdurationinhours as ProjAssignmentDurationInHours

}

where
  _Header.projassignmentlastchangedby = $session.user
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"RSH_D_PROJASGPDD",
"RSH_D_PROJASG_D"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More