I_RSHPROJECTASSIGNMENTPERDAY

CDS View

Project Assignment Per Day

I_RSHPROJECTASSIGNMENTPERDAY is a CDS View in S/4HANA. Project Assignment Per Day. It contains 6 fields. 7 CDS views read from this table.

Used by 7 CDS view(s) 6 fields

CDS Views using this table (7)

ViewTypeJoinVDMDescription
I_RSHProjectAssignmentDaily view inner BASIC Assignment details at a daily level
I_RSHProjectAssignmentDailyHrs view from COMPOSITE Resource Assignments per Day
I_RSHProjectAssignmentPerDayTP view from TRANSACTIONAL Project Assignment Per Day TP
P_RSHAssignmentPerDay view from COMPOSITE
P_RSHAssignmentPerDayActive view from BASIC
P_RSHAssignmentWithDraft view inner COMPOSITE
P_RSHAssignmentWithDraft view left_outer COMPOSITE

Fields (6)

KeyField CDS FieldsUsed in Views
KEY ProjAssignmentPerDayUUID ProjAssignmentPerDayUUID 3
ProjAssignmentDate CalendarDate,ProjAssignmentDate 3
ProjAssignmentDuration ProjAssignmentActiveDuration 1
ProjAssignmentDurationInHours AssignedHours,ProjAssignmentDurationInHours 2
ProjAssignmentDurationUnit ProjAssignmentDurationUnit 1
ProjAssignmentUUID ProjAssignmentUUID 3 
@VDM.lifecycle.contract.type: #PUBLIC_LOCAL_API
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.sqlViewName: 'IRSHPROJASGPD'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Project Assignment Per Day'

@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #XL
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE

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

Name:                       Project Assignment Per Day
Specification:              Provides the project assignment details on a per day basis reading directly from the DB. 
                            The view shall be used in the TP view for draft enablement.
Requires:                   NA
Ensures:                    Returns project assignment details on a per day basis. 
Owners:                     PSP
Contributors:               CF, PSP
Unit Test required Y/N:     Y
Additional comments         None
END OF CONTRACT***************************************************************************************************************
*/

define view I_RSHProjectAssignmentPerDay
  as select from rsh_d_projasgpd

  association [1..1] to I_RSHProjectAssignment as _ProjectAssignment on _ProjectAssignment.ProjAssignmentUUID = $projection.ProjAssignmentUUID

  association [1..1] to I_UnitOfMeasure        as _UnitOfMeasure     on _UnitOfMeasure.UnitOfMeasure = $projection.ProjAssignmentDurationUnit
{
  key projassignmentperdayuuid      as ProjAssignmentPerDayUUID,
      projassignmentuuid            as ProjAssignmentUUID,

      @Semantics.businessDate.at: true
      projassignmentdate            as ProjAssignmentDate,

      @Semantics.quantity.unitOfMeasure: 'ProjAssignmentDurationUnit'
      @DefaultAggregation: #SUM
      projassignmentduration        as ProjAssignmentDuration,

      @Semantics.unitOfMeasure: true
      projassignmentdurationunit    as ProjAssignmentDurationUnit,

      projassignmentdurationinhours as ProjAssignmentDurationInHours,

      // Associations

      _UnitOfMeasure,

      @ObjectModel.association.type: [ #TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT ]
      _ProjectAssignment

}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"RSH_D_PROJASGPD"
],
"ASSOCIATED":
[
"I_RSHPROJECTASSIGNMENT",
"I_UNITOFMEASURE"
],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More