ACDOCP on S/4 FINANCE

SAP S/4 Finance, 1610 has ACDOCP table for Planning, which has a similar structure to ACDOCA. SAP Plans to switch all CO objects to update ACDOCP and it would be the “Single Source” for planning data. COSP/COSS tables will be replaced with ACDOCP in future.

2017-02-17_212804

ACDOCP will gradually expand to cover “Period based planning” i,e General ledger Planning, Cost Center Planning, Project/WBS planning and Profitability Planning etc.

The Object based plans that for Projects, Sales orders, Productions orders will write into ACDOCP in future.

ACDOCA and ACDOCP  will bring the actual and the planning together all in one single source of truth.

Thank You

Jayanth Maydipalle

Create Bank Accounts on Fiori / NWBC

Below mentioned Roles are required to activate “Manage bank accounts” app on Fiori.

The user must be assigned with role:

  • SAP_BR_CASH_SPECIALIST (for On-premise Edition)
  • SAP_BCR_FIN_CM_BAM_MC (for Cloud Enterprise Edition)
  • SAP_BCR_FIN_CM_BANK_ACC_MGM (for Cloud Project Services Edition)
Back-End Server: Activate Web Dynpro Application:

Component: Web Dynpro Application

Technical Name: WDA_FCLM_BAM_HIERARCHY

Use transaction “SICF” and make sure that the ICF service for the Web Dynpro application is activated.

Back-End Server: Assign Role with Start Authorization for Web Dynpro Application:

Component: Back-End Role

Technical Name: SAP_SFIN_CASH_MANAGER

2016-12-09_133039

The Manage Bank Accounts transactional app provides an overview of your bank accounts in a hierarchical structure and allows you to maintain bank account master data according to your organization’s business requirements, as shown in

2016-12-09_134425.png

Activation of Material Ledger on SAP S/4 HANA 1511 Finance

Activation of Material Ledger is mandatory on S/3 HANA due change in the data design for Inventory valuation but activation of actual costing is not mandatory on SAP S/4 HANA.

Below mentioned screen shot prescribes traditional Inventory management Vs S/4 HANA Inventory management based on Material ledger.

sdad

Material Valuation in SAP S/4 HANA allows Up to 3 currencies,

  • Tracking historic rates in Material master.
  • Local legal valuation & e.g hard or trading currency.

Actual Costing:

  • Optional revaluation of stock and COGS
  • Leverage Actual cost component

Activate Material Ledger

as

We activate the Material ledger for one or more valuation areas, if the material ledger is active for a particular valuation area, all materials in the valuation area are valuated using the material ledger.

But SAP recommends if you activate the material ledger for a plant, you should also activate it for all the other plants in the company code. This ensures that the accounts in Financial Accounting and Materials Management are reconciled.

Activate Valuation Area’s for Material Ledger:

ax

In this activity, you can specify in each valuation area that a planned price is activated as the valuation price upon the first goods movement in a new posting period as long as the validity date of the planned price has been reached.

The planned prices are handled by the system with the following priority:

  • Marked standard cost estimates
  • Future valuation prices

Actual Costing:

Inventory and material movements are generally valuated either at Standard price (S) which is constant over a period of time or Moving average price (MAP) which gets adjusted (calculated) automatically based on every Goods receipt or Invoice receipt. Both of these two methods have their own pros and cons. Actual costing combines the advantages of standard price with advantages of using MAP.

ML captures all price variances (like purchase price variances, production variances etc) and allows (as optional period end activity) revaluation of ending inventories at period end and releases it as standard price (generally) for next period. Actual costing is optional in S/4 HANA.

Activate Actual Costing:

2016-08-01_105428

2016-08-01_105341

Depending on which activation type is chosen

  • Actual consumption is updated in the quantity structure but not considered by price determination.

You can use this setting if you simply want information about the complete actual quantity structure. You can assign variances between the plan price of the cost center/activity type or process, and the actual price calculated at period end to the particular cost object at period-end closing using the function ‘Revaluation at Actual Prices’.

  • Actual consumption is updated in the quantity structure and taken into account for the price determination.

If you choose this setting, the variances between the plan price and the actual price are adjusted subsequently. The cost center or the process is then credited and the material associated with the consumption is debited. In the context of multi-level price determination, these variances can be rolled up through the production structure up to the finished product in the same way that material price variances are rolled up.

