default account assignment in sap table

Defining Default Account Assignments

After completing this lesson, you will be able to:

• Introduce posting controls
• Describe the account assignment settings
• Create a default account assignment
• Analyze the impact of the assignment during journal entry

Posting Controls

Meet Chris, an experienced management accounting employee at Bike Company SE. He's skilled at using SAP S/4HANA, having extensive knowledge of his department's processes and a comprehensive understanding of the company's operations. Apart from maintaining crucial applications that streamline work for others, Chris also acts as an administrator and business process configuration expert. He is the contact person for establishing and managing Overhead Cost Accounting processes within the company.

Chris loves discovering and utilizing new features and helping other users. Recently, Sarah, a colleague from the financial accounting department, sought his expertise for support and assistance. This is what they talked about:

Let’s now take a closer look at the tools that help streamline accounting data.

You'll learn how to define default values for cost assignment. In the next lessons, you will also delve into more sophisticated features like validation and substitution rules that can identify inconsistencies in account assignment objects and ensure precise postings.

We'll start with an in-depth exploration of the default account assignment.

Default Account Assignment

Application area.

The default account assignment is a tool that automatically proposes specific cost assignment objects, such as cost centers or profit centers during journal entry. You can determine which management accounting object is defaulted for each line item based on the combination of primary cost and revenue G/L account and company code.

As an example, consider recurring utility expenses, which should be charged to the Utilities cost center. For this purpose, a default account assignment can be established as shown in the figure below.

First, the cost element for Utilities for the relevant Company Code is connected to the respective cost center in the default account assignment configuration.

Now whenever you enter a utility expense in Financial Accounting, the system automatically proposes the Utilities cost center. You still have the option to manually overwrite the cost center if necessary.

This leads to a more efficient accounting workflow, as the account assignment object is entered automatically during the posting process, minimizing the need for manual input.

Default account assignments are especially useful when line items are automatically posted, such as when posting exchange rate differences and discounts in Financial Accounting, or price differences in Material Management.

In addition to cost centers, you can also indicate profit centers or profitability segments for allocating costs and revenues to.

In summary, the default account assignment establishes a default value for the controlling objects when posting costs or revenues, ensuring that these are automatically charged to the right entities.

Configuration

To configure a default account assignment, you perform the following steps:

• For each cost assignment, enter the company code and the cost element that should be included in the account assignment.
• Enter the corresponding account assignment object (cost center or profit center). If you want the system to determine a profitability segment instead, you can use the PrfSeg checkbox. This is used when transferring data, such as price differences, to Margin Analysis.
• You have the option to specify detailed account assignments, which can be differentiated by valuation area or profit center. To do this, enter the following values in the "Acct assignmt detail" column: 1 for valuation area or 3 for profit center. Then select the corresponding entry in the Dialog structure on the left and enter the relevant cost assignment.

Define a Default Account Assignment

Overall benefits.

The default account assignment feature suggests default values for specific accounts, improving the accuracy of financial data and streamlining the process through automatic assignment. This reduces the likelihood of errors in manual data entry and saves a considerable amount of time that would otherwise be spent repeatedly assigning these costs.

Log in to track your progress & complete quizzes

• TKA3A - Automatic account assignment - default assignments

SAP Table TKA3A

Automatic account assignment - default assignments.

TKA3A (Automatic account assignment - default assignments) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TKA3A to other SAP tables.

TKA3A table fields

Tka3a foreign key relationships.

• SAP Simple Finance Tutorial
• SAP Simple Finance - Home
• SAP HANA - Introduction
• SAP Simple Finance - Introduction
• SAP Simple Finance - Architecture
• Extend G/L Coding Block
• Universal Journal
• Document Number
• Display Financial Tables
• Deployment Options
• Post & Reverse Documents
• Reporting Options
• SAP Simple Finance - Migration
• Manual Reposting of Costs
• SAP Simple Finance - G/L Accounting
• Create a Primary Cost
• Create a Secondary Cost
• SAP Simple Finance - Ledger Mgmt
• Asset Accounting
• Create an Asset
• SAP Simple Finance - Asset Scrapping

