account assignment category for services

• ABAP Snippets
• Top SAP Courses
• Top SAP Books

SAP and ABAP Free Tutorials

Account assignment in SAP Purchasing (MM) – FAQ

This note provides answers to frequently asked questions regarding account assignment in purchasing documents. This post is based on Snote 496082.

Table of Contents

FAQ: Account Assignement in SAP Purchasing

Account assignement : g/l account for a sales order.

Question: Why is the G/L account for a sales order with nonvaluated individual sales order stock different from the account with valuated indivi dual sales order stock?

Answer: See Note 458270.

Multiple Account Assignment in Purchasing

Question: Can you create several assets at the same time in the new purchasing transactions?

Answer: You can create several assets at the same time. However, you must first ensure that at least as many account assignment lines have bee n created as the number of assets that you want to create. You can do this very easily using the copy function.

G/L Account is not saved if switch to a material group

Question: You create a purchase order with account assignment using transaction ME22. You enter a material group, from which a G/L account is de termined using the valuation class. If you then switch to a material group that does not determine a G/L account via the valuation class, the system deletes the previous G/L account and prompts you to enter a G/L account. If you cancel the account assignment screen and change the material group back on the item detail screen, the previously determined G/L account is not determined again. Why is this ?

Answer: Unfortunately, this system behavior cannot be changed. First, enter any G/L account, so that the item is valid. If you then switch to the old material group again, the system also determines the correct G/L account again.

Entering the same account assignments for different items

Question: Is there an easy way of entering the same account assignments for different items in the new EnjoySAP transactions?

Answer: Ensure that Note 315676 has been implemented in your system and follow the procedure described there

Repeat account assignment function not work in the new EnjoySAP

Question: Why does the repeat acc. assignment function not work in the new EnjoySAP transactions when you create new account assignments in multiple acc. assign. ?

Solution: Use the copy function in multiple acc. assignment to create identical account assignment lines. You can use the repeat account assi gnment function to create similar account assignments for different items with the same account assignment category. To do this, proce ed as described in the answer to question 4.

Issue message KI 161 “Cost center &/& does n ot exist on &

Question: When you change the account assignment of an existing purchase order, why does the system issue message KI 161 “Cost center &/& does n ot exist on &” ? The same phenomenon occurs for other account assignment objects (for example, profit center).

Solution: Refer to Note 193371.

Can you create assets from the single account assignment screen?

Solution: Assets can only be created from the multiple account assignment screen (“Account assignment” tab). You can switch between single account assignment and multiple account assignment on the “Account assignment” tab page by clicking the icon above on the left.

Why does the system not display an account assignment tab page even though you have entered an account assignment category?

Solution: After you have implemented Note 520149, the account assignment tab is not displayed until all the required information is available, for example, the company code.

Why are account assignment objects derived in some situations, even though the relevant field on the account assignment tab page is hidden?

Solution: Refer to Note 619203.

ME 453 “Changing consump. or spec. stock indicator not allowed

You create a purchase order with reference to a subcontracting purchase requisition. This purchase requisition was created with an unknown account assignment, that is, account assignment category “U”. When you change the account assignment category in the purchase order, the system issues error message ME 453 “Changing consump. or spec. stock indicator not allowed (subcontracting)”.

Solution: See Note 205597

Select a valuated goods receipt together with multiple account assignment

Why can you not select a valuated goods receipt together with multiple account assignment in a purchase order or purchase requisition?

Solution: See Note 204252.

EBAN-FISTL, -GEBER, -KBLNR, -GRANT and -FKBER (as in table EKPO) empty

Funds Management is active. Why are the fields EBAN-FISTL, -GEBER, -KBLNR, -GRANT and -FKBER (as in table EKPO) empty? Solution: These fields are only filled if the account assignment category is set to “blank”. If you maintain an account assignment category in t he purchasing document, the system adds the information from these fields to the EBKN table (as in EKKN).

AA 334 “You cannot post to this asset (Asset & & blocked for acquisitions)

You try to change a purchase order item with acc. assignment category “A”, which contains a locked asset. The system issues error message AA 334 “You cannot post to this asset (Asset & & blocked for acquisitions)”. Solution: This is the standard system design. To make changes to this purchase order item, you have the following two options:

a) If you no longer require the purchase order item with the blocked asset, delete the purchase order item. b) Otherwise, you must activate the asset, make the required changes to the purchase order item, and then block the asset again.

The indicator for the account assignment screen

Question: What is the meaning of the indicator for the account assign. screen that you can set in Customizing for single account assignment/m ultiple account assignment? Solution: The indicator determines which account assignment screen is used by default for maintaining the account assign. for a purchase orde r item. For the EnjoySAP transactions, this value is simply a proposal that you can change in the purchasing document. For the old transactions, this value is the only one that you can use.

Question: Is there an unknown account assign. for standard purchase orders?

Solution: This is generally not allowed, and the system issues message ME 069 “Unknown account assignment not defined for use here”. There is an exception in the case of service items that are created with item category D (service) or B (limit).

Acc. Assignment check is not performed when Purchase Order is updated

Question: You change data in a purchase order item (for example, purchase order value, delivery date, and so on). Why does the system not perform another acc. assignment check?

Solution: This is the standard system design. When you created the purchase order item, if the system already checked the acc. assignment and there were no errors, another acc.?assignment check only takes place if you change a field that is relevant to account assign.?(for example, quantity, material number, and so on). If this system response does not meet your requirements, implement the account assignment check in the BAdI ME_PROCESS_PO_CUST. The BA dI is called each time the purchase order is changed.

