material group and gl account assignment in sap

2828996 - How to determine GL account using Material Group?

• How to assign Material Group to Valuation Class?
• How to determine GL account for "free-text based item" without material master record in Purchase Order?

Environment

• Sourcing & Procurement
• SAP S/4HANA Cloud All Versions
• SAP Fiori 

S4_PC, S/4 HANA Cloud, MM-SRV-ACC, MM-PUR-GF-ACC, procurement, Sourcing and Procurement, 102665, 101602, material group, valuation class, free text based item, no material master   , KBA , MM-PUR-GF-ACC , Account assignment , MM-SRV-ACC , Account Assignment , How To

About this page

Search for additional results.

Visit SAP Support Portal's SAP Notes and KBA Search .

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

• 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

Material group gl account Table in SAP

• WRF_PRICAT_002 Table for Assign External Material Group - SAP Material Group Table Type : TRANSP Package : WRF_VPRI_IN Module : SD-EDI
• /DSD/RP_DRVKTOKD Table for Define Account Group as Account Group for Driver Table Type : TRANSP Package : /DSD/RP Module : LE-DSD-RP
• A101 Table for SOrg/DstCh/Material-Main Item/Material Pricing Group Table Type : TRANSP Package : VKON Module : AP-PRC-PR
• A102 Table for SOrg/DstCh/Material Pricing Group-Main Item/Material Table Type : TRANSP Package : VKON Module : AP-PRC-PR
• A266 Table for Standard Dummy Customer/Material Group/Material Number Table Type : TRANSP Package : MEC_VKON Module : IS-EC
• MVGD Table for Material master/product group material version Table Type : TRANSP Package : MGVERS Module : LO-MD-MM
• OIRAMATHANDGRP Table for Material handling group material assignment (IS-Oil SSR) Table Type : TRANSP Package : OIR Module : IS-OIL-DS-SSR
• T023S Table for Base Material Group/Hierarchy Material Assignment Table Type : TRANSP Package : WWGR Module : CRM
• SMOTVKMT Table for Material: Account Assignment Group Texts Table Type : TRANSP Package : SMO3 Module : CRM-MSA
• TVKMT Table for Material: Account Assignment Group Texts Table Type : TRANSP Package : VS0CCORE Module : SD-MD-MM
• CRMC_ACC_MAP Table for Assignment of Account Assignment Group to Account Table Type : TRANSP Package : CRM_LEASING_SRM Module : CRM-LAM-BTX
• TZB27 Table for Assignment of G/L account to account group Table Type : TRANSP Package : FVVD_PAYMENT Module : FS-CML-AC-RPM
• A031 Table for Price Group/Material Pricing Group Table Type : TRANSP Package : VKON Module : AP-PRC-PR
• J_3R_INVDIFFMAT Table for Material group assignment to group of inventory difference Table Type : TRANSP Package : J3RALF Module : FI-LOC
• K9RP000000019SAP Table for Derivation Rule: Main Product Group from Material Group Table Type : TRANSP Package : KEG2 Module : CO-PA
• A265 Table for Standard Dummy Customer/Document Type/Material Grp/Material Table Type : TRANSP Package : MEC_VKON Module : IS-EC
• CAD_PARTS Table for Table for Assignment of Standard Material to Material Nos Table Type : TRANSP Package : CA Module : CA-CAD
• J_1IMODDET Table for Modvat Determination Table (Input Material->Output Material) Table Type : TRANSP Package : J1IN Module : FI-LOC
• KOTG401 Table for GG: Listing - Material entered / Material Table Type : TRANSP Package : HT_VKON Module : IS-HT
• KOTR012 Table for Receiving Material + Sending Material Table Type : TRANSP Package : VBDRV Module : LO-BM
• KOTR013 Table for Receiving Material Type + Sending Material Type Table Type : TRANSP Package : VBDRV Module : LO-BM
• MVOP Table for Material data material versions Table Type : TRANSP Package : MGVERS Module : LO-MD-MM
• T8APP_GLPCM Table for EC-PCA: Plan Costs from Material Costing for Rep. Material Table Type : TRANSP Package : KE1 Module : CRM
• WSDT_MAT_MTART Table for Material Type available in Material Creation Table Type : TRANSP Package : WSD_CS_DDIC Module : SD-MD-MM-CS
• /SAPCEM/MATERIAL Table for Material Assignment to Appropriate Catalog Table Type : TRANSP Package : /SAPCEM/DDIC Module : IS-EC-CEM
• A088 Table for Taxes: Material, Plant, Account Assignment and Origin Table Type : TRANSP Package : VKON Module : AP-PRC-PR
• MLCO Table for Material valuation document account assignment information Table Type : TRANSP Package : DI_ML Module : CO-PC-ACT
• PTSAFT_MATACCNT Table for GL Account based material numbers Table Type : TRANSP Package : ID-FI-PT Module : FI-LOC
• ACCRAC Table for Assignment of Acr./Def. G/L Account to Accruals Account Table Type : TRANSP Package : ACCR Module : FI
• BKK600 Table for Account Hierarchy: Account Relationships Table Type : TRANSP Package : FKBR Module : IS-B-BCA-MD
• BKK610 Table for Account Hierarchy: Assignment of Root Account to Tree Number Table Type : TRANSP Package : FKBR Module : IS-B-BCA-MD
• BSACC_HIST_GRP Table for Account Groups for Account History Table Type : TRANSP Package : FIN_BS_DIALOG Module : FI-GL-GL
• BSACC_HIST_GRPT Table for Account Groups for Account History Table Type : TRANSP Package : FIN_BS_DIALOG Module : FI-GL-GL
• CRMD_ACC_PL_ATTR Table for Account Planning account plan attributes Table Type : TRANSP Package : CRM_ACCOUNT_PLANNING Module : CRM-ACP-APL
• ICRC02 Table for Account Groups for G/L Account Reconciliation Table Type : TRANSP Package : FBAS Module : CRM
• ICRC03 Table for Account Groups for G/L Account Reconciliation - Name Table Type : TRANSP Package : FBAS Module : CRM
• ICRC04 Table for Account Groups for G/L Account Reconciliation - User Assgnmt Table Type : TRANSP Package : FBAS Module : CRM
• IDCN_ALGACCGRP Table for Account Level Hierarchy: Account Levels Table Type : TRANSP Package : ID-FI-CN Module : FI-LOC
• IDCN_ALGACCGRPT Table for Account Level Hierarchy: Account Levels (Text) Table Type : TRANSP Package : ID-FI-CN Module : FI-LOC
• IDCN_ALGACCHIER Table for Account Level Hierarchy: Account Level Hierarchy (Top Level) Table Type : TRANSP Package : ID-FI-CN Module : FI-LOC
• IDCN_ZJFSKIPACC Table for Skip G/L Account from P&L Account Closing Posting (China) Table Type : TRANSP Package : ID-FI-CN Module : FI-LOC
• IDCN_ZJFSKIPACCT Table for Skip G/L Account from P&L Account Closing Posting (Text) Table Type : TRANSP Package : ID-FI-CN Module : FI-LOC
• J_3RKPAI Table for Account priorities for account pairs Table Type : TRANSP Package : J3RK Module : FI-LOC
• KOMU Table for Account Assignment Templates for G/L Account Items Table Type : TRANSP Package : FFE Module : FI
• PKOMU Table for Personal Account Assignment Templates for G/L Account Items Table Type : TRANSP Package : FFE Module : FI
• T033D Table for Account Determination: Account Determination Key Names Table Type : POOL Package : FBAS Module : CRM
• T033J Table for Account Determination: Account Symbol Descriptions Table Type : POOL Package : FBAS Module : CRM
• T033O Table for Account Determination: Account Determination Key Values Table Type : POOL Package : FBAS Module : CRM
• T687 Table for Account Determination: Account Key Table Type : POOL Package : FBD Module : CRM
• T687T Table for Account Determination: Account Key Texts Table Type : POOL Package : FBD Module : CRM
• TACEPSRULE Table for ACE Account Determination: Account Determination Rule Table Type : TRANSP Package : ACE-PS Module : FI-GL-GL-ACE
• PT_MATDE Table Data element for Material display: First material no. or material short text
• FLQKTOSL Table Data element for Liquidity Calculation: Account Key for Material Account
• KTOSL_MG Table Data element for Account Key: Offsetting Account for Material Adjustment
• BBP_WWGDA Table Data element for Material group reference material
• BBP_WWGPA Table Data element for Material group material
• COMT_OLTP_MATKL Table Data element for Material Group for OLTP Material (Industry and Retail)
• COMT_OLTP_MATKL_MAT Table Data element for Material Group for Industrial Material
• WWGDA Table Data element for Material group reference material
• PTGRP Table Data element for Material Group for Tax like material
• WWGPA Table Data element for Material group material
• WISP_REFWG Table Data element for Indicator: Reference for Ref. Material in Material Group
• MCAT_ART Table Data element for Transfer material group material indiciator

Material group gl account related terms

Definitions.

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

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

Popular Table Searches

Latest table searches.