I_TENDERINGREQUEST

CDS View

Tendering Request

I_TENDERINGREQUEST is a CDS View in S/4HANA. Tendering Request. It contains 12 fields. 6 CDS views read from this table.

Used by 6 CDS view(s) 12 fields

CDS Views using this table (6)

ViewTypeJoinVDMDescription
C_CollabnApplFrtOrdQtanStop view inner CONSUMPTION Transportation Order Stop
C_CollabnApplFrtOrdRFQStop view from CONSUMPTION Transportation Order Stop
I_TenderingRequestEnrcd view from COMPOSITE Tendering Request Enriched
P_CollabnApplFreightOrdForConf view union CONSUMPTION Private view for confirm freight order
P_CollabnApplFreightQuotation view inner CONSUMPTION
P_CollabnApplFreightRFQ1 view from CONSUMPTION

Fields (12)

KeyField CDS FieldsUsed in Views
TenderingPreferredCurrency TenderingPreferredCurrency 1
TenderingRequestedCarrier Carrier,TenderingRequestedCarrier 5
TenderingRequestEndDateTime TenderingRequestEndDateTime 1
TenderingRequestSequenceNumber TenderingRequestSequenceNumber 1
TenderingRequestStartDateTime TenderingRequestStartDateTime 1
TenderingRequestUUID FreightRequestForQuotationUUID 1
TenderingResponseDueDateTime TenderingResponseDueDateTime 1
TenderingStepUUID TenderingStepUUID 1
TenderingVisibilitySettings TenderingVisibilitySettings 3
TndrgReqAbsolutePriceLimitAmt TndrgReqAbsolutePriceLimitAmt 1
TndrgReqLifeCycleStatus TndrgReqLifeCycleStatus 1
TransportationOrderUUID TransportationOrderUUID 1 
@EndUserText:   {label:              'Tendering Request'}
@ObjectModel:   {representativeKey:  'TenderingRequestUUID',
                 usageType:          {serviceQuality: #A,
                                      sizeCategory:   #XL,
                                      dataClass:      #TRANSACTIONAL}}
@VDM:           {viewType:           #BASIC,
                 lifecycle.contract.type: #NONE}
@AbapCatalog:   {compiler:           {compareFilter: true},
                 sqlViewName:        'ITENDREQUEST',
                 preserveKey:         true}
@AccessControl: {authorizationCheck: #CHECK,
                 personalData.blocking:#('TRANSACTIONAL_DATA')}
@ClientHandling.algorithm:           #SESSION_VARIABLE

define view I_TenderingRequest
  as select from /scmtms/d_tortrq
  association [0..*] to I_TenderingResponse           as _TenderingResponse           on $projection.TenderingRequestUUID = _TenderingResponse.TenderingRequestUUID
  association [1..1] to I_TransportationOrder         as _TransportationOrder         on $projection.TransportationOrderUUID = _TransportationOrder.TransportationOrderUUID
  association [1..1] to I_TenderingStep               as _TenderingStep               on $projection.TenderingStepUUID = _TenderingStep.TenderingStepUUID
  association [0..1] to I_BusinessPartner             as _TenderingRequestedCarrier   on $projection.TenderingRequestedCarrier = _TenderingRequestedCarrier.BusinessPartner
  association [0..1] to I_TndrgReqLifeCycleStatus     as _TndrgReqLifeCycleStatus     on $projection.TndrgReqLifeCycleStatus = _TndrgReqLifeCycleStatus.TndrgReqLifeCycleStatus
  association [0..1] to I_Currency                    as _TenderingPreferredCurrency  on $projection.TenderingPreferredCurrency = _TenderingPreferredCurrency.Currency
  association [1..1] to I_TenderingVisibilitySettings as _TenderingVisibilitySettings on $projection.TenderingVisibilitySettings = _TenderingVisibilitySettings.TenderingVisibilitySettings
{

  key cast(db_key as /scmtms/vdm_tend_request_uuid preserving type )                 as TenderingRequestUUID,
      @ObjectModel.foreignKey.association: '_TransportationOrder'
      cast(root_key   as /scmtms/vdm_tor_db_key preserving type)                     as TransportationOrderUUID,
      @ObjectModel.foreignKey.association: '_TenderingStep'
      cast(parent_key as /scmtms/vdm_tend_step_uuid preserving type )                as TenderingStepUUID,
      cast ( req_nr   as /scmtms/vdm_tend_request preserving type )                  as TenderingRequest,
      cast(req_seq_nr as /scmtms/vdm_tend_request_sqnc preserving type )             as TenderingRequestSequenceNumber,
      @ObjectModel.foreignKey.association: '_TndrgReqLifeCycleStatus'
      cast(lifecycle as /scmtms/tend_req_lifecyc_stat preserving type)               as TndrgReqLifeCycleStatus,
      @ObjectModel.foreignKey.association: '_TenderingRequestedCarrier'
      cast(tsp_internal_id as /scmtms/vdm_tend_carr_req preserving type)             as TenderingRequestedCarrier,
      cast(start_datetime as /scmtms/vdm_tend_s_datetime preserving type)            as TenderingRequestStartDateTime,
      cast(end_datetime as /scmtms/vdm_tend_req_end_dttme preserving type)           as TenderingRequestEndDateTime,
      cast(resp_due_dtime as /scmtms/vdm_tend_rsp_datetime preserving type)          as TenderingResponseDueDateTime,

      @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_req_prc_amt ) as TndrgReqAbsolutePriceLimitAmt,

      @ObjectModel.foreignKey.association: '_TenderingVisibilitySettings'
      cast(visi_prof_id as /scmtms/tend_visi_prof_id preserving type )               as TenderingVisibilitySettings,

      /* Associations */
      _TransportationOrder,
      _TenderingStep,
      _TenderingResponse,
      _TndrgReqLifeCycleStatus,
      _TenderingRequestedCarrier,
      _TenderingPreferredCurrency,
      _TenderingVisibilitySettings
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/SCMTMS/D_TORTRQ"
],
"ASSOCIATED":
[
"I_BUSINESSPARTNER",
"I_CURRENCY",
"I_TENDERINGRESPONSE",
"I_TENDERINGSTEP",
"I_TENDERINGVISIBILITYSETTINGS",
"I_TNDRGREQLIFECYCLESTATUS",
"I_TRANSPORTATIONORDER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More