“In case of account assignment, please enter acc. assignment data for item”

Question: If you delete all the account assign?lines that were entered in the account assignment screen, the system exits the account assign. tab page and goes to the material data. In addition, the system issues the error message “In case of account assignment, please enter acc. assignment data for item”.

Answer: In the current system design, if you delete all the account assignment lines, the system assumes that you do not want to maintain any account assignment data. This conflicts with the account assignment category and the system issues error message 06 436. You can then remove the account assignment indicator. Procedure: If you want to delete all the account assignment data that was entered, see the answer to question 24.

Third-party order processing (CS) and individual purchase order processing (CB)

Question: Which account assignment categories should you enter in schedule line categories for third-party order processing (CS) and individual purchase order processing (CB)? Solution: See Note 210997.

G/L Account is not transfered from Valuation class

Question: In a blanket purchase order or blanket purchase requisition with account assignment, you subsequently change the material group. Even though the new material group is assigned to another G/L account via the valuation class, the system does not redetermine the account assignment for the relevant item. The old G/L account remains.

Solution: See Note 449216.

Customizing Account assignment fields as required entry, optional entry, or display fields

Question: In Customizing, you can set the, or as completely hidden fields, depending on the account assignment category. These settings also determine whether the system deletes or retains the values for the account assignment fields when you change the account assignment category in a purchase order item.

Answer: In Customizing for materials management (MM), when you maintain account assignment categories (IMG: Materials Management-> Purchasing -> Account Assignment-> Maintain Account Assignment Categories), you can control the different account assignment fields as follows: Required entry: You must make an entry in the field, otherwise the system issues error message ME 083.

• Optional entry: Entry in this field is optional.
• Display: The field is displayed, but it is not ready for input.
• Hidden: The field is hidden. Example:

The acc. assignment category is K, the cost center is an optional entry field and it is filled with the value 1000. You change the acc. assignment category to P. Subject to the field settings for the cost center for the acc. assignment category P, the system response is as follows: The cost center is a required entry or an optional entry field: The system transfers the value 1000 for the cos t center.The cost center is a display field: First, the value 1000 for the cost center is deleted. If the system can determine a value again after you enter the changed acc. assignment category, this value is transferred. The cost center is a hidden field: The system deletes the value 1000 for the cost center.

System ignores the acc. assignment data of the purchase requisition for the second schedule line.

Question: You create a purchase order item assigned to an account with reference to a purchase requisition. For this purchase order item, you create a second schedule line with reference to another purchase requisition. The system ignores the acc. assignment data of the purchase requisition for the second schedule line. Solution: This is the standard system design. The system does not generate multiple acc. assignment in the purchase order item, even if the t wo referenced purchase requisitions are assigned to different CO objects. Refer to Note 47150 for the old transactions and to Notes 422609 and 771045 for the EnjoySAP transactions.

Undelete an item in a purchase requisition if assignment data is no longer valid

Question: Why can you undelete an item in a purchase requisition if the corresponding acc. assignment data is no longer valid? Solution: When you undelete an item in a purchase requisition, the system does not perform a new acc. assignment check. Therefore, the accoun t assignment data is not checked again. Nevertheless, errors occur if you try to create a purchase order with reference to this purchase requisition. When you undelete an item in a purchase order, however, the system does perform another acc. assignment check.

Transfer of Acc. Assign. with Reference Document

Question: You create a purchasing document with reference to a reference document. What account assig. data is transferred? Solution: The acc. assignment data is derived from the reference document. If you delete the acc.?assignment category and enter it again, a new automatic general ledger account determination takes place.

Question What is the correct procedure for changing acc. assignment data?

– If, for example, you want to change the acc. assignment category: Note that you MUST first delete all existing acc. assignment data for the relevant item. You can do this by initializing (deleting) the acc. assignment category and confirming by choosing ENTER. Following this, you can enter the new acc. assignment category and the relevant acc. assignment data.

– If you want to change acc. assignment data for the relevant item: For example, you want to change the main acc. assignment objects such as cost center, G/L account, sales order, network, or WBS ele ment, and so on. Here also, we recommend deleting all existing acc. assignment data by initializing (deleting) the account assignme nt category and confirming by choosing ENTER.If you are working with contracts, you must delete the acc. assignment line on the acc. assignment screen and enter a new line t o ensure that the data is derived correctly again. You MUST NOT change the current settings. For example, in some circumstances, the requirements type (OVZH) or the valuation of the requirements class (OVZG) is changed after th e purchasing document is created. This can cause errors in a valuation of goods movements (goods receipt, for example) and MUST BE AVOIDED.

Read more on? Account Assignment

Related Posts

The Most Important SAP Payment Terms Tables (ZTERM, Text…)

October 21, 2018 March 24, 2021

SAP Batch Management: User-exits and BAdIs

June 17, 2017 January 21, 2022

SAP Batch Management Tcodes, Tables and Customizing (SAP Batch Management)

June 16, 2017 January 21, 2022

• Programming
• Admin & EIM
• BI & BW
• FICO & BPC
• CRM & Sales
• Introductions
• SAP PRESS Subscription

Account Determination in SAP S/4HANA Materials Management

Various transactions in materials management (MM) are relevant for accounting, such as goods receipts, goods issues, and invoice receipts.

In such cases, the system always creates an accounting document and posts the amount in the appropriate general ledger accounts.

