Skip to Content

Why can't CDS View select anything from MSEG table?

Hi CDS experts,

I'm learning CDS views and facing a strange issue. Created CDS views on a few tables joined, and it worked fine. However when I tried to create a similar one, with MSEG table as one of the tables, I'm not getting any results in data preview.

I even tried a simple view on MSEG as below:

define view ZV_mseg_view as select from mseg {
   ebeln, matnr, lgort
}

But it still doesn't return any values in data preview. Just to try with another table, the following view returns values fine.

define view ZV_mseg_view as select from ekpo {
   ebeln, matnr, lgort
}

I've checked and MSEG table does have a lot of data in it. Any ideas why the same view with MSEG fails to get any values, while with EKPO does return?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Nov 08, 2017 at 05:47 AM

    Hi Mithun,

    Did you try fetching the required data from MATDOC table?

    With HANA some tables are combined into new tables, etc. There are such changes where in application layer you can still reach these tables which are now defined as views not to break existing code but on database layer you require to query correct source

    Add comment
    10|10000 characters needed characters exceeded

  • Nov 08, 2017 at 06:48 AM

    Read also the reference note for MM inventory tables in HANA: 2206980 - Material Inventory Managment: change of data model in S/4HANA. So actually when you expected read MSEG you were actually reading NSDM_DDL_MSEG.

    Add comment
    10|10000 characters needed characters exceeded