R_BDTSExecutionPlanItemTP

DDL: R_BDTSEXECUTIONPLANITEMTP Type: view_entity TRANSACTIONAL

Execution Plan Item - TP

R_BDTSExecutionPlanItemTP is a Transactional CDS View that provides data about "Execution Plan Item - TP" in SAP S/4HANA. It reads from 1 data source (R_BDTSExecutionPlanItem) and exposes 15 fields with key fields BDTSTransformationAreaID, BDTSExecPlanID, BDTSExecPlanItemID. It has 1 association to related views.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
R_BDTSExecutionPlanItem R_BDTSExecutionPlanItem from

Associations (1)

CardinalityTargetAliasCondition
[0..*] R_BDTSExecPlanItemDpndcyTP _ItemDependency

Annotations (10)

NameValueLevelField
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
EndUserText.label Execution Plan Item - TP view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.allowExtensions false view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name BDTSExecutionPlanItem view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY BDTSTransformationAreaID BDTSTransformationAreaID
KEY BDTSExecPlanID BDTSExecPlanID
KEY BDTSExecPlanItemID BDTSExecPlanItemID
BDTSExecPlanItemType BDTSExecPlanItemType
BDTSExecPlanItemGroupSequence BDTSExecPlanItemGroupSequence
BDTSExecPlanItemObjectName BDTSExecPlanItemObjectName
BDTSExecPlanItemStatus BDTSExecPlanItemStatus
BDTSExecPlanItemIsErrorSkipped BDTSExecPlanItemIsErrorSkipped
BDTSExecPlanItemHasPredecessor BDTSExecPlanItemHasPredecessor
BDTSExecPlanItemLastLogNumber BDTSExecPlanItemLastLogNumber
BDTSExecPlanCreationDateTime BDTSExecPlanCreationDateTime
BDTSExecPlanStartDateTime BDTSExecPlanStartDateTime
BDTSExecPlanEndDateTime BDTSExecPlanEndDateTime
_ExecutionPlan _ExecutionPlan
_ItemDependency _ItemDependency 
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}

@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #A,
     sizeCategory:   #S
   }
}
@EndUserText.label: 'Execution Plan Item - TP'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.allowExtensions:false
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.sapObjectNodeType.name: 'BDTSExecutionPlanItem'

define view entity R_BDTSExecutionPlanItemTP
  as select from R_BDTSExecutionPlanItem

  composition [0..*] of R_BDTSExecPlanItemDpndcyTP as _ItemDependency

  association to parent R_BDTSExecutionPlanTP      as _ExecutionPlan on  $projection.BDTSTransformationAreaID = _ExecutionPlan.BDTSTransformationAreaID
                                                                     and $projection.BDTSExecPlanID           = _ExecutionPlan.BDTSExecPlanID
{
  key BDTSTransformationAreaID,
  key BDTSExecPlanID,
  key BDTSExecPlanItemID,
      BDTSExecPlanItemType,
      BDTSExecPlanItemGroupSequence,
      BDTSExecPlanItemObjectName,
      BDTSExecPlanItemStatus,
      BDTSExecPlanItemIsErrorSkipped,
      BDTSExecPlanItemHasPredecessor,
      BDTSExecPlanItemLastLogNumber,
      @Semantics.systemDateTime.createdAt: true
      BDTSExecPlanCreationDateTime,
      BDTSExecPlanStartDateTime,
      BDTSExecPlanEndDateTime,

      //Parent

      _ExecutionPlan,
      //Compositions

      _ItemDependency

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_BDTSEXECUTIONPLANITEM"
],
"ASSOCIATED":
[
"R_BDTSEXECPLANITEMDPNDCYTP",
"R_BDTSEXECUTIONPLANTP"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More