I_TranspChargeObject

@EndUserText:   {label:              'Transportation Charge Object'}
//@ClientHandling.algorithm: #SESSION_VARIABLE

//@AbapCatalog:   { sqlViewName:        'ITCHRGOBJECT',

//                  compiler:           {compareFilter: true}}

@ObjectModel:   {compositionRoot:     true,
                 representativeKey:  'TransportationChargesObjUUID',
                 usageType:          {serviceQuality: #C,
                                      sizeCategory:   #XL,
                                      dataClass:      #TRANSACTIONAL}}
@VDM:           {viewType:           #BASIC,
                 lifecycle.contract.type: #NONE}
@AccessControl: {authorizationCheck: #PRIVILEGED_ONLY,
                 privilegedAssociations:  [ '_TranspChargeItem' ]}

define view entity I_TranspChargeObject
  as select from /scmtms/d_tchrgr
  /* Business Object related Node Associations*/
  association [0..*] to I_TranspChargeItem       as _TranspChargeItem             on $projection.TransportationChargesObjUUID = _TranspChargeItem.TransportationChargesObjUUID
  /* Foreign Key and Text Associations */
  association [0..1] to I_InvoicingStatus        as _InvoicingStatus              on $projection.InvoicingStatus = _InvoicingStatus.InvoicingStatus
  association [0..1] to I_TranspChargeCalcStatus as _TranspChargeCalcStatus       on $projection.TranspChargeCalcStatus = _TranspChargeCalcStatus.TranspChargeCalcStatus
  association [0..1] to I_CarrierInvoicingStatus as _CarrierInvoicingStatus       on $projection.CarrierInvoicingStatus = _CarrierInvoicingStatus.CarrierInvoicingStatus
  association [0..1] to I_Currency               as _TranspChargeDocumentCurrency on $projection.TranspChargeDocumentCurrency = _TranspChargeDocumentCurrency.Currency
  association [0..1] to I_Currency               as _TranspChargeLocalCurrency    on $projection.TranspChargeLocalCurrency = _TranspChargeLocalCurrency.Currency
{
  key cast(db_key as /scmtms/vdm_chrg_obj_db_key preserving type)                 as TransportationChargesObjUUID,
      host_key                                                                    as TranspChargeHostDocumentUUID, //foreign key association not unique (SFIR/CFIR) --> maybe: Create ZZI_TranspChargeObjectSFIR and CFIR with host_key foreign key

      @ObjectModel.foreignKey.association: '_TranspChargeDocumentCurrency'
      //      @Semantics.currencyCode:true // S4CE 1902

      doc_currency                                                                as TranspChargeDocumentCurrency,
      @Semantics.amount.currencyCode: 'TranspChargeDocumentCurrency' // S4CE 1902

      //cast(total_amount as /scmtms/amount preserving type) * 10000                as TranspChrgTotalAmtInDocCrcy, // S4CE 1902

      cast( cast( total_amount as abap.dec(31,6) ) * 10000 as abap.curr(31,2) )   as TranspChrgTotalAmtInDocCrcy,

      @Semantics.amount.currencyCode: 'TranspChargeDocumentCurrency'
      cast( cast( net_amount as abap.dec(31,6) ) * 10000 as abap.curr(31,2) )     as TranspChrgNetAmtInDocCrcy,

      @ObjectModel.foreignKey.association: '_TranspChargeLocalCurrency'
      //      @Semantics.currencyCode:true // S4CE 1902

      lcl_currency                                                                as TranspChargeLocalCurrency,
      @Semantics.amount.currencyCode: 'TranspChargeLocalCurrency' // S4CE 1902

      //cast(net_amount_lcl as /scmtms/amount preserving type) * 10000              as TranspChrgTotalAmtInLoclCrcy, // S4CE 1902

      cast( cast( net_amount_lcl as abap.dec(31,6) ) * 10000 as abap.curr(31,2) ) as TranspChrgTotalAmtInLoclCrcy,
      calcdate_tstmp                                                              as TranspChargeCalculationDateTme,
      @ObjectModel.foreignKey.association: '_InvoicingStatus'
      cast( invoicing   as transpchargepostingstatus )                            as InvoicingStatus,
      @ObjectModel.foreignKey.association: '_TranspChargeCalcStatus'
      calc_status                                                                 as TranspChargeCalcStatus,
      @ObjectModel.foreignKey.association: '_CarrierInvoicingStatus'
      car_invoicing                                                               as CarrierInvoicingStatus,
      tcusagecd085                                                                as TranspChargeUsage,
      exchdate_doc                                                                as ExchangeRateDate,
      /* Associations */
      _TranspChargeItem,
      _InvoicingStatus,
      _TranspChargeCalcStatus,
      _CarrierInvoicingStatus,
      _TranspChargeDocumentCurrency,
      _TranspChargeLocalCurrency
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"/SCMTMS/D_TCHRGR"
],
"ASSOCIATED":
[
"I_CARRIERINVOICINGSTATUS",
"I_CURRENCY",
"I_INVOICINGSTATUS",
"I_TRANSPCHARGECALCSTATUS",
"I_TRANSPCHARGEITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/