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.
Introducing Assortment Management
After completing this lesson, you will be able to:
- Introduce Assortment Management
- Describe the meaning of listing
- Outline the layout workbench
- Generate an assortment list
Assortment Management and Layout Workbench
Assortment Management comprises several functions and activities, such as creating assortments, and executing the article listing. An important aspect for many retailers is the implementation of shelf optimization tools, which is supported in SAP Retail through the Layout Workbench. Finally, the article data has to be provided to the individual store systems (POS), usually through the assortment list function.
Assortment Management is a key application in SAP Retail, which is used to assign articles to sites by creating the relevant article listing conditions in the assortment(s) of a site. Assortments can be connected with layout data, which are used to define the exact placement of articles in the retailer’s stores.
When you create a site (that is, a store or distribution center), the system automatically creates a local assortment exclusively for this site in the background. This local assortment is site-specific and cannot be assigned to another site. Each site has one local assortment.
These assortments are of category A for stores, and of category B for distribution centers. The technical key of these local assortments is the same as the customer number of the respective site.
General assortments of category C can be assigned to any number of (SD) customers, and there can also be several assignments per sales area. You can also assign general assortments to any number of stores and distribution centers if you have selected the multiple assignment indicator in Customizing.
Advantage of using general assortments for sites:
Assortments can be defined, which are valid for groups of sites, for example, to reflect regional or seasonal assortments. Moreover, when new sites are created, they only have to be assigned to the relevant assortments in order to define their range of available products. Furthermore, as a side-effect, the number of article listing conditions in the system can be reduced a lot compared to using local assortments only.
General assortments can be created manually in the SAP Retail system, or created in the planning tool, based on algorithms for store clustering according to multiple attributes - for example, sales history, margin, revenue. Customer-specific attributes can be used as well.
As soon as a planned, general assortment or its dependent objects are released in planning, general assortments, along with layout modules, can be created automatically in SAP Retail via interface, based on customizing settings.
Assignments of stores (sites) to general assortments (assortment users) are also copied from planning.
You can also already assign articles to the layout module versions (these are explained further below) in planning. This requires that article data is available and complete at an early stage, which is usually the case for merchandise, which can be replenished regularly.
In the assortment maintenance transactions (create/change/display assortment), you can assign merchandise categories and assortment grades, layout data, or an article hierarchy with the relevant hierarchy node. The validity period and the distribution chain are mandatory assignments.
You can also assign assortment users to general assortments in assortment maintenance.
Additionally, a user-friendly assortment assignment tool is available for this purpose. The system displays two tree structures: a list of the selected general assortments with their already assigned sites on the left, and a list of sites for which assignments are still possible on the right. You can sort the displayed sites, for example, by region, by sites not yet assigned, or by new sites. The selected sites are assigned to the desired assortment using drag and drop. However, you can only assign sites in the assortment assignment tool; customers are assigned in the assortment maintenance transactions (create/change assortment) only. Sites can be assigned in both.
You can also branch to the assortment maintenance transactions (create/change/display assortment) from the assortment assignment tool.
Meaning of Listing
An assortment is an SAP Retail object to which articles are assigned, or listed, for a particular validity period. The listing conditions created for an assortment are only valid for the assigned assortment users. For a local assortment (category A, B), this is the respective site only. For general assortments (category C), these are the assigned assortment users (sites, customers).
In addition to the individual assignment of assortment users to general assortment(s), you can also first define reference sites , and then assign a number of sites to this reference site. This allows you to group sites for assortment management purposes. For example, the reference sites could be set up by region and/or store size aspects. Usually, one site has to be assigned to several general assortments, so the grouping under a reference site helps reducing the workload: you then only have to assign the reference site to the general assortments, instead of assigning all sites individually. A duplicate assignment of a site to a specific general assortment is not possible (that is, to assign a site through the reference site and also directly). However, you can assign a site directly to one general assortment, and through its reference site to another one. The reference site concept is only available for sites, not for customers.
It is advisable to use reference sites if several sites should have the same assortment assignments.
Only when a valid listing condition exists, an article is available for the site for all logistics functions (planning, ordering, receiving, selling, and so on). Articles can be assigned to, or listed for the assortments automatically using various functions, such as the article maintenance, individual article listing, mass listing functions, layout workbench, and so on. Listing procedures are available for this automatic assignment. They define which checks the system applies when assigning articles to assortments (and thus to stores, customers, or distribution centers that use these assortments). This gives you a high degree of flexibility in assortment management.
Basic Listing Procedures help the users in rule-based listing (automatic listing) to identify the suitable assortments for an article. For example, frozen food articles should only be listed in sites with a freezer.
Three basic listing procedures are available in the SAP Retail System:
The B1: basic procedure mdse cat./assortment grade checks whether the article's merchandise category has been assigned to the assortment. Only then the article will be listed for this assortment. In any case, the merchandise category check alone can be too general. For example, both small and large stores of the same store chain carry dairy products (all created in the dairy merchandise category). But the small stores should only offer some basic dairy articles, whereas the large stores should offer a wider range of these articles. Therefore, an additional check for assortment grades can be used with the basic procedure B1. An assortment grade can be assigned to an article (in the listing view), and to an assortment (together with the merchandise category).
The B2: basic procedure classification check examines whether the classifying parameters of the article (characteristics and their values) correspond to those of the assortment. Only then will the article be listed for this assortment.
The B3: basic procedure layout check evaluates the following:
- Whether the article is assigned to a layout module, and
- whether the assortment or site is linked to a layout containing the article's layout module, or
- whether the assortment is linked to the article's layout module directly
Only under these conditions will the article be listed for the assortment in question. It is also possible to combine the listing procedures, or define own rules.
The previous figure, Category Management - Example, shows that in this case, the store size is the main criterion to define assortments. There are small, medium, and large stores. Therefore, three assortments are created. These assortments carry the sweets - chocolate articles. As the available chocolate flavors change by season, the assortments are connected with the layout concept to easily reflect the seasonality: for each assortment, a layout module exists. Articles are assigned to layout modules using layout module versions, which are period-specific. That is, with a unique start and end date, so the periods can not overlap. In that way, the assortments for example hold the yogurt-lemon, or yogurt-strawberry flavor chocolates in the summer period, and the apple-cinnamon, or orange-ginger flavor chocolates in winter time. The layout concept is also used to connect shelf optimization tools, to define the exact article placements.
How to connect the general assortment with the layout concept:
You can define, that the system automatically creates a layout module in the background, when a general assortment is created. Alternatively, it is also possible to assign a layout, or a layout module manually to a general assortment. In that way, the assortment and layout functions are tightly connected.
Layout Workbench
The Layout Workbench is the central access platform to all the functions for shelf optimization and layout. If accessed by selecting a site or an assortment, the assigned layout and layout modules and their versions are displayed, and it is possible to execute listing.
The layout workbench can also be accessed selecting an individual layout module . In this case, the available layout module versions are displayed, and you can assign articles, and adjust the existing article assignments. A mass selection option is available to assign a large number of articles to a layout module in one step. It is also possible to execute listing, and to maintain layout module variants, which are local article assignment deviations in a layout version. Variants are for example used to replace an article by a local specialty product. If you use fixtures, the system also displays the fixtures that are assigned to a layout module version, and you can assign fixtures. Fixtures are master data, for example representing shelves, gondolas, baskets, and so on. If the layout module versions have been assigned planogram files from a shelf optimization system, these are also displayed.
You can access an external shelf optimization program from the Layout Workbench, but you can also use the layout workbench for planning purposes (manual article placement, listing) without using the shelf optimization interface.
Assortment Module Management
Specifically for the public cloud edition, a new assortment concept, the Assortment Module Management , was introduced. In SAP Retail (on premise / private cloud), it can be used instead of the classic assortment management, or, for example, in parallel for a transition time. Several SAP Fiori apps are available for Assortment Module Management. For example, you can create new assortment modules with the app Manage Assortment Modules . Each assortment module has at least one version, which has a validity period. This means, versions are used to determine the range of articles assigned to the assortment module for a given period, to reflect for example seasonal changes of merchandise. Additionally, assortment users can be assigned with this app. On the other hand, in order to assign a store to one or more assortment modules, you can use the Assign Store to Assortment Modules app.
Articles can be assigned to assortment modules via the Assign Product to Assortment Modules app. The Assign Products to Distribution Centers app allows you to assign articles to the relevant supplying sites.
With the Postprocess Assortments app, you can schedule and monitor the generation of missing listing conditions and site-specific product master data, for example when an error in posting occurred for article-site specific data. There are APIs (OData services) for Assortment Module Management to integrate external applications with SAP S/4HANA.
The Assortment Module Management solution creates listing conditions (table WLK1) for the local assortments of stores and DCs in SAP S/4HANA in order to integrate with all the applications which rely on these WLK1 table entries, such as POS outbound.
Assortment List
An assortment list provides the stores with an overview of all listed articles. This is true for a full version of an assortment list. With a change version , the store only receives information on changes to the assortment, for example, about new or discontinued articles, price changes, promotional articles. For each article, it at least contains the relevant data for sales at the point of sale (POS) system.
The assortment list type is used to group the articles for the assortment list. For each assortment list type, you determine the frequency in which new assortment lists are generated, and how often change versions are due before a new full version is created. An assortment list type is assigned to an article in the Basic Data view. Thus, a store may receive several assortment lists.
An assortment list profile , in combination with an assortment list type, is used to define the contents and structure of the assortment list. For example you can determine, which (additional) data for an article is to be included, such as supply source information, and how the articles are sorted. An assortment list profile is assigned to a site.
Assortment lists can be configured for every situation and assortment and they can be prepared in different media, for example in paper form, as an e-mail, and of course as an electronic file (SAP Intermediate Document: IDoc) sent to a store retailing system, or to a POS system.
Log in to track your progress & complete quizzes
IMAGES
VIDEO
COMMENTS
The journal entry items generated by the foreign currency valuation still has value for field "Cost center" or "functional Area" for Cost Element, even though, the Controlling Object Inheritance Option are set to "Always No Assignment" for the field in the configuration "104827 Define …
Example. You want to restrict the task of buying certain materials to certain individuals within a specific organizational unit. This is achieved by creating an assignment between a purchasing …
I have an background in planning solutions (BY ESP, SAP IBP) so SAP MM is somewhat new. Now so far I had been able to understand most of the topics and use cases that came along …
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 …
SAP document management is used to integrate external files (originals) into the SAP system. The external files can have any format. The only thing you have to do is to define the right …
Welcome to the tutorial about SAP CO Account Assignment. This tutorial is part of our free SAP CO training. You will learn how account assignment works in SAP ERP and what are different …
An assortment is an SAP Retail object to which articles are assigned, or listed, for a particular validity period. The listing conditions created for an assortment are only valid for the assigned …