A_BDTSExecutionPlan

DDL: A_BDTSEXECUTIONPLAN Type: view_entity CONSUMPTION

BDTS Execution Plan

A_BDTSExecutionPlan is a Consumption CDS View that provides data about "BDTS Execution Plan" in SAP S/4HANA. It reads from 1 data source (R_BDTSExecutionPlanHeader) and exposes 13 fields with key fields BDTSTransformationAreaID, BDTSExecPlanID. It has 4 associations to related views.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
R_BDTSExecutionPlanHeader R_BDTSExecutionPlanHeader from

Associations (4)

CardinalityTargetAliasCondition
[0..*] A_BDTSExecutionPlanItemDpndcy _ExecutionPlanItemDpndcy _ExecutionPlanItemDpndcy.BDTSTransformationAreaID = $projection.BDTSTransformationAreaID and _ExecutionPlanItemDpndcy.BDTSExecPlanID = $projection.BDTSExecPlanID
[0..*] A_BDTSExecutionPlanJob _ExecutionPlanJob _ExecutionPlanJob.BDTSTransformationAreaID = $projection.BDTSTransformationAreaID and _ExecutionPlanJob.BDTSExecPlanID = $projection.BDTSExecPlanID
[0..*] A_BDTSExecutionPlanItemLog _ExecutionPlanItemLog _ExecutionPlanItemLog.BDTSTransformationAreaID = $projection.BDTSTransformationAreaID and _ExecutionPlanItemLog.BDTSExecPlanID = $projection.BDTSExecPlanID
[0..*] A_BDTSExecutionPlanItem _ExecutionPlanItem

Annotations (9)

NameValueLevelField
EndUserText.label BDTS Execution Plan view
AccessControl.authorizationCheck #MANDATORY view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
OData.entityType.name BDTSExecutionPlan_Type view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY BDTSTransformationAreaID R_BDTSExecutionPlanHeader BDTSTransformationAreaID
KEY BDTSExecPlanID R_BDTSExecutionPlanHeader BDTSExecPlanID
BDTSExecPlanUseCase R_BDTSExecutionPlanHeader BDTSExecPlanUseCase
BDTSExecPlanStatus R_BDTSExecutionPlanHeader BDTSExecPlanStatus
BDTSExecPlanIsActive R_BDTSExecutionPlanHeader BDTSExecPlanIsActive
BDTSExecPlanHasErrorItem R_BDTSExecutionPlanHeader BDTSExecPlanHasErrorItem
BDTSExecPlanCreationDateTime R_BDTSExecutionPlanHeader BDTSExecPlanCreationDateTime
BDTSExecPlanStartDateTime R_BDTSExecutionPlanHeader BDTSExecPlanStartDateTime
BDTSExecPlanEndDateTime R_BDTSExecutionPlanHeader BDTSExecPlanEndDateTime
_ExecutionPlanItem _ExecutionPlanItem
_ExecutionPlanItemDpndcy _ExecutionPlanItemDpndcy
_ExecutionPlanJob _ExecutionPlanJob
_ExecutionPlanItemLog _ExecutionPlanItemLog 
@EndUserText.label: 'BDTS Execution Plan'
@AccessControl.authorizationCheck: #MANDATORY
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@Metadata.ignorePropagatedAnnotations:true
@VDM.viewType: #CONSUMPTION
@ObjectModel: {
   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #A,
     sizeCategory:   #L
   }
}
@OData.entityType.name: 'BDTSExecutionPlan_Type'

define root view entity A_BDTSExecutionPlan
  as select from R_BDTSExecutionPlanHeader
  //association [0..*] to A_BDTSExecutionPlanItem       as _ExecutionPlanItem       on  _ExecutionPlanItem.BDTSTransformationAreaID = $projection.BDTSTransformationAreaID

  //                                                                              and _ExecutionPlanItem.BDTSExecPlanID           = $projection.BDTSExecPlanID

  composition [0..*] of A_BDTSExecutionPlanItem       as _ExecutionPlanItem
  association [0..*] to A_BDTSExecutionPlanItemDpndcy as _ExecutionPlanItemDpndcy on  _ExecutionPlanItemDpndcy.BDTSTransformationAreaID = $projection.BDTSTransformationAreaID
                                                                                  and _ExecutionPlanItemDpndcy.BDTSExecPlanID           = $projection.BDTSExecPlanID
  association [0..*] to A_BDTSExecutionPlanJob        as _ExecutionPlanJob        on  _ExecutionPlanJob.BDTSTransformationAreaID = $projection.BDTSTransformationAreaID
                                                                                  and _ExecutionPlanJob.BDTSExecPlanID           = $projection.BDTSExecPlanID
  association [0..*] to A_BDTSExecutionPlanItemLog    as _ExecutionPlanItemLog    on  _ExecutionPlanItemLog.BDTSTransformationAreaID = $projection.BDTSTransformationAreaID
                                                                                  and _ExecutionPlanItemLog.BDTSExecPlanID           = $projection.BDTSExecPlanID
{
  key R_BDTSExecutionPlanHeader.BDTSTransformationAreaID,
  key R_BDTSExecutionPlanHeader.BDTSExecPlanID,
      R_BDTSExecutionPlanHeader.BDTSExecPlanUseCase,
      R_BDTSExecutionPlanHeader.BDTSExecPlanStatus,
      R_BDTSExecutionPlanHeader.BDTSExecPlanIsActive,
      R_BDTSExecutionPlanHeader.BDTSExecPlanHasErrorItem,
      R_BDTSExecutionPlanHeader.BDTSExecPlanCreationDateTime,
      R_BDTSExecutionPlanHeader.BDTSExecPlanStartDateTime,
      R_BDTSExecutionPlanHeader.BDTSExecPlanEndDateTime,
      _ExecutionPlanItem,
      _ExecutionPlanItemDpndcy,
      _ExecutionPlanJob,
      @ObjectModel.filter.enabled: false
      _ExecutionPlanItemLog
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"R_BDTSEXECUTIONPLANHEADER"
],
"ASSOCIATED":
[
"A_BDTSEXECUTIONPLANITEM",
"A_BDTSEXECUTIONPLANITEMDPNDCY",
"A_BDTSEXECUTIONPLANITEMLOG",
"A_BDTSEXECUTIONPLANJOB"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More