- ERPCorp FI/CO Books
- Access SAP Modules
- SAP Webinars
- Client Roster
- BECOME A MEMBER
ERPCorp SAP FICO Blog
Display sap mm-fi automatic account assignment.
by John Jordan
Table of Contents
Introduction, display obyc accounts with se16n, more information.
You use configuration Transaction OBYC to assign SAP General Ledger (GL) accounts in Financial Accounting (FI) to movement types in Materials Management (MM), also known as SAP MM-FI Automatic Account Determination or Assignment.
End users do not typically have the authorization to run configuration Transaction OBYC.
You can easily display automatic account assignments as follows:
View table T030, which stores OBYC configuration settings, with Transaction SE16N.
Type in Table T030 and press Enter to display the selection screen shown in Figure 1.
Figure 1 : Table T030 Selection Screen To Display SAP MM-FI Configuration Settings
You restrict the table entries displayed on the subsequent results screen by making entries in the Selection Criteria section. To display G/L accounts posted during goods issues (GI) to production orders, make the following entries:
- Chart of Accounts : Restrict your selection by your chart of accounts, INT in this example
- Transaction : You display inventory movements with Transaction GBB
- Valuation Grouping Code : A group of company codes (set up with transaction OMWD)
- Account modifier : VBR for GI to production orders
- Valuation Class : You assign a valuation class in the Costing 2 view
Click the execute icon to display the screen shown in Figure 2.
Figure 2 : Table T030 Entries Display SAP MM-FI Configuration Settings
This screen displays the G/L Accounts posted during goods issues to production orders.
For more information on entries in table T030, follow IMG menu path:
Materials Management • Valuation and Account Assignment • Account Determination • Account Determination Without Wizard • Configure Automatic Postings
Figure 3 displays the menu path.
Figure 3 : Configure Automatic Postings Menu Path
Click the paper and glasses icon to the left of Configure Automatic Postings at the bottom to display standard SAP documentation on setting up automatic postings.
Activity Type
An activity type identifies activities provided by a cost center to manufacturing orders. The secondary cost element associated with an activity type identifies the activity costs on cost center and detailed reports
Alternative Hierarchy
While there can only be one cost center standard hierarchy, you can create as many alternative hierarchies as you like. You create an alternative hierarchy by creating cost center groups
Automatic Account Assignment
Automatic account assignment allows you to enter a default cost center per cost element within a plant with Transaction OKB9.
Condition Type
A condition type is a key that identifies a condition. The condition type indicates, for example, whether the system applies a price, a discount, a surcharge, or some other pricing, such as freight costs and sales taxes.
Cost Center Accounting
A cost center is a function within an organization that does not directly add to profit but still costs money to operate, such as the accounting, HR, or IT departments. The main use of a cost center is to track actual expenses for comparison to the budget.
Cost Estimate
A cost estimate calculates the plan cost to manufacture a product or purchase a component. It determines material costs by multiplying BOM quantities by the standard price, labor costs by multiplying operation standard quantities by plan activity price, and overhead values by costing sheet configuration.
Cost Object
An SAP Cost object such as a cost center or internal order describes where the cost occurs. A cost element or account describes what the cost is.
Costing Lot Size
The costing lot size in the Costing 1 view determines the quantity cost estimate calculations are based on. The costing lot size should be set as close as possible to actual purchase and production quantities to reduce lot size variance.
Goods Issue
A goods issue is the movement (removal) of goods or materials from inventory to manufacturing or to a customer. When goods are issued, it reduces the number of stock in the warehouse.
Goods Receipt
It is a goods movement that is used to post goods received from external vendors or from in-plant production. All goods receipts result in an increase of stock in the warehouse.
Internal Order
An internal order monitors costs and revenue of an organization for short- to medium-term jobs. You can carry out planning at a cost element and detailed level, and you can carry out budgeting at an overall level with availability control.
Production Variance
Production variance is a type of variance calculation based on the difference between net actual costs debited to the order and target costs based on the preliminary cost estimate and quantity delivered to inventory. You calculate production variance with target cost version 1.
Profit Center
A profit center receives postings made in parallel to cost centers and other master data such as orders. Profit Center Accounting (PCA) is a separate ledger that enables reporting from a profit center point of view. You normally create profit centers based on areas in a company that generate revenue and have a responsible manager assigned.
If PCA is active, you will receive a warning message if you do not specify a profit center, and all unassigned postings are made to a dummy profit center. You activate profit center accounting with configuration Transaction OKKP, which maintains the controlling area.
Purchasing Info Record
A purchasing info record stores all of the information relevant to the procurement of a material from a vendor. It contains the Purchase Price field, which the standard cost estimate searches for when determining the purchase price.
Scheduling Agreement
A scheduling agreement is a longer-term purchase arrangement with a vendor covering the supply of materials according to predetermined conditions. These apply for a predefined period and a total purchase quantity.
Standard Hierarchy
A standard hierarchy represents your company structure. A standard hierarchy is guaranteed to contain all cost centers or profit centers because a mandatory field in cost and profit center master data is a standard hierarchy node.
To learn more about MM-FI, and SAP S/4HANA FICO topics become a member Click here now :
Standard Price
The standard price in the Costing 2 view determines the inventory valuation price if price control is set at standard (S). The standard price is updated when a standard cost estimate is released. You normally value manufactured goods at the standard price.
You can apply surcharges to material prices and activity prices in order to take into account increases or decreases in item prices over time when calculating the lifecycle costs for a project.
Target Costs
Target costs are plan costs adjusted by the delivered quantity. For example, if the quantity delivered to inventory is 50% of the plan quantity, target costs are calculated as 50% of the plan costs.
Material Master
A material master contains all of the information required to manage a material. Information is stored in views, and each view corresponds to a department or area of business responsibility. Views conveniently group information together for users in different departments, for example, sales and purchasing.
Origin Group
An origin group separately identifies materials assigned to the same cost element, allowing them to be assigned to separate cost components. The origin group can also determine the calculation base for overhead in costing sheets.
Price Control
The Price control field in the Costing 2 view determines whether inventory is valuated at standard or moving average price.
The price unit is the number of units to which the price refers. You can increase the accuracy of the price by increasing the price unit. To determine the unit price, divide the price by the price unit.
Process Order
Process orders are used for the production of materials or provide services in a certain quantity and on a certain date. They allow resource planning, process order management control, and account assignment and order settlement rules to be specified.
Procurement Alternative
A procurement alternative represents one of a number of different ways of procuring a material. You can control the level of detail in which the procurement alternatives are represented through the controlling level. Depending on the processing category, there are single-level and multilevel procurement alternatives. For example, a purchase order is single-level procurement, while production is multilevel procurement.
Production Order
A production order is used for discrete manufacturing. A BOM and routing are copied from master data to the order. A sequence of operations is supplied by the routing, which describes how to carry out work-steps. An operation can refer to a work center at which it is to be performed. An operation contains planned activities required to carry out the operation. Costs are based on the material components and activity price multiplied by a standard value.
Product Drilldown Reports
Product drilldown reports allow you to slice and dice data based on characteristics such as product group, material, plant, cost component, and period. Product drilldown reports are based on predefined summarization levels and are relatively simple to setup and run.
Production variance is a type of variance calculation based on the difference between net actual costs debited to the order and target costs based on the preliminary cost estimate and quantity delivered to inventory. You calculate production variance with target cost version 1. Production variances are for information only and are not relevant for settlement.
Production Version
A production version determines which alternative BOM is used together with which task list/master recipe to produce a material or create a master production schedule. For one material, you can have several production versions for various validity periods and lot-size ranges.
Purchase Price Variance
When raw materials are valued at the standard price, a purchase price variance will post during goods receipt if the goods receipt or invoice price is different from the material standard price.
Profitability Analysis
Costing-based profitability analysis enables you to evaluate market segments, which can be classified according to products, customers, orders (or any combination of these), or strategic business units, such as sales organizations or business areas concerning your company’s profit or contribution margin.
SAP Profit Center is a management-oriented organizational unit used for internal controlling purposes. Segmenting a company into profit centers allows us to analyze and delegate responsibility to decentralized units.
A purchasing info record stores all the information relevant to the procurement of a material from a vendor. It contains the Purchase Price field, which the standard cost estimate searches for when determining the purchase price.
Raw Materials
Raw materials are always procured externally and then processed. A material master record of this type contains purchasing data but not sales.
A routing is a list of tasks containing standard activity times required to perform operations to build an assembly. Routings, together with planned activity prices, provide cost estimates with the information necessary to calculate labor and activity costs of products.
Sales and Operations Planning
Sales and operations planning (SOP) allows you to enter a sales plan, convert it to a production plan, and transfer the plan to long-term planning.
S&OP is slowly being replaced by SAP Integrated Business Planning for Supply Chain (SAP IBP), which supports all S&OP features. S&OP is intended as a bridge or interim solution, which allows you a smooth transition from SAP ERP to on-premise SAP S/4HANA and SAP IBP. See SAP Note 2268064 for details.
SAP Fiori is a web-based interface that can be used in place of the SAP GUI. SAP Fiori apps access the Universal Journal directly, taking advantage of additional fields like the work center and operation for improved variance reporting.
Work in process (WIP) and variances are transferred to Financial Accounting, Profit Center Accounting (PCA), and Profitability Analysis (CO-PA) during settlement. Variance categories can also be transferred to value fields in CO-PA.
Settlement Profile
A settlement profile contains the parameters necessary to create a settlement rule for manufacturing orders and product cost collectors and is contained in the order type.
Settlement Rule
A settlement rule determines which portions of a sender’s costs are allocated to which receivers. A settlement rule is contained in a manufacturing order or product cost collector header data.
You need setup time to prepare equipment and machinery for the production of assemblies, and that preparation is generally the same regardless of the quantity produced. Setup time spread over a smaller production quantity increases the unit cost.
Simultaneous Costing
The process of recording actual costs for cost objects, such as manufacturing orders and product cost collectors in cost object controlling, is called simultaneous costing. Costs typically include goods issues, receipts to and from an order, activity confirmations, and external service costs.
Source Cost Element
Source cost elements identify costs that debit objects, such as manufacturing orders and product cost collectors.
Source List
A source list is a list of available sources of supply for a material, which indicates the periods during which procurement is possible. Usually, a source list is a list of quotations for a material from different vendors.
You can specify a preferred vendor by selecting a fixed source of supply indicator. If you do not select this indicator for any source, a cost estimate will choose the lowest cost source as the cost of the component. You can also indicate which sources are relevant to MRP.
The standard price in the Costing 2 view determines the inventory valuation price when price control is set at standard (S). The standard price is updated when a standard cost estimate is released. You normally value manufactured goods at the standard price.
Subcontracting
You supply component parts to an external vendor who manufactures the complete assembly. The vendor has previously supplied a quotation, which is entered in a purchasing info record with a category of subcontracting.
Tracing Factor
Tracing factors determine the cost portions received by each receiver from senders during periodic allocations, such as assessments and distributions.
Universal Journal
The efficiency and speed of the SAP HANA in-memory database allowed the introduction of the Universal Journal single line-item tables ACDOCA (actual) and ACDOCP (plan). The Universal Journal allows all postings from the previous financial and controlling components to be combined in single items. The many benefits include the development of real-time accounting. In this book, we discuss both period-end and event-based processing.
Valuation Class
The valuation class in the Costing 2 view determines which general ledger accounts are updated as a result of inventory movement or settlement.
Valuation Date
The valuation date determines which material and activity prices are selected when you create a cost estimate. Purchasing info records can contain different vendor-quoted prices for different dates. Different plan activity rates can be entered per fiscal period.
Valuation Grouping Code
The valuation grouping code allows you to assign the same general ledger account assignments across several plants with Transaction OMWD to minimize your work. The grouping code can represent one or a group of plants.
Valuation Type
You use valuation types in the split valuation process, which enables the same material in a plant to have different valuations based on criteria such as batch. You assign valuation types to each valuation category, which specify the individual characteristics that exist for that valuation category. For example, you can valuate stocks of a material produced in-house separately from stocks of the same material purchased externally from vendors. You then select procurement type as the valuation category and internal and external as the valuation types.
Valuation Variant
The valuation variant is a costing variant component that allows different search strategies for materials, activity types, subcontracting, and external processing. For example, the search strategy for purchased and raw materials typically searches first for a price from the purchasing info record.
Valuation Variant for Scrap and WIP
This valuation variant allows a choice of cost estimates to valuate scrap and WIP in a WIP at target scenario. If the structure of a routing is changed after a costing run, WIP can still be valued with the valuation variant for scrap and WIP resulting in a more accurate WIP valuation.
Valuation View
In the context of multiple valuation and transfer prices, you can define the following views: – Legal valuation view – Group valuation view – Profit center valuation view
Work Center
Operations are carried out at work centers representing; for example, machines, production lines, or employees. Work center master data contains a mandatory cost center field. A work center can only be linked to one cost center, while a cost center can be linked to many work centers.
Work in Process
Work in process (WIP) represents production costs of incomplete assemblies. For balance sheet accounts to accurately reflect company assets at period end, WIP costs are moved temporarily to WIP balance sheet and profit and loss accounts. WIP is canceled during period-end processing following delivery of assemblies to inventory.
Meet John Jordan, Kent Bettisworth, Gerald Steele and other SAP expert speakers in person at SAP Controlling Financials 2024 Conference in San Diego, CA
Use exclusive coupon code: jj100 for $100 off click here.
For the latest updates
About the author
John Jordan
Author's recent posts
Captcha Image
- July 30, 2017
- by Sachin Patil
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.
Post comment
Cancel reply.
You must be logged in to post a comment.
I share experience and observations knowledge about the SAP and peripheral systems.
Copyright © 2022 Sachin H Patil . All Rights Reserved.
IMAGES
VIDEO