I_TENDERINGRESPONSE

@EndUserText:   {label:              'Tendering Reponse'}
@ObjectModel:   {representativeKey:  'TenderingResponseUUID',
                 usageType:          {serviceQuality: #B,
                                      sizeCategory:   #XL,
                                      dataClass:      #TRANSACTIONAL}}
@VDM:           {viewType:           #BASIC,
                 lifecycle.contract.type: #NONE}
@AbapCatalog:   {compiler:           {compareFilter: true},
                 sqlViewName:        'ITENDRESPONSE',
                 preserveKey:        true}
@AccessControl: {authorizationCheck: #CHECK,
                 personalData.blocking:#('TRANSACTIONAL_DATA')}
@ClientHandling.algorithm:           #SESSION_VARIABLE

define view I_TenderingResponse
  as select from /scmtms/d_tortre
  association [1..1] to I_TransportationOrder        as _TransportationOrder          on $projection.TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID
  association [1..1] to I_TenderingRequest           as _TenderingRequest             on $projection.TenderingRequestUUID = _TenderingRequest.TenderingRequestUUID
  association [0..1] to I_BusinessPartner            as _TenderingSelectedCarrierUUID on $projection.TenderingSelectedCarrierUUID = _TenderingSelectedCarrierUUID.BusinessPartnerUUID
  association [0..1] to I_TenderingAwardStatus       as _TenderingAwardStatus         on $projection.TenderingAwardStatus = _TenderingAwardStatus.TenderingAwardStatus
  association [0..1] to I_TenderingResponseCode      as _TenderingResponseCode        on $projection.TenderingResponseCode = _TenderingResponseCode.TenderingResponseCode
  association [0..1] to I_TndrgQuotationEvalResult   as _TndrgQuotationEvalResult     on $projection.TndrgQuotationEvalResult = _TndrgQuotationEvalResult.TndrgQuotationEvalResult
  association [0..1] to I_TenderingRejectionReason   as _TenderingRejectionReason     on $projection.TenderingRejectionReason = _TenderingRejectionReason.TenderingRejectionReason
  association [0..1] to I_FreightQuotationStatus     as _FreightQuotationStatus       on $projection.FreightQuotationStatus = _FreightQuotationStatus.FreightQuotationStatus
  association [0..1] to I_QuotationReviewIsRequired  as _QuotationReviewIsRequired    on $projection.QuotationReviewIsRequired = _QuotationReviewIsRequired.QuotationReviewIsRequired
  association [0..1] to I_IsProposedFreightQuotation as _IsProposedFreightQuotation   on $projection.IsProposedFreightQuotation = _IsProposedFreightQuotation.IsProposedFreightQuotation
  association [0..1] to I_Currency                   as _TndrgRspSubmdAmtCrcy         on $projection.TndrgRspSubmdAmtCrcy = _TndrgRspSubmdAmtCrcy.Currency
  association [0..1] to I_Currency                   as _TenderingPreferredCurrency   on $projection.TenderingPreferredCurrency = _TenderingPreferredCurrency.Currency
{

  key cast(db_key as /scmtms/vdm_tend_response_uuid preserving type )                       as TenderingResponseUUID,
      @ObjectModel.foreignKey.association: '_TransportationOrder'
      cast(root_key  as /scmtms/vdm_tor_db_key preserving type)                             as TransportationOrderUUID,
      @ObjectModel.foreignKey.association: '_TenderingRequest'
      cast(parent_key as /scmtms/vdm_tend_request_uuid preserving type )                    as TenderingRequestUUID,
      cast(quo_doc_id as /scmtms/vdm_tend_response preserving type )                        as TenderingResponse, 
      cast(resp_seq_nr as /scmtms/vdm_tend_resp_sqnc preserving type )                      as TenderingResponseSqncNumber,
      @ObjectModel.foreignKey.association: '_TenderingAwardStatus'
      cast(acc_result as /scmtms/vdm_tend_award_status preserving type )                    as TenderingAwardStatus,
      @ObjectModel.foreignKey.association: '_TenderingResponseCode'
      cast(response_code as /scmtms/vdm_tend_response_code preserving type )                as TenderingResponseCode,
      @ObjectModel.foreignKey.association: '_TndrgQuotationEvalResult'
      cast(eval_result as /scmtms/vdm_tend_resp_eval_res preserving type )                  as TndrgQuotationEvalResult,
      @ObjectModel.foreignKey.association: '_TenderingRejectionReason'
      cast(rej_reason_code as /scmtms/vdm_tend_rejection_rsn preserving type )              as TenderingRejectionReason,
      @ObjectModel.foreignKey.association: '_FreightQuotationStatus'
      lifecycle                                                                             as FreightQuotationStatus,
      cast(tsp_key as /scmtms/vdm_tend_tsp_key preserving type)                             as TenderingSelectedCarrierUUID,
      cast(submit_datetime as /scmtms/vdm_tend_sub_datetime preserving type)                as TenderingSubmissionDateTime,
      @Semantics.currencyCode: true
      @ObjectModel.foreignKey.association: '_TndrgRspSubmdAmtCrcy'
      cast(currcode016sub as /scmtms/vdm_tend_subm_amt_crcy preserving type)                as TndrgRspSubmdAmtCrcy,
      @Semantics.amount.currencyCode: 'TndrgRspSubmdAmtCrcy'
      cast( cast(amountsub as abap.dec(31,6)) * 10000 as  /scmtms/vdm_tend_rsp_submd_amt  ) as TndrgRspSubmdAmt,
      @Semantics.currencyCode: true
      @ObjectModel.foreignKey.association: '_TenderingPreferredCurrency'
      cast(currcode016prf as /scmtms/vdm_tend_pref_curr preserving type )                   as TenderingPreferredCurrency,
      @Semantics.amount.currencyCode: 'TenderingPreferredCurrency'
      cast( cast( amountprf as abap.dec(31,6)) * 10000 as  /scmtms/vdm_tend_submd_amt_prf ) as TndrgRspSubmdAmtInPrefCrcy,
      @ObjectModel.foreignKey.association: '_IsProposedFreightQuotation'
      cast(preselected as /scmtms/vdm_tend_rsp_presel preserving type)                      as IsProposedFreightQuotation,
      @ObjectModel.foreignKey.association: '_QuotationReviewIsRequired'
      cast(review_required as /scmtms/vdm_tend_quo_rev_rqd preserving type)                 as QuotationReviewIsRequired,
        
      /* Associations */
      _TransportationOrder,
      _TenderingRequest,
      _TenderingAwardStatus,
      _TenderingResponseCode,
      _TenderingRejectionReason,
      _TndrgQuotationEvalResult,
      _TenderingSelectedCarrierUUID,
      _FreightQuotationStatus,
      _QuotationReviewIsRequired,
      _IsProposedFreightQuotation,
      _TndrgRspSubmdAmtCrcy,
      _TenderingPreferredCurrency
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/SCMTMS/D_TORTRE"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_CURRENCY",
"I_FREIGHTQUOTATIONSTATUS",
"I_ISPROPOSEDFREIGHTQUOTATION",
"I_QUOTATIONREVIEWISREQUIRED",
"I_TENDERINGAWARDSTATUS",
"I_TENDERINGREJECTIONREASON",
"I_TENDERINGREQUEST",
"I_TENDERINGRESPONSECODE",
"I_TNDRGQUOTATIONEVALRESULT",
"I_TRANSPORTATIONORDER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/