I_TransportationOrderStop

@EndUserText:   {label:              'Transportation Order: Stops'}
@ObjectModel:   {representativeKey:  'TransportationOrderStopUUID',
                 usageType:          {serviceQuality: #C,
                                      sizeCategory:   #XL,
                                      dataClass:      #TRANSACTIONAL}}
@VDM:           {viewType:           #BASIC}
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl: {authorizationCheck: #PRIVILEGED_ONLY,
                 personalData.blocking:#('TRANSACTIONAL_DATA'),
                 privilegedAssociations: ['_TranspOrdExecution', '_CapaStop', '_TranspOrdExecTranspActyArr', '_TranspOrdExecTranspActyDep' ]  }
@Metadata.ignorePropagatedAnnotations: true

/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ]  } */
define view entity I_TransportationOrderStop
  as select from /scmtms/d_torstp as stop
  /* Business Object related Node Associations*/
  association [1..1] to I_TransportationOrder      as _TransportationOrder        on  $projection.TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID
  association [0..*] to I_TranspOrdExecution       as _TranspOrdExecution         on  $projection.TransportationOrderStopUUID = _TranspOrdExecution.TransportationOrderStopUUID
  association [0..1] to I_TranspOrdExecTranspActy  as _TranspOrdExecTranspActyDep on  $projection.TransportationOrderStopUUID       = _TranspOrdExecTranspActyDep.TransportationOrderStopUUID
                                                                                  and _TranspOrdExecTranspActyDep.TranspOrdActivity = '03'
  association [0..1] to I_TranspOrdExecTranspActy  as _TranspOrdExecTranspActyArr on  $projection.TransportationOrderStopUUID       = _TranspOrdExecTranspActyArr.TransportationOrderStopUUID
                                                                                  and _TranspOrdExecTranspActyArr.TranspOrdActivity = '04'
  association [0..1] to I_TransportationOrderStop  as _CapaStop                   on  $projection.TranspOrdCapacityStopUUID = _CapaStop.TransportationOrderStopUUID
  association [0..1] to I_TransportationOrderStop  as _CapacityStop               on  $projection.TranspOrdCapacityStopUUID = _CapacityStop.TransportationOrderStopUUID
  association [0..1] to I_LocationBasic            as _LocationAdditional         on  $projection.LocationId             is not initial
                                                                                  and $projection.LocationId             = _LocationAdditional.Location
                                                                                  and $projection.LocationAdditionalUUID = _LocationAdditional.LocationAdditionalUUID
  association [0..1] to I_TmLocationDescription    as _Locationdescr              on  $projection.LocationId is not initial
                                                                                  and $projection.LocationId = _Locationdescr.Location
  association [0..1] to I_TmLocationDescription    as _LocationDescription        on  $projection.LocationId is not initial
                                                                                  and $projection.LocationId = _LocationDescription.Location
  association [0..1] to I_TransportationLocationVH as _LocationVH                 on  $projection.LocationId = _LocationVH.Location
  association [0..1] to I_TranspOrdStopCategory    as _TranspOrdStopCategory      on  $projection.TranspOrdStopCategory = _TranspOrdStopCategory.TranspOrdStopCategory
  association [0..1] to I_TranspOrdStopRole        as _TranspOrdStopRole          on  $projection.TranspOrdStopRole = _TranspOrdStopRole.TranspOrdStopRole
  association [0..1] to I_TranspHndlgExecStatus    as _TranspHndlgExecStatus      on  $projection.TranspOrdStopHndlgExecStatus = _TranspHndlgExecStatus.TranspOrdStopHndlgExecStatus
{
      @ObjectModel.text.element:  [ 'TransportationOrderStop' ]
  key db_key                                                                              as TransportationOrderStopUUID,
      @ObjectModel.foreignKey.association: '_TransportationOrder'
      cast(parent_key as /scmtms/vdm_tor_db_key preserving type)                          as TransportationOrderUUID,
      @Semantics.text: true
      stop_id                                                                             as TransportationOrderStop,
      @ObjectModel.foreignKey.association: '_TranspOrdStopCategory'
      stop_cat                                                                            as TranspOrdStopCategory,
      @ObjectModel.foreignKey.association: '_LocationAdditional'
      cast(log_loc_uuid as /scmtms/vdm_location_adtl_uuid preserving type)                as LocationAdditionalUUID,
      cast(_LocationAdditional.LocationUUID as /scmtms/vdm_location_uuid preserving type) as LocationUUID,
      @Consumption.valueHelp: '_LocationVH'
      log_locid                                                                           as LocationId,
      log_locun                                                                           as TranspOrdStopLocUNCode,
      log_lociata                                                                         as TranspOrdStopLocIATACode,
      stop_parent_key                                                                     as TranspOrdStopStopParentUUID,
      stop_seq_pos                                                                        as TranspOrdStopSequencePosition,
      cast(acc_start as log_created_on preserving type)                                   as TranspOrdStopAccptblStrtDteTme,
      cast(req_start as log_created_on preserving type)                                   as TranspOrdStopReqStartDteTme,
      cast(req_end   as log_created_on preserving type)                                   as TranspOrdStopReqEndDteTme,
      cast(acc_end   as log_created_on preserving type)                                   as TranspOrdStopAccptblEndDteTme,
      cast(plan_trans_time as log_created_on preserving type)                             as TranspOrdStopPlanTranspDteTme,
      @ObjectModel.foreignKey.association: '_TranspOrdStopRole'
      stop_role                                                                           as TranspOrdStopRole,
      cast(appointment_start as log_created_on preserving type)                           as TranspOrdStopApptStrtDteTme,
      cast(appointment_end   as log_created_on preserving type)                           as TranspOrdStopApptEndDteTme,
      cast(carr_conf_start   as log_created_on preserving type)                           as TranspStopCarrConfStrtDteTme,
      cast(carr_conf_end     as log_created_on preserving type)                           as TranspStopCarrConfEndDteTme,
      cast(prepare_start     as log_created_on preserving type)                           as TranspOrdStopPrepStrtDteTme,
      cast(prepare_end       as log_created_on preserving type)                           as TranspOrdStopPrepEndDteTme,
      cast(finalize_start    as log_created_on preserving type)                           as TranspStopFinalizeStrtDteTme,
      cast(finalize_end      as log_created_on preserving type)                           as TranspStopFinalizeEndDteTme,
      cast(
        case when _TranspOrdExecTranspActyArr.TranspOrdEvtActualDateTime > _TranspOrdExecTranspActyDep.TranspOrdEvtActualDateTime then _TranspOrdExecTranspActyArr.TranspOrdEvtActualDateTime
             else  _TranspOrdExecTranspActyDep.TranspOrdEvtActualDateTime
             end as log_created_on preserving type)                                       as TranspOrdStopPlanExecDteTme,
      @ObjectModel.foreignKey.association: '_TranspHndlgExecStatus'
      handling_exec                                                                       as TranspOrdStopHndlgExecStatus,
      cast(aggr_assgn_start_l as log_created_on preserving type)                          as TranspOrdStopLoadStartDateTime,
      cast(aggr_assgn_end_l   as log_created_on preserving type)                          as TranspOrdStopLoadEndDateTime,
      cast(aggr_assgn_start_c as log_created_on preserving type)                          as TranspOrdStopCoupleStrtDteTme,
      cast(aggr_assgn_end_c   as log_created_on preserving type)                          as TranspOrdStopCoupleEndDteTme,
      entry_port                                                                          as TranspOrdStopIsEntryPort,
      exit_port                                                                           as TranspOrdStopIsExitPort,
      assgn_stop_key                                                                      as TranspOrdCapacityStopUUID,
      assgn_item_key                                                                      as TranspOrdStopCapacityItemUUID,
      cast(assgn_start as log_created_on preserving type)                                 as TranspOrdStopCapPlngStrtDteTme,
      cast(assgn_end   as log_created_on preserving type)                                 as TranspOrdStopCapPlngEndDteTme,

      cast(cutoff_doc as log_created_on preserving type )                                 as TranspOrdStopDocCutOffDateTime,
      cast(cutoff_cargo as log_created_on preserving type )                               as TranspOrdStopCrgoCutOffDteTme,
      cast(cutoff_carr_vgm as log_created_on preserving type )                            as TranspOrdStopVGMCutOffDateTime,
      @Semantics.booleanIndicator: true
      blk_exec                                                                            as TranspOrdStopExecIsBlocked,

      case // In case we have an actual date/time for departure, this is used as TranspOrdStopDteTme. otherwise the  plan_trans_time is used as fallback

        when stop_cat = 'O' and _TranspOrdExecTranspActyDep.TranspOrdEvtActualDateTime is not initial then _TranspOrdExecTranspActyDep.TranspOrdEvtActualDateTime
        when stop_cat = 'I' and _TranspOrdExecTranspActyArr.TranspOrdEvtActualDateTime is not initial then _TranspOrdExecTranspActyArr.TranspOrdEvtActualDateTime
        else cast(plan_trans_time as log_created_on preserving type)
      end                                                                                 as TranspOrdStopDteTme,

      // Warehouse Information for ASR Cockpit

      wh_number                                                                           as TranspOrdStopWrhsNmbr,
      wh_cat                                                                              as TranspOrdStopWrhsCat,
      load_point_id                                                                       as TranspOrdStopLoadingPointID,
      wh_door                                                                             as TranspOrdStopWrhsDoorID,
      wh_door_status                                                                      as TranspOrdStopWrhsDoorStatus,
      asr_indicator                                                                       as TranspOrdStopASRRelevance,
      

      /* Associations */
      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT ]
      _TransportationOrder,
      _CapaStop,
      _CapacityStop,
      _LocationAdditional,
      _Locationdescr,
      _LocationDescription,
      _TranspOrdExecution,
      _TranspOrdExecTranspActyDep,
      _TranspOrdExecTranspActyArr,
      _TranspOrdStopCategory,
      _TranspOrdStopRole,
      _TranspHndlgExecStatus,
      _LocationVH
}