Skip to Content
Author's profile photo Marco Wahler

HOWTO find S/4HANA Compatibility Views

Hi all,

recently I was asked: How to find out, if the “old R/3 Tables” are still used in S/4HANA!?

Within all the Simple Finance rework the universal journal should eliminate a lot of tables, so why they are still there an even have entries!?

Example: left side = HDB (zero entries), right side = Appl. Server (tousands of entries)

<img />

First of all, if you just look at the Table entries in S/4HANA this could be misleading.

Why is that? The answer are compatibility views! And  how can we find out what is happening behind the scene!?

Use t-code: SE16N (not SE16!)

doubleclick on Proxy Object: You can then find the DDL Source.

Now use the ABAP report to find out more details!


again with DDL Source FGL_GLSI…

and again with DDL Source FGL_GLSI_ACD…

<img />

Finally you reach the “real table” called ACDOCA where the data is finally stored.

Hope that helps!

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      Awesome Marco. good work. Thanks for the blog.



      Author's profile photo Former Member
      Former Member

      Thanks Marco for this simple blog.

      Since SQL select in HANA database doesn't give any syntax error, the SQL view (or table?) with name FAGLFLEXA does exist in the database. Why is the table/view not totally deleted from HANA database?

      Is the definition of compatibility only relevant in ABAP (is it a purely ABAP concept)? As far as I know SQL view of CDS view is accessible from database - I am not sure if this is true for "compatibility view" as well.

      Is there any table which stores mapping of proxy object and the compatability view?



      Author's profile photo Zhengzhang Lu
      Zhengzhang Lu

      Very useful, thanks!