How to Distribute Costs During Periods of Irregular Production Activity

WALK AWAY FROM THIS SESSION WITH AN UNDERSTANDING OF DISTRIBUTING COSTS DURING PERIODS OF IRREGULAR PRODUCTION ACTIVITY


There are certain scenarios where the activities of a business are not aligned with the period when the costs for those activities are incurred. This occurrence is typical with companies with seasonal production cycles, such as those in the Agribusiness industry, whose investments in land or other resources, do not always coincide with when the utilization of those resources occurs. In those cases, a cost model is set up so that the original cost is spread through the periods of the production cycle, when the actual cultivation of the land takes place.

In these times, where disruption due to COVID 19 has impacted many industries and hence production activities, the model described above could also be useful. During periods of Production Downturn which leads to minimal or no activity, how do you reflect that in a cost structure that had assumed that production will take place? Hear from Rogerio Faleiros, SAP Controlling Expert and Author, who will take you through the following:
- Using Assessments between Cost Centers and Internal
- Orders for Operational Expenses
- Using Internal Order Settlement to transfer Costs to AUCs
- Setting up Depreciation Rules to reflect periods of Uneven
Production
- Using the Allocation Structure to Distinguish Between
- Different Types of Costs

S/4HANA Central Finance Implementation Dummy Initial Load

S/4HANA Central Finance Implementation Dummy Initial Load

SAP Central Finance (CFIN), every large organization is thinking/talking about it is one or another way! It quickly gives the S/4HANA value benefits without necessarily disrupting existing processes. In such CFIN projects, there is a mandatory step for the initial load, even if you do not want to migrate the historical data from the legacy system to the SAP Central Finance system.

Asset Accounting in SAP S/4HANA

SAP S/4HANA has brought about a number of improvements in Asset Accounting. There is a tighter integration with Finance, and postings are now real-time, updating all ledgers at the same time as the asset, allowing a smoother period end and an easier migration.

This is a new webcast, to update the original “Ask a Fixer: What You Should Know About New Asset Accounting with SAP S/4HANA” created in 2017. It explains the previous material in a new way, and in addition, covers new transactions for closing and migration. It also introduces the new Fiori “experience”, which brings additional functionality such as the asset accounting overview and embedded analytics.

Executing the Steps for Migrating to S/4HANA Finance

One of the key tasks when migrating to S/4HANA is to convert your Financial data from the old tables in ECC to the new tables (particularly the Universal journal) in S/4HANA. This process usually takes place after the technical upgrade from ECC to S/4 and is done during a downtime period. It involves a series of transactional steps that are executed in sequence, with progression to the next step only possible when a previous step has been executed successfully or confirmed. Several iterations of a Finance Migration need to be done in a Sandbox (or test) system in order to resolve any issues that arise. This will therefore make the eventual Production migration smoother and easier to accomplish during the downtime window. It is therefore important to know what steps are carried out and the types of errors that could occur.

A Few benefits of SAP S/4HANA

Abstract:

SAP S/4HANA inherits the capabilities of SAP HANA. SAP HANA provides native in-memory engines that can process any type of data in real-time. It can support both Online Transaction Processing and Online Analytical Processing requirements and built to run on high-end hardware. It stores data optimally. It has built-in, high-availability functions that keep the database running and ensure mission-critical applications are never down.

SAP began by rewriting the Business Suite applications starting with Financial Accounting. The data model for Financial Accounting was redeveloped, and the application code for Finance was rewritten entirely on a simplified data model. The revised application is called SAP S/4HANA Finance, formerly known as Simple Finance.

Later, other applications like sales, procurement, and inventory management, etc., are also simplified.

SAP ECC customers can convert their ECC system to SAP S/4HANA using tools that are provided by SAP.

In SAP, ECC applications are built on a hierarchical data model. The complex data model causes the application code complex. With this sometimes, integration with other applications and enhancements appear difficult. SAP S/4HANA has simplified this data model.

 When users post Financial documents in S/4HANA, records hold all information needed for both legal and management accounting. It gives the ability to track financial accounting data centrally.

The new journal entry has header table BKPF and line items table ACDOCA. It contains all fields needed for G/L, CO, AA, ML, and PA. Data for COEP, FAGLFLEXA, ANEP, MLIT will be stored in single table ACDOCA in S/4HANA. I would like to articulate some of the potential benefits of SAP S/4HANA in this article.

Introduction

The business style around us has been changing and becoming more complex. Every one of us has been experiencing a digital transformation. The usage of Mobile devices and social media, bringing changes in the way we live, work, and run the business. New technologies improve work-life and provide us new opportunities in business. The new SAP S/4HANA has a digital core that gives firms a unique platform for improving main business processes and develops analytical and decision-making capabilities in real-time. This enables a firm smarter, and it helps firms in getting real-time insights.

 When I visit our ECC customers as a part of Hackett Group's S/4HANA engagement program, Many of the SAP ECC customers ask a common question "What are the insights and benefits of SAP S/4HANA?". I would like to share a few of the benefits out of SAP S/4HANA.

Advantages of SAP HANA Technology

With SAP HANA, the key to optimum application performance is pushing as much of the execution logic into the database as possible. It helps to improve data processing performance. It has faster response times. Many organizations are happy with their optimizations and the resulting response times.

Some of the SAP HANA Benefits

· Significant reduction of data volume.

· Simplification of data models & programs.

· Considerable reduction of backup and restore processes.

· Algorithms can be corrected much faster as real data. This is supported by reducing data volume. Data is prepared at runtime and doesn't have to be pre-prepared by using aggregate tables

