What is S/4HANA 1610???

s4h_network_architecture_924976.png

  • HANA (High performance ANalytics Appliance) was introduced as in-memory computing database in 2011.
  • SAP BW was powered on HANA Database making analytical reporting real-time and no need for running the extractors overnight, no more latency in 2012
  • SAP Business suite powered by SAP HANA and cloud services introduced in 2013
  • Simple Finance as a frontrunner was released with simplified database structures, much faster reporting, single source of truth & no aggregates in 2014
  • In late 2015, S4 HANA 1511 was released with simplified data models across the landscape, extremely friendly Ux, advanced processing and choice of deployment: Public Cloud, On-Premise or Hybrid Cloud

s4_hana_history_924994.png

As you can see in the figure below, S/4 HANA Finance is a different product that S/4HANA (Enterprise Management).

Scope as on today:

 

1_975621.png

What has changed:Database tables:

  • Most of the relational databases are re-defined and re-structured.
  • Most database tables are columnar store, very few remain row-store.
  • Most of the tables that contained indices, statuses, totals etc have been removed and duplication has been removed.

What this essentially means is SAP has “simplified” their data structures and re-written most of the standard SAP programs.

In the demo sessions I have seen: Thanks for the new database innovation in HANA, I can visibly see a faster performance, much faster results from running a report.

Simplified Data Structures.png

Simpler Landscape/Architecture: 

SAP has aggressively invested and acquired few organizations who were leaders in their respective fields.

Most of the functionalities offered by different landscapes: BI, CRM, SCM, SRM, etc.. are clubbed in one server* making it much easier, faster to interact and provides seamless integration.

Enterprise Management:

S4HANA_-_Enterprise_Management.jpg

Ux( User Experience):

  • SAP Fiori UX is the new face of SAP to business users for ALL lines of business across devices and deployment options
  • Provides only the relevant tasks and activities for an end user though the SAP Fiori launchpad
  • SAP Fiori’s design is based on 5 Principles: Role-Based, Responsive, Simple, Coherent, Delightful

SAP Fiori.png

I’ve personally installed Fiori Client App on my phone( the demo version) and used it and I must admit that’s definitely much simpler, smarter, faster & interactive.

IoT, real-time collaboration:

  • SAP claims that it’s solution for the Internet of Things(IoT) provide all the data-driven intelligence business would need by connection to devices/ machines/ assets/ vehicles by sensors
  • Imagine being able to track your assets all along it’s way till it reaches an end destination or being able to track, trace, communicate,  plan or re-plan routes based on the traffic situation and optimizing the route or meeting a promised delivery timeline to a customer

An example below of how data from IoT could be put to use.

IoT.png

Choice of deployment:

For the uninitiated:

  • On-premise is the same situation as it was before the the SaaS/PaaS/IaaS world i.e. the platform/software is run on the premises managed by the business themselves.
  • Cloud is deploying the software on a server provided by Vendor and the upgrades, maintenance managed by the Vendor who provides the services
  • Hybrid, as the name suggests is a hybrid of the above options: for ex. A company may choose to have their Human Resources functionality, T&E on the cloud the rest on-premise

SAP offers all 3 deployment options depending on their current/initial state:

Deployment Options.jpg

Easy Adoption : 

SAP claims that the new HANA is quiet easy to adopt with quicker implementation cycles and there are the following paths that they see:

  1. 1) Existing client on SAP ECC or further: Adopt  a system “Conversion” methodology
  2. 2) Existing client on version 47 or below: SAP recommends a new implementation
  3. 3) For Existing clients with different installations or multi landscape, SLT- System Landscape Transformation

 

Except for some minor differences which are listed below. This make things a bit easier to understand later on :).

S/4HANA Enterprise Management and Finance deltas

Source: www.sap.com

S/4HANA 1610 FINANCE – Key differences and innovations

Now we have to understand the product. Let’s look at the benefits of S/4HANA for our organization & key differences compared to classic FICO in R3 including some features which were already included in Simple Finance 1.0 back in 2014.

Before and after S4 HANA The Principle of simplified and One

/wp-content/uploads/2016/06/3_975710.png

Diagram source :www.sap.com

  • Simple Data Model

Only mail table exists now no redundancies

