SADL_V_EXP_SO_rootView

@AbapCatalog.sqlViewName: 'SADL_V_E_SOROOT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'CDS View Testing UI Annotations'
@AbapCatalog.preserveKey: true

@Search.searchable: true


define root view SADL_V_EXP_SO_rootView
  as select from snwd_so
{
      @UI.lineItem: { position: 10, label: 'Sales Order' }
      @Search.ranking: #HIGH
  key snwd_so.so_id               as SalesOrder,

      @UI.selectionField:{position: 10}
      @UI.textArrangement: #TEXT_ONLY
      @ObjectModel.text.element:  'CurrencyText'
      @Semantics.currencyCode: true
      snwd_so.currency_code       as CurrencyCode,

      'CurrText'                  as CurrencyText,

      @Semantics.amount.currencyCode: 'CurrencyCode'
      @EndUserText.label: 'Customer Name'
      @UI.lineItem: { position: 20, label: 'Gross Amount' }
      @UI.dataPoint: { title: 'GrossAmount',
                       description: 'The gross amount',
                       longDescription: 'The gross amount of the sales order',
                       valueFormat:{scaleFactor:1000,numberOfFractionalDigits:0},
                       referencePeriod:{description: 'Reference period'}
                      }
      snwd_so.gross_amount        as GrossAmount,

      @UI.lineItem: { position: 30, label: 'Net Amount' }
      @Semantics.amount.currencyCode: 'CurrencyCode'
      @UI.dataPoint: { title: 'NetAmount', valueFormat:{scaleFactor:1000,numberOfFractionalDigits:1} }
      @UI.selectionField:{position: 20}
      snwd_so.net_amount          as NetAmount,

      @UI.lineItem: { position: 40, label: 'Tax Amount' }
      @Semantics.amount.currencyCode: 'CurrencyCode'
      @UI.dataPoint: { valueFormat:{scaleFactor:1000,numberOfFractionalDigits:1} }
      snwd_so.tax_amount          as TaxAmount,

      @UI.lineItem: { position: 50, label: 'Life Cycle Status' }

      snwd_so.lifecycle_status    as LifecycleStatus,

      snwd_so.billing_status      as BillingStatus,

      @UI.selectionField:{position: 30}

      @Consumption.filter: { selectionType: #INTERVAL, defaultValue: 'D', defaultValueHigh: 'F' }
      snwd_so.delivery_status     as DeliveryStatus,

      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      snwd_so.op_id               as OpportunityID,

      snwd_so.created_at          as CreationDateTime,

      @UI.selectionField:{position: 40}
      @Consumption.filter: { selectionType: #INTERVAL, defaultValue: '20160101000000.0000000', defaultValueHigh: '20170101000000.0000000' }
      snwd_so.changed_at          as LastChangedDateTime,

      @Consumption.filter.hidden: true
      @UI.masked
      snwd_so.dummy,

      snwd_so.buyer_guid          as bp_guid

}