· Very few efforts for programming to get performance under control.

Advantages of SAP S/4HANA

Improvements in the data model

Actual Tables:

The data model of Finance, Inventory Management, etc.. is simplified in S/4HANA. Only one table for Finance, i.e., ACDOCA and Only one table for Material Documents, i.e., MATDOC, etc. Enabled on the fly aggregation, it

simplifies the data structure and makes accounting more flexible in the long term as reporting is no longer limited by the number of fields in the totals records.

There are significant changes in the way transactional data is stored for financial reporting in SAP S/4HANA. This brings considerable benefits in terms of the ability to harmonize internal and external reporting requirements. This simplification brings accounting more flexible.

Planning Table:

From SAP S/4HANA 1610, it is possible to store the results of planning in the ACDOCP Table. This has the same structure as the universal journal (ACDOCA). Plan/actual reporting will be provided by comparing the entries in the two tables. Integration to SAP Analytics Cloud is also via the new table and master data and reference data and can source from SAP S/4HANA to SAP Analytics Cloud.

For group reporting, the SAP Universal Consolidation Journal Entries table is ACDOCU.

Fixed Asset Accounting:

Asset Accounting is based on the universal journal entry ACDOCA. This means there is no longer any redundant data store. The advantage with New Design for Fixed Asset Accounting is, No redundancy in data storage, Reconciliation between G/L and AA is ensured by design- So does not require FI-AA reconciliation, All non-statistical items are updated as Universal Journal Entries. You will be able to display reports Even after migration. Reporting for previous fiscal years is possible due to compatibility views, even if you convert your system. Depreciation posted with all details: Accumulated depreciation and depreciation cost by asset.

FI-AA Reconciliation postings are no longer necessary as a part of closing operations

Asset Accounting and General Ledger Accounting post to the same Table ACDOCA, Asset Accounting will be reconciled permanently with GL. So, a lot of time saves during period end as we don't need to do Consistency Check of General Ledger and Asset Accounting.

 Real-time updation:

For each asset-related transaction example: acquisition, capitalization of assets under construction (AUC), retirement, post-capitalization, etc., asset values for all posting depreciation areas updated in Realtime.

Transparent assignment of depreciation area to accounting principle:

Simplified chart of depreciation. Only one depreciation area per valuation is necessary. Additional depreciation areas (delta areas) not required to portray a parallel valuation, helping in Navigation and drill down per accounting principle.

Separate Document for each Valuation:

Different accounting principles are represented in separate ledgers. Separate accounting-principle-specific documents are posted for each accounting principle.

Accounting Principle specific postings if any

Accounting principle particular assignments can be done using a separate transaction AB01L for an asset acquisition, a post-capitalization, manual depreciation, or write up.

 Cash management for SAP S/4HANA

The new SAP S/4HANA Finance for cash management provides cash managers with novel user experiences.

The end-to-end process of monitoring bank statement imports, checking cash position, and transferring funds to handle surplus and deficit. It also helps in the Medium-term liquidity forecast and rolling plans of long-term liquidity. It has Centralized bank Relationship management, with which business users can manage bank accounts as master data with more business attributes.

Enables analysis of global bank balances & cash positions, based on data from SAP and non-SAP systems. It comes with integrated liquidity forecasting, central bank Relationship management, and equips cash managers with a smart business cockpit.

Centralized Bank Relationship Management.

These Components help for the Approval process for Bank Account Opening, adjustment, and Closing, Cash Position analysis on Bank Accounts instead of G/L Accounts, Signatory integrated with BCM Payment Approval, Plenty of attributes reflecting controls on both bank side and internal side 

Bank Account Master Data stores extensive information like Company Code & Beneficiary Name, Account Number, IBAN & Description, Bank & SWIFT code, Signatory and Limit, Overdraft Limit, Connectivity Path, Account Type, Contact Person, Bank Details, User-Defined Fields, Attachments, etc.

 Integration with Bank Communication Management

Integrated with Bank Communication Management and Fiori App, "Bank Payment Approval." It can define everyone's payment approval limit. Support Single Sign and Joint Sign; Support both sequential and non-sequential Sign. Signatories information used in the Payment Approval process.

Bank Account Approval Workflow can activate for Opening & Closing Approval, Sensitive Attributes Change Approval, Batch Signatories change, and Approval, Review Process Approval, Display existing Bank Accounts in Approval, etc.

 Cash Pooling

The bank account structure maintenance is done using the new bank account group, which is easy to apply for a business user, without configuration The cash pool detail settings Ex: "expected amount" and "minimal movement amount" for every bank account, can be set directly by a business user, without configuration

While concentrating, it's possible to see the balance* before concentration and the simulated balance after the concentration and adjust the transfer amount if needed.

 Transfer Prices

Holding company may do a transaction with its subsidiary or a division with other divisions within a company; transfer price arises for accounting purposes. It determines costs. SAP S/4HANA has Transfer Price Solution

Transfer Price Solution in S/4HANA offers the following:

· Up to three parallel valuation methods for legal, group and profit center valuation provide the following different perspectives on the value chain within a group:

o The legal perspective looks at the business transactions from the affiliated companies including markups

o Profit center valuation treats profit centers as if they were independent companies using, for example, negotiated prices

o Group valuation looks at the whole group eliminating markups

 The Business Partner approach replaces SAP ECC (ERP) SD customer master.

In SAP S/4HANA, we don't need to maintain customer master data and vendor master data separately in two transaction codes. It is possible to manage master data for customers and vendors centrally. The link between a business partner and other components is achieved by a role. A business partner role corresponds like customer or Vendor etc.

New Accrual Engine in SAP S/4HANA for Accruals:

With this, by posting accruals in the system, the relevant costs are allocated to the fiscal period in which they occurred. With release S/4HANA 1809, a new Accrual Engine has developed. The new Accrual Engine is called S/4HANA Accrual Engine. The S/4HANA Accrual Engine is seamlessly integrating with General Ledger. It supports all currencies of General Ledger, and postings can perform on ledger level instead of only accounting principle level. The benefits of New SAP S/4HANA Accrual Engine is :

It is fully integrated into General Ledger. All currencies of General Ledger are supported. The Accrual Engine postings are stored in table ACDOCA as line items. The fiscal year variant of the G/L ledgers is supported. Standard FI reversal, for example, using transaction FB08 or F.80, is supported.

SAP Fiori app Monitor GR/IR Account Reconciliation

With this app, you can get an overview of the status of open items of GR/IR accounts that need clarification. It helps analyze the GR/IR reconciliation by KPIs for purchase order items and open FI items. After identifying where more in-depth analysis is necessary, you can also navigate the monitor to the list of items for GR/IR clarification, investigate the details, or even start processing purchase order items with no matching goods Receipts and invoices receipts.

 It helps in Analyzing the situation for the reconciliation processing of unbalanced GR/IR accounts. You can also find which company codes indicate most of the open items in financial accounting? For which supplier exists the most open FI items? Navigate directly to the worklist of items to be processed.

Production versions are mandatory in S/4HANA

In S/4 HANA, the production version has been made compulsory for the Subcontracting process in purchasing. If the same material is being manufactured in-house and procured from the vendor using the sub-contracting process, two production versions can be created and assigned to the product code. Production version helps you to define different combinations of BOM's

 Flexible Workflow:

The flexible workflow in place of the traditional release process for purchase requisitions and purchase orders. It is an alternative to the Release strategy. Flexible workflow is a scenario-based workflow that can have more than one start conditions. There is a possibility of determining approvers through a lot of different options. It has an option to specify under which condition should the workflow step be triggered / applicable. It configures using a Fiori app, and approval action can be taken from Fiori App, and it supports Fiori 2.0 push notifications

 MRP Live:

The advantage with this is Improved performance and execute the planning run in much shorter cycles (10+ times) – several planning runs daily can be achieved using MD01N. The classic MRP run (MD01) also runs on HANA (parallel to MD01N) with the same functionality as on any other database

More up-to-date supply and demand information on which to base decisions. Faster reaction to demand changes reduces the risk of stock-outs and means that you can reduce safety stocks. Users can identify and react to issues faster than was previously possible.

 Lean Service Procurement:

With the introduction of new material type SERV, business no longer needs to create a service master. It already has the product type group 'Service' in the material type configuration.

Businesses can create materials with material type SERV and product type group 'service' in place of service masters. Purchase requisitions and purchase orders can be created using the Fiori Apps 'Manage Purchaser Requisitions' and 'Manage Purchase orders' and 'Manage Service Entry Sheet's. Services are created as materials with SERV and product type group 'service,' and service lines sub-item levels are not required to maintain in purchasing documents. New material type SERV is created with the reduced user departments and fields in the classical transactions like MM01/MM02/MM03.

 SAP S/4HANA blends transactions and analytics

SAP S/4HANA allows operational reporting on live transactional data. This is supported by core data services views for real-time operational reporting. The content is represented as a virtual data model based on the transactional and master data tables of

S/4HANA. The embedded analytics are available inside the business processes. This helps in making the processing more efficient.

SAP S/4HANA Financial Closing Cockpit

The SAP S/4HANA Financial Closing Cockpit is an application that enables companies to create a structured interface for executing transactions and programs that form part of complex closing processes; The structural layout supports operations within a company code, as well as scenarios affecting multiple organizational structures. This allows all users who do financial closing for a company code or for numerous company codes to set a manual status for a task, document whether the task has been checked, and manually confirm that a transaction has been executed or not.

Managers who have authorizations to view an overview of the status of the closing process, can access status information, and see issues related to tasks, and job logs, spool lists, or application logs created by the system during task execution.

Companies can use Closing cockpit for their month-end and year-end closing activities chronologically and make them available on a standardized interface to all the team that do these activities

Harmonizes financial & managerial accounting by using a single data source of truth for all financial and managerial processes. It significantly reduces reconciliation efforts and allows on-the-fly analysis without system limitations from pre-built aggregates. It comes with built-in data migration to seamlessly transform your current data into the new accounting world.

 New Depreciation Run-

With new Transaction code, The planned depreciation is calculated with every master record change and with every posting on the asset. When the depreciation run is executed, it adopts the projected asset values and posts them in GL. The journal entry is updated in UJE on the asset level. You can perform period-end closing even if there is an error on individual assets. You can also perform a test run. The Selection view is simplified.

 SAP S/4HANA Finance Credit Management replaces ERP SD Credit Management

FI-AR-CR Credit Management is not available in SAP S/4HANA. The functional equivalent is SAP Credit Management (FIN-FSCM-CR). The FSCM credit management provides enhanced functionality to improve cash flow through the new FSCM functionalities- Collections management disputes management. FSCM-CM helps to bring better control over customers' credit scoring with features like managing credit scoring internally and/or storing credit rating of External Rating companies, Interfacing with Credit Rating Agencies, etc.

 SAP S/4HANA Sales

SAP S/4HANA provides significant simplifications in the areas of sales and distribution, capacity planning Etc.

These changes are informed of re-architecting the data model and functions, new user experience, and unifying functionality in the core, in-depth integration into the SAP Cloud solution SAP Hybris. Also, you can use complementary Sales and Billing solutions (like Multi-Channel-Billing)

