Jaehoon

EXT201_3.4.5

Feb 11th, 2020
426
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. @AbapCatalog.sqlViewName: 'ZVI_TRAVEL_M_XXX'
  2. @AbapCatalog.compiler.compareFilter: true
  3. @AbapCatalog.preserveKey: true
  4. @AccessControl.authorizationCheck: #CHECK
  5. @EndUserText.label: 'Travel data - XXX'
  6. define root view ZI_TRAVEL_M_XXX
  7.  
  8.  as select from ztravel_xxx as Travel
  9.  
  10.  /* Associations */
  11.  association [0..1] to /DMO/I_Agency   as _Agency   on $projection.agency_id = _Agency.AgencyID
  12.  association [0..1] to /DMO/I_Customer as _Customer on $projection.customer_id = _Customer.CustomerID
  13.  association [0..1] to I_Currency      as _Currency on $projection.currency_code = _Currency.Currency
  14.  {
  15.   key travel_id,
  16.      agency_id,
  17.      customer_id,
  18.      begin_date,
  19.      end_date,
  20.      @Semantics.amount.currencyCode: 'currency_code'
  21.      booking_fee,
  22.      @Semantics.amount.currencyCode: 'currency_code'
  23.      total_price,
  24.      @Semantics.currencyCode: true
  25.      currency_code,
  26.      overall_status,
  27.      description,
  28.  
  29. /*-- Admin data --*/
  30.      @Semantics.user.createdBy: true
  31.      created_by,
  32.      @Semantics.systemDateTime.createdAt: true
  33.      created_at,
  34.      @Semantics.user.lastChangedBy: true
  35.      last_changed_by,
  36.      @Semantics.systemDateTime.lastChangedAt: true
  37.      last_changed_at,
  38.  
  39.      /* Public associations */
  40.      _Agency,
  41.      _Customer,
  42.      _Currency
  43. }
RAW Paste Data

Adblocker detected! Please consider disabling it...

We've detected AdBlock Plus or some other adblocking software preventing Pastebin.com from fully loading.

We don't have any obnoxious sound, or popup ads, we actively block these annoying types of ads!

Please add Pastebin.com to your ad blocker whitelist or disable your adblocking software.

×