I_TranspOrdStopAnalytics

@EndUserText.label:          'Transportation Order Stop Analytics'
@ClientHandling.algorithm:   #SESSION_VARIABLE

@Metadata:          {allowExtensions:             true,
                     ignorePropagatedAnnotations: true}

@AbapCatalog:       {sqlViewName:               'ITRANSPORDSTPANA',
                     compiler.compareFilter:    true,
                     buffering:                 {status: #NOT_ALLOWED},
                     preserveKey:               true}

@AccessControl:     {authorizationCheck:        #CHECK,
                     personalData.blocking:     #('TRANSACTIONAL_DATA')}

@ObjectModel:       {representativeKey:         'TransportationOrderStopUUID',
                     usageType:                 {serviceQuality: #D,
                                                 sizeCategory:   #XXL,
                                                 dataClass:      #MIXED},
                     modelingPattern:           #NONE,
                     supportedCapabilities:    [#CDS_MODELING_DATA_SOURCE,
                                                #CDS_MODELING_ASSOCIATION_TARGET,
                                                #SQL_DATA_SOURCE,
                                                #EXTRACTION_DATA_SOURCE]}

@VDM:               {viewType:                  #COMPOSITE}

@Analytics:         {dataCategory:              #DIMENSION,   // FACT,

                     dataExtraction:           {enabled: true,
                                                delta.changeDataCapture: {
                                                mapping:[
                                                          {
                                                          table: '/scmtms/d_torstp', role: #MAIN,
                                                          viewElement:  ['TransportationOrderStopUUID'],
                                                          tableElement: ['db_key']
                                                          }
                                                        ]                }
                                                },
                     internalName:                #LOCAL}

define view I_TranspOrdStopAnalytics
  as select from I_TransportationOrderStop

  /* Business Object related Node Associations*/
  association [1..1] to I_TransportationOrderAnalytics as _TransportationOrderAnalytics on $projection.TransportationOrderUUID = _TransportationOrderAnalytics.TransportationOrderUUID
  association [0..*] to I_TranspOrdExecutionAnalytics  as _TranspOrdExecutionAnalytics  on $projection.TransportationOrderStopUUID = _TranspOrdExecutionAnalytics.TransportationOrderStopUUID

  /* Foreign Key and Text Associations */
  association [0..1] to I_LocationAnalytics            as _LocationAnalytics            on $projection.TranspOrdStopLocation = _LocationAnalytics.Location

{
      /* keys and references */
      @Semantics.uuid:true
  key cast(TransportationOrderStopUUID    as /scmtms/vdm_tor_stop_db_key preserving type )   as TransportationOrderStopUUID,

      @ObjectModel.foreignKey.association: '_TransportationOrderAnalytics'
      @Semantics.uuid:true
      TransportationOrderUUID,

      @Semantics.uuid:true
      cast(TranspOrdStopStopParentUUID    as /scmtms/vdm_tor_stp_stp_p_uuid preserving type) as TranspOrdStopStopParentUUID,

      @Semantics.uuid:true
      cast(TranspOrdCapacityStopUUID      as /scmtms/vdm_tor_stp_cp_stp_key preserving type) as TranspOrdCapacityStopUUID,

      @Semantics.uuid:true
      cast(TranspOrdStopCapacityItemUUID  as /scmtms/vdm_tor_stp_cp_itm_key preserving type) as TranspOrdStopCapacityItemUUID,

      /* Stop */
      cast(TransportationOrderStop as /scmtms/vdm_tor_stop_id preserving type )              as TransportationOrderStop,

      @ObjectModel.foreignKey.association: '_TranspOrdStopCategory'
      TranspOrdStopCategory,

      @ObjectModel.foreignKey.association: '_TranspOrdStopRole'
      TranspOrdStopRole,
      TranspOrdStopSequencePosition,

      @Semantics.booleanIndicator:true
      TranspOrdStopIsEntryPort,

      @Semantics.booleanIndicator:true
      TranspOrdStopIsExitPort,

      @ObjectModel.foreignKey.association: '_TranspHndlgExecStatus'
      cast(TranspOrdStopHndlgExecStatus   as /scmtms/vdm_tor_stp_hdl_exe_st preserving type) as TranspOrdStopHndlgExecStatus,

      /* Location */
      @Semantics.uuid:true
      cast(LocationUUID                   as /scmtms/vdm_tor_stp_loc_uuid preserving type)   as TranspOrdStopLocationUUID, // (CHAR 22)


      @Semantics.uuid:true
      cast(LocationAdditionalUUID         as /scmtms/vdm_tor_stp_loc_a_uuid preserving type) as TranspOrdStopLocationAddlUUID, // (RAW 16)


      @ObjectModel.foreignKey.association: '_LocationAnalytics'
      cast(LocationId                     as /scmtms/vdm_tor_stp_loc_id preserving type)     as TranspOrdStopLocation,
      cast(TranspOrdStopLocUNCode         as /scmtms/vdm_tor_stp_loc_un_cd preserving type)  as TranspOrdStopLocUNCode,
      cast(TranspOrdStopLocIATACode       as /scmtms/vdm_tor_stp_loc_iata preserving type)   as TranspOrdStopLocIATACode,

      /* Dates */
      cast(TranspOrdStopAccptblStrtDteTme as /scmtms/vdm_tor_stp_acc_st_d_t preserving type) as TranspOrdStopAccptblStrtDteTme,
      cast(TranspOrdStopAccptblEndDteTme  as /scmtms/vdm_tor_stp_acc_en_d_t preserving type) as TranspOrdStopAccptblEndDteTme,
      cast(TranspOrdStopReqStartDteTme    as /scmtms/vdm_tor_stp_req_st_d_t preserving type) as TranspOrdStopReqStartDteTme,
      cast(TranspOrdStopReqEndDteTme      as /scmtms/vdm_tor_stp_req_en_d_t preserving type) as TranspOrdStopReqEndDteTme,
      cast(TranspOrdStopPlanTranspDteTme  as /scmtms/vdm_tor_stp_pln_tr_d_t preserving type) as TranspOrdStopPlanTranspDteTme,
      cast(TranspOrdStopPlanExecDteTme    as /scmtms/vdm_tor_stp_pln_ex_d_t preserving type) as TranspOrdStopPlanExecDteTme,
      cast(TranspOrdStopLoadStartDateTime as /scmtms/vdm_tor_stp_load_s_dt preserving type)  as TranspOrdStopLoadStartDateTime,
      cast(TranspOrdStopLoadEndDateTime   as /scmtms/vdm_tor_stp_load_e_dt preserving type)  as TranspOrdStopLoadEndDateTime,
      cast(TranspOrdStopCoupleStrtDteTme  as /scmtms/vdm_tor_stp_coupl_s_dt preserving type) as TranspOrdStopCoupleStrtDteTme,
      cast(TranspOrdStopCoupleEndDteTme   as /scmtms/vdm_tor_stp_coupl_e_dt preserving type) as TranspOrdStopCoupleEndDteTme,
      cast(TranspOrdStopCapPlngStrtDteTme as /scmtms/vdm_tor_stp_cp_pl_s_dt preserving type) as TranspOrdStopCapPlngStrtDteTme,
      cast(TranspOrdStopCapPlngEndDteTme  as /scmtms/vdm_tor_stp_cp_pl_e_dt preserving type) as TranspOrdStopCapPlngEndDteTme,
      cast(TranspOrdStopApptStrtDteTme    as /scmtms/vdm_tor_stp_appt_s_dt preserving type)  as TranspOrdStopApptStrtDteTme,
      cast(TranspOrdStopApptEndDteTme     as /scmtms/vdm_tor_stp_appt_e_dt preserving type)  as TranspOrdStopApptEndDteTme,
      cast(TranspOrdStopPrepStrtDteTme    as /scmtms/vdm_tor_stp_prep_s_dt preserving type)  as TranspOrdStopPrepStrtDteTme,
      cast(TranspOrdStopPrepEndDteTme     as /scmtms/vdm_tor_stp_prep_e_dt preserving type)  as TranspOrdStopPrepEndDteTme,
      cast(TranspStopFinalizeStrtDteTme   as /scmtms/vdm_tor_stp_final_s_dt preserving type) as TranspStopFinalizeStrtDteTme,
      cast(TranspStopFinalizeEndDteTme    as /scmtms/vdm_tor_stp_final_e_dt preserving type) as TranspStopFinalizeEndDteTme,
      cast(TranspStopCarrConfStrtDteTme   as /scmtms/vdm_tor_stp_ca_co_s_dt preserving type) as TranspStopCarrConfStrtDteTme,
      cast(TranspStopCarrConfEndDteTme    as /scmtms/vdm_tor_stp_ca_co_e_dt preserving type) as TranspStopCarrConfEndDteTme,
      cast(TranspOrdStopDteTme            as /scmtms/vdm_tor_stop_datetime preserving type)  as TranspOrdStopDteTme,

      /* Associations */
      // defined in this view

      _TransportationOrderAnalytics,
      _TranspOrdExecutionAnalytics,
      _LocationAnalytics,

      // propagated from underlying view

      _TranspOrdStopCategory,
      _TranspOrdStopRole,
      _TranspHndlgExecStatus

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_TRANSPORTATIONORDERSTOP"
],
"ASSOCIATED":
[
"I_LOCATIONANALYTICS",
"I_TRANSPHNDLGEXECSTATUS",
"I_TRANSPORDEXECUTIONANALYTICS",
"I_TRANSPORDSTOPCATEGORY",
"I_TRANSPORDSTOPROLE",
"I_TRANSPORTATIONORDERANALYTICS"
],
"BASE":
[
"I_TRANSPORTATIONORDERSTOP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/