I_EHSTaskPlannedInstanceTP

DDL: I_EHSTASKPLANNEDINSTANCETP SQL: IEHSTASKPLANTP Type: view TRANSACTIONAL

EHS Planned Task Instance TP

I_EHSTaskPlannedInstanceTP is a Transactional CDS View that provides data about "EHS Planned Task Instance TP" in SAP S/4HANA. It reads from 1 data source (I_EHSTaskPlannedInstance) and exposes 18 fields with key field EHSPlannedTaskUUID. It has 3 associations to related views.

1 data source(s) 18 fields

Data Sources (1)

SourceAliasJoin Type
I_EHSTaskPlannedInstance I_EHSTaskPlannedInstance from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_EHSTaskDefinitionTP _EHSTaskDefinition $projection.EHSTaskDefinitionUUID = _EHSTaskDefinition.EHSTaskDefinitionUUID
[1..*] I_EHSTaskFollowUpTP _EHSTaskFollowUp $projection.EHSPlannedTaskUUID = _EHSTaskFollowUp.EHSPlannedTaskUUID
[1..1] E_EHSTaskPlannedInstance _Extension $projection.EHSPlannedTaskUUID = _Extension.EHSPlannedTaskUUID

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName IEHSTASKPLANTP view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label EHS Planned Task Instance TP view
ObjectModel.transactionalProcessingUnitRoot true view
ObjectModel.updateEnabled false view
ObjectModel.createEnabled false view
ObjectModel.deleteEnabled false view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.writeActivePersistence EHFNDD_TASK_PLAN view
ObjectModel.writeDraftPersistence EHFNDW_TASK_PLAN view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY EHSPlannedTaskUUID EHSPlannedTaskUUID
EHSTaskDefinitionUUID EHSTaskDefinitionUUID
WorkflowTaskInternalID WorkflowTaskInternalID
EHSTaskTimeZone EHSTaskTimeZone
EHSTaskStartDateTime EHSTaskStartDateTime
EHSTaskStartDate EHSTaskStartDate
EHSTaskDueDate EHSTaskDueDate
EHSTaskInstceCompletionDate EHSTaskInstceCompletionDate
EHSTaskAssignedBP EHSTaskAssignedBP
EHSTaskApprovingBP EHSTaskApprovingBP
EHSTaskOwnerBP EHSTaskOwnerBP
EHSPlannedTaskID EHSPlannedTaskID
EHSTaskInstanceProcessorBP EHSTaskInstanceProcessorBP
EHSTaskAssignedLocRole EHSTaskAssignedLocRole
EHSTaskApproverLocRole EHSTaskApproverLocRole
MigrationStatus MigrationStatus
_EHSTaskDefinition _EHSTaskDefinition
_EHSTaskFollowUp _EHSTaskFollowUp 
@AbapCatalog.sqlViewName: 'IEHSTASKPLANTP'
@AbapCatalog.preserveKey:true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@AccessControl.personalData.blocking: #('TRANSACTIONAL_DATA')
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'EHS Planned Task Instance TP'

@ObjectModel.transactionalProcessingUnitRoot: true

@ObjectModel: {
  updateEnabled: false,
  createEnabled: false,
  deleteEnabled: false,
  transactionalProcessingEnabled:true
}
@ObjectModel.usageType:{ serviceQuality: #C,
                         sizeCategory:  #XL,
                         dataClass: #MIXED }

@ObjectModel.writeActivePersistence: 'EHFNDD_TASK_PLAN'
@ObjectModel.writeDraftPersistence:  'EHFNDW_TASK_PLAN'

@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API

define view I_EHSTaskPlannedInstanceTP
  as select from I_EHSTaskPlannedInstance
  association [1..1] to I_EHSTaskDefinitionTP as _EHSTaskDefinition on $projection.EHSTaskDefinitionUUID = _EHSTaskDefinition.EHSTaskDefinitionUUID
  association [1..*] to I_EHSTaskFollowUpTP   as _EHSTaskFollowUp   on $projection.EHSPlannedTaskUUID = _EHSTaskFollowUp.EHSPlannedTaskUUID

  // Extension include

  association [1..1] to E_EHSTaskPlannedInstance as _Extension on $projection.EHSPlannedTaskUUID = _Extension.EHSPlannedTaskUUID
{
  key EHSPlannedTaskUUID,
      @ObjectModel.foreignKey.association: '_EHSTaskDefinition'
      EHSTaskDefinitionUUID,
      WorkflowTaskInternalID,
      EHSTaskTimeZone,
      EHSTaskStartDateTime,
      EHSTaskStartDate,
      EHSTaskDueDate,
      EHSTaskInstceCompletionDate,
      EHSTaskAssignedBP,
      EHSTaskApprovingBP,
      EHSTaskOwnerBP,
      EHSPlannedTaskID,
      EHSTaskInstanceProcessorBP,
      EHSTaskAssignedLocRole,
      EHSTaskApproverLocRole,
      MigrationStatus,

      @ObjectModel.association.type: [#TO_COMPOSITION_PARENT,
                                      #TO_COMPOSITION_ROOT]
      _EHSTaskDefinition,
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _EHSTaskFollowUp
}

Learn More