If you choose this setting, you cannot use the function ‘Revaluation at Actual Prices’ at period closing in Cost Object Controlling, as the variances from the cost centers/processes are debited to the material direct. If you do use the function ‘Revaluation at Actual Prices’ at period closing, the cost centers/processes are credited twice and the materials are debited twice.

We have to keep below mentioned points during Migration of Material Ledger Customizing:

Key Points:

  • The material ledger is required if you are using SAP S/4 HANA Materials Management – Inventory Management (Simplified Logistics).
  • You need to migrate the material ledger even if you are already using SAP Simple Finance (that is, you are migrating from SAP Simple Finance to SAP S/4 HANA Inventory Management).
  • You need to migrate the material ledger even if you are already using the material ledger in your source system.

Document number ranges in S/4 HANA sFIN

Document number ranges in S/4 HANA sFIN

Since the system now writes only one journal entry for all of the components G/L,
CO, AA, ML, one document number is sufficient from a business point of view. The
journal entry consists of a header (BKFP) and items {ACDOCA). The respective
document number (BKPF-BELNR/ACDOCA-BELNR) must obey the legal rules of
Financial Accounting. As a consequence, the document number is dependent on
the fiscal year and the company code.

2016-04-14_142900

CO document numbers have not been year dependent. Material ledger document ACDOCA numbers have not been dependent from the DOCLN
organizational unit (e.g. company code). ooooo1 Both numbers did not have a legal ooooo2 relevance. Moreover, ACDOCA has a 6 digit …
field for the document line, whereas COEP oo1o82 has only a 3 digit field. This is still used in 001083 many user interfaces and reports. For compatibility reasons, SAP offers a new 001130transaction number for every 999 documen lines.

The new universal journal entry replaces the Financial Accounting (FI) document and the Controlling (CO) document with a universal document. A journal entry is created for every business transaction in one of the following application components:

  • General Ledger Accounting (FI-GL)

  • Asset Accounting (FI-AA)

  • Controlling (CO)

    Exception: Costing-based Profitability Analysis (CO-PA)

  • Material Ledger (CO-PC-ACT)

Changes in S/4 HANA sFIN Document types and Number ranges:

2016-04-14_151701

In this activity, you define your document types. Document types are used to differentiate the business transactions and to manage how document are stored. This documentation describes the special procedure for setting up document types for New General Ledger Accounting.

2016-04-14_151825

Here, you make the settings specifying the document type for postings to non-leading ledgers.

Under Define document types for Entry View, you make the document type settings for postings in the entry view that effect all ledgers and for postings to the leading ledger.

2016-04-14_152000

SIMGSIMG_CFMENUORFBFBN1

In this IMG activity you create number ranges for documents. For each number range you specify (among other things):

  1. a number interval from which document numbers are selected
  2. the type of number assignments (internal or external)

You assign one or more document typesto each number range. The number range becomes effective via the document type specified in document entry and posting. You can use one number range for several document types. This means you can differentiate documents by document type but combine them again for filing the original documents, provided you store your original documents under the EDP document number.

Integration of Controlling with Financial Accounting:

New Settings for customizing Controlling in S/4 HANA sFIN

2016-04-14_150055

In this activity, you can create new Document types for posting in Controlling, example you can create a document type that you can use for the manual reposting of primary costs.

2016-04-14_150630.jpg

2016-04-14_151033

In this activity, you define a mapping variant that maps CO business transactions to document types. This mapping must be done for all CO business transactions that do actual postings.

Upgrades: The migration of the ledger Customizing generates a default mapping variant in which all CO business transactions are mapped to the document type that was entered in the variant for real-time CO-FI integration.

2016-04-14_151259

You place your mapping of FI documents to CO transaction / document types here

2016-04-14_151441

Parallel Accounting in New Asset accounting powered by SAP HANA

In New asset accounting, you can handle parallel accounting using depreciation areas.

For representing parallel accounting in New asset accounting, you have two scenario’s as mentioned below.

  • Using Parallel ledgers: The Ledger approach
  • Using Additional accounts: The Accounts approach

