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!
SE38: DEMO_SHOW_DDL_SOURCE -> FGL_FAGLFLEXA
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!
Awesome Marco. good work. Thanks for the blog.
Regards,
G.V.Shivakkumar
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?
Anup
Very useful, thanks!