Create Default Account Assignment

• Management Accounting
• Profitability Analysis
• Period Lock Transaction
• New Period Closing Program
• SAP Simple Finance - Integration
• SAP Simple Finance - IBPF
• Consultant Capabilities
• SAP Simple Finance Resources
• SAP Simple Finance - Quick Guide
• SAP Simple Finance - Resources
• SAP Simple Finance - Discussion
• Selected Reading
• UPSC IAS Exams Notes
• Developer's Best Practices
• Questions and Answers
• Effective Resume Writing
• HR Interview Questions
• Computer Glossary

You can create a default account assignment for any cost element using Transaction code OKB9. Later, you can also post a document to check if that account assignment works.

Transaction code - OKB9

Step 1 − To create a new Account Assignment, click New Entries

Step 2 − In the next window, you have to enter the following fields −

• The values of CoCd box
• The value in Cost Elem. box
• The value in the Cost Ctr box

Step 3 − To save the entry, click the Save button at the top

Step 4 − To post a test document to check that the account assignment works, use Transaction code fb50 . In the next window, click Tree On.

Step 5 − Select the Screen Variant in the next window and click Tree Off button.

Step 6 − In the next window, enter the following details −

• The value in Doc Header Box
• Select entry Debit by clicking it
• Amount in doc. Curr. Box
• Select entry H credit by clicking it
• Amount in doc.curr. box

Step 7 − To make the document assignment, click the Save button at the top.

Blog about all things SAP

ERProof » SAP CO » SAP CO Training » SAP CO Account Assignment

SAP CO Account Assignment

Normally, when a financial document is entered in SAP FI module , user has the option of entering the cost center in the financial document. However, when documents are entered from different modules or a cross-module financial transaction occurs, such as from MM or SD , there is no option of entering the cost center in the document. In this situation, the SAP system will derive the cost center through automatic SAP CO account assignment, substitutions, or through default settings made in the primary cost element.

Automatic SAP CO Account Assignment

The automatic account assignment has to be configured in the transaction code OKB9 . For posting made in external accounting, such as for price differences, exchange rate differences, etc., the SAP system automatically checks entries in the OKB9 settings and derives the cost center.

If you do not enter a CO object (order, cost center, or project) in external accounting postings made in FI, MM or SD modules and the posting is cost relevant, then the automatic account assignment checks the relevant cost center and makes the posting.

Here are examples of automatic account assignments:

• Banking fees, exchange rate differences and discounts in FI
• Minor differences and price differences in MM

The account assignment objects that can be maintained in the transaction OKB9 are:

• Cost center
• Profit center (profitability segment)

Normally, the automatic account assignment runs on the company code level along with the CO object. However, if the user wants to make the posting on the business area level, valuation area level or profit center level, it is also available in OKB9 settings. So basically it includes the following levels:

• Company code level
• Business area level
• Valuation area level
• Profit center level

The above 3 excluding the company code level are used in cases when the account assignment is needed below the company code level.

Prerequisites

Here are the prerequisites of activating automatic SAP CO account assignment:

• Activation of the cost center accounting
• Creation of cost centers
• Maintenance of cost elements

Additionally, you can also create orders and profit centers as per the business requirements.

Settings in Transaction OKB9

Let’s discuss settings that are possible for automatic SAP CO account assignment in OKB9 transaction.

Start SPRO transaction and navigate to the following path:

Controlling – Cost Center Accounting – Actual Postings – Manual Actual Postings – Edit Automatic Account Assignment (OKB9)

Alternatively, you can start OKB9 transaction directly from the command bar.

• If you want to have the setting on the company code level only, then enter the company code and the cost element along with the corresponding CO object, i.e. a cost center, an order or a profit center.
• If you want to have the settings on the valuation area level, then enter the company code and the cost element and chose the ‘valuation area’ option in the account assignment detail as ‘1’.
• Similarly, if you want to have the settings on the business area or profit center level, then choose the option ‘2’ or ‘3’ respectively.