General ledger accounts are automatically determined with the help of automatic account determination settings. Consider, for example, a manufacturing enterprise that stores stock materials purchased from vendors. Whenever a material is received in a storage location with reference to a PO, the company wants its system to automatically determine and update the stock general ledger account. Similarly, whenever an invoice is posted, the system should automatically determine the vendor general ledger account and post the liability.

The SAP S/4HANA system provides automatic general ledger account posting via the automatic account determination process. When posting a goods receipt against a PO, the system creates an accounting document (along with the material document), and general ledger account postings are made. The system determines which general ledger accounts should be debited and credited based on configuration settings you’ve maintained for automatic account determination.

Essential Terms

Before discussing these configuration settings, let’s define a few essential terms:

Chart of Accounts

A chart of accounts provides a framework for recording values to ensure an orderly rendering of accounting data. The general ledger accounts it contains are used by one or more company codes. For each general ledger account, the chart of accounts contains the account number, the account name, and technical information.

Valuation Class

A valuation class is used to determine the general ledger account for the materials stock account. In automatic account determination, valuation classes must be created and then assigned to material types. While creating material master records, selecting the appropriate valuation class under the Accounting 1 tab is required. The valuation class list in the material master record will depend on the material type. For example, in a standard SAP system, material type ROH (raw material) has three valuation classes: 3000, 3001, and 3002.

Transaction Key

Transaction keys are used to determine accounts or posting keys for line items that are automatically created by the system. They’re defined in the system and can’t be changed.

Now that you have an understanding of the key terms in automatic account determination and understand how it can work in your business, we’ll move on to describe the configuration steps and business processes involved.

Configuration with the Automatic Account Determination Wizard

Automatic account determination can be configured either with or without the automatic account determination wizard, a tool provided by SAP to help you manage the automatic account determination functionality. To configure automatic account determination using the wizard, follow the configuration menu path SAP IMG > Materials Management > Valuation and Account Assignment > Account Determination > Account Determination Wizard .

The wizard will ask you a number of questions and, based on your answers, finds the correct settings and saves them in the corresponding SAP tables. Except for a few restrictions (as documented in the wizard), the wizard will perform the following steps:

• Defines valuation control
• Groups valuation areas
• Defines valuation classes
• Defines account grouping for movement types
• Manages purchase accounts
• Configures automatic postings

We’ll explain how to set up automatic account determination without the wizard because this manual and step-by-step approach to account determination will help you understand how to work with the wizard. Further, using account determination without the wizard enables the creation of more complex configurations. Once you’ve gained the concepts and the fundamentals behind account determination, you can use the automatic account determination’s wizard tool to quickly setup account determination processes in SAP systems.

Configuration without the Automatic Account Determination Wizard

We’ll now follow a step-by-step approach to setting up account determination in an SAP system. We’ll cover the necessary configuration steps involved, followed by steps for assigning the configured objects in the master data. Business processes involving account determination and that use the master data are covered next. We’ll also cover the accounting entries that occur as the result of a stock posting.

Let’s walk through the required steps next:

Define a Valuation Control

In account determination, you can group together valuation areas by activating the valuation grouping code (also known as the valuation modifier ), which makes configuring automatic postings much easier. A valuation grouping code can be made active or inactive by choosing the respective radio button.

To define a valuation control, follow the configuration menu path SAP IMG > Materials Management > Valuation and Account Assignment > Account Determination > Account Determination without Wizard > Define Valuation Control .

By default, the valuation grouping code is active in the standard SAP system.

Assign Valuation Grouping Codes to Valuation Areas

The valuation grouping code makes setting up automatic account determination easier. Within the chart of accounts, assign the same valuation grouping codes to the valuation areas you want assigned to that account. As shown in the figure below, valuation grouping code 0001 has been assigned to valuation area 1100 and company code 1100. If another valuation area also uses the same set of general ledger accounts as valuation area 0001, then assign valuation grouping code 0001 to that valuation area.

To assign valuation grouping codes to valuation areas, follow the configuration menu path SAP IMG > Materials Management > Valuation and Account Assignment > Account Determination > Account Determination without Wizard > Group Together Valuation Areas .

Define Valuation Classes

In this step, you’ll define the valuation classes allowed for each material type. Then, you’ll assign the account category reference to the material type. As shown in the second figure below, account category references 0001 and 0002 have been defined, and for each account category reference, one or more valuation classes can be assigned. Account category reference 0001 has been assigned to material type ROH, and valuation classes 3000, 3001, and 3002 have been assigned to account category reference 0001. Consequently, valuation classes 3000, 3001, and 3002 have been assigned to material type ROH. While creating the material master record for material type ROH, select any of these valuation classes. Similarly, for material type HALB, select valuation classes 7900 or 7901.

In this section, through an example, we’ll create the new valuation class 3004 and cover all the associated configuration settings required to ensure a working end-to-end business process.

To define which valuation classes are allowed for a material type, use Transaction OMSK or follow the configuration menu path SAP IMG > Materials Management > Valuation and Account Assignment > Account Determination > Account Determination without Wizard > Define Valuation Classes . On the screen that appears, you’ll see three options: Account Category Reference , Valuation Class , and Material Type/Account Category Reference . Follow these steps:

• Click on Account Category Reference and, if needed, create an account category reference, as shown here:

• Click on Valuation Class , shown below, and then click on the New Entries Create a new valuation class ( ValCl ) 3004 (with Description Raw Materials- Steel ) and assign the valuation class to account category reference ( ARef ) 0001 . 2

• Click on Account Category Reference and maintain a mapping between the material types and account references. For material type ( MType ) ROH , assign the account reference ( ARef ) 0001 , as shown here:

