• Get data from AUFK & Purchase Order, use Paramters @AbapCatalog.sqlViewName: 'ZKR_VW_CAPCC' @AbapCatalog.compiler.compareFilter: true @AbapCatalog.preserveKey: true @AccessControl.authorizationCheck: #NOT_REQUIRED @EndUserText.label: 'CDS View with Field Annotations' //'Project Orders & Purchase Order data for CaptainCostCrunchur' @Metadata.ignorePropagatedAnnotations: true @OData.publish: true

define view ZKR_CAPCOSTCRUNCHER with parameters P_PLANT :WERKS_D, P_FRODT :ERDAT,
P_TODAT :ERDAT

as select from aufk as orders left outer join ekkn as assign on orders.aufnr = assign.aufnr left outer join ekpo as poitem on ( poitem.ebeln = assign.ebeln and poitem.ebelp = assign.ebelp ) join ekko as pohdr on ( poitem.ebeln = pohdr.ebeln )

{ key

// @EndUserText.label:  'Order Number'
orders.aufnr, 
@EndUserText.label:  'Order Type'
orders.auart,
@EndUserText.label:  'Created By' 
orders.ernam, 
@EndUserText.label:  'Created Date'
orders.erdat, 
orders.ktext,
orders.ltext,
orders.bukrs,
orders.werks,
@EndUserText.label: 'Location Plant'
orders.sowrk,    
@EndUserText.label: 'Order status'
orders.astnr,    
pohdr.ebeln,
pohdr.lifnr,
poitem.ebelp,
poitem.txz01,
poitem.matnr,  
poitem.netpr

} where orders.auart = 'PM31' and orders.werks = :P_PLANT and ( orders.erdat >= :P_FRODT and orders.erdat <= :P_TODAT )

Testing: URL : http://:8000/sap/opu/odata/sap/ZKR_CAPCOSTCRUNCHER_CDS/$metadata