C_TranspChargeItemElement

@EndUserText.label: 'Transportation Charge Item Element'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog:   {sqlViewName: 'CTCHRGITEMELEM' ,
                 compiler.compareFilter: true,
                 preserveKey:        true                }
@ObjectModel:   {representativeKey:  'TranspChargeItemElementUUID',
                 usageType:          { serviceQuality: #D,
                                       sizeCategory:   #XXL,
                                       dataClass:      #MIXED}}
@AccessControl: {authorizationCheck: #PRIVILEGED_ONLY,
                 privilegedAssociations:  [ '_TranspChargeObject',
                                            '_TranspChargeCalcRule',
                                            '_TranspChargeCalcBase'],
                 personalData.blocking:  #('TRANSACTIONAL_DATA')}
@VDM:           {viewType:          #CONSUMPTION}
@Metadata.allowExtensions: true

define view C_TranspChargeItemElement
  as select from I_TransportationChargeElement
  /* Business Object related Node Associations*/
  association [1..1] to C_TranspChargeObject             as _TranspChargeObject      on $projection.TransportationChargesObjUUID = _TranspChargeObject.TransportationChargesObjUUID
  association [0..*] to C_TranspChargeCalcBase           as _TranspChargeCalcBase    on $projection.TranspChargeItemElementUUID = _TranspChargeCalcBase.TranspChargeItemElementUUID
  association [0..*] to C_TranspChargeCalcRule           as _TranspChargeCalcRule    on $projection.TranspChargeItemElementUUID = _TranspChargeCalcRule.TranspChargeItemElementUUID
//  association        to parent C_FrtOrdGenDataBasicFacts as _FrtOrdGenDataBasicFacts on $projection.transpchargehostdocumentuuid = _FrtOrdGenDataBasicFacts.TransportationOrderUUID

  /* Foreign Key and Text Associations */
  association [0..*] to I_OTRText                        as _OTRText                 on _OTRText.OnlnTxtRpstryConceptID = '40F2E9AFC5011ED8BA840937780C5DE1'
{
  key TranspChargeElementUUID                                                                                                           as TranspChargeItemElementUUID,
      TransportationChargeUUID                                                                                                          as TransportationChargesObjUUID,
      TranspChrgElmntCalcShtLineNo                                                                                                      as TranspChargeCalcSheetLineNmbr,
      _TranspChargeObject.TranspChargeHostDocumentUUID,
      TranspChargeInstrnType,
      @ObjectModel.text.element: ['TranspChargeTypeDesc']
      TranspChargeElementType                                                                                                           as TranspChargeType,
      @Semantics.text: true
      cast(_TranspChargeElementType._Text[1: Language = $session.system_language].TranspChargeTypeDesc as /scmtms/charge_desc preserving type) as TranspChargeTypeDesc,
      @ObjectModel.text.element: ['TranspChargeCalcReslnBaseDesc']
      TranspChrgElmntCalcResBase                                                                                                        as TranspChargeCalcReslnBase,
      @Semantics.text: true
      _TranspChargeCalcReslnBase._Text[1: Language = $session.system_language].TranspChargeCalcReslnBaseDesc,
      @Semantics.amount.currencyCode: 'TranspChargeCalcdAmountCrcy'
      cast(TranspChrgElmntCalcAmount as /scmtms/vdm_calc_amount)                                                                        as TranspChargeCalcdAmount,
      TranspChrgElmntCalcAmtCrcy                                                                                                        as TranspChargeCalcdAmountCrcy,
      TranspChrgElmntLoglRefDesc                                                                                                        as TranspChrgLogisticalRefDesc,
      TranspChrgElmntRateAmtCrcy                                                                                                        as TranspChrgRateCurrency,
      @Semantics.amount.currencyCode: 'TranspChrgRateCurrency'
      cast(TranspChrgElmntRateAmount as /scmtms/vdm_rate_amount)                                                                        as TranspChrgRateAmount,
      cast(TranspChrgElmntLineNumber as /scmtms/vdm_trchrg_line_no)                                                                     as TranspChrgLineNumber,
      cast(TranspChrgElmntRefFrmLineNmbr as /scmtms/vdm_trchrg_ref_item)                                                                as TranspChrgRefFromLineNumber,
      TranspChrgElmntDocCurrency                                                                                                        as TranspChargeDocumentCurrency,
      @Semantics.amount.currencyCode: 'TranspChargeDocumentCurrency'
      cast(TranspChrgElmntAmtInDocCrcy as /scmtms/vdm_doc_amount)                                                                       as TranspChrgAmountInDocCurrency,
      TranspChrgElmntLoclCurrency                                                                                                       as TranspChargeLocalCurrency,
      @Semantics.amount.currencyCode: 'TranspChargeLocalCurrency'
      cast(TranspChrgElmntAmtInLoclCrcy as /scmtms/vdm_local_amount)                                                                    as TranspChrgAmountInLoclCurrency,
      TranspChrgElmntCalcMethType                                                                                                       as TranspCalculationMethodType,
      TranspChrgElmntCalcMethName                                                                                                       as TranspCalculationMethodName,
      cast(_TranspChargeExchRate.TranspChrgExchangeRate as abap.dec( 28, 5 ) )                                                          as TranspChrgExchangeRate,
      TranspChrgElmntIsMandatory                                                                                                        as TranspChargeIsMandatory,
      @ObjectModel.text.element: ['ExchangeRateTypeName']
      _TranspChargeExchRate.TranspChrgExchangeRateType                                                                                  as TranspChrgExchangeRateType,
      @Semantics.text: true
      _TranspChargeExchRate._TranspChrgExchangeRateType._Text[1: Language = $session.system_language].ExchangeRateTypeName,
      _TranspChargeExchRate.ExchangeRateDate                                                                                            as ExchangeRateDate,
      @ObjectModel.text.element: ['TranspDimnWeightProfDesc']
      _TranspDimnWeightProfile.TranspDimnWeightProfile                                                                                  as TranspDimnWeightProfile,
      _TranspDimnWeightProfile._Text[1: Language = $session.system_language].TranspDimnWeightProfDesc,
      cast( case
      when TranspChrgElmntRateAmtCrcy is not initial and TranspChrgElmntRateAmtCrcy <> '%' and TranspChrgElmntDocCurrency is not initial
           and (TranspChrgElmntRateAmtCrcy <> TranspChrgElmntDocCurrency)
      then concat_with_space( TranspChrgElmntRateAmtCrcy,
                              concat_with_space(_OTRText[1: Language = $session.system_language].Text, TranspChrgElmntDocCurrency, 2 ), 2)
      else ' ' end as /scmtms/vdm_curr_conv_from_to)                                                                                    as TranspChargeRateToDocCrcy,
      _TranspChargeCalcRule[1: TranspChargeItemElementUUID = TranspChargeItemElementUUID ].TranspChrgDataSourceQuantity,
      _TranspChargeCalcRule[1: TranspChargeItemElementUUID = TranspChargeItemElementUUID ].TranspChrgCalcRuleUnit,
      _TranspChargeCalcRule[1: TranspChargeItemElementUUID = TranspChargeItemElementUUID ].TranspChrgPricePerQuantity,
      TranspChargeCalcStatus,
      case TranspChargeCalcStatus
                  when '03' then 1
                  when '05' then 2
                  else 3
                  end                                                                                                                   as TranspChargeCalcStsCriticality,
      @ObjectModel.text.element: ['TranspCalculationDateTypeDesc']
      TranspChrgElmntCalcDateType                                                                                                       as TranspCalculationDateType,
      @Semantics.text: true
      _TranspChrgElmntCalcDateType._Text[1: Language = $session.system_language ].TranspCalculationDateTypeDesc,
      TranspChrgElmntCalcDateTime                                                                                                       as TranspChargeItmElmntCalcDteTme,
      cast(tstmp_to_dats(TranspChrgElmntCalcDateTime,
                  abap_system_timezone( $session.client,'NULL' ),
                 $session.client,
                 'NULL' ) as /scmtms/vdm_calc_date)                                                                                     as TranspChargeCalculationDate,
      TranspChrgElmntRateUUID                                                                                                           as TransportationRateUUID,
      @ObjectModel.text.element: ['TranspRateTableDesc']
      @Consumption.semanticObject: 'TransportationRateTable'
      case when _TranspChrgElmntRate.TranspCalculationSheetUUID = hextobin('00000000000000000000000000000000')
                 then TranspRateTableID 
                 else ' ' end                                                                                                           as TransportationRate, 
      @Semantics.text: true
      _TranspChrgElmntRate._TranspRateTableText.TranspRateTableDesc,                            
                                                                            
      /* Associations */
      _TranspChargeObject,
      _TranspChargeCalcBase,
      _TranspChargeCalcRule,
      _TranspChrgElmntCalcMethType
      //_FrtOrdGenDataBasicFacts,

}