I_TranspOrdBlockEnrcd

DDL: I_TRANSPORDBLOCKENRCD Type: view BASIC

Transportation Order Block Enriched

I_TranspOrdBlockEnrcd is a Basic CDS View (Dimension) that provides data about "Transportation Order Block Enriched" in SAP S/4HANA. It reads from 1 data source (I_TransportationOrderBlock) and exposes 17 fields with key field TransportationOrderBlockUUID. It has 2 associations to related views.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_TransportationOrderBlock I_TransportationOrderBlock from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_TransportationOrderEnrcd _TransportationOrderEnrcd $projection.TransportationOrderUUID = _TransportationOrderEnrcd.TransportationOrderUUID
[0..1] I_TranspOrdStageEnrcd _TranspOrdStageEnrcd $projection.TranspOrdBlockedNodeUUID = _TranspOrdStageEnrcd.TransportationOrderStageUUID

Annotations (13)

NameValueLevelField
EndUserText.label Transportation Order Block Enriched view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
ObjectModel.representativeKey TransportationOrderBlockUUID view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ITORBLOCKENRCD view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY TransportationOrderBlockUUID TransportationOrderBlockUUID
TransportationOrderUUID TransportationOrderUUID
TranspOrdBlockedNodeUUID TranspOrdBlockedNodeUUID
BlockReason BlockReason
TranspOrdBlockIsOverruled TranspOrdBlockIsOverruled
TranspOrdPlanningBlock TranspOrdPlanningBlock
TranspOrdExecutionIsBlocked TranspOrdExecutionIsBlocked
InvoicingIsBlocked InvoicingIsBlocked
BlockCategory BlockCategory
_TransportationOrderEnrcd _TransportationOrderEnrcd
_TranspOrdStageEnrcd _TranspOrdStageEnrcd
_TranspOrdBlockIsOverruled _TranspOrdBlockIsOverruled
_BlockReason _BlockReason
_TranspOrdPlanningBlock _TranspOrdPlanningBlock
_TranspOrdExecutionIsBlocked _TranspOrdExecutionIsBlocked
_InvoicingIsBlocked _InvoicingIsBlocked
_BlockCategory _BlockCategory 
@EndUserText:   {label:              'Transportation Order Block Enriched'}
@Analytics:     {dataCategory:       #DIMENSION,
                 internalName:       #LOCAL}
@ObjectModel:   {representativeKey:  'TransportationOrderBlockUUID',
                 usageType:          {serviceQuality: #B,
                                      sizeCategory:   #XXL,
                                      dataClass:      #TRANSACTIONAL}}
@VDM:           {viewType:           #BASIC}
@AbapCatalog:   {compiler:           {compareFilter: true},
                 sqlViewName:        'ITORBLOCKENRCD'}
@AccessControl: {authorizationCheck: #CHECK,
                 personalData.blocking: #('TRANSACTIONAL_DATA')}
@ClientHandling.algorithm:           #SESSION_VARIABLE
@Metadata.allowExtensions:           true

define view I_TranspOrdBlockEnrcd
  as select from I_TransportationOrderBlock
  /* Business Object related Node Associations */
  association [1..1] to I_TransportationOrderEnrcd as _TransportationOrderEnrcd on $projection.TransportationOrderUUID = _TransportationOrderEnrcd.TransportationOrderUUID
  association [0..1] to I_TranspOrdStageEnrcd      as _TranspOrdStageEnrcd      on $projection.TranspOrdBlockedNodeUUID = _TranspOrdStageEnrcd.TransportationOrderStageUUID
{
  key TransportationOrderBlockUUID,
      @ObjectModel.foreignKey.association: '_TransportationOrderEnrcd'
      TransportationOrderUUID,
      TranspOrdBlockedNodeUUID,
      @ObjectModel.foreignKey.association: '_BlockReason'
      BlockReason,
      @ObjectModel.foreignKey.association: '_TranspOrdBlockIsOverruled'
      TranspOrdBlockIsOverruled,
      @ObjectModel.foreignKey.association: '_TranspOrdPlanningBlock'
      TranspOrdPlanningBlock,
      @ObjectModel.foreignKey.association: '_TranspOrdExecutionIsBlocked'
      TranspOrdExecutionIsBlocked,
      @ObjectModel.foreignKey.association: '_InvoicingIsBlocked'
      InvoicingIsBlocked,
      @ObjectModel.foreignKey.association: '_BlockCategory'
      BlockCategory,

      /* Associations */
      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT ]
      _TransportationOrderEnrcd,
      _TranspOrdStageEnrcd,
      _TranspOrdBlockIsOverruled,
      _BlockReason,
      _TranspOrdPlanningBlock,
      _TranspOrdExecutionIsBlocked,
      _InvoicingIsBlocked,
      _BlockCategory
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TRANSPORTATIONORDERBLOCK"
],
"ASSOCIATED":
[
"I_BLOCKCATEGORY",
"I_BLOCKREASONCODE",
"I_INVOICINGISBLOCKED",
"I_TRANSPORDBLOCKISOVERRULED",
"I_TRANSPORDEXECUTIONISBLOCKED",
"I_TRANSPORDPLANNINGBLOCK",
"I_TRANSPORDSTAGEENRCD",
"I_TRANSPORTATIONORDERENRCD"
],
"BASE":
[
"I_TRANSPORTATIONORDERBLOCK"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More