Define an Account Grouping for Movement Types

Now, assign an account grouping to movement types. The account grouping is a finer subdivision of the transaction/event keys for account determination. For example, during a goods movement, the offsetting entry for the inventory posting (Transaction GBB) can be made to different accounts, depending on the movement type. The account grouping is provided for the following transactions:

• Transaction GBB (Offsetting Entry for Inventory Posting)
• Transaction PRD (Price Differences)
• Transaction KON (Consignment Liabilities)

The account grouping in the standard system is only active for Transaction GBB. To define account groupings for movement types, follow the configuration menu path SAP IMG > Materials Management > Valuation and Account Assignment > Account Determination > Account Determination without Wizard > Define Account Grouping for Movement Types . Define the account grouping code, the movement type, and the transaction/event key combination, as shown in the next figure.

Note: Value strings group together the various transactions used in account determination. For example, the value string WE01 can be seen by following the configuration menu path SAP IMG > Materials Management > Valuation and Account Assignment > Account Determination > Account Determination Without Wizard > Define Account Grouping for Movement Types . On this screen, if you double-click on any entries that contain WE01, a list of transactions along with their descriptions will appear. The transactions that appear in the value string are hard coded in the system, so you should never try to change them.

Configure Automatic Postings

In this step, enter the system settings for inventory management and invoice verification transactions that result in automatic posting to general ledger accounts. A transaction/event key is a key to differentiate account determination by business transaction. For example, we must differentiate general ledger account posted by goods receipt transaction and posted by invoice receipt transaction.

You don’t need to define these transaction keys; they are determined automatically from the transaction of the movement type (inventory management) or from the transaction of invoice verification. All you need to do is assign the relevant general ledger account to each posting transaction.

To assign general ledger accounts to transaction/event keys, use Transaction OMWB or follow the menu path SAP IMG > Materials Management > Valuation and Account Assignment > Account Determination > Account Determination without Wizard > Configure Automatic Posting . Click on Cancel , as shown below.

To assign a general ledger account, on the screen shown above, click on Account Assignment (not shown). A list of transaction keys will appear; double click on the key for which setting the general ledger accounts is required. Next, define the valuation grouping code (also known as the valuation modifier ), valuation class, and general ledger account, as shown below. Then, check the settings function by using the simulation function.

Use Transaction BSX for inventory posting and for assigning general ledgers. In the popup window that appears, enter the Chart of Accounts 1100 , and the screen shown below will appear.

This figure shows the Transaction BSX screen for posting inventory. Click New Entries and enter the newly created Valuation Class 3004 and assign the Account 11020101 .

Go back to the screen shown when utilizing Transaction OMWB, and this time, use Transaction WRX (for the goods receipt/invoice receipt [GR/IR] clearing account) and maintain the general ledger account of the newly created Valuation class 3004 . Similarly, repeat the same steps for Transaction PRD (for price difference account).

Let’s now look at the business processes and the associated master data setup and transactions, not only to check that the newly created valuation class 3004 works correctly, but also that the associated general ledger accounts are correct.

Master Data Setup

Access the screen shown below via Transaction MM01. Under the Accounting 1 tab of the material master 157 , assign the newly created Valuation Class 3004 .

Now, let’s discuss the account determination for the general ledger as it relates to goods receipt and goods issue postings. Post a good receipt of the material 157 with reference to a PO via Transaction MIGO. Then, display the goods receipt document and go to the Doc. info tab. Click on the FI Documents button, which will display a list of financial documents created for the goods receipt document. Select Accounting document to see the details of that accounting document.

As shown below, you’ll see the general ledger account postings, which are determined based on the automatic account determination configuration. General ledger account 11020201 (inventory raw material stock account) is debited, and GR/IR account 22010202 is credited.

In this blog post, we covered the account determination process that is useful to those running materials management with SAP .

Editor’s note : This post has been adapted from a section of the book Materials Management with SAP S/4HANA: Business Processes and Configuration by Jawad Akhtar and Martin Murray.

Recommendation

Manage your materials with SAP S/4HANA! Whether your focus is on materials planning, procurement, or inventory, this guide will teach you to configure and manage MM in SAP S/4HANA. Start by creating your organizational structure and defining business partners and material master data. Then follow step-by-step instructions for your essential processes, from purchasing and MRP runs to goods issue and receipt. Discover how to get more out of SAP S/4HANA by using batch management, demand-driven MRP, SAP Fiori reports, and other built-in tools.

SAP PRESS is the world's leading SAP publisher, with books on ABAP, SAP S/4HANA, SAP CX, intelligent technologies, SAP Business Technology Platform, and more!

Latest Blog Posts

A Look at Materials Management and Logistics in SAP S/4HANA

Sales Contract Management with SAP S/4HANA Logistics

The official sap press blog.

As the world’s leading SAP publisher, SAP PRESS’ goal is to create resources that will help you accelerate your SAP journey. The SAP PRESS Blog is designed to provide helpful, actionable information on a variety of SAP topics, from SAP ERP to SAP S/4HANA. Explore ABAP, FICO, SAP HANA, and more!

SAP Blog Topics

• Administration
• Business Intelligence
• Human Resources

Blog curated by

• Legal Notes
• Privacy Policy
• Terms of Use
• Guest Posting

Creating Purchase Requisitions

After completing this lesson, you will be able to:

• Create a Purchase Requisition for Stock Item and Consumable Material

Purchase Requisitions

