cost center and gl account assignment in sap

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.

2302825 - Cost Center Assignment to Bank Charges

You are allocating bank charges in the payment allocation, nevertheless you notice that there is no option to assign a cost center nor the defaults for account determination groups set for the company ID works to assign a cost center in the resulting journal entry.

Environment

SAP Business ByDesing.

Reproducing the Issue

• Go to Payment Management work center.
• Go to Payment Allocation view.
• Edit the concerned payment allocation.

You have allocated the amount in the Bank Charges/Interest tab.

• Open the concerned journal entry for this payment allocation

You see that there is no cost center derived, although you have maintained it under Set Defaults for G/L Account Determination Groups.

You have different setup for account determination depending on how the costs are allocated in the originating source document (payment allocation).

• Amount allocated in the Bank Charges/Interests: When fees are allocated via such tab, the system does the account determination via Cash ledger -> Interest/Change. Therefore, the G/L Account is derived based on the account determination group of the bank account. For this circumstance, the cost center is not derived.
• Amount allocated in the Allocation to G/L Account: With this allocation, you directly specify an account determination group through which the system will do the account determination in the Cost ledger -> General Expenses. In this tab, you have a Cost Center column and may set up the system so that the same G/L Account is derived by this means, as in the Cash ledger.

The default account assignment for G/L account/account determination group is triggered when the user does a cost assignment to G/L account from the User Interface (UI) only. In the above case, where the bank fees are allocated via Allocation to G/L Account and account determination group, the system would populate the cost center column automatically based on this default account assignment rules, which is then reflected in the journal entry. This is not used for the first case of Bank Charges and Interests.

It is the current system design that the cost center is not derived in the occurrence of a posting via Bank Charges and Interests. For newer bank statement imports, you could set up rules for analyzing memo lines so that the payment allocation posts it to the G/L Account and selects a cost center as required. Please, refer to ByDesign documentation Memo Line Analysis Rules and Assign a G/L Account to a Memo Line Analysis Rule.

Bank Charges, Payment Allocation, Bank Fees, Journal Entry, Cost Center, Automatic Postings, No Cost Center , KBA , SRD-FIN-GL , General Ledger , How To

Privacy | Terms of use | Legal Disclosure | Copyright | Trademark

Gl account and cost center combination Table in SAP

