How to Visualize Removal of Aggregate/ Index Tables in sFIN

[Former Member]

Hello SAP Experts,

I am trying to create a video detailing the advantages of simple financials over traditional SAP ERP Financials. To do this, my plan of action has been to first walk through an example of viewing an Aggregated Data Chart (KNC1) in traditional SAP Business Suite GUI. I am able to do this through the data browser and then inputting the KNC1 chart transaction code.

Now I have read that the following tables have been removed with the simple finance solution:

Index tables removed:

BSIS	Index for G/L Accounts
BSAS	Index for G/L Accounts (Cleared Items)
BSID	Index for Customers
BSAD	Index for Customers (Cleared Items)
BSIK	Index for Vendors
BSAK	Index for Vendors (Cleared Items)
BSIM	Index, Documents for Material
FAGLBSIS	Index for G/L Accounts – New G/L
FAGLBSAS	Index for G/L Accounts – New G/L (Cleared Items)

Aggregate tables removed:

GLT0	General Ledger: Totals
GLT3	Summary Data Preparations for Consolidation
FAGLFLEXT	New General Ledger: Totals
KNC1	Customer master (transaction figures)
LFC1	Vendor master (transaction figures)
KNC3	Customer master (special G/L transaction figures)
LFC3	Vendor master (special G/L transaction figures)
COSS	Cost Totals for Internal Postings
COSP	Cost Totals for External Postings

So my next step is to attempt and view this table in SAP GUI within my S/4HANA system where SFin 2.0. Ideally, what I would be trying to prove is that this same table (KNC1) does not exist since this is what the research above would suggest. Then I can draw the obvious conclusion that tables such as KNC1 are no longer needed due to the in memory processing of sFIN on S/4 HANA. (I will then further show HANA studio back end to finish with my conclusions).

But instead, when I search for the table KNC1, it says it exists within my SFin 2.0 system.

Am I misunderstanding the "removal of aggregate/index tables"? How can I show in my video that these same tables are no longer needed but rather are replaced by in memory calculations?

Any help would be greatly appreciated as this is a new and unknown area for myself.

Thanks,

Paul Browning

[BODHISATTWA__20]

Did you create the video ? I am trying to understand Aggregate/ Index Tables in sFIN

[Former Member · Accepted solution]

Hello Paul,

When SAP removed the above table including KNC1, it changed them to view.

This was to ensure that all client custom development which are reading from these tables would still work.

So if I compare you KNC1 in Sfin vs non Sfin, you can see the difference in definition

This is in SAP ECC non Sfin..see that KNC1 is a transparent table with data being stored in Db level.

Now check KNC1 in an Sfin system

Now you see KNC1 is a view , so it does not own its data at the HANA db Level.

That is the advantage of Sfin, where all the aggregate tables are removed and changed as view.

This reduce the data footprint and provide quicker access ( that is due to other factors too )

Hope this answers your question and we would love to see your final video and how it come out

Regards & have a good day

Rishab

[Former Member · Accepted solution]

Hi Rishab,

Thank you for the insight into this problem. I hadn't thought to make the comparison from this point of view, but now looking in to both systems I see the same conclusion.

I appreciate your help!

Thanks,

Paul

[Former Member]

Cool Paul, we all are learning.

Happy to help...