I_TranspOrdBlockAnalytics

DDL: I_TRANSPORDBLOCKANALYTICS Type: view COMPOSITE

Transportation Order Block Analytics

I_TranspOrdBlockAnalytics is a Composite CDS View that provides data about "Transportation Order Block Analytics" in SAP S/4HANA. It reads from 1 data source (I_TransportationOrderBlock) and exposes 16 fields with key fields TranspOrderBlockNodeKeyUUID, TransportationOrderBlockUUID. It has 2 associations to related views.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_TransportationOrderBlock I_TransportationOrderBlock from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_TransportationOrderAnalytics _TransportationOrderAnalytics $projection.TransportationOrderUUID = _TransportationOrderAnalytics.TransportationOrderUUID
[0..1] I_TranspOrdStageAnalytics _TranspOrdStageAnalytics $projection.TransportationOrderStageUUID = _TranspOrdStageAnalytics.TransportationOrderStageUUID

Annotations (15)

NameValueLevelField
EndUserText.label Transportation Order Block Analytics view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
AbapCatalog.sqlViewName ITRANSPORDBLKANA view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.modelingPattern #NONE view
VDM.viewType #COMPOSITE view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY TranspOrderBlockNodeKeyUUID TranspOrderBlockNodeKeyUUID
KEY TransportationOrderBlockUUID TransportationOrderBlockUUID
TransportationOrderUUID TransportationOrderUUID
TranspOrdBlockedNodeUUID TranspOrdBlockedNodeUUID
TranspOrdBlockCategory
TranspOrdBlockReason
TranspOrdBlockIsOverruled
TranspOrdPlanningBlock
TranspOrdExecutionIsBlocked
_TransportationOrderAnalytics _TransportationOrderAnalytics
_TranspOrdStageAnalytics _TranspOrdStageAnalytics
_TranspOrdBlockCategory _BlockCategory
_TranspOrdBlockReason _BlockReason
_TranspOrdBlockIsOverruled _TranspOrdBlockIsOverruled
_TranspOrdPlanningBlock _TranspOrdPlanningBlock
_TranspOrdExecutionIsBlocked _TranspOrdExecutionIsBlocked 
@EndUserText.label: 'Transportation Order Block Analytics'
@ClientHandling.algorithm:   #SESSION_VARIABLE

//@Metadata:          {allowExtensions:             true,

@Metadata:          {ignorePropagatedAnnotations: true}

@AbapCatalog:       {sqlViewName:                 'ITRANSPORDBLKANA',
                     compiler.compareFilter:      true,
                     buffering:                   {status: #NOT_ALLOWED},
                     preserveKey:                 true}

@AccessControl:     {authorizationCheck:          #CHECK,
                     personalData.blocking:       #('TRANSACTIONAL_DATA')}

//@ObjectModel:       {representativeKey:           'TransportationOrderBlockUUID',

@ObjectModel:       {usageType:                   {serviceQuality: #D,
                                                   sizeCategory:   #XXL,
                                                   dataClass:      #MIXED},
                     modelingPattern:             #NONE,
                     supportedCapabilities:      [#CDS_MODELING_DATA_SOURCE,
                                                  #CDS_MODELING_ASSOCIATION_TARGET,
                                                  #SQL_DATA_SOURCE,
                                                  #EXTRACTION_DATA_SOURCE]}

@VDM:               {viewType:                    #COMPOSITE}

//@Analytics.dataCategory:                        #DIMENSION

// view cannot be used as dimension in a Cube. Use view with 1 key field instead

@Analytics:         {dataExtraction:              {enabled: true,
                                                   delta.changeDataCapture: {
                                                               mapping:[
                    {
                    table: '/scmtms/d_torblk', role: #MAIN,
                    viewElement:  ['TranspOrderBlockNodeKeyUUID', 'TransportationOrderBlockUUID'],
                    tableElement: ['node_key', 'db_key']
                    }
                                                                       ]}
                                                  },
                     internalName:                #LOCAL}


define view I_TranspOrdBlockAnalytics
  as select from I_TransportationOrderBlock

  /* Business Object related Node Associations */
  association [1..1] to I_TransportationOrderAnalytics as _TransportationOrderAnalytics on $projection.TransportationOrderUUID = _TransportationOrderAnalytics.TransportationOrderUUID
  association [0..1] to I_TranspOrdStageAnalytics      as _TranspOrdStageAnalytics      on $projection.TransportationOrderStageUUID = _TranspOrdStageAnalytics.TransportationOrderStageUUID
{
      @Semantics.uuid:true
  key TranspOrderBlockNodeKeyUUID,
      @Semantics.uuid:true
  key TransportationOrderBlockUUID,
      @ObjectModel.foreignKey.association: '_TransportationOrderAnalytics'
      TransportationOrderUUID,
      // Blocked Node ID = Root (if = TOR UUID) or Stage (if <> TOR UUID)

      TranspOrdBlockedNodeUUID,
      @ObjectModel.foreignKey.association: '_TranspOrdStageAnalytics'
      cast(case when TranspOrdBlockedNodeUUID <> TransportationOrderUUID
        then TranspOrdBlockedNodeUUID
      // else

      end as /scmtms/vdm_tor_stage_db_key preserving type)                             as TransportationOrderStageUUID,

      @ObjectModel.foreignKey.association: '_TranspOrdBlockCategory'
      cast(BlockCategory as /scmtms/vdm_block_category preserving type)                as TranspOrdBlockCategory,
      @ObjectModel.foreignKey.association: '_TranspOrdBlockReason'
      cast(BlockReason as /scmtms/vdm_block_reason preserving type)                    as TranspOrdBlockReason,
      @Semantics.booleanIndicator: true
      @ObjectModel.foreignKey.association: '_TranspOrdBlockIsOverruled'
      cast(TranspOrdBlockIsOverruled as /scmtms/vdm_block_overruled preserving type)   as TranspOrdBlockIsOverruled,
      @Semantics.booleanIndicator: true
      @ObjectModel.foreignKey.association: '_TranspOrdPlanningBlock'
      cast(TranspOrdPlanningBlock as /scmtms/vdm_block_planning preserving type)       as TranspOrdPlanningBlock,
      @Semantics.booleanIndicator: true
      @ObjectModel.foreignKey.association: '_TranspOrdExecutionIsBlocked'
      cast(TranspOrdExecutionIsBlocked as /scmtms/vdm_block_execution preserving type) as TranspOrdExecutionIsBlocked,


      /* Associations */
      // defined in this view

      _TransportationOrderAnalytics,
      _TranspOrdStageAnalytics,
      // propagated from underlying view

      _BlockCategory                                                                   as _TranspOrdBlockCategory,
      _BlockReason                                                                     as _TranspOrdBlockReason,
      _TranspOrdBlockIsOverruled,
      _TranspOrdPlanningBlock,
      _TranspOrdExecutionIsBlocked
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TRANSPORTATIONORDERBLOCK"
],
"ASSOCIATED":
[
"I_BLOCKCATEGORY",
"I_BLOCKREASONCODE",
"I_TRANSPORDBLOCKISOVERRULED",
"I_TRANSPORDEXECUTIONISBLOCKED",
"I_TRANSPORDPLANNINGBLOCK",
"I_TRANSPORDSTAGEANALYTICS",
"I_TRANSPORTATIONORDERANALYTICS"
],
"BASE":
[
"I_TRANSPORTATIONORDERBLOCK"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More