I_TransportationOrderStopEnrcd

DDL: I_TRANSPORTATIONORDERSTOPENRCD Type: view COMPOSITE

Transportation Order Stop enriched

I_TransportationOrderStopEnrcd is a Composite CDS View (Dimension) that provides data about "Transportation Order Stop enriched" in SAP S/4HANA. It reads from 1 data source (I_TransportationOrderStop) and exposes 11 fields with key field TransportationOrderStopUUID. It has 3 associations to related views.

1 data source(s) 11 fields

Data Sources (1)

SourceAliasJoin Type
I_TransportationOrderStop I_TransportationOrderStop from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_TransportationOrderEnrcd _TransportationOrderEnrcd $projection.TransportationOrderUUID = _TransportationOrderEnrcd.TransportationOrderUUID
[0..*] I_TranspOrdExecutionEnrcd _TranspOrdExecutionEnrcd $projection.TransportationOrderStopUUID = _TranspOrdExecutionEnrcd.TransportationOrderStopUUID
[0..1] I_LocationBasic _Location $projection.LocationUUID = _Location.LocationUUID

Annotations (13)

NameValueLevelField
EndUserText.label Transportation Order Stop enriched view
Analytics.dataCategory #DIMENSION view
Analytics.internalName #LOCAL view
ObjectModel.representativeKey TransportationOrderStopUUID view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName ITORSTOPE view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.allowExtensions true view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY TransportationOrderStopUUID TransportationOrderStopUUID
TransportationOrderUUID TransportationOrderUUID
TransportationOrderStop TransportationOrderStop
TranspOrdStopCategory TranspOrdStopCategory
LocationUUID LocationUUID
TranspOrdStopSequencePosition TranspOrdStopSequencePosition
TranspOrdStopPlanTranspDteTme TranspOrdStopPlanTranspDteTme
_TransportationOrderEnrcd _TransportationOrderEnrcd
_Location _Location
_TranspOrdExecutionEnrcd _TranspOrdExecutionEnrcd
_TranspOrdStopCategory _TranspOrdStopCategory 
@EndUserText:   {label:              'Transportation Order Stop enriched'}
@Analytics:     {dataCategory:       #DIMENSION,
                 internalName:       #LOCAL}
@ObjectModel:   {representativeKey:  'TransportationOrderStopUUID',
                 usageType:          {serviceQuality: #C,
                                      sizeCategory:   #XXL,
                                      dataClass:      #TRANSACTIONAL}}
@VDM:           {viewType:           #COMPOSITE}
@AbapCatalog:   {compiler:           {compareFilter: true},
                 sqlViewName:        'ITORSTOPE'}
@AccessControl: {authorizationCheck: #CHECK,
                 personalData.blocking: #('TRANSACTIONAL_DATA')}
@ClientHandling.algorithm:           #SESSION_VARIABLE
@Metadata.allowExtensions:           true

define view I_TransportationOrderStopEnrcd
  as select from I_TransportationOrderStop
  /* Business Object related Node Associations*/
  association [1..1] to I_TransportationOrderEnrcd as _TransportationOrderEnrcd on $projection.TransportationOrderUUID = _TransportationOrderEnrcd.TransportationOrderUUID
  association [0..*] to I_TranspOrdExecutionEnrcd  as _TranspOrdExecutionEnrcd  on $projection.TransportationOrderStopUUID = _TranspOrdExecutionEnrcd.TransportationOrderStopUUID
  association [0..1] to I_LocationBasic            as _Location                 on $projection.LocationUUID = _Location.LocationUUID
{
  key TransportationOrderStopUUID,
      @ObjectModel.foreignKey.association: '_TransportationOrderEnrcd'
      TransportationOrderUUID,
      TransportationOrderStop,
      @ObjectModel.foreignKey.association:'_TranspOrdStopCategory'
      TranspOrdStopCategory,
      LocationUUID,
      // LocationAdditionalUUID,

      TranspOrdStopSequencePosition,
      TranspOrdStopPlanTranspDteTme,

      /* Associations */
      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT ]
      _TransportationOrderEnrcd,
      _Location,
      _TranspOrdExecutionEnrcd,
      _TranspOrdStopCategory
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TRANSPORTATIONORDERSTOP"
],
"ASSOCIATED":
[
"I_LOCATIONBASIC",
"I_TRANSPORDEXECUTIONENRCD",
"I_TRANSPORDSTOPCATEGORY",
"I_TRANSPORTATIONORDERENRCD"
],
"BASE":
[
"I_TRANSPORTATIONORDERSTOP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More