CDS Consumption View - OData Service returns no data

Question

I have created a VDM.viewType #CONSUMPTION view as seen below (Code 1) and a VDM.viewType #BASIC view (Code 2). When I activate it and run it via F8 the data are showing up but when I create an OData service via @OData.publish: true the data are not there. Am I missing something??

Thank you very much!!

@AbapCatalog.sqlViewName: 'ZCDLMATERIALQRY'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@ObjectModel.usageType.sizeCategory: #M // < 100'000 entries
@ObjectModel.usageType.serviceQuality: #C // <= 15 tables

@AccessControl.authorizationCheck: #CHECK
@OData.publish: true // Used for enabling CDS as a backend service in transaction /IWFND/MAINT_SERVICE
@Analytics.query: true // Defines the possible usage in Embedded analytics! -> VDM.viewType = #CONSUMPTION
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Material-Informationen - Query'
define view ZC_DL_MATERIAL_QRY 
    as select from ZI_DL_MATERIAL_HEADER {
    key matnr,
    maktx,
    werks,
    prctr,
    prctr_ltext,
    prodh,
    prodh_vtext
}

@AbapCatalog.sqlViewName: 'ZVDLMATERIALH' // Defines the SQL name of the view in the database. With this name, the table can be accessed through SE11 and SE16 transactions.
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK // Defines implicit access control for the CDS view.
@Analytics.dataCategory: #DIMENSION
@VDM.viewType: #BASIC // Defines the usage for reading data directly from database with join or association
@EndUserText.label: 'Material-Informationen' // Defines a short description for a field/view.
define view ZI_DL_MATERIAL_HEADER
  // Allgemeine Materialdaten
  as select from mara

  // Materialkurztexte
  association [0..1] to makt on mara.matnr = makt.matnr // Materialnummer
                            and makt.spras = $session.system_language // Sprachkennzeichen 

  // Lesen der Werksdaten zu Material mit den dazugehörigen Detail-Informationen
  // MVKE - Verkaufsdaten zum Material
  // T179T - Materialien: Produkthierarchien: Texte
  // C003 - GrpMaterial/KtoSchl
  // TVKMT - Materialien: Kontierungsgruppen: Texte
  // SKAT - Sachkontenstamm (Kontenplan: Beizeichnung)
  // CEPC - Stammdatentabelle Profit-Center
  // CEPT - Profit-Center-Stammdaten Texte
  association [0..*] to ZI_DL_MATERIAL_DETAIL as _MaterialDetail on _MaterialDetail.matnr = mara.matnr {
    key mara.matnr, // Materialnummer

    _MaterialDetail.werks, // Werk
    
    makt.maktx, // Materialkurztext
    _MaterialDetail.prctr, // Profit-Center
    _MaterialDetail.prctr_ltext, // Langtext Profit-Center
    _MaterialDetail.vkorg, // Verkaufsorganisation
    _MaterialDetail.vtweg, // Vertriebsweg
    _MaterialDetail.prodh, // Produkthierarchie
    
    _MaterialDetail.prodh_vtext, // Bezeichnung Produkthierarchie
    _MaterialDetail.ktgrm, // Kontierungsgruppe für Material
    
    _MaterialDetail.ktgrm_vtext, // Bezeichnung Kontierungsgruppe für Material
    _MaterialDetail.sakn1, // Sachkonto
    
    _MaterialDetail.sakn1_txt20, // Kurztext Sachkonto
    
    _MaterialDetail.sakn1_txt50, // Langtext Sachkonto
    _MaterialDetail.sakn2, // Rückstellungskonto
    _MaterialDetail
}

Gateway Client

CDS Consumption View - OData Service returns no data

0 Answers