Skip to Content
1
Former Member
Jul 23, 2015 at 07:50 PM

How to Visualize Removal of Aggregate/ Index Tables in sFIN

564 Views

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