I_FrtUnitBlock

DDL: I_FRTUNITBLOCK SQL: ITORFUBLK Type: view COMPOSITE

Freight Unit: Blocks

I_FrtUnitBlock is a Composite CDS View that provides data about "Freight Unit: Blocks" in SAP S/4HANA. It reads from 1 data source (I_TransportationOrderBlock) and exposes 13 fields with key field TransportationOrderBlockUUID.

1 data source(s) 13 fields

Data Sources (1)

SourceAliasJoin Type
I_TransportationOrderBlock I_TransportationOrderBlock from

Annotations (12)

NameValueLevelField
EndUserText.label Freight Unit: Blocks view
ObjectModel.representativeKey TransportationOrderBlockUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName ITORFUBLK view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.buffering.status #NOT_ALLOWED view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Metadata.allowExtensions true view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY TransportationOrderBlockUUID TransportationOrderBlockUUID
TransportationOrderUUID TransportationOrderUUID
BlockCategory BlockCategory
TranspOrdPlanningBlock TranspOrdPlanningBlock
TranspOrdExecutionIsBlocked TranspOrdExecutionIsBlocked
TranspOrdBlockIsOverruled TranspOrdBlockIsOverruled
BlockReason BlockReason
_TransportationOrder _TransportationOrder
_BlockCategory _BlockCategory
_TranspOrdPlanningBlock _TranspOrdPlanningBlock
_TranspOrdExecutionIsBlocked _TranspOrdExecutionIsBlocked
_TranspOrdBlockIsOverruled _TranspOrdBlockIsOverruled
_BlockReason _BlockReason 
@EndUserText.label: 'Freight Unit: Blocks'
@ObjectModel:   {representativeKey:  'TransportationOrderBlockUUID',
                 usageType:          {serviceQuality: #C,
                                      sizeCategory:   #XXL,
                                      dataClass:      #TRANSACTIONAL}}
@VDM:           {viewType:           #COMPOSITE}
@AbapCatalog.sqlViewName:           'ITORFUBLK'
@AbapCatalog:   {compiler:           {compareFilter: true},
                 buffering:          {status: #NOT_ALLOWED}}
@AccessControl: {authorizationCheck: #PRIVILEGED_ONLY,
                 personalData.blocking:#('TRANSACTIONAL_DATA')}
@Metadata.allowExtensions:  true
@ClientHandling.algorithm:  #SESSION_VARIABLE

define view I_FrtUnitBlock
  as select from I_TransportationOrderBlock
{
      @Consumption: { filter.hidden: true }
  key TransportationOrderBlockUUID,
      @Consumption: { filter.hidden: true }
      TransportationOrderUUID,
      BlockCategory,
      TranspOrdPlanningBlock,
      TranspOrdExecutionIsBlocked,
      TranspOrdBlockIsOverruled,
      BlockReason,

      // Assoc

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

Learn More