Consolidation

1

Consolidation SAP's consolidation supports both legal consolidation (legal independent entities) and management consolidation (profit centers or business centers), with the new G/L you can easily undertake company consolidation or profit center consolidation, without any additional setup as the new G/L already contains the fields required for consolidation (trading partner, partner profit center and consolidation transaction type), you do not need any consolidation staging ledger for company consolidation which you do for classic G/L accounting. We will need to customize the below settings   

General specifications Transaction types Company consolidation

General Settings

We start with the general specifications which include preparing the chart of accounts related settings and the creation and assignment of transactions types for consolidation, besides the settings required transferring the G/L data, lets assign the scenarios and customer fields to ledgers we use the transaction code FAGL_SCENARIO_ASS, we configured this already in Financial Global Settings and Company Code Parameters

The datadisk mobility company use CAUS as the operational chart of accounts and CONS as the group chart of accounts, for consolidation we need to link these charts for correct value flow, the first task in connecting the accounts in operational and group of charts of accounts is to ensure that a group chart of accounts is available in the chart of accounts list, make sure that the group chart of accounts in the chart of accounts list is created using transaction code OB13 (see Financial Global Settings and Company Code Parameters)), next we assign the account groups to the group chart of accounts using Parameters transaction code OBD4 (see screenshot below) ,

http://www.datadisk.org.uk/html_docs/sap/fi/consolidation.htm

2

Now we assign the the group chart of accounts to the charts of accounts, you need to do this for all the charts of accounts DDGB and DDJP, we use transaction code OB13,

Now we need to assign the group charts account numbers to the operational charts account numbers (this can be done automatically or manually), make sure that the you have created the financial statement version for the group chart, which should have happened when you created that chart of accounts, if you want to create the account automatically use transaction code OCCC or you can manually assign group accounts to operational accounts use transaction FSP0,

Transaction Types

The transaction types help you in horizontal development of balance sheets (opening balance, additions, reductions and closing balance), you can create special transaction types to differentiate the consolidation transactions from others, you can validate account assignment automatically or manually, we will use transaction code OC08,


3

If you have performed the following then you need to assign the asset transaction types using transaction code OCBO, if you have not don the below then you can skip this step  

Define your own asset transaction types or changed the standard ones in FI -AA Define any new consolidation transaction types or changed the standard ones

Next we set the transaction types as a required entry using transaction code OBC4,

Now we define the validation for account/transaction type using transaction code OB28, for more information on validation see the document section

Company Consolidation

To consolidate the financial statements of all the legal entities of a company you need to make the company assignment in the master data, as well as maintain the settings for parallel valuation (we did this in Financial Global Settings and Company Code Parameters). inter-company elimination is a task when you prepare data consolidation as you need to square off the payables and receivables between the participating companies in consolidation, you can do this in two ways


4

1. Create the groups company codes as vendors and customers and assign the company ID in the master record (trading partner under the account control in the control tab), for example you can create a vendor and customer for company code DD11 and assign the company ID DD1000 in the trading partner field, this would be the same for other company codes, during the posting of groupinternal transactions the SAP system uses this company ID from these master records and assigns the company code as the trading partner thereby eliminating the receivable with payables and vice versa 2. Create specific G/L accounts instead of vendor and customer master records and enter the company ID in these G/L accounts, this way elimination happens through the inter-company transfer postings, we have already created these G/L accounts (164011 - payables DD11, 164012 - payables DD12, etc, see G/L accounting), see screenshot below

Lastly we need to maintain the document types for transaction posting using transaction code OBA7,  

inter-company postgs - allow inter-company business transactions enter trading partner - allow users to input trading partner manually, this normally should be transferred from the master data


5


Consolidation

Recommend Documents