As a long-term SAP user, you want to understand the usage of purchase requisitions in the purchase to pay business process as well as the usage of document types, item categories and account assignment for consumable items.

A purchase requisition is an internal document that the purchasing department uses to procure a particular quantity of a material or a service for a particular date.

A purchase requisition can be created directly or indirectly.

Directly means that a purchase requisition is created manually in the department that has the need. Whoever creates the purchase requisition determines which material or service in which quantity, and for which date have to be ordered.

Material requirement planning (MRP)

Maintenance orders

Planned orders

You can also initiate purchase requisitions from SAP Ariba.

When you create a purchase requisition for materials that have a material master record, the system transfers the data in the material master record to the purchase requisition. You also have the option to select items from a web-based catalog.

You can convert purchase requisitions into requests for quotations (RFQs), purchase orders (POs), or outline agreements.

Purchase Requisition Processing

Account assignment objects.

If you buy material, you procure it either for stock or for direct consumption.

You need to enter an account assignment for an item under the following circumstances:

If you order a material that is not subject to value-based inventory management and post its value directly to consumption (pure consumable material)

If you order an article that does not have a material master record

If you order a service

If you want to procure a material as a consumable, you must specify an account assignment category and other account assignment data in the document item of the purchase requisition or purchasing document.

The account assignment category determines the account assignment object category that is to be charged. You must provide the account assignment data. The accounts are debited when the goods receipt or invoice is posted.

The following are the examples of account assignment objects:

The account assignment object cost center (account assignment category K): When you make an account assignment to a cost center, you must enter the general ledger (G/L) account number of the consumption account. You must also enter the cost center for which the material will be procured on the account assignment data screen. You can specify that the system automatically proposes the number of the GL account to be charged in Customizing.

The account assignment object asset (account assignment category A): If you use account assignment category A, you have to enter the asset number on the account assignment data screen. The system automatically determines the G/L account to charge based on the asset number you cannot enter manually.

Procurement for Consumption

When you procure a material directly for consumption, no material master record is necessary.

The characteristics of consumable materials with a master record are as follows:

There is no value-based inventory management.

The system automatically updates consumption in the material master record.

In SAP S/4HANA, the term "consumable material" is any material subject to procurement whose value is settled using cost element accounts or asset accounts. Therefore, a consumable material is procured directly for an account assignment object.

When procuring a consumable material without a material master record, you have to enter a short description, a material group, and a purchase order unit in the document manually. You have to do this because you cannot fetch this data from a master record. This is not true for a material with a master record. For these materials, the material type controls whether inventory management takes place on a value basis.

Procurement for Consumable Materials

When you procure a consumable material, a material master record is not required, but can be used.

You can procure stock material for consumption. In all cases, you must specify an account assignment category and other dependent account assignment data, such as an account assignment object and a G/L account (consumption account). At the time of goods receipt or invoice receipt, the system debits the consumption account the purchase order specifies with the procurement value. Additionally, the system posts the amount to the account assignment object.

The Procure to Pay business process integrates with many different SAP application modules.

A purchase requisition can be created from a MRP run.  If a purchase requisition line item is a consumable for a cost object, then upon saving the purchase requisition, a commitment in Management Accounting is created. Please note: Commitment Management within Management Accounting needs to be activated.

 If a purchase order line item is a consumable for a cost object, then upon saving the purchase order, a commitment in Management Accounting is created. Please note: Commitment Management within Management Accounting needs to be activated.

When you save a goods receipt for stock materials, on hand inventory is increased.

If a change in material valuation occurred, then the system creates an accounting document in Financial Accounting.

If the purchase order was for consumable materials, the system not only creates an accounting document in Financial Accounting, but also creates a controlling document in Management Accounting and creates a document to update the Material Ledger.

If the organization is using Warehouse Management, then the system creates a transfer requirement.

Lastly, the system updates the purchase order history.

When an invoice is posted, the system creates an accounting document, in Financial Accounting to record the liability owed to the vendor.  The system, also creates an open item against the vendor’s account.

If the purchase order was for consumable materials, and the invoice amount differs from the purchase order amount, then the system creates a controlling document, in Management Accounting.

Create a Purchase Requisition for a Stock Item and a Consumable Material

Log in to track your progress & complete quizzes

Service Purchase Order in SAP: ME23N

What is Service Purchase Order?

Service purchase orders are entered for services that are procured internally or externally. These purchase orders are different from standard ones as they don’t require a goods receipt since they have no stock. Other than that, there are a few small differences in PO creation. First is the document type for these orders. It should be FO – Framework Order. To procure a service directly for a cost center, we will follow the below procedure.

Step 1) Go to transaction ME21N .

• Choose document type FO – Framework Order.
• Choose vendor.
• Choose validity start for PO.
• Choose Account Assignment Category – K and Item Category – D .
• Enter the description for the service.
• Enter the quantity and unit of measure.
• Enter the price for the service (e.g. 900 EUR per 1 AU – activity unit).

Step 2) On item level, there are few fields you need to maintain in order to create a valid PO for service. On the “Services” tab, enter the information about your service, quantity and price.

You might be prompted for Account assignment information.

Step 3) Here, you can enter the G/L account (it will be proposed in most cases), and cost center for service cost to be assigned.

• G/L account.

Step 4) On the Limits tab, you can enter the limit for unplanned services. Expected value that services should not exceed.

Step 5) Now choose the Delivery tab and uncheck the Goods Receipt check box. Services do not have goods receipt as they are not relevant for inventory management (they don’t have stock).

Step 6) Account assignment tab shows the information we were asked to enter in pop-up window. If you are not asked to enter via pop-up you can enter information here.

Step 7) We don’t need storage location for our item as it’s not stock relevant.

You can save your changes and get the document number.

Change and display mode are accessed through the same transactions as for a standard purchase order , ME22N and ME23N .

• MRBR: Release Blocked Invoices in SAP
• Release Strategy in SAP MM – Procedure for Purchase Order
• Overview Of Pricing Procedure in SAP MM & SAP SD
• How to Define Access Sequence & Condition Table in SAP V/05, M/03
• How to Define Condition Types in SAP
• How to Define Calculation Schema in SAP
• How to Define Schema Group & Determination in SAP
• Reservation of Inventory in SAP MB21, MB1A, MBST, MB22

Account Assignment Categories and Document Types for PR in SAP

How to assign categories and document types for purchase requisition.

The following training tutorials guide how to assign account categories and document types for PR. You can assign categories and document types for PR by using one of the following navigation methods.

• SAP IMG Path : – Project system >> material >> procurement >> Account Assignment Categories and Document Types for Purchase Requisitions
• Transaction code: – OPS8

Refer below step by step procedure to assign account assignment categories to document types for purchase requisition in SAP.

Step 1: – Enter transaction code “OPS8” in the SAP command field and press enter key.

Step 2: – On material flow in the network overview screen, click on new entries to assign categories and document types

Step 3: – On new entries of the Account assignment screen, update the following fields.

• Procurement: – Update the three digits alpha-numeric id that identifies the procurement indicator and updates the descriptive text.
• Priorities: – Priorities control various stock types, for example, you can set priority project to 1, priority plant to 2, and priority sales to 3.
• Control data: – Control data control the purchase requisition network, third-party material is delivered to customers, and preliminary purchase requisitions.
• Default item category: – Update the default item category for the item category MRP (Material Requirement Planning)

After maintaining the required details Account Assignment Categories and Document Types for PR Click on the save button to save the configured data.

Continue to read SAP PS Tutorial with real-time scenarios.

• 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

Blog about all things SAP

ERProof » SAP MM » SAP MM Training » SAP Goods Receipt for Consumable Material

SAP Goods Receipt for Consumable Material

Goods receipts is the sixth phase of the procurement cycle. After processing and monitoring of a purchase order, comes the time to receive the ordered material from the vendor via SAP goods receipt transaction as depicted in the following figure.

SAP ERP differentiates two types of materials known as stock materials and consumable materials. Let us talk about SAP goods receipt for consumable materials.

Consumable Materials

Consumable materials can be defined as:

• Materials without value-based inventory management (not tracked in inventory)
• Materials purchased for a particular account assignment object (purchased for a cost element, an asset accounts, etc.)

A material master record is not necessary for a consumable material. However, there are cases when a consumable material has a master record. In certain scenarios we can have:

• Consumable material having a master record but not subject to quantity-based or value-based inventory management
• Consumable material having a master record and subject to quantity-based inventory management but not to value-based inventory management
• Stock material purchased for consumption

Consumable Material with Master Record

A material with a master record has a property controlling if inventory management for this material is carried out on a value basis . This property is called material type. As consumable materials are not tracked in inventory, therefore, they are never under the value-based inventory management . SAP system includes two standard material types for consumable items known as:

• Non-valuated material : under inventory management on a quantity basis (in SAP MM) but not on a value basis (SAP FI).
• Non-stock material : Inventory management is not possible neither on a quantity nor on a value basis.

Each of these material types is used for a specific purpose. The first one is used for low value items with stocks that have to be monitored, whereas the second is used for regularly needed consumable items with the properties to allow the storage of information needed to produce purchasing documents.

Account Assignment Objects

For each item of a purchase order (PO) or a purchase requisition (PR) that is intended for direct consumption, an account assignment has to be entered in SAP. Account assignment entry is mandatory for consumable materials. We have account assignment objects follows:

SAP Goods Receipt for Consumable Materials

Let us assume that a vendor has completely delivered a material ordered in one of our purchase orders . The first thing to do will be to capture the goods receipt.

Please consider that the numbers that will be mentioned below (for example purchase requisition, purchase order, etc.) are just for illustrative purpose. Learners are most likely to have different numbers according to their SAP configuration.

A purchase requisition with the number 5010000518 was created with the following data:

• Account assignment category: U
• Short text for description: Laptop Lenovo with an i3 processor
• Quantity to be Supplied: 3
• The unit of measure: PC
• The delivery date: today date + 3
• Material group: 0020010
• The plan: 1100
• The purchasing group: 001
• Valuation price (In the item detail valuation tab): 700

This purchase requisition was created for a material without a master record having in its description a short text (Laptop Lenovo with an i3 processor) and an account assignment category (U).

Then, this purchase requisition was converted into a purchase order with the following data:

• Order type: Standard PO
• Purchase organization: 1000
• Vendor: 9001
• Account assignment category: K

The account assignment category U (Unknown) was replace by K (Cost Center) because the purchasing department that is responsible for the purchase order has to perform a proper account assignment. Additionally, the following information was entered under the item details in the Account Assignment tab:

• The G/L Account: 410000
• Cost Center: 1000

The purchase order number 4500019259 is surely an order for a consumable material with characteristics like:

• Short text (description): Laptop Lenovo with an i3 processor
• Account Assignment Category: K

To capture SAP goods receipt of that consumable material, as we know the purchase order number, we will use the following path:

Logistics > Materials Management > Inventory Management > Goods Movement > Goods Receipt > For Purchase order > PO Number Known (MIGO)

On the initial screen of MIGO transaction, make sure to select on the upper part of the screen at your left for the transaction/event drop-down Goods Receipt and next to it on the reference document drop-down menu Purchase Order .

Enter the purchase order number next to the reference document drop-down menu, and also the following details:

• Document date: today date
• Posting date: today date
• Delivery note: *

The delivery note is a mandatory field. It is an external reference field for delivery note that has to be filled. ‘*’ is just a placeholder if we don’t have any delivery note number.

Next, after pressing on Enter button, the system will retrieve and display details of our purchase order. Let us click on the field with the number 1 on the first item and tick on the checkbox Item OK at the bottom of the screen. If the purchase order has many items, we will have click on each line and performed the same operation.

Above the Item OK checkbox, there are several tabs with detailed data. In the Where tab, there is the Movement Type field equal to 101 for our transaction. This is a standard SAP movement type for goods receipts. We can also specify stock type here (which is unrestricted use by default) that we will leave unchanged.

Save the document. The SAP system will post goods receipt by generating a material document and show its number at the bottom of the screen.

The accounting document that was automatically generated with our goods receipt posting is shown on the screenshot below. As written above, it can be viewed using “FI Documents” button.

Did you like this SAP MM 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 MM tutorials.

Navigation Links

Go to next lesson:  SAP Goods Receipt for Stock Material

Go to previous lesson:  SAP Inventory Valuation

Go to overview of the course: SAP MM Training

7 thoughts on “SAP Goods Receipt for Consumable Material”

Can you please add the accounting entries screen during MIGO transaction please ?

Added (see the last screenshot)

Thank you.This was so important.It would have been better if you explained the relevance of the item category field as well

Hi I am glad using SAP BI, its is the real software for controls. Kindly send me the procedure in software for both procurement and finance

This is very much helpful, however also mentioned here for illustration purposes, still it would be preferable to use normal consumables like printing papers and ball point pens in this example, rather than a lenovo laptop that may be managed as a fixed asset in many organizations.

How we maintain posting period I tried t-code mmrv, mmpv, ob52, omsy but my problem is not solved when I trying to posting the GR posting period massage is come. Please I request you solve my problem. Give me screenshot for solutions.🙏

GR done for Cost center PO without out materials. now materials are at interim area without storage location. my issue is : how to issue the consumable from interim area to requested cost center.

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.

• Administering Oracle Fusion Analytics Warehouse
• Manage Users, Groups, Application Roles, and Data Access

Manage Uploads and Downloads

As the cloud account administrator with security administrator or functional administrator or service administrator role, you can upload and download data to your data warehouse using the Upload tile on the Console.

About Uploading and Downloading Your Data

Upload and download data security assignments, upload and download financial categories, upload and download financial category assignments, upload and download user group mappings, download and upload area of responsibility data, download and upload custom job roles mappings, download and upload data security exclusion rules.

The Upload tile in the Console enables the cloud account administrators to upload and download the following:

• Data security assignments
• Financial categories
• Financial category assignments
• User to group associations

You can upload and download only csv files.

You can download security assignment template files to help you set up security assignments, and then upload the files to your environment.

You can also download data security assignment files using the Download File button available from the Security Assignments tab on the Security page. In this case, you don't need to specifically select Data Security Assignments . Click Download File , select the type of file you want to download, and proceed with the remaining steps. You can also upload data security assignment files using the Upload button available from the Security Assignments tab on the Security page. In this case, you don't need to specifically select Data Security Assignments . Click Upload and then proceed with the remaining steps.

Replace existing configuration settings deletes existing data security assignments.

Ensure that these prerequisites are in place:

• Security assignment has 1:1 mapping with application roles.
• Application roles are assigned to groups.
• Users who are being assigned to a security context are part of the group that is linked to the security context through the application roles.
• Sign in to your service.
• In Oracle Fusion Analytics Warehouse Console , click Uploads under Application Administration.
• On the Uploads page, click Download File , select Data Security Assignments and then select the type of file you want to download.
• USERNAME: The user name and user display name.
• SEC_OBJ_CODE: The object code for which you are adding the data security assignment.
• SEC_OBJ_MEMBER_VAL: The security assignment member for each context. See Security Object Tables .
• When you are done updating the file, save your changes.
• On the Uploads page, click Upload File and the applicable file type.
• Select whether you want to Merge to the existing settings or Replace existing configuration settings .
• Select the file you want to upload and click Upload File . You can review the status of the upload on the Uploads tab.

• Click Properties to check the upload statistics.
• Click Download to download the file you just uploaded in the event you want to upload the file again.
• Click Delete if a file fails to process and you want to remove the file history.

Security Object Tables

Use these security object codes and associated SQL to access the assignment member for each context.

Security Objects

Table 5-1 Security Object Codes

Assignment Member SQL

Table 5-2 Assignment Member SQL

You can download financial category template files to help you set up financial categories, and then upload the files to your environment.

• In Oracle Fusion Analytics Warehouse Console , click Uploads under Application Administration. You see the Uploads page.
• On the Uploads page, click Download File , select Financial Categories and then select the type of file you want to download.
• FINANCIAL_CATEGORY: The financial category code.

You can download financial category assignment template files to help you set up financial categories, and then upload the files to your environment.

• On the Uploads page, click Download File , select Financial Category Assignments and then select the type of file you want to download.
• CHART_OF_ACCOUNTS – Name of your chart of accounts.
• Actual segment values.
• FINANCIAL_CATEGORY: The financial category code. This can be a predefined category or a custom category defined using the Financial Categories upload option.

