Path Expression in CDS association PART 12 ABAP on HANA Course


@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'path expresson'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #X,
    sizeCategory: #S,
    dataClass: #MIXED
}
define view entity ZDDLS_SAMPLE_06
  as select from vbak
  association [1..*] to vbap as _item on vbak.vbeln = _item.vbeln
  association [1..1] to kna1 as _cust on vbak.kunnr = _cust.kunnr
  association [1..*] to makt as _matdesc on $projection.matnr = _matdesc.matnr
  association [0..*] to vbfa as _docflow on vbak.vbeln  = _docflow.vbelv
{
  key vbeln as so,
      kunnr,
      _item.posnr,
      _item.matnr,
      _cust[inner].name1,
      _docflow,
      _matdesc

      
}

/*
source._assoc1[parameter/properties]._assc2.field
cardinality
join
filter condition

*/








/*
SQL path expression
A path expression of the CDS DDL is a sequence of CDS associations 
separated by periods (.)
Source._assoc1(p1,p2)._assoc2[attribute].field

When a CDS entity with a path expression is accessed, the following is evaluated: 
◾The joins defined by the CDS associations, from left to right.
◾All other conditions of the CDS entities involved.

◾The most simple path expression is the name of a single CDS association. = _assoc

If we get mutiple fields from same association then join depends on each fields access


Attribute :-
◾Cardinality  [1:filter condition/join]
  The addition 1: or *: cannot be specified as the only addition in square brackets. 
  It must always be combined with a filter condition. 
  The addition 1: prevents a syntax error if a path specified with filter conditions 
◾Join type implemented when used
    INNER determines an inner join
    LEFT OUTER determines a left outer join
 
◾Filter conditions
  If the join type is explicitly defined with INNER|{LEFT OUTER}, 
  the addition  WHERE must be specified explicitly


*/
**********************************************************************************
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Consume 06'
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #X,
    sizeCategory: #S,
    dataClass: #MIXED
}
define view entity ZDDLS_SAMPLE_07
  as select from ZDDLS_SAMPLE_06
{
  key so,
      kunnr,
      posnr,
      matnr,
      name1,
      /* Associations */
      _docflow[ 1:posnv =$projection.posnr 
                and  vbtyp_n = 'M'].vbeln as invoice,
      _docflow[left outer where posnv =$projection.posnr 
                and  vbtyp_n = 'M'].posnn,      
      _matdesc
}
where
  so = '0000000011'
  or so = '0000000343'
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  
  


Comments

Post a Comment

Popular posts from this blog

AMDP ( ABAP Managed Database Procedure ) Part - 1

Image
CLASS zcl_amdp_class DEFINITION PUBLIC FINAL CREATE PUBLIC . PUBLIC SECTION. INTERFACES if_amdp_marker_hdb . TYPES: BEGIN OF ty_cust , cust_name TYPE kna1 - name1 , netwr TYPE vbak - netwr , END OF ty_cust , tt_cust TYPE TABLE OF ty_cust . TYPES: BEGIN OF session_variables , client TYPE sy - mandt , cds_client TYPE sy - mandt , uname TYPE sy - uname , langu TYPE sy - langu , datum TYPE sy - datum , END OF session_variables . CLASS-METHODS get_session_variables_amdp AMDP OPTIONS READ-ONLY CDS SESSION CLIENT iv_clnt IMPORTING VALUE( iv_clnt ) TYPE sy - mandt EXPORTING VALUE( clnt ) TYPE session_variables - client VALUE( cds_clnt ) TYPE session_variables - cds_client VALUE( unam ) TYPE session_variables - uname VALUE( lang ) TYPE session_variables - langu ...
Read more

Backup all ADT Objects & Other queries RAP Part 10.1

CLASS zcl_DATA_GENERATOR DEFINITION PUBLIC FINAL CREATE PUBLIC . PUBLIC SECTION. INTERFACES: if_oo_adt_classrun . PROTECTED SECTION. PRIVATE SECTION. ENDCLASS . CLASS zcl_DATA_GENERATOR IMPLEMENTATION. METHOD if_oo_adt_classrun ~ main . " delete existing entries in the database table DELETE FROM ztravel_tech_m . DELETE FROM zBOOKING_tech_m . DELETE FROM zbooksupp_tech_m . COMMIT WORK. " insert travel demo data INSERT ztravel_tech_m FROM ( SELECT * FROM /dmo/travel_m ). COMMIT WORK. " insert booking demo data INSERT zbooking_tech_m FROM ( SELECT * FROM /dmo/booking_m * JOIN ztravel_tech_m AS z * ON booking~travel_id = z~travel_id ). COMMIT WORK. INSERT zbooksupp_tech_m FROM ( SELECT * FROM /dmo/booksuppl_m * JOIN ztravel_tech_m AS z * ON booking~travel_id = z~travel_id ). ...
Read more

SAP CDS Introduction Part 2 - ABAP on HANA Course

Image
Code :- @AbapCatalog.sqlViewName: 'ZVSQL_SAMPLE_01' @EndUserText.label: 'This is my fist DDIC based CDS' @AbapCatalog.preserveKey: true @AbapCatalog: {     buffering: {         status:#SWITCHED_OFF,         type: #NONE,         numberOfKeyFields: 000     },     viewEnhancementCategory: [#PROJECTION_LIST,#UNION],     compiler: {         compareFilter: true     },     dataMaintenance: #RESTRICTED } @AccessControl.authorizationCheck: #CHECK @ClientHandling: {     type: #INHERITED,     algorithm:#SESSION_VARIABLE } define view zcds_sample_01 --( SO, Kunnr, curr,netwr,clnt,sydate,syslang)   as select from vbak   association [1..*] to vbap as _item on vbak.vbeln = _item.vbeln {   key   vbeln                    as so,         kunnr  ...
Read more