I_TenderingStep

@EndUserText:   {label:              'Tendering Step'}
@ObjectModel:   {representativeKey:  'TenderingStepUUID',
                 usageType:          {serviceQuality: #A,
                                      sizeCategory:   #XL,
                                      dataClass:      #TRANSACTIONAL}}
@VDM:           {viewType:           #BASIC,
                lifecycle.contract.type: #NONE}
@AbapCatalog:   {compiler:           {compareFilter: true},
                 sqlViewName:        'ITENDSTEP',
                 preserveKey:         true}
@AccessControl: {authorizationCheck: #CHECK}
@ClientHandling.algorithm:           #SESSION_VARIABLE

define view I_TenderingStep
  as select from /scmtms/d_tortst
  association [0..*] to I_TenderingRequest           as _TenderingRequest           on $projection.TenderingStepUUID = _TenderingRequest.TenderingStepUUID
  association [1..1] to I_TransportationOrder        as _TransportationOrder        on $projection.TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID
  association [1..1] to I_Tendering                  as _Tendering                  on $projection.TenderingUUID = _Tendering.TenderingUUID
  association [0..1] to I_TenderingType              as _TenderingType              on $projection.TenderingType = _TenderingType.TenderingType
  association [0..1] to I_TenderingProcessMode       as _TenderingProcessMode       on $projection.TenderingProcessMode = _TenderingProcessMode.TenderingProcessMode
  association [0..1] to I_CarrierAssignmentMethod    as _CarrierAssignmentMethod    on $projection.CarrierAssignmentMethod = _CarrierAssignmentMethod.CarrierAssignmentMethod
  association [0..1] to I_TndrgStepLifeCycleStatus   as _TndrgStepLifeCycleStatus   on $projection.TndrgStepLifeCycleStatus = _TndrgStepLifeCycleStatus.TndrgStepLifeCycleStatus
  association [0..1] to I_TrAlcAndBusShrIsUpdtdByRFQ as _TrAlcAndBusShrIsUpdtdByRFQ on $projection.TrAlcAndBusShrIsUpdtdByRFQ = _TrAlcAndBusShrIsUpdtdByRFQ.TrAlcAndBusShrIsUpdtdByRFQ
  association [0..1] to I_Currency                   as _TenderingPreferredCurrency on $projection.TenderingPreferredCurrency = _TenderingPreferredCurrency.Currency
{

  key cast( db_key as /scmtms/vdm_tend_step_uuid preserving type )                        as TenderingStepUUID,
      @ObjectModel.foreignKey.association: '_TransportationOrder'
      cast( root_key  as /scmtms/vdm_tor_db_key preserving type)                          as TransportationOrderUUID,
      @ObjectModel.foreignKey.association: '_Tendering'
      cast( parent_key as /scmtms/vdm_tend_uuid preserving type )                         as TenderingUUID,
      step_seq_nr                                                                         as TenderingStepSequenceNumber,
      @ObjectModel.foreignKey.association: '_TenderingType'
      tend_type                                                                           as TenderingType,
      @ObjectModel.foreignKey.association: '_TndrgStepLifeCycleStatus'
      cast( lifecycle as /scmtms/tend_step_lifecyc_stat preserving type )                 as TndrgStepLifeCycleStatus,
      @ObjectModel.foreignKey.association: '_TenderingProcessMode'
      process_mode                                                                        as TenderingProcessMode,
      @ObjectModel.foreignKey.association: '_CarrierAssignmentMethod'
      cast( tsp_assign_meth as /scmtms/vdm_tend_carr_assgmt preserving type )             as CarrierAssignmentMethod,
      @Semantics.currencyCode: true
      @ObjectModel.foreignKey.association: '_TenderingPreferredCurrency'
      cast( currcode016 as /scmtms/vdm_tend_pref_curr preserving type )                   as TenderingPreferredCurrency,
      @Semantics.amount.currencyCode: 'TenderingPreferredCurrency'
      cast( cast( amount as abap.dec(31,6) ) * 10000 as  /scmtms/vdm_tend_prc_limit_amt ) as TndrgStepAbsltPriceLimitAmount,
      cast(rel_price_limit as /scmtms/vdm_tend_rel_prc_lmt preserving type )              as RelativePriceLimitInPercent,
      cast( max_resp_dur as /scmtms/vdm_max_rsp_durn_val preserving type )                as MaximumResponseDuration,
      @ObjectModel.foreignKey.association: '_TrAlcAndBusShrIsUpdtdByRFQ'
      cast(update_tal_bs as /scmtms/tend_update_tal_bs preserving type)                   as TrAlcAndBusShrIsUpdtdByRFQ,
      cast(start_datetime as /scmtms/vdm_tend_step_s_dtetim preserving type)              as TenderingStepStartDateTime,
      cast(end_datetime as /scmtms/vdm_tend_stp_end_dttme   preserving type)              as TenderingStepEndDateTime,

      /* Associations */
      _TransportationOrder,
      _Tendering,
      _TenderingRequest,
      _TenderingType,
      _TenderingProcessMode,
      _TndrgStepLifeCycleStatus,
      _CarrierAssignmentMethod,
      _TrAlcAndBusShrIsUpdtdByRFQ,
      _TenderingPreferredCurrency
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/SCMTMS/D_TORTST"
],
"ASSOCIATED":
[
"I_CARRIERASSIGNMENTMETHOD",
"I_CURRENCY",
"I_TENDERING",
"I_TENDERINGPROCESSMODE",
"I_TENDERINGREQUEST",
"I_TENDERINGTYPE",
"I_TNDRGSTEPLIFECYCLESTATUS",
"I_TRALCANDBUSSHRISUPDTDBYRFQ",
"I_TRANSPORTATIONORDER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/