ABAP by Ajay

         //  <fieldname> as <Alis name>                          @AbapCatalog.sqlViewName: 'ZAJAY_3JOIN'      @AbapCatalog.compiler.compareFilter: true      @AbapCatalog.preserveKey: true      @AccessControl.authorizationCheck: #NOT_REQUIRED      @EndUserText.label: 'join 3 tables'      define view zajay_join as select from ekko as a      inner join ekpo as b on a . ebeln = b . ebeln      inner join mara as c on b . matnr = c . matnr      {      key a . ebeln ,      a . aedat ,      b . ebelp ,      b . brgew ,      c . matnr ,      cast( ebelp as abap . int2 )* 5 as custom     "cutom field ...

  @AbapCatalog.sqlViewName: 'ZCDS_VIEW_INPUT1' define view zajay_cds_view_input1 with parameters p_mgroup : matkl , p_mtype : mtart as select from mara { matnr , matkl , mtart , ntgew } where mtart = : p_mtype and matkl =: p_mgroup Input           output

  Sale Order Item @AbapCatalog.sqlViewName: 'ZSO_VBAP' @AbapCatalog.compiler.compareFilter: true @AbapCatalog.preserveKey: true @AccessControl.authorizationCheck: #NOT_REQUIRED @EndUserText.label: 'sale order item' define view zso_vbap1 as select from vbap { key vbeln as Sale_Order , key posnr as Item_num , matnr as Material_num , matwa as Material_Entered } Sale Order Header @AbapCatalog.sqlViewName: 'ZSALE_VBAK' @AbapCatalog.compiler.compareFilter: true @AbapCatalog.preserveKey: true @AccessControl.authorizationCheck: #NOT_REQUIRED @EndUserText.label: 'sale order header' define view zso_vbak1 as select from vbak as a association [ 1 ..*] to zso_vbap1 as b on a . vbeln = b . Sale_Order { key a . vbeln as Sale_Order , a . erdat as Creation_date , a . erzet as Creation_time , b . Item_num as Item_num , b . Material_num as Material_num , b . Material_Entered as...

Take two tables  1)  zajay_stu           2) zajay_stu1                               Apply inner join   @AbapCatalog.sqlViewName: 'ZST_INNER' @AbapCatalog.compiler.compareFilter: true @AbapCatalog.preserveKey: true @AccessControl.authorizationCheck: #NOT_REQUIRED @EndUserText.label: 'student innerjoin' define view zast_inner as select from zajay_stu as a inner join zajay_stu1 as b on a . zst_id = b . zst_id { key a . zst_id as ZstId , a . zst_name as ZstName , a . zst_dept as ZstDept , a . zst_fee as ZstFee , b . zst_fn as ZstFn , b . zst_ln as ZstLn } output         Apply Left outer join @AbapCatalog.sqlViewName: 'ZST_INNER' @AbapCatalog.compiler.compareFilter: true @AbapCatalog.preserveKey: true @AccessControl.authorizationCheck: #NOT_REQUIRED @EndUserText.label: 'studen...

  @AbapCatalog.sqlViewName: 'ZST_DETAILS' @AbapCatalog.compiler.compareFilter: true @AbapCatalog.preserveKey: true @AccessControl.authorizationCheck: #NOT_REQUIRED @EndUserText.label: 'student deatils' define view zstu_details as select from zajay_stu { key zst_id as Student_Id , zst_name as Student_tName , zst_dept as Student_Dept , zst_fee as Student_Fee }