If you have chosen account assignment detail ‘1’ or ‘2’, then click on ‘Detail per business area/valuation area’ on the left sidebar.

Default SAP CO Account Assignment

In order to determine the correct CO account assignment, the SAP system performs several checks in the following sequence. First it checks the document which a user is posting. If the cost center is empty in the document, then the system checks if any substitutions are maintained for the particular G/L account . Next, if the substitution is also missing, then the system moves on to the OKB9 settings for automatic SAP CO account assignments. Finally, if these settings are also missing, the SAP system checks master data of the primary cost element (G/L Account) under the tab of Default Account Assignment . You can display this master data using the transaction KA03 .

You can maintain the cost center and the order in the master data of the primary cost element.

So, basically the order of checks the system makes is:

• Financial document – Cost center
• Substitutions – transaction OKC9
• Automatic account assignments – transaction OKB9
• Default account assignments – transaction KA03 / KA02

Lastly, if any of the above is not maintained, then the SAP system throws an error ‘Account X requires an assignment to a CO Object’ and doesn’t allow posting of a document.

SAP CO Account Assignment using Substitution

In cases where you don’t need OKB9 or default account assignment, the user can go for user exits where a specific G/L account is mentioned under the company and the value in the cost center is substituted by the cost center given in the substitution.

The transaction for maintaining the substitution is GGB1 .

Usage of substitutions for SAP CO account assignment is justified by the business requirement and usually SAP CO account assignment requirements are fulfilled by OKB9 or default account assignments.

Did you like this tutorial? Have any questions or comments? We would love to hear your feedback in the comments section below. It’d be a big help for us, and hopefully it’s something we can address for you in improvement of our free SAP CO tutorials.

Navigation Links

Go to next lesson:  SAP Adjustment Postings

Go to previous lesson:  SAP Profit Center

Go to overview of the course: Free SAP CO Training

4 thoughts on “SAP CO Account Assignment”

it is helpful material i ask for more clear details for using substitution method for Account Assignment. thanks in advance

Sir, I am not receiving the training mails from yesterday 7/1/2019. I have completed my training till here(SAP CO Account Assignment) please do send the rest of the training emails for SAP CO. Hope you will do the needful.

I am getting the same error “Account 500911 requires an assignment to a CO object”. In OKB9, we have given company code, Cost element and ticked the check box ‘Indicator: Find profitability segment using substitution’ (V_TKA3A-BSSUBST) and not filled anything like cost center, order and profit center. in OKC9 we have created substitution. All the process happening through Idoc Message Type SINGLESETTRQS_CREATE and inside BAPI BAPI_SINGLESETTREQS_CREATEMULT triggering and raising this error. Cost center is not maintained in 1. Financial document – Cost center 2. Automatic account assignments – transaction OKB9 and 3. Default account assignments – transaction KA03/KA02 But we have substitution in transaction OKC9 to determine cost centre.

Where woulbe be the issue?

good explanation

Leave a Reply Cancel reply

Do you have a question and want it to be answered ASAP? Post it on our FORUM here --> SAP FORUM !

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

Save my name, email, and website in this browser for the next time I comment.

SAP Table TKA3A

Automatic account assignment - default assignments, recommended now, all-new echo dot smart speaker with alexa.

This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.

The table TKA3A ( Automatic account assignment - default assignments ) is a standard table in SAP ERP. It belongs to the package KIST .

Technical Information

Fields for table tka3a, sap erp dictionary.

• SAP Transactions
• SAP Customer Exits
• SAP Authorization Objects
• SAP Authorization Object Classes
• SAP Programs
• SAP Function Groups
• SAP Function Modules
• SAP Message Classes
• SAP Packages
• SAP Search Helps

SAP Master Data

• Access Control List
• Characteristic
• Material Document
• Notification
• Purchasing Document
• Sales Order
• Selected Set
• WBS Element