I am trying to extract the data from the MSEG table. In SE16N all data appears normally, when I make a SQL query in HANA Studio, no data appears. What can it be?
Table MSEG is a "simplified object" in S/4HANA. Due to the simplication of the data model the table itself does not contain data anymore. If you access the table via the ABAP layer (e.g. SE16N) then the database interface redirects the query to the CDS View which gets the data out of the new data model in MSEG form. If you do the query directly on the DB that redirect is not done, because as said this is part of the db interface. For details you can check the Simplification List for SAP S/4HANA (search for table MSEG).
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.