Clear separation of Master data from transactional data

Reduction of Memory footprint

  • Principal of “ONE”

Only one evaluation method(Material Ledger)

Instead of 2(IM + ML)

Flexible rebate Management instead of cumbersome and expensive redundancies

  • Throughput Increase

INSERT command available only on data base level (MM-IM)

No locks for standard price valuation

  • Master Data:  Business partner is now capable of centrally manage data for customers and vendors. BP is now the single point of entry to create, edit and display master data.
  • ProductTable T130F (Table of Field attributes) does have delivery class E (E = Control table, SAP and customer have separate key areas). In SAP Business Suite the delivery class of table T130F is G (G= Customizing table, protected against SAP Update, only INS all).
  • Material Number field length:   With SAP S/4HANA, on premise edition 1511, the maximum field length of the material number is extended from 18 to 40 characters.
  • Simplification The field KZEFF in table MARA is not available anymore. The current setting KZEFF is such that the field will be hidden only from the UI, but still continue to be available in the database. However, Assign effectivity parameter values/ override change numbers (KZEFF) impacts the parameter effectivity in BOM explosion by providing a popup to manually overwrite validity parameters.
  • The user interface for SAP S/4HANA, on premise edition 1511 is transaction BP.
  • The specific transactions like XD01, XD02, XD03 or VD01, VD02, VD03 / XK01, XK02, XK03 or MK01, MK02, MK03 etc. are not available in SAP S/4HANA on premise edition 1511
  • Currently mass maintenance for customers and vendors via transaction MASS is not available (on the roadmap of a future SAP S/4HANA release)

Hence, the value of this field needs to be reset from X to space. This ensures similar behavior in UI & in the backend.

  • The Foreign Trade functionality as part of Sales & Distribution is not available within SAP S/4HANA. The functional equivalent in SAP S/4 HANA is     SAP Global Trade Services (GTS). The below mentioned fields for Letter of Credit/ Legal control/ Export control/ Preference management in Foreign Trade is supported by GTS and not through Material Master:
    • CAP product list no.
    • CAP prod. Group
    • Preference status
    • Vendor decl. status
    • Exemption Certificate
    • Exemption Cert. No.
    • Iss.date of ex.cert.
    • Military goods
  • MRP fields in Material Master

The SAP S/4HANA simplification is done on the following tabs in transaction MM01/02/03.

Lot Size data in MRP1 Tab: unit of measure group is considered in only retail henceforth it is not

required to switch it on in the material master.

    • Unit of Measure Group

Procurement in MRP2: MRP considers quota arrangements always, henceforth it is not required to

switch it on in the material master.

    • Quota arr. usage.

BOM explosion /dependent Requirement tab in MRP4

    • Selection Method

Repetitive manufacturing /assembly /deployment strategy tab of MRP4

    • Action control
    • fair share rule
    • push distribution
    • Deployment horizon.

Storage Location in MRP4

    • SLoc MRP indicator
    • spec.proc.type SLoc
    • Reoder Point
    • Replenishment qty.

Also the backend database fields for these “omitted functionality” remains existing in the system

  • Material type “SERV” for services is introduced for Product Master in S/4HANA for simplification purposes. When you use material type SERV, some fields and departments that are irrelevant in S/4 are hidden from the screen. This gives all transactions relevant for material master, a leaner and simplified look.
  • Business Partner IDOC Types (DEBMAS and CREMAS): The business partner related iDoc message types – DEBMAS and CREMAS are not available with Sap S/4HANA, on-premise edition 1511. They are planned to be available in a future release of SAP S/4HANA, on-premise edition.

If you try to transfer data using these message types in S/4HANA, data would be transferred without actually having created a business partner

  • SD Data Model:
    • Elimination of Status Tables VBUK, VBUP: Status fields have been moved to the corresponding header and item tables – VBAK and VBAP for sales documents, LIKP, and LIPS for deliveries, VBRK for billing documents
    • Simplification of Document Flow table VBFA.
    • Field length extension of SD document category: Data element VBTYP (Char1) has been replaced by data element VBTYPL (Char4), also: elimination of field VBTYP_EXT (Char4)
    • Elimination of redundancies – Document Index Tables VAKPA , VAPMA, VLKPA, VLPMA, VRKPA, VRPMA
    • Elimination of redundancies – Rebate Index Table VBOX: see simplification item SD Rebate Optimization

Key benefits of the data model changes:

    • Reduced memory footprint (simplified Document Flow, elimination of index tables, fewer aggregates)
    • Increased performance of HANA queries and code pushdown (one select statement instead of two select statements, easier join for header/items including status and business data)
    • Increased robustness of Rebate processing (no redundancies due to aggregates)
  • Data Model Changes in SD Pricing

Business documents within the SAP Business Suite such as the sales order or the purchase order used

to store the pricing result in the database table KONV. In SAP S/4HANA, table KONV was replaced in

its data persistency role by the new table PRCD_ELEMENTS. However, KONV is and can still be used for

data declaration purposes. It still defines the structure of the pricing result within the application coding. The content of KONV is transferred to PRCD_ELEMENTS when moving to SAP S/4HANA.

Several other DDIC changes have been done in pricing condition table. Please refer the SAP paper for more details.

Element Description Type of Change
KOLNR3Access Sequence – Access NumberField is obsolete. Possible field content will be

merged with content of KOLNR and moved

to PRCD_ELEMENTS

STUFELevel (in multi-level BOM explosions)Field is obsolete and will not be transferred to

PRCD_ELEMENTS

WEGXXPath (for multi-level BOM explosions)Field is obsolete and will not be transferred to

PRCD_ELEMENTS

  • Billing Document Output Management

With SAP S/4HANA a new Output Management approach is in place

    • The complete configuration differs from the configuration that is used when output

management is based on NAST. The configuration is based on BRF+ which is accessible for Customers.

    • Output management based on NAST is not available for new documents in SD Billing. Billing documents that

are migrated from legacy systems and for which NAST based output has been determined, can be processed

with this technology.

    • In application Billing it is recommended to use Adobe Forms but also Smartforms and SapScripts are supported
    • In contrast to the output management based on NAST the new output management supports only the

Channels PRINT, EMAIL, XML and IDOC (for on premise). Other channels are not available by default.

  • The FI-AR-CR Credit Management
  • SD Rebate Processing replaced by Settlement Management: In general, SD Rebate Processing is not available within SAP S/4HANA. The functional equivalent in SAP S/4 HANA is SD Rebate Processing is Settlement Management.
  • SAP SRM: The functional scope of SAP supplier relationship management will gradually be made available with S/4 HANA a limited functional scope is now available as compared to SAP SRM. The coverage is proposed to grow overtime and procurement solution will evolve to take over SRM functions.
  • SAP Supplier Lifecycle Management: The goal is that – over time – the functional scope of SAP Supplier Lifecycle Management (SAP SLC) will be available within the SAP S/4HANA stack.
  • MM-Inventory management data Model:
  • Material Ledger Obligatory for Material Valuation: This simplification makes it obligatory to use the Material Ledger in all SAP S/4HANA systems. When a system is converted to SAP S/4HANA the Material Ledger will be activated if not active already. Please take a note that though material ledger will be active for parallel valuation of inventory and other purposes it is not mandatory to activate/use actual costing.

In MM02 and MR21 material prices can now be maintained in multiple currencies. In Financials the inventory account balances are calculated separately for each currency and result therefore in a cleaner and more consistent valuation in other currencies than the local currency.

  • Sales & Operations Planning (SOP) will be replaced by Integrated Business Planning IBP12. Integrated Business Planning supports all SOP features plus advanced statistical forecasting, multi-level supply planning, an optimizer, collaboration tools, an Excel-based UI, and Web-based UIs.

There is a complete list of t-codes and programs that are impacted after migrating to S4 HANA Finance. Most important that we focused on were as below:

