I_TRANSPORDEXECUTION

@EndUserText:   {label:              'Transportation Order: Execution'}
@ObjectModel:   {representativeKey:  'TransportationOrderEventUUID',
                 usageType:          {serviceQuality: #B,
                                      sizeCategory:   #XXL,
                                      dataClass:      #TRANSACTIONAL}}
@VDM:           {viewType:           #BASIC}
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl: {authorizationCheck: #PRIVILEGED_ONLY,
                 personalData.blocking: #('TRANSACTIONAL_DATA'),
                 privilegedAssociations:  [ '_CreatedByUser', '_LastChangedByUser',
                                            '_TransportationOrderItem', '_TransportationOrderStop' ]}
@Metadata.allowExtensions: true

define view entity I_TranspOrdExecution
  as select from /scmtms/d_torexe
  /* VDM-based Associations */
  association [1..1] to I_TransportationOrder        as _TransportationOrder           on $projection.TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID
  association [0..1] to I_TransportationOrderItem    as _TransportationOrderItem       on $projection.TransportationOrderItemUUID = _TransportationOrderItem.TransportationOrderItemUUID
  association [0..1] to I_TransportationOrderStop    as _TransportationOrderStop       on $projection.TransportationOrderStopUUID = _TransportationOrderStop.TransportationOrderStopUUID
  /* Foreign Key and Text Associations */
  association [0..1] to I_TranspOrdEventCode         as _TranspOrdEventCode            on $projection.TranspOrdEventCode = _TranspOrdEventCode.TranspOrdEventCode
  association [0..1] to I_TranspOrdEventCode         as _TranspOrdReferenceEventCode   on $projection.TranspOrdReferenceEventCode = _TranspOrdReferenceEventCode.TranspOrdEventCode
  association [0..1] to I_TranspOrdEventStatus       as _TranspOrdEventStatus          on $projection.TranspOrdEventStatus = _TranspOrdEventStatus.TranspOrdEventStatus
  association [0..1] to I_TranspOrdHasQtyDiscrepancy as _TranspOrdHasQtyDiscrepancy    on $projection.TranspOrdHasQtyDiscrepancy = _TranspOrdHasQtyDiscrepancy.TranspOrdHasQtyDiscrepancy
  association [0..1] to I_TranspOrdIsDiscrepant      as _TranspOrdIsDiscrepant         on $projection.TranspOrdIsDiscrepant = _TranspOrdIsDiscrepant.TranspOrdIsDiscrepant
  association [0..1] to I_DiscrepancyType            as _DiscrepancyType               on $projection.DiscrepancyType = _DiscrepancyType.DiscrepancyType
  association [0..1] to I_TranspOrdIsDscrptWthoutBlk as _TranspOrdIsDscrptWthoutBlk    on $projection.TranspOrdIsDscrptWthoutBlk = _TranspOrdIsDscrptWthoutBlk.TranspOrdIsDscrptWthoutBlk
  association [0..1] to I_TranspExecDscrcySubCat     as _TranspExecDscrcySubCat        on $projection.TranspOrdExecDscrcySubCat = _TranspExecDscrcySubCat.TranspOrdExecDscrcySubCat
  association [0..1] to I_TransportationActivity     as _TransportationActivity        on $projection.TransportationActivity = _TransportationActivity.TransportationActivity
  association [0..1] to I_TranspOrdEventIsRecalled   as _TranspOrdEventIsRecalled      on $projection.TranspOrdEventIsRecalled = _TranspOrdEventIsRecalled.TranspOrdEventIsRecalled
  association [0..1] to I_LocationBasic              as _LocationAdditional            on $projection.LocationAdditionalUUID = _LocationAdditional.LocationAdditionalUUID
  association [0..1] to I_User                       as _CreatedByUser                 on $projection.CreatedByUser = _CreatedByUser.UserID
  association [0..1] to I_User                       as _LastChangedByUser             on $projection.LastChangedByUser = _LastChangedByUser.UserID
  association [0..1] to I_UnitOfMeasure              as _TranspOrdExecGrossWeightUnit  on $projection.TranspOrdExecGrossWeightUnit = _TranspOrdExecGrossWeightUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure              as _TranspOrdExecGrossVolumeUnit  on $projection.TranspOrdExecGrossVolumeUnit = _TranspOrdExecGrossVolumeUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure              as _TranspOrdExecNetWeightUnit    on $projection.TranspOrdExecNetWeightUnit = _TranspOrdExecNetWeightUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure              as _TranspOrdExecQuantityUnit     on $projection.TranspOrdExecQuantityUnit = _TranspOrdExecQuantityUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure              as _TranspOrdExecAltvQtyUnit      on $projection.TranspOrdExecAltvQtyUnit = _TranspOrdExecAltvQtyUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure              as _TranspOrdExecBaseQtyUnit      on $projection.TranspOrdExecBaseQtyUnit = _TranspOrdExecBaseQtyUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure              as _TranspOrdExecTareWeightUnit   on $projection.TranspOrdExecTareWeightUnit = _TranspOrdExecTareWeightUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure              as _TranspOrdExecNumberOfCtnsUnit on $projection.TranspOrdExecNumberOfCtnsUnit = _TranspOrdExecNumberOfCtnsUnit.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure              as _TranspOrdExecDngrsGdsExmppUoM on $projection.TranspOrdExecDngrsGdsExmppUnit = _TranspOrdExecDngrsGdsExmppUoM.UnitOfMeasure
  association [0..1] to I_UnitOfMeasure              as _TranspOrdExecLengthUnit       on $projection.TranspOrdExecLengthUnit = _TranspOrdExecLengthUnit.UnitOfMeasure
  association [0..1] to I_TranspOrdExecInfoSource    as _TranspOrdExecInfoSource       on $projection.TranspOrdExecInfoSource = _TranspOrdExecInfoSource.TranspOrdExecInfoSource
{
      //Header and Links (BOBF)

      @ObjectModel.text.element:  [ 'TranspOrdExecution' ]
  key db_key                                                                               as TransportationOrderEventUUID,
      @ObjectModel.foreignKey.association: '_TransportationOrder'
      cast(parent_key as /scmtms/vdm_tor_db_key preserving type)                           as TransportationOrderUUID,
      @Semantics.text: true
      cast(execution_id as /scmtms/vdm_execution_id preserving type)                       as TranspOrdExecution,
      @ObjectModel.foreignKey.association: '_TransportationOrderStop'
      torstopuuid                                                                          as TransportationOrderStopUUID,
      @ObjectModel.foreignKey.association: '_TransportationOrderItem'
      toritmuuid                                                                           as TransportationOrderItemUUID,

      // Admin

      @Semantics.user.createdBy: true
      created_by                                                                           as CreatedByUser,
      cast(created_on as /scmtms/vdm_tm_tstmp_crt preserving type)                         as CreationDateTime,
      @Semantics.user.lastChangedBy: true
      changed_by                                                                           as LastChangedByUser,
      cast(changed_on as /scmtms/vdm_tm_tstmp_cht preserving type)                         as ChangedDateTime,

      //Event

      @ObjectModel.foreignKey.association: '_TranspOrdEventCode'
      event_code                                                                           as TranspOrdEventCode,
      @ObjectModel.foreignKey.association: '_TranspOrdEventStatus'
      event_status                                                                         as TranspOrdEventStatus,
      @ObjectModel.foreignKey.association: '_TransportationActivity'
      trans_activity                                                                       as TransportationActivity,
      @ObjectModel.foreignKey.association: '_TranspOrdEventIsRecalled'
      cast(event_revoked as /scmtms/event_revoked preserving type)                         as TranspOrdEventIsRecalled,
      event_reason_code                                                                    as TranspOrdEventReasonCode,
      @Semantics.text: true
      event_reason                                                                         as TranspOrdEventReasonDesc,
      @ObjectModel.foreignKey.association: '_TranspOrdExecInfoSource'
      cast(execinfo_source as /scmtms/execinfo_source preserving type)                     as TranspOrdExecInfoSource,
      @ObjectModel.foreignKey.association: '_TranspOrdReferenceEventCode'
      ref_event_code                                                                       as TranspOrdReferenceEventCode,

      //Duration and Dates

      cast(actual_date as /scmtms/vdm_event_actl_dtetme preserving type)                   as TranspOrdEvtActualDateTime,
      cast(actual_tzone as /scmtms/vdm_actual_timezone preserving type)                    as TranspOrdEvtActualDateTimeZone,
      cast(exp_end_date as /scmtms/vdm_expd_end_datetime preserving type)                  as TranspOrdEvtExpdEndDateTime,
      cast(estimated_date as /scmtms/vdm_estimated_datetime preserving type)               as TranspOrdEvtEstimatedDateTime,

      //Location

      cast (ext_loc_uuid as /scmtms/vdm_location_adtl_uuid preserving type)                as LocationAdditionalUUID,
      cast (_LocationAdditional.LocationUUID as /scmtms/vdm_location_uuid preserving type) as LocationUUID,

      @Semantics.geoLocation.latitude: true
      geolat                                                                               as GeographicalLocationLatitude,
      @Semantics.geoLocation.longitude: true
      geolon                                                                               as GeographicalLocationLongitude,
      geoalt                                                                               as GeographicalLocationAltitude,

      //Discrepancy

      @ObjectModel.foreignKey.association: '_TranspOrdHasQtyDiscrepancy'
      qty_discrepancy                                                                      as TranspOrdHasQtyDiscrepancy,
      @ObjectModel.foreignKey.association: '_TranspOrdIsDiscrepant'
      discrepancy                                                                          as TranspOrdIsDiscrepant,
      @ObjectModel.foreignKey.association: '_DiscrepancyType'
      discr_type                                                                           as DiscrepancyType,
      @ObjectModel.foreignKey.association: '_TranspOrdIsDscrptWthoutBlk'
      discr_no_block                                                                       as TranspOrdIsDscrptWthoutBlk,
      discr_inside_tlr                                                                     as TranspOrdIsDiscrepantWithinTol,
      @ObjectModel.foreignKey.association: '_TranspExecDscrcySubCat'
      dsc_subcat                                                                           as TranspOrdExecDscrcySubCat,

      //Quantities (for Discrepacy only)

      @Semantics.quantity.unitOfMeasure: 'TranspOrdExecGrossWeightUnit'
      //scmtms/quantity_13_3

      cast(gro_wei_val as /scmtms/vdm_exec_grss_wgt preserving type)                       as TranspOrdExecGrossWeight,
      @ObjectModel.foreignKey.association: '_TranspOrdExecGrossWeightUnit'
      cast(gro_wei_uni as /scmtms/vdm_exec_grss_wgt_unit preserving type)                  as TranspOrdExecGrossWeightUnit,
      @Semantics.quantity.unitOfMeasure: 'TranspOrdExecGrossVolumeUnit'
      cast(gro_vol_val as /scmtms/vdm_exec_grss_vol preserving type)                       as TranspOrdExecGrossVolume,
      @ObjectModel.foreignKey.association: '_TranspOrdExecGrossVolumeUnit'
      cast(gro_vol_uni as /scmtms/vdm_exec_grss_vol_unit preserving type)                  as TranspOrdExecGrossVolumeUnit,
      @Semantics.quantity.unitOfMeasure: 'TranspOrdExecNetWeightUnit'
      cast(net_wei_val as /scmtms/vdm_exec_net_wgt preserving type)                        as TranspOrdExecNetWeight,
      @ObjectModel.foreignKey.association: '_TranspOrdExecNetWeightUnit'
      cast(net_wei_uni as /scmtms/vdm_exec_net_wgt_unit preserving type)                   as TranspOrdExecNetWeightUnit,
      @Semantics.quantity.unitOfMeasure: 'TranspOrdExecQuantityUnit'
      cast(qua_pcs_val as /scmtms/vdm_exec_qty preserving type)                            as TranspOrdExecQuantity,
      @ObjectModel.foreignKey.association: '_TranspOrdExecQuantityUnit'
      cast(qua_pcs_uni as /scmtms/vdm_exec_qty_unit preserving type)                       as TranspOrdExecQuantityUnit,
      @Semantics.quantity.unitOfMeasure: 'TranspOrdExecAltvQtyUnit'
      cast(qua_pcs2_val as /scmtms/vdm_exec_qty_altv preserving type)                      as TranspOrdExecAltvQty,
      @ObjectModel.foreignKey.association: '_TranspOrdExecAltvQtyUnit'
      cast(qua_pcs2_uni as /scmtms/vdm_exec_qty_altv_unit preserving type)                 as TranspOrdExecAltvQtyUnit,
      @Semantics.quantity.unitOfMeasure: 'TranspOrdExecBaseQtyUnit'
      cast(base_uom_val as /scmtms/vdm_exec_qty_base preserving type)                      as TranspOrdExecBaseQty,
      @ObjectModel.foreignKey.association: '_TranspOrdExecBaseQtyUnit'
      cast(base_uom_uni as /scmtms/vdm_exec_qty_base_unit preserving type)                 as TranspOrdExecBaseQtyUnit,
      @Semantics.quantity.unitOfMeasure: 'TranspOrdExecTareWeightUnit'
      cast(pkgun_wei_val as /scmtms/vdm_exec_tare_wgt preserving type)                     as TranspOrdExecTareWeight,
      @ObjectModel.foreignKey.association: '_TranspOrdExecTareWeightUnit'
      cast(pkgun_wei_uni as /scmtms/vdm_exec_tare_wgt_unit preserving type)                as TranspOrdExecTareWeightUnit,
      @Semantics.quantity.unitOfMeasure: 'TranspOrdExecNumberOfCtnsUnit'
      cast(cont_cnt_val as /scmtms/vdm_exec_ctn_nmbr preserving type)                      as TranspOrdExecNumberOfCtns,
      @ObjectModel.foreignKey.association: '_TranspOrdExecNumberOfCtnsUnit'
      cast(cont_cnt_uni as /scmtms/vdm_exec_ctn_nmbr_unit preserving type)                 as TranspOrdExecNumberOfCtnsUnit,
      @Semantics.quantity.unitOfMeasure: 'TranspOrdExecDngrsGdsExmppUnit'
      cast(dg_adr_pts_val as /scmtms/vdm_dngrsgd_exmpp preserving type)                    as TranspOrdExecDngrsGdsExmpp,
      @ObjectModel.foreignKey.association: '_TranspOrdExecDngrsGdsExmppUoM'
      cast(dg_adr_pts_uni as /scmtms/vdm_dngrsgd_exmpp_unit preserving type)               as TranspOrdExecDngrsGdsExmppUnit,
      slac_val                                                                             as ShippersLoadAndCountQuantity,
      @Semantics.quantity.unitOfMeasure: 'TranspOrdExecLengthUnit'
      cast(length as /scmtms/vdm_exec_length preserving type)                              as TranspOrdExecLength,
      @Semantics.quantity.unitOfMeasure: 'TranspOrdExecLengthUnit'
      cast(width as /scmtms/vdm_exec_width preserving type)                                as TranspOrdExecWidth,
      @Semantics.quantity.unitOfMeasure: 'TranspOrdExecLengthUnit'
      cast(height as /scmtms/vdm_exec_height preserving type)                              as TranspOrdExecHeight,
      @ObjectModel.foreignKey.association: '_TranspOrdExecLengthUnit'
      cast(measuom as /scmtms/vdm_exec_length_unit preserving type)                        as TranspOrdExecLengthUnit,
      @Semantics.quantity.unitOfMeasure: 'TranspOrdExecLengthUnit'
      cast (net_duration as  /scmtms/vdm_net_duration)                                     as TranspOrdExecutionNetDuration,
      recording_method                                                                     as TranspOrdExecRecordingMethod,
      recording_person                                                                     as TranspOrdExecPersnRespRecg,
      cast(exec_role_cat as /scmtms/vdm_partner_function preserving type )                 as TranspOrdExecPartnerFunction,

      /* Associations */
      @ObjectModel.association.type:  [ #TO_COMPOSITION_ROOT, #TO_COMPOSITION_PARENT ]
      _TransportationOrder,
      _TransportationOrderStop,
      _TransportationOrderItem,
      _LocationAdditional,
      _TranspOrdEventCode,
      _TranspOrdReferenceEventCode,
      _TranspOrdEventStatus,
      _TransportationActivity,
      _TranspOrdEventIsRecalled,
      _TranspOrdHasQtyDiscrepancy,
      _TranspOrdIsDiscrepant,
      _DiscrepancyType,
      _TranspOrdIsDscrptWthoutBlk,
      _TranspExecDscrcySubCat,
      _CreatedByUser,
      _LastChangedByUser,
      _TranspOrdExecGrossWeightUnit,
      _TranspOrdExecGrossVolumeUnit,
      _TranspOrdExecNetWeightUnit,
      _TranspOrdExecQuantityUnit,
      _TranspOrdExecAltvQtyUnit,
      _TranspOrdExecBaseQtyUnit,
      _TranspOrdExecTareWeightUnit,
      _TranspOrdExecNumberOfCtnsUnit,
      _TranspOrdExecDngrsGdsExmppUoM,
      _TranspOrdExecLengthUnit,
      _TranspOrdExecInfoSource

}