Skip to Content
0

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

Nov 08, 2017 at 05:28 AM

517

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

ERALPER YILMAZ Nov 08, 2017 at 05:47 AM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Thanks a lot for the explanation. It works fine with MATDOC.

0
Raymond Giuseppi
Nov 08, 2017 at 06:48 AM
0

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.

Share
10 |10000 characters needed characters left characters exceeded