You can download user group mapping template files to help you set up user group mappings, and then upload the files to your environment.

You can download "Sample" or "Current" files. Sample provides a csv file with relevant headers to help familiarize you with the types of data you can expect. Current provides a list of current data assignments you can download to your test or production environments. Regardless of the file you download, you need to populate the USERNAME and GROUPNAME columns. Use the Operation column to make bulk changes to the user group mappings. Don't change any of the header names in the downloaded files. When you're done updating the files, you can upload them to your environment.

• On the Uploads page, click Download File , select User Group Mapping , and then select the type of file you want to download.
• USERNAME: The username in Oracle Identity Cloud Service .
• GROUPNAME: The group name in Oracle Identity Cloud Service .
• OPERATION: Enter ADD or leave it blank to add the user group mappings or enter REMOVE to remove the user group mappings.
• When you're done updating the security file, save your changes.
• On the Uploads page, click Upload File and then select the applicable file type.

If you use Oracle Fusion HCM Analytics , then you can manage the area of responsibility (AOR) data in the Oracle Autonomous Data Warehouse associated with the Oracle Fusion Analytics Warehouse instance for security setups.

You can use the AOR-related data in custom security setups and for mass assignment. You can download the latest AOR data security assignment files to make changes to the existing data and upload it back. This enables you to avoid using other methods to get the AOR data into Oracle Autonomous Data Warehouse .

The downloaded AOR data security assignment file supports only the ready-to-use security contexts. For custom contexts, you can utilize the AOR data available in the DW_ASG_RESPONSIBILITY_D table while configuring custom security. The format of the AOR file that you download is different from the data security assignment file that you can upload, hence you must copy the required columns from the AOR file to the security assignment file prior to uploading it as the AOR-related security assignment file. For example, the AOR file has additional columns like AOR TYPE, which is for your reference only.

When you run the data pipeline for the Area of Responsibility functional area after activating it, Oracle Fusion Analytics Warehouse loads the AOR-related data from the DW_ASG_RESPONSIBILITY_D view, transforms it, and uses this data to populate the AOR file. The data in the AOR-related downloadable file is formatted as per the current data security assignment .csv file and pertains to the ready-to-use security contexts of business unit, country, legal entity, and organization.

After uploading the security assignments data to Oracle Autonomous Data Warehouse , if the AOR assignment ends, then you must download the AOR and data security assignment files, compare mismatches between the two files, and take necessary actions of adding or removing contexts from the data security context and upload the correct data as and when required. The AOR file has only the current effective records; hence any end-dated record won’t be available in this file.

• Unzip the DataSecurityAssignmentAOR_csv.zip file you downloaded and edit the csv file as required. When you are done updating the file, save your changes.

If you want to automate the application of the security exclusion rules, then download the file to make the changes and upload it.

• Unzip the DataSecurityExclusionAssignments_csv.zip file you downloaded and edit the csv file as required. When you are done updating the file, save your changes.

If you've custom job roles in Oracle Fusion Cloud Applications and want to use them as data and duty roles in Oracle Fusion ERP Analytics , then you can map the job roles to the data and duty roles, and upload the mappings.

Oracle Fusion Analytics Warehouse uses the mappings to apply the security assignments to the applicable Oracle Fusion Cloud Applications users in Oracle Fusion Analytics Warehouse during the automatic synchronization of the data security assignment configurations between Oracle Fusion Cloud Applications and Oracle Fusion Analytics Warehouse .

• Unzip the CustomRoleMapping_csv file you downloaded and create the mapping by entering the Oracle Fusion Cloud Applications jobe role in the FA_JOB_ROLE column and a corresponding Oracle Fusion Analytics Warehouse data or duty role in the FAW_ROLE column. When you are done updating the file, save your changes.

• wind damage

Baytown residents recall jet-like roar as NWS estimates 100 mph winds during storm

BAYTOWN, Texas (KTRK) -- The National Weather Service estimated that the wind speeds in Baytown hit between 90 to 100 miles per hour at times during the May 16 Derecho event.

NWS field crews surveyed damage, which included downed power lines and tree limbs in parts of the Baytown area.

"I heard the freight train sound. When I heard that, I flipped all the mattresses for my brother and mama," resident Joshua Rendon said.

Rendon said the storm moved in quickly.

He spoke with ABC13 while clearing debris with Ian Dillon on Bob Smith Road.

Dillion said he was driving on the highway in the area when the storm moved in.

"I was just driving, and then it started to sound like multiple jets just flew next to my windows," Dillion said.

For news updates, follow Jiovanni Lieggi on Facebook , X and Instagram .

Related Topics

• STORM DAMAGE
• WIND DAMAGE

Wind Damage

People still driving under leaning power pole: 'Definitely a hazard'

Mom of 4 moving SUV during storm among at least 7 killed

Cooling centers available for storm-impacted neighbors

Widespread Houston-area storm costs $5B to $7B in damage: AccuWeather

Top Stories

77 schools still without power as HISD eyes Monday return to classroom

• 7 minutes ago

Sunny & warm weekend, fog & decreased air quality again Sunday

• 2 hours ago

Channelview mom's son relies on ventilator as power outage continues

80% of customers to have power restored by Sunday evening: CenterPoint

Which cooling centers are open on Sunday after storm damage?

125 out of 1,100 signals in need of repair after power outage: TxDOT

Galveston bridge reopens for vehicles after barge crashed into it