C_TranspChargeObject

@EndUserText:   {label:              'Transportation Charge Object'}
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog:   {sqlViewName:        'CTCHRGOBJECT',
                 compiler.compareFilter: true}
@ObjectModel:   {compositionRoot: true,
                 representativeKey:  'TransportationChargesObjUUID',
                 usageType:          {serviceQuality: #C,
                                      sizeCategory:   #XL,
                                      dataClass:      #TRANSACTIONAL}}
@VDM:           {viewType:           #CONSUMPTION}
@AccessControl: {authorizationCheck: #PRIVILEGED_ONLY,
                personalData.blocking:  #('TRANSACTIONAL_DATA')}
@Metadata.allowExtensions: true
define view C_TranspChargeObject
  as select from I_TransportationCharge
  /* Business Object related Node Associations*/
//  association [0..1] to I_BusinessPartner         as _BusinessPartner         on $projection.businesspartner = _BusinessPartner.BusinessPartner

  association [0..*] to C_TranspChargeItemElement as _TranspChargeItemElement on $projection.TransportationChargesObjUUID = _TranspChargeItemElement.TransportationChargesObjUUID
  association [0..*] to I_OTRText                 as _OTRText                 on _OTRText.OnlnTxtRpstryConceptID = '40F2E9AFC5011ED8BA840937780C5DE1'
{
  key TransportationChargeUUID                                                                                                                                  as TransportationChargesObjUUID,
      TranspChargeHostDocumentUUID,
      @ObjectModel.foreignKey.association: '_TranspChargeDocumentCurrency'
      @Semantics.currencyCode:true
      TranspChargeDocumentCurrency,
      @Semantics.amount.currencyCode: 'TranspChargeDocumentCurrency'
      TranspChrgTotalAmtInDocCrcy                                                                                                                               as TranspChrgTotalAmtInDocCrcy,
      TranspChargeLocalCurrency,
      @Semantics.amount.currencyCode: 'TranspChargeLocalCurrency'
      TranspChrgTotalAmtInLoclCrcy                                                                                                                              as TranspChrgTotalAmtInLoclCrcy,
      TranspChargeCalculationDateTme,
      tstmp_to_dats(TranspChargeCalculationDateTme,
                   abap_system_timezone( $session.client,'NULL' ),
                 $session.client,
                 'NULL' )                                                                                                                                       as TranspChargeCalculationDate,

      // @ObjectModel.text.element: ['InvoicingStatusDesc']

      // InvoicingStatus,

      // _InvoicingStatus._Text[1: Language = $session.system_language].InvoicingStatusDesc,

      @ObjectModel.text.element: ['TranspChargeCalcStatusDesc']
      TranspChargeCalcStatus,
      case TranspChargeCalcStatus
      when '01' then 2
      when '02' then 3
      else 1 end                                                                                                                                                as TranspChargeCalcStsCriticality,
      _TranspChargeCalcStatus._Text[1: Language = $session.system_language].TranspChargeCalcStatusDesc,
      // @ObjectModel.text.element: ['CarrierInvoicingStatusDesc']

      // CarrierInvoicingStatus,

      // _CarrierInvoicingStatus._Text[1: Language = $session.system_language].CarrierInvoicingStatusDesc,

      TranspChargeUsage,
//      @ObjectModel.foreignKey.association: '_BusinessPartner'

//      _TranspChargeItem[1:TransportationChargesObjUUID = TransportationChargesObjUUID]._BusinessPartner.BusinessPartner,

//      //TransportationAgreementUUID field is required for navigation to the agreement details page when the agreement link is clicked on FO

//      _TranspChargeItem[1:TransportationChargesObjUUID = TransportationChargesObjUUID].TransportationAgreementUUID,

//      @Consumption.semanticObject:'FreightAgreement'

//      _TranspChargeItem[1:TransportationChargesObjUUID = TransportationChargesObjUUID]._TransportationAgreement.TransportationAgreement,

//      _TranspChargeItem[1:TransportationChargesObjUUID = TransportationChargesObjUUID].ExchangeRateDate,

//      @ObjectModel.text.element: ['TranspDimnWeightProfDesc']

//      _TranspChargeItem[1:TransportationChargesObjUUID = TransportationChargesObjUUID].TranspDimnWeightProfile,

//      _TranspChargeItem[1:TransportationChargesObjUUID = TransportationChargesObjUUID]._TranspDimnWeightProfile._Text[1: Language = $session.system_language].TranspDimnWeightProfDesc,

//      cast(_TranspChargeItem[1:TransportationChargesObjUUID = TransportationChargesObjUUID]._TranspChargeExchRate.TranspChrgExchangeRate  as abap.dec( 28, 5 )) as TranspChrgExchangeRate,

//      @ObjectModel.text.element: ['ExchangeRateTypeName']

//      _TranspChargeItem[1:TransportationChargesObjUUID = TransportationChargesObjUUID]._TranspChargeExchRate.TranspChrgExchangeRateType,

//      @Semantics.text: true

//      _TranspChargeItem[1:TransportationChargesObjUUID = TransportationChargesObjUUID]._TranspChargeExchRate._TranspChrgExchangeRateType._Text[1: Language = $session.system_language].ExchangeRateTypeName,

      case
      when TranspChargeDocumentCurrency <> TranspChargeLocalCurrency
      then concat_with_space(TranspChargeDocumentCurrency,
                         concat_with_space(_OTRText[1: Language = $session.system_language].Text, TranspChargeLocalCurrency, 2 ), 2)
      else ' ' end                                                                                                                                              as TranspChargeLocalToDocCrcy,
//      @ObjectModel.text.element: ['PaymentTermsName']

//      _TranspChargeItem[1:TransportationChargesObjUUID = TransportationChargesObjUUID].PaymentTerms,

//      @Semantics.text: true

//      _TranspChargeItem[1:TransportationChargesObjUUID = TransportationChargesObjUUID]._Text[1: Language = $session.system_language].PaymentTermsName,

      /* Associations */
      //@ObjectModel.association.type:  [ #TO_COMPOSITION_CHILD ]

      _TranspChargeItemElement,
      _TranspChargeCalcStatus,
      _TranspChargeDocumentCurrency,
      _TranspChargeLocalCurrency
//      _BusinessPartner

}
where
  TranspChargeUsage = ''