The changes in sales and billing include the replacement of add-ons and the expanded integrated functional bandwidth such as EWM, PP/DS, and advanced ATP, etc.

Below are some of the areas simplified on SAP S/4HANA Sales

·  The Business Partner approach replaces the ECC ( ERP) SD customer master.

·  SAP S/4HANA Finance Credit Management replaces FI-AR-CR Credit Management.

·  SAP S/4HANA International Trade Management functionality replaces SAP SD Foreign Trade

·  Migration of Financial Documents from SD-FT to Trade Finance in Treasury and Risk Management.

·  SAP Condition Contract Settlement replaces ERP SD Rebates

·  SAP Revenue Accounting replaces SD-BIL-RR Revenue Recognition

·  SAP S/4HANA Analytics: ODATA & Open CDS views replace ERP LIS/ODP.

 Primary changes in Sales and Billing:

Re-architecting the data model, New SAP Fiori apps & streamlined processes, Expansion of the roles, in-depth analytics, and in-depth integration within and across the business lines. To improve efficiency SAP, Leonardo has been introduced to the sales core processes.

 SAP S/4HANA helps in the optimized order-to-cash process in Sales. SAP Fiori apps and analytical views help for managing and controlling sales and distribution. Embedded analytics allows businesses with smart business processes like the sales order fulfillment cockpit. Sales KPIs are delivered out of the box with the flexibility to create dedicated KPIs as per your need. It helps in business transparency. The sales Heads get insight into the sales data to make the right decision at the appropriate time. Complexity in the order-to-cash process turns simple with simplified logistics. A variety of options such as simulation and predictive information will help the sales team make the correct decision

Foreign Trade:

The classical Foreign Trade functionality is not available in SAP S/4HANA; SAP GTS should be used instead.

Rebate Processing:

Settlement Management replaces SAP SD Rebate Processing in SAP S/4HANA, which means that existing rebate agreements will only be processed up until the end of the validity date of the agreement and must then be closed by a final settlement. New agreements will only be created based on condition contracts, which are part of Settlement Management.

Revenue Recognition

SD Revenue Recognition is not available in SAP S/4HANA. The new SAP Revenue Accounting and Reporting ( RAR)

functionality should be used.

This functionality supports the revenue accounting standard as outlined in the IFRS15 and adapted by local Generally Accepted Accounting Principles. Migration to the new solution will be

required to comply with IFRS15 even if an upgrade to SAP S/4HANA is not done.

Sales Activities:

Computer-Aided Selling is not available. It is recommended that customers use CRM side-by-side with SAP S/4HANA or SAP Hybris Cloud for Customer.

 Advanced ATP Overview

The advanced ATP is part of SAP S/4HANA. It helps to improve time to deliver, reduced number of missed business opportunities, and enhanced revenue and profitability. The internal logic for the planning elements from the database to the internal table has been fully redesigned to run in-memory planning. It is integrated into the SAP S/4HANA core.

Advantages:

Promise what you can order, avoid over confirmation

Manage shortage situations

Manage Business Priorities and protect the interest of the customer

Intuitive and fast re-planning

 Manage Sales Plan SAP Fiori app:

This app helps sales managers to create, change, release, and display their sales plans. They can set sales targets on various dimensions for a planned period. Then they compare the actual sales figures to the sales targeted/planned using the Sales Performance - Plan/Actual app.

 Sap Fiori App: Sales Performance — Plan/Actual

Users can select one of their sales plan versions to compare with the actual data. After a sales plan version is selected, the plan and real data can be compared as follows:

Planned and actual values represent incoming sales orders or sales volume, depending on what you have planned in the selected sales plan version

Planned and actual values are compared by month, quarter, or year within the planned period, depending on how you have defined this in the selected sales plan version.

If a customer calls and asks for information on his order, or if our colleague or Manager asks for details on all orders belonging to a particular customer, the Sales team can use it to provide this information quickly. You need to enter search criteria, such as sales documents, requested delivery date, document date, customer reference, to find the relevant sales document

 Embedded EWM :

Reduce cost through better warehouse efficiency, enhanced labor productivity, and better space utilization. It has process transparency, flexible automated processes. Excellent integration with other SAP solutions.

Production planning / Detailed scheduling:

Business benefits from comprehensive planning to production in a single system. It is easy to monitor and for administration. Just a single database to manage.

The Sales order Fulfillment Cockpit

The Sales order Fulfillment Cockpit changes the working mode for an internal sales representative. In SAP, there is an exception based working mode to detect issues earlier and improve customer satisfaction by using sales order Fulfillment Cockpit in SAP S/4HANA.

It brings benefits to the business in a reduction in O to C cycles as well as Outstanding Payments, while service level increases. Using this, we get full insights into all issues of the order Fulfillment process, and we can focus on the most critical issues, Run actions directly and get a track of solution progress. We can also get analytical insights with operational actions

 Group Reporting (Financial consolidation)

Financial consolidation is a very complex topic for Accounts and Finance Departments. It involves complex processes. This is a mandatory exercise for large companies as they have numerous entities, different ERPs, local accounting standards, currencies, etc. play a very significant role.

There is an on-premise solution that is available from SAP S/4HANA 1809 Edition onwards. There is also the SAP S/4HANA Cloud for group reporting solution which became available from May of 2017 onwards

SAP S/4HANA Finance for group reporting stands on the shoulders of consolidation solutions such as Enterprise Controlling-Consolidation System (EC-CS), & Business Planning and Consolidation (BPC).

Some of SAP S/4HANA Group Reporting Features

·  Simultaneous legal and management consolidation.

·  Automated consolidation of investments

·  Group structure manager.

·  Capability to calculate multiple group currencies for a group all in one run.

·  Integration into the financial closing cockpit.

·  Integration scenarios with planning applications.

·  Advanced intercompany reconciliation

·  Intelligent data validation leveraging machine learning.

·  Restatements with less data redundancy.

·  Customer defined dimensions. ( To be verified with SAP)

SAP S/4HANA Manufacturing benefits

·  Newly designed MRP Live Transaction (MD01N) for optimized MRP run performance. The planning file is optimized for update performance (SAP Note 2227059). The primary key is the MRP run's speed, which runs much faster with reduced storage compared to SAP ECC. Therefore, it can be executed more frequently during the day.

·  Simple logic for sourcing, subcontracting (SAP Note 2226333 and 2227532)

·  ABAP list-based process instructions sheets have been replaced by browser-based PI sheets (SAP note 397504)

·  Use MED integration or the POI interface instead of outdated interfaces such as PFS, LPO, Icon CBP, KK2, KK5, and s95 interface.

·  ECL viewer replaced by Visual Enterprise Viewer.

·  Flow manufacturing and Process flow scheduled PFS outdated – use SAP APO instead (SAP note 217113)

·  We will be able to move from batch processing to real-time Executions

·  Manage inventories in the small lot sizes

·  Real-time inventory postings and visibility of inventory values

·  Higher inventory accuracy

·  Reduced safety stocks due to high visibility into stock

 

SAP BPC Optimized for SAP S/4HANA

·  Some of the essential capabilities of SAP BPC Optimized for SAP S/4HANA are below:

·  Single planning solution

·  Real-time access to master & transactional data, for modeling and variance analysis

·  Flexible drill-down on drivers for profitability analysis & End-to-end simulation capabilities

·  Better and seamless integration of planning screens into SAP ERP workflows

·  Pre-built planning models

The advantages of SAP BPC Optimized for SAP S/4HANA are as follows:

·  We can overcome the limitations of GUI based planning

·  Elimination of data replication.

·  Plan data transfer of plan data developed in SAP Business Planning and Consolidation to SAP ERP for variance analysis.

·  SAP Business Planning and Consolidation provides access to real-time master data & actual data maintained in SAP ERP.

Enablement of financial planning capabilities based on

·  SAP Business Planning and Consolidation.

·  An SAP NW version is seamlessly integrated into SAP ERP user interfaces & workflows, effectively replacing the current planning capabilities in SAP ERP.

·  We can have end-to-end simulation capabilities.

Budget Availability Control for Cost Center

The standard SAP R/3 System has no active availability control for cost centers. You can exceed the cost center budget without corresponding messages. If anyone wants availability control for postings to cost centers, we used to use indirect solutions for primary postings. We will be able to activate AVC for cost centers in S/4HANA 1909.

We can create a budget availability control profile, assign budget relevant account groups, and define budget tolerance limits to control the budget consumption in cost centers.

When users post expense, which is tagged as an Actual Cost, the available budget is checked. When the budget consumption reaches a defined limit, the system responds with either a warning or an error message. This system response depends on the settings that you have specified in the budget availability control profile.

If you create a purchase requisition or a purchase order assigned to a cost center, a commitment is generated. This commitment reduces the available budget.

 SAP Fiori Apps

SAP Fiori offers a new Web-based User Experience based on HTML5 and the UI5 framework. It provides Capabilities to users to personalize the screens and adjust the screens. SAP Fiori offers the power to deliver a state-of-the-art user experience.

Conclusions:

SAP S/4HANA is a real-time Business suite for digital business. It allows IT to connect to social & business networks (for example, Ariba and Concur) and the "Internet of Things." SAP S/4HANA comes with very innovative and new feature rich-applications, which make it simple to get insight from real-time data anywhere. Planning, execution, prediction & simulation are all made "on-the-fly," at the highest level of granularity, to drive faster business impact. It is designed with SAP Fiori UX, enabling business users to get the job done with a personalized, responsive, and simple user experience available on any device. In short, SAP S/4HANA is the re-imagined Business suite for re-imagining business.

Design and Configuration Changes In Controlling with S/4HANA

WALK AWAY FROM THIS SESSION WITH AN UNDERSTANDING OF DESIGN AND CONFIGURATION CHANGES IN CONTROLLING WITH S/4HANA.

Presenter will share important design and configuration changes in Controlling with S/4HANA, including: Cost Element part of G/L Account; Account Based Profitability Analysis; Material Ledger mandatory; Cost of Goods Sold by cost component; Production variances by category. • In ECC, Cost Elements are created within Controlling module; with S/4HANA Finance, Cost Elements are now part of G/L Account.• In ECC, Costing-based CO-PA has several advantages over Account-based CO-PA and had therefore been a preferred choice for majority of the clients; with S/4HANA Finance, most limitations of Account-based CO-PA have been addressed.• In ECC, Material Ledger is optional, which includes Actual Costing functionality which calculates Actual Cost / Periodic Unit Price; with S/4HANA Material Ledger is mandatory (Price Determination 2 – Transaction-based); but Actual Costing is still optional (Price Determination 3 – Single-/Multilevel).• In ECC, costing-based CO-PA allows visibility of various cost components in profitability reports, but in FI, only one line item is visible for COGS; with S/4HANA’s account-based CO-PA, different cost components can be mapped to multiple general ledger accounts.• In ECC, all production variances are bundled and posted to one price difference (PRD-PRF) account; analysis of variances is carried using Controlling reports; with S/4HANA, variances can be posted to different G/L accounts.

Trailing Foreign Currency Valuation Posting Log in SAP S/4 HANA 1709

The valuation of foreign currency in SAP has always been a process that requires additional accounting effort to track historic posting for Financial reporting and auditing requests. Information reports available in SAP do not include some details usually requested by the auditing process (i.e., vendor or customer associated to valuation document, original open item document valuated, etc.) in a single report. Even though a log can be activated and stored for this transaction, further custom development should be done to fulfill internal information needs.

A single report gathering balance and open items valuations that could be executed whenever be required can have the following simplified layout:

Blog 1.png

      I. Process Overview

Foreign currency valuation runs utilizing transaction FAGL_FCV.  This application allows the valuation of balance accounts and open items.

Blog 2.png

The financial/accounting department has to define all parameters required to execute this transaction (i.e., valuation method, accounts to be valuated, etc.) per local accounting principles. Then it can be used to calculate how the rate of exchange of the balance is affected by foreign currency fluctuations at the month-end. As a result, a gain or loss is posted with correspondence to configured accounts.

Depending on what kind of valuation has been chosen by the user, there are two possible posting options: balance accounts and open items documents (accounts, vendors, and customers). Both scenarios will be presented in the next paragraphs.

Balance account valuation.

It is executed using tab ¨Open Items: G/L Accounts¨:

Blog 3.png

Resulting screen will look like:

Blog 4.png

Journal entries will have the following accounting structure:

Blog 5.png

The screenshot above demonstrates that valuated account 11010500 is directly debited or credited to a gain or loss account (i.e., 42020106 or 62010206); as a result, the actual account balance is changed.

 Open items valuation

It should be executed on the tab "Open Items: G/L Accounts":

Blog 6.png

The result is shown below:

Blog 7.png

The associated postings do not affect reconciliation accounts directly; they post balance differences to balance correction account. It keeps intact the reconciliation account balance of vendors and customers

For document 0800000004, currency exchange difference generates a debit to an expense account and a credit to balance correction account.  On the other hand, the document 0800000006 posting credit a gain account and debit to balance correction account. Hence, the document´s open balance remains unchanged.

Standard transaction log available in FAGL_FCV.

SAP provides the possibility of the store log from the execution clicking on “Save Log” option to store execution outcome in a log file:

Blog 8.png

But it does not bring information besides what you see in the standard screens showed above. Moreover, if this option is not timely activated, the log will not be saved. 

     II. Technical approach for custom log report

Three main tables store data created after execution of the valuation process: ACDOCA, FAGL_BSBW_HISTRY, FAGL_BSBW_HST_BL, and ACDOCA. Now we are going to see their relationship in the next paragraphs.

FAGL_BSBW_HISTRY - Valuation History for Documents

This table keeps historical documents created by the valuation of open items documents (vendors, customers, and balance accounts with OI management). In the next table, I have detailed principal fields that should be considered to build a link with Universal Ledger:

table 2.jpg

FAGL_BSBW_HST_BL  - Valuation History of Balances:

This table keeps historical documents created by the valuation of balance accounts.  In the next table, I have detailed principal fields that should be considered:

table 3.jpg

ACDOCA -Universal Ledger and Foreign valuation

In S/4 HANA 1709, the universal ledger provides the table ACDOCA for most financial data postings. So, this table must be used as a principal database for any report related to the FI module.  The next table shows the essential fields to consider:

table 4.jpg

III. Balance Report design

Using a query ABAP or an ABAP report is possible to do the desired layout following this mapping chart:

table 5.jpg

There are some crucial points to keep in consideration:

· Auxiliary tables FAGL_BSBW_HISTRY and FAGL_BSBW_HST_BL  collect information of balance and open items in a time interval selected

· FI documents created during FAGL_FCV execution are recorded in ACDOCA.

· Company code, year, business transaction type, valuated account, date, and time stamp are the key linking ACDOCA and FAGL_BSBW_HST_BL.

· Company code, year, business transaction type, date, and time stamp are the key linking ACDOCA and FAGL_BSBW_HST_BL.

· ACDOCA is the main table to collect data from auxiliary tables.

· Currency exchange rate used for each document in ACDOCA can be retrieved using function module READ_EXCHANGE_RATE.

Application Development in SAP S/4HANA

SAP Customers deal with many business objects in daily business. SAP developed many applications to manage several business objects to use. In many scenarios, customers do define and develop custom business objects (Applications) to speed up or to develop a new business process.

Most of the business objects are in hierarchical structures—a mandatory header, Item, sub-item, and so on. In SAP S/4HANA, one can utilize the power of SAP S/4HANA development artifacts to design and develop applications in simple steps that require basic knowledge of ABAP, Core Data Services, and Fiori Elements using WebIDE. Business object development starts with design. Let’s continue with an example of a business object with header and item relation.

Image_1.jpg

Step 1: Design a database table for header and Item with respective keys and foreign key relation.

Step 2: Define basic CDS views on top of DB tables (Basic views starts with I_*). The basic view should reflect the underlying data model.  Define mandatory header annotations like

@VDM.viewtype: #BASIC, @objectmodel.representativekey: 'Material' @accesscontrol.authorizationcheck: #CHECK @objectmodel.usagetype.*, @abapcatalog:*

Tip: Make use of SAP Global Field Names (GFN) to refer to the DB field names. SAP GFN's are approved abbreviations to refer to a view field.

Tip: Annotate basic CDS view fields with semantic annotations like Currency key, Currency, Quantity Quantity Unit, Visibility, and so on.

