contract account assignment table in sap

Contract account Table in SAP

• A201 Table for IS-M: Contract Standing: Booking Unit/Contract UM Table Type : TRANSP Package : JAS Module : IS-M
• A202 Table for IS-M: Contract Standing: Content Component/Contract UM Table Type : TRANSP Package : JAS Module : IS-M
• A203 Table for IS-M: Contract Standing: Contract Unit of Measure Table Type : TRANSP Package : JAS Module : IS-M
• A206 Table for IS-M: Contract Standing: Booking Unit/Contract Currency Table Type : TRANSP Package : JAS Module : IS-M
• A207 Table for IS-M: Contract Standing: Content Component/Contract Currency Table Type : TRANSP Package : JAS Module : IS-M
• A208 Table for IS-M: Contract Standing: Contract Currency Table Type : TRANSP Package : JAS Module : IS-M
• JKSDFCLIKECON Table for IS-M: Forecast Contract - Contract Assigned per Product Table Type : TRANSP Package : JSDI Module : IS-M
• JKSD_ASORT_HEAD Table for IS-M: Contract Data - Contract for Assortment Table Type : TRANSP Package : JSDI Module : IS-M
• T7AR23 Table for Assignment of contract category to contract type AR Table Type : TRANSP Package : PB29 Module : PA-PA-AR
• TB2BE Table for Trading Contract: Trading Contract Type Table Type : TRANSP Package : WB2B_DDIC Module : LO
• TB2BET Table for Trading Contract: Trading Contract Type Description Table Type : TRANSP Package : WB2B_DDIC Module : LO
• TB2BI Table for Trading Contract: Communication Tables for Trading Contract Table Type : TRANSP Package : WB2B_DDIC Module : LO
• TB2BL Table for Trading Contract: Allowed Field Changes Trading Contract Table Type : TRANSP Package : WB2B_DDIC Module : LO
• TB2BP Table for Trading Contract: Assignment of Contract Type to Condit.Grp Table Type : TRANSP Package : WB2B_DDIC Module : LO
• TCACS_STDCNTXT Table for Standard Contract: Context of Standard Contract Object Table Type : TRANSP Package : CACSC7 Module : ICM
• TCACS_STDCNTXT_T Table for Standard Contract: Context of Contract Object (Text Table) Table Type : TRANSP Package : CACSC7 Module : ICM
• TCMACCOTYGRPASGN Table for Assign Contract Object Type to Contract Object Type Group Table Type : TRANSP Package : CMACGM_E Module : IS-HER-CM-AC
• TIVCN05 Table for RE Contract: Relationship between Contract and Objects Table Type : TRANSP Package : FVVICN Module : RE
• TIVORBPROLEMOD Table for Transfer of Role from Contract Offer to Role in RE Contract Table Type : TRANSP Package : RE_OR_OF Module : RE-FX-OR
• TIVXABDCNACCT Table for FI-CA: Contract Acct Category per Contract and Partner Role Table Type : TRANSP Package : RE_XA_BD Module : FI-CA
• VICN01 Table for Real Estate Contract: Contract Data Table Type : TRANSP Package : FVVICN Module : RE
• /BEV3/CHASPL002 Table for Detailed Data Communication Contract Statement per Contract Table Type : TRANSP Package : /BEV3/CH Module : SD-SLS-PLL-OBS
• /BEV3/CHCBKRIVBW Table for Contract MVT dependent on CoCd, RI, Date part, Contract view Table Type : TRANSP Package : /BEV3/CH Module : SD-SLS-PLL-OBS
• /BEV3/CHCDPCTR1 Table for CDP: Contract Data 1 - General Contract Data Table Type : TRANSP Package : /BEV3/CH Module : SD-SLS-PLL-OBS
• /BEV3/CHCDPCTR2 Table for CDP: Contract Data 2 - Specific Contract Data Table Type : TRANSP Package : /BEV3/CH Module : SD-SLS-PLL-OBS
• /BEV3/CHCVBWBKRI Table for RI, DAPART,contract view dependent on contract movement type Table Type : TRANSP Package : /BEV3/CH Module : SD-SLS-PLL-OBS
• CMACCADD Table for Due Date Schedule for Contract Account Table Type : TRANSP Package : CMAC_E Module : IS-HER-CM-AC
• CNVTDMS_05_DFKK Table for Contract Account Document TDMS for ISU Table Type : TRANSP Package : CNV_TDMS_05_TI_X Module : CA-EUR
• DFKKBRPOPNOT Table for Balance Reporting: Noticed Contract Account Document Items Table Type : TRANSP Package : FKK_ID_XX Module : FI-CA
• DFKKMOP Table for Items in contract account document Table Type : TRANSP Package : FKKB Module : FI-CA
• DFKKMOPK Table for Items in contract account document Table Type : TRANSP Package : FKKB Module : FI-CA
• DFKKMOPW Table for Items in contract account document Table Type : TRANSP Package : FKKB Module : FI-CA
• DFKKOP Table for Items in contract account document Table Type : TRANSP Package : FKKB Module : FI-CA
• DFKKOPK Table for Items in contract account document Table Type : TRANSP Package : FKKB Module : FI-CA
• DFKKOPW Table for Items in contract account document Table Type : TRANSP Package : FKKB Module : FI-CA
• DFSCIHISTIOB Table for Balance Int. Calculation at Contract Account Level: History Table Type : TRANSP Package : FSCR Module : FI-CAX
• ECAMIOPRACC Table for IS-U: Pre-entry Document: Contract Account Data Table Type : TRANSP Package : EE06A Module : IS-U-CS-BT-IO
• EKCPA Table for Purchasing Contract Commitment Plan Account Assignment Data Table Type : TRANSP Package : ME Module : SRM-EBP
• ESERV_C_VGROUP Table for Grouping Characteristic of Aggregated Contract Account Table Type : TRANSP Package : EE_DEREG_INV Module : IS-U-IDE
• FKKVK Table for Contract Account Header Table Type : TRANSP Package : FKKB Module : FI-CA
• FKKVKP Table for Contract Account Partner-Specific Table Type : TRANSP Package : FKKB Module : FI-CA
• FKKVK_CORR Table for Correspondence for Relationship Contract Account Partner Table Type : TRANSP Package : FKKV Module : FI-CA-BF-CA
• TE002A Table for IS-U Specific Attribute for Contract Account Categories Table Type : TRANSP Package : EE03 Module : IS-U-MD
• TECOK Table for CO account assignment key IS-U contract Table Type : TRANSP Package : EE30 Module : IS-U-CA
• TFICA_DEF Table for Samples for Contract Account Types Table Type : TRANSP Package : FMCAD Module : IS-PS-CA
• TFK002A Table for Contract Account Categories Table Type : TRANSP Package : FKKB Module : FI-CA
• TFK043U Table for Assign clerk --> tolerance group in contract account Table Type : TRANSP Package : FKKB Module : FI-CA
• TFK_BUAG_REF Table for Determination of Reference Contract Account for Replication Table Type : TRANSP Package : FKK_BUSINESS_AGREEMENT Module : FI-CA
• TFMCA007 Table for Account Determination ID for Contract Objects Table Type : TRANSP Package : FMCAD Module : IS-PS-CA
• TFMCA007T Table for Account Determination ID for Contract Objects - Texts Table Type : TRANSP Package : FMCAD Module : IS-PS-CA
• TFMCA_REV2PSOB Table for Define Revenue Types for Contract Account Types Table Type : TRANSP Package : FMCA_INV Module : IS-PS-CA
• FKTSA Table Data element for Contract Account of Service Provider that Invoices Contract
• ECTRSWTCVKONT Table Data element for Copy contract account during contract change
• E_EDMIDEINVCAT Table Data element for Bill Category of a General Ledger Account/Contract Account
• SAMRG_KK Table Data element for Contract Account is Collective Bill Account
• CPD_KK Table Data element for Contract Account is a One-Time Account
• INV_INVCAT Table Data element for Bill Category of a General Ledger Account/Contract Account
• BNKKO Table Data element for Bank account/bank clearing account (G/L account)
• UBHKT Table Data element for G/L Account Number for Our Bank Account / Bank Sub-Account
• TKONN Table Data element for Trading Contract: Trading Contract Number
• DSVASDCONTRACTNO Table Data element for DSVAS: Contract data (for example, contract number)
• E_PP_PPM_CONTRACT Table Data element for Identifies Contract as Prepayment Meter Contract
• TV_KURSFUT Table Data element for Current price of futures contract/option on futures contract

Contract account 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.

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.