Ledger approach:

  1. Different accounting principles or valuation are mapped in separate ledgers, as in new General ledger accounting. In general, the same accounts are used in the ledgers.
  2. The depreciation areas have equal status. Separate documents are posted for each accounting principle or valuation.
  3. For each accounting principle or valuation, the system posts the correct values in real time. The values that are posted are full values and not delta values.
  4. For each valuation, there is always just one depreciation area that posts to the general ledger in real time and manages APC. For this leading depreciation area, choose the posting option Area Posts in Realtime. This applies both for the leading valuation and for all parallel valuations. You can choose which of these depreciation areas, which post to the general ledger, posts to the leading ledger.
  5. One or more depreciation areas represent a valuation. You must assign an accounting principle uniquely to all depreciation of a valuation. For each valuation, the accounting principle has to be assigned to a separate ledger group. The ledgers of these ledger groups are not allowed to overlap.
  6. Differences in values in each accounting principle: You can enter documents that are valid only for a certain accounting principle or valuation. To do so, when entering the business transaction, you can restrict the posting to the accounting principle or to one or more depreciation areas.

  7. You can assign different fiscal year variants to each type of valuation. (There is a restriction in this case: The start dates and end dates of the fiscal year variants must be the same.)

  8. Within an asset class, it is possible to make a simple assignment of different G/L accounts (such as, reconciliation accounts for APC and value adjustments) for each valuation.

  9. If you have defined parallel currencies in new General Ledger Accounting, and you want to use these currencies in new Asset Accounting, you are required to create – for the leading valuation and the parallel valuations – the necessary depreciation areas for each currency.

  10. Managing quantities: In the standard system, depreciation area 01 is intended for the quantity update. If needed, you can specify a different depreciation area for the quantity update. However, this has to be a depreciation area that posts to the general ledger. The quantity – if it is to be managed on the asset – is updated in the asset master record only when a posting is made to this different depreciation area.

Different Fiscal Year Variants:

You can enter a separate fiscal year variant for each depreciation area in Asset Accounting. The start and end dates of this fiscal year variant have to be the same as the start and end dates of the fiscal year variant of the company code. As part of the ledger approach, the system also allows a posting in a representative ledger, to which any fiscal year variant is assigned. The system then derives the period from the posting date. The depreciation, however, is determined as before using the fiscal year variant of the depreciation area of the posting.

Accounts Approach:
  1. You represent different valuations on different accounts within the same general ledger. This means that you have to create the same set of accounts again for each parallel valuation.

  2. Separate documents are posted for each accounting principle or valuation.

  3. For each accounting principle or valuation, the system posts the correct values in real time. The values that are posted are always full values and not delta values.

  4. For each valuation, there is always just one depreciation area that posts to the general ledger in real time and manages APC. The following applies for these posting depreciation areas:

    1. For the leading valuation, choose the posting option Area Posts in Realtime.

    2. For the parallel valuations, choose the posting option Area Posts APC Immediately, Depreciation Periodically.

    You can choose which of these depreciation areas that post to the general ledger represent the leading valuation.

  5. There can also be investment support on the liabilities side for the valuations. These depreciation areas also receive the posting option Area Posts in Realtime for the leading valuation or Area Posts APC Immediately, Depreciation Periodically for parallel valuations.

  6. One or more depreciation areas represent a valuation. You must assign an accounting principle uniquely to all depreciation areas of a valuation. For each valuation, the accounting principle has to be assigned to a separate ledger group. These ledger groups must always contain the leading ledger as the representative ledger.

  7. If you have defined parallel currencies in new General Ledger Accounting, and you want to use these currencies in new Asset Accounting, you are required to create a depreciation area for each currency for the leading valuation. However, this is not mandatory for the parallel valuations.

  8.  Differences in values in each accounting principle: You can enter documents that are valid only for a certain accounting principle or valuation. To do so, when entering the business transaction, you can restrict the posting to the accounting principle or to one or more depreciation areas.

Source:SAP Library

Migration to SAP Simple Finance powered by SAP HANA

SAP Accounting powered by HANA contains New General Ledger accouting , Controlling and New Asset Accounting. If you want to implement and use SAP Accounting powered by SAP HANA, you have to migrate the existing user data from the G/L Accounting (FI-GL), Asset Accounting (FI-AA), Controlling and Material Ledger areas. The comprehensive data table “ACDOCA” contains all of the line item documents from  FI, FI- AA and CO.  All postings of these applications are written to the new table after the installation and migration are complete. 2015-04-02_181732 The above screenshot shows the various accounting applications merge in the new structure of SAP Simple finance powered by SAP HANA. The following tables were replaced by SAP HANA views with the same names:

  • The line item, totals tables and application index tables of General Ledger Accounting (GLT0, BSIS, BSAS and FAGLFLEXA, FAGLFLEXT, FAGLBSIS, FAGLBSAS)
  • The totals tables and application index tables of Accounts Receivable and Accounts Payable (KNC1, KNC3, LFC1, LFC3, BSID, BSIK, BSAD, BSAK)
  • The line item and totals tables of Controlling (COEP for certain value types, COSP and COSS)
  • The material ledger tables for parallel valuations (MLIT, MLPP, MLPPF, MLCR, MLCD, CKMI1, BSIM)
  • The Asset Accounting tables (ANEK, ANEP, ANEA, ANLP, ANLC)

Replacing these tables with views with the same names ensures the continuation of all read accesses to the tables mentioned. With the SAP Simple Finance add-on for SAP Business Suite powered by SAP HANA 2.0, the comprehensive data table ACDOCA is provided, containing all line item documents from FI, FI-AA, and CO. All postings of these applications are written to the new table after the installation and migration are complete. SAP Accounting powered by SAP HANA is based on new General Ledger Accounting (FI-GL (New)) and uses functions such as ledgers to update a particular valuation, and the document splitting function. If you want to use SAP Accounting powered by SAP HANA, but were still using classic General Ledger Accounting until now, migrate the application data for General Ledger Accounting and the necessary settings for the new Customizing, for example ledgers and integration for Controlling. However, none of the functions of new General Ledger Accounting such as Parallel Ledgers and document splitting, are implemented. For Asset Accounting purposes you use new Asset Accounting in SAP Accounting powered by SAP HANA. During the migration from classic Asset Accounting to new Asset Accounting in SAP Accounting powered by SAP HANA, you migrate Customizing settings and transaction data. Source:SAP.com

New General Ledger Accounting powered by SAP HANA

Smart Financials requires New General Ledger Accounting. ( The classic General Ledger Accounting is not part of Smart Financials)

  • Either you already have New General Ledger Accounting active

  • Or when you don’t have New General Ledger Accounting active yet, you can install the Smart Finanicals first. Then you can migrate to New General Ledger Accounting directly and active it there.

2015-03-02_123350

The data model of new General Ledger Accounting was simplified for the integration with SAP Accounting powered by SAP HANA. All data in new General Ledger Accounting is stored in document tables and line item tables. The system calculates the aggregated data in the relevant views.

The new data model eliminates the need to save redundant data (for example, in totals tables or index tables). Furthermore, inconsistencies can no longer arise between FI documents and totals tables.

The following tables have been replaced by views:

  • BSIS
  • BSAS
  • GLT0
  • FAGLFLEXT
  • FAGLBSIS
  • FAGLBSAS

Tables GLT1 and GLT2 are no longer available for new General Ledger Accounting within SAP Accounting powered by SAP HANA. Consequently, ledgers for these tables are no longer updated and can no longer be processed or analyzed in the Special Purpose Ledger (FI-SL). If you still need to use one of these ledgers, contact SAP Development Support (message component FI-SL-SL). The new data model allows you to continue to use programs to access the database as before. This also applies for user-defined programs.

The following functions are no longer available with SAP Accounting powered by SAP HANA:

  • Balance Sheet Planning
  • Reports for comparing planning data and actual data in Profit Center Accounting
  • Destruction of data or deletion of FI documents (Information Lifecycle Management)
  • Average balance ledger

Classic General Ledger Accounting is no longer available due to the changed data model within SAP Accounting powered by SAP HANA. If you have previouslybeen using classic General Ledger Accounting, you can transfer your data to new General Ledger Accounting during the migration to SAP Accounting powered by SAP HANA.

Since Customizing for classic General Ledger Accounting is no longer available with SAP Accounting powered by SAP HANA, the following Customizing activities have been included in Customizing for new General Ledger Accounting:

  • Clocing Cockpit: General Ledger Accounting(New) Periodic Processing Closing Cockpit.
  • ReGroup: General Ledger Accounting(New) Periodic Processing Re Classify.

As of SAP Accounting powered by SAP HANA, new General Ledger Accounting offers the following new functions and changes to existing functions (compared against SAP enhancement package 7 for SAP ERP 6.0 : SAP Accounting powered by SAP HANA.

  • Balance Carryforward: In addition to the functions that were previously available, the program for carrying forward balances now enables you to initialize data carried forward previously when you want to repeat a balance carryforward. Furthermore, you can save results lists and then use the program to display them at a later point in time.
  • Integration with Materials Management: Account Determination for Cost of Sales, You can specify that the cost of sales is posted to different accounts on the basis of the cost component assignments. For more information, see the relevant release note for Controlling.
  • Data Aging: The previous functions for archiving accounting documents has been replaced by data aging. For more information, see the release note for data aging.