CDS View does not show quantity values

[marcus_schiffer]

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 ?

[joachimrees1]

Hey Marcus, it seems you asked that question twice, the other one being here: https://answers.sap.com/questions/31710/cds-view-does-not-show-quantity-field.html

-> you can close one of them via the "Actions" button on the right side.

best

Joachim

[former_member760424]

Hi Marcus ,

could you solve the issue? i have the same Problem. I can't see the Total Valuated Stock and Valueo Total Valuated Tock.

Please, could you tell me how did you solve that.

Thank You

Elizabeth

[DmitryKuznetsov]

An answer in this case is MBEW is (partially) replaced by a CDS view. There are many tables like this. So, if you want to know all of them - read on.

DD02L contains all table definitions. If we filter by field VIEWREF not empty, we get all of those (at least partially) replaced by a CDS view. See example below in 1909 there are 292 tables like that.

Depending on how and where are you accessing the information you will need to potentially adjust the code.

Dmitry Kuznetsov

BI Consulting

[sdebaerd]

If you're on S4/HANA, MBEW should not be used directly.

There is a replacement view:

MBV_MBEW

If you use this view, you'll get the correct results.
When you would use eclipse to see what is inside the CDS, you'll understand why certain columns remain blank, due to the way the data is now stored in the database.

Replacement views can be found, by opening the "old" table in SE11, go in Display -> More -> Extras -> Replacement Object

[Former Member]

you may use

mbvmbewbase

view

[shanthi_bhaskar]

Check the below views

[abehaegel]

Hello,

You can find the quantity which is into the table MBEW into the table ACDOCA_M_EXTRACT

put your article on the Period 9999999

you will find the quantity into the field VQUAN1_12

Regards

Alexandre

[Pradeep_Reddy1]

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.

[joachimrees1]

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).