I_RSHProjectAssignmentPerDayTP

DDL: I_RSHPROJECTASSIGNMENTPERDAYTP SQL: IRSHPROJASGPDTP Type: view TRANSACTIONAL Package: RSH_CDS_PROJECT_ASG

Project Assignment Per Day TP

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

Data Sources (1)

SourceAliasJoin Type
I_RSHProjectAssignmentPerDay I_RSHProjectAssignmentPerDay from

Associations (1)

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

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IRSHPROJASGPDTP view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Project Assignment Per Day TP view
Metadata.allowExtensions true view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.writeActivePersistence RSH_D_PROJASGPD view
ObjectModel.writeDraftPersistence RSH_D_PROJASGPDD 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 #XL view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ProjAssignmentPerDayUUID ProjAssignmentPerDayUUID
ProjAssignmentUUID ProjAssignmentUUID
ProjAssignmentDate ProjAssignmentDate
ProjAssignmentDuration ProjAssignmentDuration
ProjAssignmentDurationUnit ProjAssignmentDurationUnit
ProjAssignmentDurationInHours ProjAssignmentDurationInHours
_ProjectAssignment _ProjectAssignment
@AbapCatalog.sqlViewName: 'IRSHPROJASGPDTP'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Project Assignment Per Day TP'
@Metadata.allowExtensions: true
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.transactionalProcessingEnabled: true
@ObjectModel.writeActivePersistence: 'RSH_D_PROJASGPD'
@ObjectModel.writeDraftPersistence: 'RSH_D_PROJASGPDD'

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

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

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

Name:                       Per Day Project Assignment Transactional Processing
Specification:              Creates draft table for the per day assignments 
Requires:                   NA
Ensures:                    Draft enablement for the per day assignment
Owners:                     CF, PSP
Contributors:               PSP
Unit Test required Y/N:     Y
Additional comments         None

END OF CONTRACT***************************************************************************************************************
*/

define view I_RSHProjectAssignmentPerDayTP
  as select from I_RSHProjectAssignmentPerDay
  
  association [1..1] to I_RSHProjectAssignmentTP as _ProjectAssignment on _ProjectAssignment.ProjAssignmentUUID = $projection.ProjAssignmentUUID
{
  key ProjAssignmentPerDayUUID, 
      ProjAssignmentUUID,  
      ProjAssignmentDate, 
      ProjAssignmentDuration,
      ProjAssignmentDurationUnit,
      ProjAssignmentDurationInHours,
      
      /* Associations */
      @ObjectModel.association.type: [ #TO_COMPOSITION_PARENT, #TO_COMPOSITION_ROOT ]
      _ProjectAssignment
}