Step 3:  Build a relation between header and Item CDS view via association.

Define consumption view, in view of the business process and user interface:

Step 4: Define consumption header(root) CDS view and include view fields from the underlying BASIC header view. Must include the mandatory header annotations

@VDM.viewtype: #CONSUMPTION, @objectmodel.*, @objectmodel.semantickey:*, @abapcatalog.* , @accesscontrol.*

 Step 5: Define consumption item CDS view and include fields from underlying BASIC Item view. Must include the mandatory header annotations

@abapcatalog*, @accesscontrol.*, @VDM.viewtype: #CONSUMPTION, @objectmodel.*

Step 6: Associate header and item consumption views with respective key combination.

Consumption views reflect the user interface. Which means, the UI technology ‘Fiori Elements’ will generate the user interface in resemblance to the annotations defined in consumption views.

Fiori elements offer different layouts to develop the user interface. The most popular layout is the list report. List report comes with the pattern of a list page, that displays the header data records in a table format. Upon selecting the record, user will be navigated to an object page, where further details of header data and items can be found. Header data and items are groped by Facets. Further selection of item from related table will navigate to the object page of respective item.

Application to use Fiori elements must define a set of annotations either in CDS views or in local UI project metadata.

Frequently used annotation in list report:

List page: @ui.lineitem, @ui.selectionfield

List page contains a table and associated filters. For an example, a header CDS view has 8 fields and list page must show 5 important fields in table and 2 of them are filterable.

@AbapCatalog.sqlViewName: 'CHEADER'

@AccessControl.authorizationCheck: #CHECK

@EndUserText.label: Header view'

@VDM.viewType: #CONSUMPTION

@ObjectModel.createEnabled: true

@ObjectModel.updateEnabled: true

@ObjectModel.deleteEnabled: true

C_Header as select from I_Header

association [1..1] to C_Item as _Item on $projection.ID = _Item.ID

{

@UI.lineItem: [{position: 10 }]

@UI.SelectionField: [{position: 10 }]

Key Field1,

@UI.lineItem: [{position: 20 }]

@UI.SelectionField: [{position: 20 }]

Field2,

@UI.lineItem: [{position: 30 }]

Field3,

@UI.lineItem: [{position: 40 }]

Field4,

@UI.lineItem: [{position: 50 }]

Field5,

@UI.SelectionField: [{position: 30 }]

Field6,

Field7,

Field8,

}

As a result, Field1, Field2, Field3, Field4, Field5 will be positioned in list page table. Fields Field1, Field2, Field6 will be positioned in global filters in respective position order.

Image_2.jpg

Object page:

Object page projects an overview of an entity and relation to associated entity sets. In our example, the general data facet should show all fields of header data and a facet for item data table.

Frequently used annotation in Object Page:

@ui.Identification, @ObjectModel.association.type, @ui.Datapoint

Below example can be followed to display non fields of root node in one facet and another facet to access item records formatted in a table.

{          

            @ui.dataPoint: { targetValueElement: ‚Field1‘ }

Key Field1,

@UI.identification: [{position: 10 }]

Field2,

@UI.identification: [{position: 20 }]

Field3,

@UI.identification: [{position: 30 }]

Field4,

@UI.identification: [{position: 40 }]

Field5,

@UI.identification: [{position: 50 }]

Field6,

@UI.identification: [{position: 60 }]

Field7,

@UI.identification: [{position: 70 }]

Field8,

@ObjectModel.association.type: [#TO_COMPOSITION_CHILD]

_Item

}

Result:

Image_3.jpg

As a result, fields from 1 to 8 are shown as a form in facet ‘General Data’ and Item table in another facet. Field1 will be positioned in Object page Header.

CDS header annotations like @Objectmodel.create/update/delete enabled will enable create, update, delete operations on respective entity set. Of course, ABAP data provider class must be implemented to handle the request.

In addition, a gateway project should be defined (Tcode: SEGW) to build an interface between UI & Backend. The project should be created via Referenced Data Source in reference to the Consumption Header CDS view. As a result, Data provider class, Model Provider classes, Gateway service will be granted automatically upon project generation. Register the service in gateway client to build an UI project using Web IDE.

Using the Prediction and Commitment Extension Ledger for Sales and Purchase Orders

WALK AWAY FROM THIS SESSION WITH AN UNDERSTANDING OF THE PREDICTION AND COMMITMENT EXTENSION LEDGER FOR SALES AND PURCHASE ORDERS PAGE.

Watch this pre-recorded webcast with FI/CO expert Paul Ovigele to learn:

· The different types of Extension Ledger and what they can be used for

· The difference between Predictive Analytics and predictive accounting

· How to Set up the Extension Ledger for Prediction and Commitments

· How the Extension Ledger works with Sales Order postings

· How the Extension Ledger works with Purchase Order postings

The Ropes to a Successful Data Migration

The Ropes to a Successful Data Migration

SAP S/4HANA Migration Cockpit https://help.sap.com/viewer/29193bf0ebdd4583930b2176cb993268/1709%20002/en-US Steps to create a simple LSMW using batch input recording https://wiki.scn.sap.com/wiki/display/ABAP/Steps+to+create+a+simple+LSMW+using+batch+input+recording Types of Enterprise Data (Transactional, Analytical, Master) http://bi-insider.com/posts/types-of-enterprise-data-transactional-analytical-master/

Optimization of Cash Operations using SAP Cash Management Powered by SAP HANA.

Optimization of Cash Operations using SAP Cash Management Powered by SAP HANA.

About the Author:

Dr. Ravi Surya Subrahmanyam   is a technical and Financials writer with a background in SAP Financial Accounting, Funds Management, Financial Supply Chain Management, Cash Management & in-house cash, SAP S/4 HANA Finance, RAR etc.   He has been working as a Director for the SAP Practice for The Hackett group India Ltd, GDC- India. He completed his Master’s degree in Finance from Central University, Master of Commerce from Osmania University, Master of Commerce from Andhra University, and Ph.D.in Finance from one of the best universities in India. His research Papers have been published in National and International magazines. He has been a Visiting Instructor for SAP India Education and SAP Indonesia – Education. He has been working on Conversion and Upgradation projects. He is a Certified Solution Architect for SAP S/4 HANA and an SAP S/4 HANA Certified Professional. He can be reached at sravi@answerthink.com  or fico_rss@yahoo.com.

Migration to SAP S/4HANA: What it means to SAP Customers

Globally, the technology space is changing fast and as such, the business enterprise systems are under immense pressure not only to keep up with these advances in technology but also the agile needs of business organizations and their desire to improve efficiency while simplifying business processes. It is with this regard that SAP embarked on a journey in 2015 to offer its customers new improved best practices, a simple and intuitive user interface coupled with faster processing speeds and embedded analytics powered by SAP S/4HANA. SAP, therefore, announced in 2015 that all its customers that the support for the SAP ERP will be ending by the close of 2025. According to a survey carried out by a market research firm IDC, 73 percent of surveyed businesses were planning to migrate into SAP S/4HANA, 18 percent currently deploying and 54 percent of SAP customers were planning to migrate in the next 3 years. Whether this is a sale strategy by SAP or not, we seek to evaluate what this migration means to the existing SAP customers and the expected changes.

Planning Your Finance Migration From SAP ECC to SAP S/4HANA

To help organizations through the SAP ECC to SAP S/4HANA journey, ERPFIXERS and Winshuttle have joined forces for a webinar to discuss our views on the tools, tricks, and processes that can help companies.

Watch this webinar to understand the complex challenges and choices involved in making the finance transition from ECC to S/4HANA as smooth as possible.

Journal Entry Fiori Upload

The purpose of JE posting is to take a batch, validate it for consistency, and create FI documents and post those entries in various line item accounts needed for subsequent business processing.

JE Posting is a process that with a few exceptions runs "behind the scenes" (without user dialog) and is the heart of Journal Entry. It receives journal entry data (representing financial transactions) from the PRA modules (Valuation, Revenue Distribution, etc.), and summarizes them in batches and posts them to the PRA JE line item tables and to SAP FI. JE Posting is the link between the journal entries coming from PRA applications and the FI documents and JE line item table items that are created.

The JE Posting Module is automatically called by the various PRA application areas. For example, whenever you create a Valuation, Revenue Distribution, Checkwrite, Check Input, Tax and Royalty, Owner Suspense, or Accounts Receivable document, the JE Posting Process is automatically triggered, but the standard postings limited in such a way that it can’t handle mass upload of the JE records for various business needs like periodically post entire leasing documents and costs associated to it into SAP FI . Also, the standard SAP JE backend upload program provides the ability to rejected / errored out entries corrected online and it is a manual and tedious effort. This can be simplified by using this JE Fiori upload application by mass upload of the rejected records by downloading, correcting and uploading again

The need is to have an JE Fiori upload application so that the end users can validate, park / post the various financial records into SAP FI with ease , simplified and with great user experience.

Accelerated Accounting Close Can Fix So Many Problems!

The year-end close process is one of the important activities of companies. End users spend most of the time on reconciliations, collecting and validating the data from different components of the same company code or multiple company codes reconciling intercompany activities, reconciling accounts, and making necessary adjustments, finally producing the financial statements. Even today many companies are following outdated & poor closing processes using excel sheets. This paper is aimed to provide an overview on closing processes in SAP S/4 HANA, so companies can shorten the Accounting close and helps faster decision making

Fiori Advancements in Financial Closing Cockpit in S/4HANA

Period end closing is always a critical and high visibility item in any ERP. The timely and effective monitoring and control of period end closing is top most need for the finance department. For this purpose, you must process a sequence of interdependent steps diligently in a specific and well-defined order. Entities use various tools for this, ranging from excel to more sophisticated tools like SAP Financial Closing Cockpit, Blackline’s Runbook etc.

Q&A: Enable Cost Component Split in G/L Accounts – Before SAP S/4HANA!

The Cost Component Split allows for granularity of the cost drivers in your inventory and cost of goods sold. The cost components can be seen in various reports in Product Cost Planning and Material Ledger. However, this breakdown has not been available in the General Ledger before SAP S/4HANA. By utilizing a Custom Enhancement, the Cost Component Split by G/L Account can be available in the ECC system. This will provide suitable transparency about cost drivers in the General Ledger, particularly for companies that do not plan an S/4 conversion for a few years, and also positions them with a Splitting Structure that is compatible for an eventual S/4 Conversion. This functionality can be used to split cost components for COGS accounts as well as Inventory accounts (which means that you can get transparency into how much material stock or Fixed costs are sitting in inventory). Also, this functionality can be used whether a company uses Material Ledger or not (i.e. it can be used for Standard and/or Actual cost components). Watch this pre-recorded live Q&A with FI/CO expert Rogerio Faleiros to learn:

  • The things to consider when deciding whether to split COGS in the G/L Accounts.

  • How to map the original COGS account to the Cost Component Split Accounts.

  • A demo of the Cost Component G/L Split program and how to view the General Ledger postings.

  • The Reports that can be used to display the COGS documents that have been split.