R_BDTSExecutionPlanTP

DDL: R_BDTSEXECUTIONPLANTP Type: view_entity TRANSACTIONAL

Execution Plan Root - TP

R_BDTSExecutionPlanTP is a Transactional CDS View that provides data about "Execution Plan Root - TP" in SAP S/4HANA. It reads from 1 data source (R_BDTSExecutionPlanHeader) and exposes 11 fields with key fields BDTSTransformationAreaID, BDTSExecPlanID. It has 2 associations to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
R_BDTSExecutionPlanHeader R_BDTSExecutionPlanHeader from

Associations (2)

CardinalityTargetAliasCondition
[0..*] R_BDTSExecPlanItemDpndcyTP _ItemDependency $projection.BDTSTransformationAreaID = _ItemDependency.BDTSTransformationAreaID and $projection.BDTSExecPlanID = _ItemDependency.BDTSExecPlanID
[0..*] R_BDTSExecutionPlanItemTP _Item

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 Root - TP view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.allowExtensions false view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name BDTSExecutionPlan view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY BDTSTransformationAreaID BDTSTransformationAreaID
KEY BDTSExecPlanID BDTSExecPlanID
BDTSExecPlanUseCase BDTSExecPlanUseCase
BDTSExecPlanStatus BDTSExecPlanStatus
BDTSExecPlanIsActive BDTSExecPlanIsActive
BDTSExecPlanHasErrorItem BDTSExecPlanHasErrorItem
BDTSExecPlanCreationDateTime BDTSExecPlanCreationDateTime
BDTSExecPlanStartDateTime BDTSExecPlanStartDateTime
BDTSExecPlanEndDateTime BDTSExecPlanEndDateTime
_ItemDependency _ItemDependency
_Item _Item 
@VDM: {
  viewType: #TRANSACTIONAL,
  lifecycle.contract.type: #SAP_INTERNAL_API
}

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

define root view entity R_BDTSExecutionPlanTP
  as select from R_BDTSExecutionPlanHeader

  composition [0..*] of R_BDTSExecutionPlanItemTP as _Item
  association [0..*] to R_BDTSExecPlanItemDpndcyTP as _ItemDependency on  $projection.BDTSTransformationAreaID = _ItemDependency.BDTSTransformationAreaID
                                                                      and $projection.BDTSExecPlanID           = _ItemDependency.BDTSExecPlanID

{
  key BDTSTransformationAreaID,
  key BDTSExecPlanID,
      BDTSExecPlanUseCase,
      BDTSExecPlanStatus,
      BDTSExecPlanIsActive,
      BDTSExecPlanHasErrorItem,
      @Semantics.systemDateTime.createdAt: true
      BDTSExecPlanCreationDateTime,
      BDTSExecPlanStartDateTime,
      BDTSExecPlanEndDateTime,

      //Associations

      _ItemDependency,
      //Compositions

      _Item

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

Learn More