DescriptionCurrent t-codeNew t-code
Vendor Line Item BrowserFBL1NFBL1H
G/L Account Line Item BrowserFBL3NFBL3H
Customer Line Item BrowserFBL5NFBL5H
G/L Account Line Item Browser (G/L View)FAGLL03FAGLL03H
Foreign Currency ValuationFAGL_FC_VALFAGL_FCV
Display Actual Line Items for Cost CentersKSB1KSB1N
Variance CalculationKKS1KKS1H
Actual Settlement: Production/ Process OrdersCO88CO88H
Calculate Work in Process: Collective ProcessingKKAOKKAOH
Mass Schedule Maintenance PlansIP30IP30H
FI12FI12_HBANK
NWBC
House Banks
Accounts
Depreciation RunAFABAFAB
* t-code remains same, options changed
Create asset transactionAB01AB01L
Unplanned DepreciationABAAABAAL
Asset Sales Without CustomerABAOABAOL
Asset Retirement By ScrappingABAVABAVL
Manual DepreciationABMAABMAL
Miscellaneous TransactionsABSOABSOL
Transfer From Initial ScreenABUMABUML
Acquisition From In-House ProductionABZEABZEL
Asset Acquisition Autom. Offset.PostingABZOABZON
ABZOL (sFIN)
Acquisition From Affiliated CompanyABZPABZPL
WRITE-UPABZUABZUL

One Single Source of truth and all accounts become GL accounts

All actual line items will be stored in the new table ACDOCA. There will be no redundant, aggregate or total tables anymore. All dimensions of GL, CO, COPA, AA and ML will be in ACDOCA.

In the ACDOCA whe have multidemsional GL, parallel ledgers, parallel currencies, 999,999 line items and custom defined fields. The chalenges of gathering combined content of several tables to represents the truth and reconcile the different level of detail stored in the different components/tables of SAP (e.g. CO= much detail, Fi= less detail) is now somehting of the past.

S/4HANA One Single Source of Truth

Source: www.sap.com

The reason of the merge of secondary and primary cost elements is the fact that all actual line items will now be stored in one single table. The ACDOCA. This also applies on purely (internal) CO postings. You should not include these secondary accounts in your P&L.

S/4HANA GL account Cost Element

Source: www.sap.com

Parallel currencies and parallel valuation

In S/4HANA 1610 we can now have up to 10 parallel currencies per ledger. Real-time conversion for all currency types is possible, Zero balance per document is guaranteed for each currency and CO-area currency is now calculated for all accounts (also non cost element).

S/4HANA Additional Currencies

Source: www.sap.com

Parallel valuation functionality is significantly enhanced in S/4HANA 1610. SAP now provides two options to store multiple valuations:

  • Parallel valuation updated in parallel single-valuation ledger
    • Separate ledger for each valuation
    • Transparent separation of posting and reporting based on different regulations
  • Parallel valuation updated in multi-valuation ledger
    • Separate amount columns in the same ledger
    • Reduce memory footprint
    • Reduce effort and time for closing

See an example of the 2 methods below.

S/4HANA Parallel Valuation

Source: www.sap.com

Profitability Analysis in S/4HANA 1610

With S/4HANA SAP focuses on the enhancement and integration of Account based COPA. This is the preferred type of Profitability Analysis. Costing Based profitability analysis is still available and can be used in parallel, but there will be no integration with the Universal Journal (ACDOCA table).

Below you will find the list of enhancements on Account Based profitability analysis. Critical gaps of the past are closed.

  • Split of Cost of Goods Sold on multiple accounts based on cost component split. This is done during posting of the Goods issue.
  • Split of production variances on multiple accounts. This is done at order settlement.
  • 3 new quantity fields provided in the line items and a BAdI for conversion of the logistical quantities to common quantities in Finance.
  • Real-Time derivation of market segment information from cost postings (Cost Center, order etc.)

Summary of the enhancement:

S/4HANA Profitability Analysis Account Based vs. Costing Based

Source: www.sap.com

Unfortunately there are still some limitations which are on the future roadmap. Current limitations of Account Based profitability analysis:

  • Sales conditions which are not posting to GL (statistical) are not supported
  • Realignment of characteristics which are changed after posting are partially supported. Not for all characteristics!
  • Creation of sales order generates expected revenue, COGS etc. in profitability analysis is not supported.

Attributed Profitability Segments

In my opinion, this is one of the greatest enhancements in Profitability Analysis. I was always thinking why this was not possible in SAP and now it is here! With a couple of additional configuration steps the ‘Attributed PA segment’ can be activated.

S/4HANA Attributed Profitability Segment

Source: www.sap.com

