Advertisement
Jaehoon

EXT201_3.4.5

Feb 11th, 2020
1,022
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
ABAP 1.28 KB | None | 0 0
  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. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement