CDS View

@AbapCatalog: { sqlViewName: 'ZJB_DEMO',
                compiler.compareFilter: true,
                preserveKey: true }
                
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Mein erster CDS View'
define view zjb_cds_demo
  as select from    zbc_tasks as t

    left outer join zbc_users as u on t.assignee = u.user_id
{
      // Blockmodus: Alt + Shift + A
      // Pretty Printer: Shift + F1
  key t.task_key    as TaskKey,
      t.summary     as Summary,
      t.status      as Status,
      t.project     as Project,
      t.description as Description,
      t.assignee    as Assignee,
      u.firstname   as Firstname,
      u.lastname    as Lastname,
      t.type        as Type      
}

CREATE OR REPLACE VIEW "ZJB_DEMO" AS SELECT 
  "T"."CLIENT" AS "MANDT", 
  "T"."TASK_KEY" AS "TASKKEY", 
  "T"."SUMMARY" AS "SUMMARY", 
  "T"."STATUS" AS "STATUS", 
  "T"."PROJECT" AS "PROJECT", 
  "T"."DESCRIPTION" AS "DESCRIPTION", 
  "T"."ASSIGNEE" AS "ASSIGNEE", 
  "U"."FIRSTNAME" AS "FIRSTNAME", 
  "U"."LASTNAME" AS "LASTNAME", 
  "T"."TYPE" AS "TYPE"
FROM "ZBC_TASKS" "T" LEFT OUTER JOIN "ZBC_USERS" "U" ON ( 
  "T"."CLIENT" = "U"."CLIENT" AND 
  "T"."ASSIGNEE" = "U"."USER_ID" 
)