Another good example is when you have a debit memo request in a Time & Material Service order which has a settlement rule for settlement to COPA. The debit memo request will have an account assignment to the service order and no profitability segment. That means that you do not have the profitability segment information until the service order is settled to COPA. With this new functionality you can have the real account assignment to the service order and an attributed assignment to a profitability segment. Great stuff!

Event based revenue recognition

The revenue recognition process is now fully integrated with the Universal Journal. There is no separate storage for Revenue Recognition data anymore.

Cost and revenues are recognized as they occur. The entry of the source document will generate two postings. An entry for the initial costs and revenue and an entry for the revenue recognition posting.

S/4HANA event based Revenue Recognition

Source: www.sap.com

There is even a new app ‘Event based revenue recognition’ for monitoring of revenue recognition postings and manual adjustments.

S/4HANA Event Based Revenue Recognition app

Source: www.sap.com

Bank Account Management (lite)

In the ‘old’ setup there were house banks and bank accounts in SAP. In S/4HANA basic functions of the Bank Account Management functionality of Cash Management is brought in to the core. This is called Bank Account Management Lite.

The main new features and differences compared to the old house bank and bank account setup are the following:

  • Group-wised account management
  • Signatory
  • Overdraft Limit
  • Opening and Closing with approval process
  • Easily maintain bank accounts

To highlight the latest point. Bank accounts are now part of master data and can be maintained by users through a dedicated Web Dynpro or Fiori application. The house banks itself are still created in customizing. Transaction FI12 is obsolete and the new transaction FI12_HBANK is introduced for this purpose.

So the process of creating the house bank and the house bank account are separated and executed in two different places.

New Asset Accounting

Migrating to New Asset Accounting is a pre-requisite for migration to S/4HANA (Finance). The reason and motivation behind New Asset Accounting is:

  • No data redundancy
  • Reconciliation between GL and AA ensured
  • Transparent assignment of depreciation area to accounting principle
  • Simplified chart of depreciation: only 1 CoD per valuation
  • No delta depreciation areas
  • Asset balance in real-time (APC posting run not needed)
  • Plan values in real-time

Usage of the New Depreciation Calculation Engine is mandatory and the tables ANEA, ANEP, ANEK, ANLC, and ANLP are not updated anymore in New Asset Accounting.

New Asset Accounting is not really new. It has been available since SAP ECC enhancement pack 6. However, lately it has gained attention because it is a mandatory step to activate New Asset Accounting in the S4HANA Finance or S4HANA migration. It is mandatory. One good thing about it is that it provides an opportunity to be proactive. If you are already on New GL, you could start going through the pre-requisites, pre-checks and even head start activating New Asset Accounting project before your S4HANA migration project.

Though in our recent S4HANA Finance 1605 project we did not come across any serious issues, few consultants I talked to face some challenges that could turn into prove a bottleneck and slow down the progress. It is not only because of the complexity but also large impact of asset accounting on business. I am hereby trying to connect few dots that would bring clarity.

The program RASFIN_MIGR_PRECHECK checks if the migration pre-requisite is complete. Also the business function (Enterprise extension) EA-FIN and FIN_AA_CI_1 (for parallel accounting) are activated. Refer to the SAP Note 1939592 and also Note 965032 for more details.

Pre-Check if the New Asset Accounting

Check if the New Depreciation Engine is Active once business extensions activated.

Let us now start with the functional benefits of New Asset Accounting when you migrate to S4HANA Finance and then discuss on changes in the architecture, configuration options, new posting logic, new t-codes and (positive) impact on the closing process. I will also discuss on some specific errors we came across in our recent S4HANA Fin 1605 migration project and the resolution.

Impact on Functionality

  • Reconciliation between FI and AA is not required
  • Depreciation values posted in Real time – efficient and faster depreciation run.
  • Depreciation posted for the individual asset
  • Depreciation posting run, detailed log option provides information on individual assets level along with cost centers.
  • Clean and transparent assignment of depreciation areas to the Accounting Principle.
  • APC ( Acquisition and Production Costs) posting run are not required – Closing
  • Balance carryforward is not required by design and FAGLGVTR takes care of balance carry forward for all sub ledger accounts including Asset Accounting – Closing
  • Planned values are updated online with master data and transaction to assets – Closing
  • No need of the delta areas as separate single valuation area per valuation
  • Since the Asset Accounting is a part of universal journal there are many opportunities combining GL and Asset Accounting example drill down by cost center or asset from one place.
  • Accounting Principle and depreciation area can be entered in the Document posting
  • Optional display of Asset view of journal entries
  • Period Close is possible even if there are errors on assets ( No blocking for the process) – Closing

Architectural Changes

  • Classic Asset Accounting is no more supported
  • All actual line items are posted to the Universal Journal Entry – ACDOCA table. Tables ANEK, ANEP, ANLC, ANLP are hence redundant but reporting is possible due to compatibility views. You still can run reports for earlier periods before migration.
  • The plan and statistical data is stored in separate tables FAAT_DOC_IT ( statistical), FAAT_PLAN_VALUES (Planned) and FAAT_YDDA (year dependent

Posting Logic:

The integrated acquisition of an asset is split in to two parts – an operational ( Vendor Invoice –  Debit Technical Clearing Account to Vendor. In the second part, valuation part ledger group specific document is posted to each of the accounting principle.

Example

 Customizing / Configuration

The IMG path covers step by step customizing / configuration of the new Asset Accounting

I am covering only few of the important customizing / configuration steps to build our understand

  • Migration of Chart of Depreciation. There is a migration program FAA_CHECK_MIG2SFIN but it is recommended to it manually.
  • Assign Accounting Principles and Ledger Groups to the depreciation are.
  • Make sure that for each currency type a separate Depreciation area is assigned

Example:

GL currency config in parallel accounting

LedgerCurrency typeCurrencyAccounting Principle
0LCompany Code CurrencyCADLGAAP
0LGroup CurrencyUSDLGAAP
0LAdditional CurrencyEURLGAAP

 

NL1Company Code CurrencyCADIFRS
NL1Group CurrencyUSDIFRS

Depreciation Area Config

AreaName od Dep AreaPosting to GLAccounting Principle
01Book Depreciation (Co Code)Posting to GLLGAAP
02Consolidated B/S (Group)Area Does not postLGAAP
03Adj Current EarningArea Does not PostLGAAP
31Company Code – Val 2Area Post in Real timeIFRS
32Group – Val 2Area Does not postIFRS
  • Refer to SAP Note 2180591. This note is to address issues with parallel valuation / currencies but useful in clear understanding of the new architecture and configuration requirements.
  • Additionally, if you are using the Accounting approach, for parallel valuation, define the hen G/L accounts as reconciliation accounts

  • We need to create a Technical Clearing Account for Integrated Asset Acquisition.
  • Following are manual activates needs to be completed depending on the scenario

 List of Obsolete t-codes and new t-codes

Old TransactionsNew Transactions
Reconciliation checkABST2FAGLGVTR (Close)
Periodic APC RunASKBObsolete
Reconciliation FI-AAABST /ABST2Obsolete
Asset ExplorerAW01_AFARAW01N
Create assetAB01AB01L
Unplanned depreciationABAAABAAL
Last Retirement on Group AssetABAKNABAKNL
Asset Sale Without CustomerABAOABAOL
Asset Retirement by ScrappingABAVABAVL
Balance sheet revaluationABAWABAWL
Adjustment Posting to AreasABCOABCOL
Credit Memo in Year after InvoiceABGFABGFL
Credit Memo in Year of invoiceABGLABGLL
Investment supportABIFABIFL
Manual depreciationABMAABMAL
Manual transfer of reservesABMRABMRL
Post-capitalizationABNAABNAL
Subsequent RevenueABNEABNEL
Subsequent CostsABNKABNKL
Miscellaneous TransactionsABSOABSOL
Transfer fromABUMABUML
Acquisition from in-house productionABZEABZEL
Asset acquis. autom. offset. postingABZOABZOL
Acquisition from affiliated companyABZPABZPL
Write-upABZUABZUL 

Changes in loading of Asset Master – Transaction AS91

The process is changed after migrating to New Asset Accounting. The transaction AS91 still exists but to load the historical values, accumulated depreciation and depreciation costs for the year are loaded through ABLDT. The current year acquisition managed through AB01L

Limitations

  • Reversal for the documents posted prior to migration ( prior to activation of new posting logic) is not possible.
  • Transaction types that are specific to depreciation area cannot be used and required to be marked as obsolete

Errors in Migration

We came across a few errors in migration – one of them being “Mismatched Balance for ANLC”. It was corrected thru an SAP Note 2155523

 

An example of the new posting logic during integrated asset acquisition with two ledger with two different accounting principles:

S/4HANA New Asset Accounting

Source: www.sap.com

As you can see a new ‘technical clearing account’ is used to post accounting principle specific documents. The balance of the technical clearing account is zero.

Embedded Analytics and Reporting

SAP blends transactions and analytics in one system allowing operational reporting on live transactional data.

I can talk hours about reporting in S/4HANA. With the new data structure (e.g. ACDOCA), all the pre-delivered Virtual Data Models (VDM’s), the performance of HANA and the modern and state of the art reporting tools/interfaces, there are so many new possibilities.

The concept of embedded analytics in S/4HANA is to provide pre-defined models across the entire suite in which the business logic is embedded. So the provided data models are delivering contextual information rather than raw data.

S/4HANA Embedded Analytics architecture. Virtual Data Models (VDM) reporting tools, Business Object, BW.

Source: www.sap.com

Let us start with the most commonly used t-code FAGLL03H – G/L Account Line Item Browser (G/L View) that could set up a theme and most of the rest new t-codes become more intuitive to understand.

Please note that the old t-code FAGLL03 still works. The h-version FAGLL03H is optimized for HANA and also provides very interesting and useful, additional features for reporting and analyzing the reports.

The line item browser displays the line items that have been posted in General Ledger Accounting, and also the line items that have arisen through document splitting. The new t-code provides selection from hundreds of fields like COPA, Material Master, Customer. The new t-code also provides additional functionality as on the fly aggregates and pivot model on top of transactions detail. The output is more structured and easy to use.

Run t-code FAGLL03H

Dynamic Selection 

With Change Layout Option several fields that were not available earlier could be added and saved as a new Layout.

Click on the the Arrow  to expand other functions.

Select line you want to get the line item report. Click on right bottom corner of button   and select ‘Call Line Item Report’ from the pull down menu.

G/L Account Line Item Display

Green Arrow Back to go back to G/L Account Line Item Browser

In a nutshell, I can say that the following reporting tools are mostly used at my customers where I did S/4HANA implementations:

  • Fiori-reporting
  • Analysis for Office
  • SAP Lumira

Each tool has its own purpose of course. I can say that with out of the box analytical Fiori apps and the KPI Modeler in SAP Smart Business together with the Analytical Path Framework already provides a lot of content and satisfies a lot of customers.

Some examples of Smart Business cockpit and the Analytical Path Framework apps.

S/4HANA Out of the Box Reporting with Fiori

Source: www.sap.com

Next to these type of apps, SAP provided multi-dimensional reporting apps. For example the Market Segment Actuals app in which I can report on my P&L with in addition my Profitability Analysis characteristics.

S/4HANA Market Segment Actuals App

Source: www.sap.com

For more flexibility the products from the BO suite (additional license) Analysis for Office and Lumira can be used.

 

Benefits to Organization:

Business Benefits

  • Financial soft close ( simulation) on the fly, reduced FTE for reconciliation and reporting
  • Planning and predictive finance: allows companies to predict inbound and outbound cash flows and risk management
  • S&OP will enable sales and marketing department to collaborate with operations and finance in order to evaluate the impact of their strategies and make accurate predictions
  • With Live MRP, planners are able to plan to the lot size of 1 making it very customizable resulting in higher customer satisfaction and retention
  • Real-time & advanced ATP, interactive back order processing

S4 HANA Value play.jpg

Users:

  • With the agility, simplicity S4H offers Users & businesses can re-imagine, re-engineer their business processes
  • Role-based screens rather than having to go all the screens relevant or irrelevant
  • Can focus on strategic tasks than admin tasks
  • Faster reports, analytics will help users in decision making process

IT Value:

  • Reduced TCO in terms of data footprint, maintenance, number of servers

S4H_Perspective_datafootprint.jpg

 

 

 

 

Average Rating
0 out of 5 stars. 0 votes.
My Rating:

0 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *