I_RSHProjectAssgmtPerWeekTP

DDL: I_RSHPROJECTASSGMTPERWEEKTP SQL: IRSHPRJASGWTP Type: view TRANSACTIONAL Package: RSH_CDS_PROJECT_ASG

Project Assignment Per Week TP

I_RSHProjectAssgmtPerWeekTP is a Transactional CDS View that provides data about "Project Assignment Per Week TP" in SAP S/4HANA. It reads from 1 data source (I_RSHProjectAssignmentPerWeek) and exposes 9 fields with key field ProjAssignmentWeeklyUUID. It has 1 association to related views. Part of development package RSH_CDS_PROJECT_ASG.

1 data source(s) 9 fields

Data Sources (1)

SourceAliasJoin Type
I_RSHProjectAssignmentPerWeek I_RSHProjectAssignmentPerWeek from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_RSHProjectAssignmentTP _ProjectAssignment _ProjectAssignment.ProjAssignmentUUID = $projection.ProjAssignmentUUID

Annotations (17)

NameValueLevelField
AbapCatalog.sqlViewName IRSHPRJASGWTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Project Assignment Per Week TP view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeActivePersistence rsh_d_projasgpw view
ObjectModel.writeDraftPersistence rsh_d_projasgpwd view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ProjAssignmentWeeklyUUID ProjAssignmentWeeklyUUID
YearPeriod YearPeriod
ProjAssignmentUUID ProjAssignmentUUID
ProjAssignmentDuration ProjAssignmentDuration
ProjAssignmentDurationUnit ProjAssignmentDurationUnit
ProjAssignmentDurationInHours ProjAssignmentDurationInHours
ProjAssignmentActiveDuration ProjAssignmentActiveDuration
ProjAssignmentDraftDuration ProjAssignmentDraftDuration
_ProjectAssignment _ProjectAssignment 
@AbapCatalog.sqlViewName: 'IRSHPRJASGWTP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Project Assignment Per Week TP'

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.transactionalProcessingEnabled: true
@ObjectModel.writeActivePersistence: 'rsh_d_projasgpw'
@ObjectModel.writeDraftPersistence: 'rsh_d_projasgpwd'

@ObjectModel.createEnabled: true
@ObjectModel.updateEnabled: true
@ObjectModel.deleteEnabled: true

@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API

@ObjectModel.alternativeKey: [{ element: ['ProjAssignmentUUID' , 'YearWeek'],
uniqueness: #UNIQUE_IF_NOT_INITIAL }]

define view I_RSHProjectAssgmtPerWeekTP

  as select from I_RSHProjectAssignmentPerWeek

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

{

  key ProjAssignmentWeeklyUUID,
      YearPeriod,
      ProjAssignmentUUID,
      ProjAssignmentDuration,
      ProjAssignmentDurationUnit,
      ProjAssignmentDurationInHours,
      
      ProjAssignmentActiveDuration,
      ProjAssignmentDraftDuration,
      
      // Associations 

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

}

Learn More