• A061 Table for Controlling Area/Cost Center Type/Cost Center Table Type : POOL Package : VKON Module : AP-PRC-PR
• CRCO Table for Assignment of Work Center to Cost Center Table Type : TRANSP Package : CR Module : CRM
• IDCN_ZJFPRCTR Table for Assignment of Cost Center to Profit Center Table Type : TRANSP Package : ID-FI-CN Module : FI-LOC
• SMOWRKCNT Table for Work Center to Cost Center Allocation Table Type : TRANSP Package : SMO3 Module : CRM-MSA
• CSSK Table for Cost center /cost element Table Type : TRANSP Package : KBAS Module : CRM
• TIVSCTRANSACC Table for Assignment of Clearing Account to Cost Account Table Type : TRANSP Package : RE_SC_BC Module : RE-FX-SC
• CRMC_UI_WC_A Table for Assign Work Center Link Groups To Work Center Table Type : TRANSP Package : CRM_BSP_UI_FRAME_CORE Module : CA-WUI-APF
• A026 Table for Controlling Area/Cost Center Table Type : POOL Package : VKON Module : AP-PRC-PR
• A058 Table for Controlling Area/Cost Center Type Table Type : POOL Package : VKON Module : AP-PRC-PR
• A062 Table for Controlling Area/Company Code/Cost Center Table Type : POOL Package : VKON Module : AP-PRC-PR
• A063 Table for Controlling Area/Business Area/Cost Center Table Type : POOL Package : VKON Module : AP-PRC-PR
• A123 Table for Discount Type/Resp. Cost Center Table Type : TRANSP Package : VKON Module : AP-PRC-PR
• A132 Table for Price per Cost Center Table Type : TRANSP Package : KBAS Module : CRM
• B066 Table for Cost center Table Type : POOL Package : VKON Module : AP-PRC-PR
• CFICR0C Table for FIN Objects for Cost Center/Resource Pool Table Type : TRANSP Package : CON_ACC Module : FIN-BAC-INV
• CMDT_CC Table for Generic Master Data: Cost Center Enhancements Table Type : TRANSP Package : KBAS Module : CRM
• CRMC_TOOL_CO Table for CRM Service: Cost Center / Activity Type for Tool Table Type : TRANSP Package : IAOM_CRMSERVICE_EXEC Module : CO
• CRMD_AC_ASSF4_05 Table for Search Help Values for Cost Center AC_ASSIGN Table Type : TRANSP Package : CRM_AC_ASSIGN Module : CRM-BTX-COI-SRV
• CSKS Table for Cost Center Master Data Table Type : TRANSP Package : KBAS Module : CRM
• CSKT Table for Cost Center Texts Table Type : TRANSP Package : KBASCORE Module : CO
• CSSL Table for Cost Center/Activity Type Table Type : TRANSP Package : KBAS Module : CRM
• FMDERIVE002 Table for Derivation rule:Cost Center/CE to Commitment Item/Funds Ctr/ Table Type : TRANSP Package : FMFS_E Module : PSM-FM
• FMDERIVE003 Table for Derivation rule:Cost Center to Commitment Item/Funds Ctr/Fun Table Type : TRANSP Package : FMFS_E Module : PSM-FM
• KBEROBJ Table for Settings for authorization objects in Cost Center Accounting Table Type : TRANSP Package : KBAS Module : CRM
• KCR_T_CCAT Table for Data Model for Cost Center/Activity Type Table Type : TRANSP Package : DI_KCR Module : CO-OM
• KCR_T_CCAT_TD Table for Data Model for Cost Center/Activity Type - Time-Dependent Table Type : TRANSP Package : DI_KCR Module : CO-OM
• MPO_CCMON_RULES Table for Cost Center Monitor: Rule Definition for Exception Reporting Table Type : TRANSP Package : MPO_COST_CENTER_MONITOR Module : CA
• NO2K Table for IS-H: Assign OU to Cost Center for Revenue Acct Asgmt Table Type : TRANSP Package : NBAS Module : CRM
• NOEK Table for IS-H: Assign Org. Unit to Cost Center Table Type : TRANSP Package : NBAS Module : CRM
• OFIC_COSTCTR_SRV Table for Orgfinder Customizing: Assign Cost Center to Service Org. Table Type : TRANSP Package : CRM_OFI_APPLICATION Module : CRM-BF-OFI
• OIFOCSKS Table for Object links - CO cost center (IS-Oil MRN) Table Type : TRANSP Package : OIF Module : CRM
• OIRBOCSKS Table for Object links - CO cost center (IS-Oil SSR) Table Type : TRANSP Package : OIR_B Module : IS-OIL-DS-SSR
• OIUH_RV_GLCC Table for Cross Reference GL to Cost Center Table Type : TRANSP Package : OIU_H Module : IS-OIL-PRA-REV
• ONRKL Table for Object Number Index, Cost Center/Activity Type Table Type : TRANSP Package : DONR Module : CRM-CIC
• ONRKS Table for Object Number Index, Cost Center Table Type : TRANSP Package : DONR Module : CRM-CIC
• SETHANAHIER0101 Table for Hierarchy table for Cost Center Groups Table Type : TRANSP Package : GBSE_HANA Module : FI-SL-SL-MD-SE
• SMOACTTYP Table for Cost Center to Activity Type Allocation Table Type : TRANSP Package : SMO3 Module : CRM-MSA
• T8J5E Table for JV cost center type for supplemental detail Table Type : TRANSP Package : GJV2 Module : CA-JVA
• T8J_SUS_CC Table for JV Cost Center in Suspense Table Type : TRANSP Package : GJVA Module : CRM
• TKA05 Table for Cost Center Types Table Type : TRANSP Package : KBASCORE Module : CO
• TKAR2 Table for CO Resource Prices Per Cost Center Table Type : TRANSP Package : KBAS Module : CRM
• TKSA0 Table for Administration for Cost Center Accrual Table Type : POOL Package : KSA Module : CO-OM-CCA
• TKSR5 Table for Field transfers for cost center summarization Table Type : TRANSP Package : KSRO Module : CO-OM-CCA
• TKSRT Table for Texts for cost center summarization Table Type : TRANSP Package : KSRO Module : CO-OM-CCA
• TKT05 Table for Cost center type texts Table Type : TRANSP Package : KBAS Module : CRM
• TKZU4 Table for Surcharge Base - Cost Center / Activity Type Table Type : TRANSP Package : KAUC Module : CRM
• TOIGS1 Table for TD Intransit Store Location/Cost Center Determination Table Type : TRANSP Package : OIG Module : CRM
• TVAUK Table for Cost Center Determination Table Type : TRANSP Package : VA0C Module : CRM-BF
• UPB_CCP_CUST Table for SEM Cost Center Planning: Customizing Table Table Type : TRANSP Package : UPB Module : FIN-SEM-BPS-BP
• UPB_CW_ANSWER Table for Cost Center Wizard: Answers Table Type : TRANSP Package : UPB Module : FIN-SEM-BPS-BP
• UPB_CW_AREA Table for Cost Center Wizard: Planning Areas Table Type : TRANSP Package : UPB Module : FIN-SEM-BPS-BP
• CNV_MBT_COMBINATION Table Data element for AND / OR ( AND NOT / OR NOT ) combination
• RPM_TV_PS_GROUP Table Data element for Group (Cost Center/Activity Type/Cost Element Group)
• ISH_LVAKS Table Data element for IS-H: Activity allocation orders and cost center
• ISH_LVAKSA Table Data element for IS-H: Activity allocation orders and cost center
• CO_KAKST Table Data element for Account Assignment Type: Cost Center
• JKZKS Table Data element for IS-M: Enter cost center in clearing account
• PK_KNTTP Table Data element for Cost Center Account Assignment Category
• /SPE/COST_CTR_ACC Table Data element for Indicator: Cost Center as Account Assignment
• EHSWAE_MNCHKMATKEY Table Data element for Check Combination of Assigned Waste Codes and Wastes
• RMPS_EVENT_COMBINATION Table Data element for Event Combination (AND/OR Relation)
• QMISKEYGRP Table Data element for Combination of Catalog Type and Code Group for Problem
• SCIDM_TV_IS_IDTSET_GUID Table Data element for GUID for IS and Type Group Combination

Gl account and cost center combination related terms

Definitions.

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

Popular Table Searches

Latest table searches.