Skip to Content

CDS View does not show quantity values

I have a simple CDS view:

define view Zmaterial_Cds as select * from mbew

When it is executed, all the quantity fields show only 0.00.

What am I missing ?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Nov 30, 2017 at 11:25 AM

    you may use

    mbvmbewbase

    view

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 19, 2016 at 03:06 PM

    I haven't tried but maybe if you use MBVMBEWOLD instead, it will work?

    Here's the relevant part from the simplification liste (S/4HANA 1511 FPS2).

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 21, 2017 at 03:02 PM

    Hi,

    we are also facing same problem.

    We created simple CDS view to get total stock from MBEW, it is not getting the quantity value. I written below code

    @AbapCatalog.sqlViewName: 'z_test_cds11_D'

    @AbapCatalog.compiler.compareFilter: true

    @AccessControl.authorizationCheck: #CHECK

    @EndUserText.label: 'test data'

    define view z_test_cds11 as select from mbew {

    key matnr as material,

    key bwkey as store,

    key mbew.bwtar,

    @DefaultAggregation: #SUM

    lvorm as TotalStock

    }

    Thanks,

    Pradeep.

    Add comment
    10|10000 characters needed characters exceeded