account assignment group description in sap

What is SAP SD?
SAP SD Training Tutorials for Beginners
SAP SD T-codes
SAP SD User Exit for Billing Document
SAP SD User Exits for Sales Order
SAP Customer Down Payment Configuration
SAP PGI (Post Goods Issue)
SAP IS-Retail Module
SAP Incoterms
SAP SD Variant Configuration Steps
SAP SD Configuration Step by Step Guide
SAP SD Credit Management Interview Questions
Account Assignment Group In SAP
Subcontracting Process In SAP SD
Rebate Processing In SAP SD
Difference Between Rebate And Discount
Movement Type In SAP
SAP SD Availability Check Configuration
Debit And Credit Note in SAP
Sales Documents List
Intercompany vs Intracompany
SAP SD Pricing Routines & User Exit
Shipping Condition In Sales Order
SAP SD Invoice Table
SAP SD Certification & Course Fees
SAP SD Interview Questions

Define Account Assignment Group

Updated May 18, 2018

Field found in Material Master Sales Organization 2. To define the General Ledger Posting:- IMG -> Sales and Distribution -> Account Assignment/Costing -> Revenue Account Determination -> Assign G/L Accounts With this link, the material that used this account assignment group will be posted with the desired G/L accounts during Billing. User will not be able to Release the billing document to Accounting if this is not setup. If you happened to assign it via Cust.Grp/MaterialGrp/AcctKey, then you can let your user use this report to check the material assignment. * Transaction code VKOA REPORT ZMATNR_AC_ASSIGN LINE-SIZE 132 NO STANDARD PAGE HEADING LINE-COUNT 044(001).

05 Apr 2010 6:12 am Manzoor Ahmad Its very good and helpful for SD Trainee.
08 Oct 2010 8:24 am Guest very nice.....

Defining General Ledger (G/L) Accounts and Cost Elements

After completing this lesson, you will be able to:

Define a G/L account

Chart of Account

account assignment group description in sap

Each G/L is set up according to a chart of accounts. The chart of accounts contains the definitions of all G/L accounts. The definitions consist of the account number, the account name, and the type of G/L account (e.g. balance sheet, non operating expenses/revenues, primary costs/revenues, secondary costs or cash accounts).

Assignment of Company Codes to Chart of Accounts

A chart of accounts can be used by multiple company codes so that the general ledgers of these company codes have an identical structure.

General Ledger Account and Cost Element

The two segments of the G/L master record from a Financial Accounting perspective are as follows:

The chart of accounts segment contains a description of the account, the account type that classifies how the account can be used in FI and/or CO and, the account group that controls the company code segment fields, and the consolidation account number.

The company code segment contains values specific to how the company code will manage that account.

Account Groups

Accounts with the same account group normally have similar business functions. You can, for example, have an account group for:

Cash accounts

Expense accounts

Revenue accounts

Other balance sheet accounts

The account groups are assigned number ranges. You can control which account numbers are permissible for cash accounts, expense accounts, and so on, through the number ranges.

Account groups also control the appearance of the company code segment of G/L accounts. Account groups control:

The fields that are required for data entry

The fields that are optional for data entry

The fields that are display only.

The fields that do not show up at all in the company code segment

Reconciliation Accounts

Expenditures versus costs.

In the economical theory, there are two approaches for values:

In the first approach, the values in Financial Accounting and Management Accounting are the same:

Controlling provides additional reporting opportunities by separating the FI documents along additional characteristics, such as segments, profit centers, projects, stored in a coding block. The results may be P&L statements and balance sheets per segment, per profit center or per project.

In the second approach (most used in central Europe), Management Accounting is based on cost and revenues. Costs are only those expenditures, which are as follows:

Related to the business of the company

Exactly assigned to periods (source specific)

For example, a gift to a welfare organization is an expenditure, but not a cost, because it is not the business of the company to make gifts.

Expenditures, which do not meet the definition of costs, are only reflected in Financials, and not in Management Accounting. They are called neutral expenditures.

SAP provides the opportunity to realize each of the theories. In SAP S/4HANA revenues, expenditures, and cost are represented by financial accounts and separated by the Account Type of the accounts. Based on the account type, the accounts used in CO are also called cost elements.

Account Types

The controlling area-specific data is only needed for Secondary Costs and Primary Costs or Revenue accounts. In the controlling area-specific data, you assign a Cost Element category. This category determines which account can be used for which business transaction in CO.

Create a Primary Cost Account

Blog about all things SAP

ERProof » SAP FI » SAP FI Training » SAP Account Group of G/L Accounts

SAP Account Group of G/L Accounts

SAP account groups are used to maintain intervals, segregate G/L accounts groups, and define field statuses. SAP account group has a four-digit alphanumeric code and serves for organization of G/L account master data based on specifications on how G/L account master data to be defined.

SAP account group controls G/L account intervals and screen layouts while defining or extending G/L account master data at the company code level. SAP account group helps users to define required fields while creating the G/L account master data. For example, the fields for entering a reconciliation account and open item management indicator are not required for Profit and Loss accounts .

As per the requirement of the company, SAP account groups can be created and are defined at the chart of accounts level as explained below.

How to Create SAP Account Group?

In order to create a new SAP account group or modify the existing one, it is necessary to navigate to the following path in SPRO transaction:

Financial Accounting (New) – General Ledger Accounting (New) – Master Data – G/L Accounts- Preparations – Define Account Group.

Or directly start the transaction OBD4 (define SAP account group) using the transaction bar.

Relevant table: T077S (G/L account groups).

In the above screenshot 1234 is the chart of accounts and Asst , BS , PL , MAT and GL are SAP account groups. Here are detailed explanations of meaning of each column in this transaction:

Chart of accounts : G/L accounts are defined at the chart of accounts level.

Account group : A four-digit identification to group certain G/L accounts.

Name : Name to the account group.

From account : Starting number in the range of accounts belonging to a particular account group.

To account : Ending number in the range of accounts belonging to a particular account group.

By double clicking on each group we can define whether the fields will be suppress, required, optional or display.

Suppress : Field is not visible while creating the G/L master record.

Required : Field is mandatory while creating the G/L master record.

Optional : Field is available for entry but not mandatory to update.

Display : Field available only in display mode.

Let’s discuss each group of fields one by one.

1. Account control

Available fields in account control group. This group contains fields of company code level G/L account creation.

Currency : G/L account currency, by default it is company code currency, it can be change also.

Tax category : To maintain tax category for the G/L account, so that tax-related postings are possible while booking transactions.

Reconciliation account : G/L account which be maintained in the master data of Vendor, Customer and Asset accounts.

Exchange rate difference : Key for account determination to perform foreign currency valuation.

Account managed in ext. system : If the same account is used in another application, then this field status will be defined.

Only balance in local currency : To update only in local currency.

Alternative account number : To update country chart of accounts G/L master record.

Inflation key : Only useful when inflation accounting is used in financial accounting .

Tolerance group : Useful to maintain if any difference raised while clearing of open items.

2. Account Management

Available fields in account management. This group contains fields of company code level G/L account creation.

Line item management : To activate line item display.

Open item management : To activate line items as open items to perform clearing.

Sort key : Sorting the data while execution of reports.

Authorization group : To control through authorization object.

Administrator : It is called accounting clerk.

3. Document entry

Available fields in document entry. This group contains fields of company code level G/L account creation.

Reconciliation account ready for input : To enable the alternative reconciliation change functionality.

Field status group : To maintain which fields are required while booking transactions.

Post automatically only : To restrict manual postings.

Supplement automatic postings : To activate bank charges while posting incoming payments.

4. Bank/financial details

Available fields in Bank/financial details. This group contains fields of company code level G/L account creation.

Planning level : To control display in cash management.

Commitment item : To be used for budgeting.

Relevant to cash flow : To define as a cash flow account.

House bank : Default house bank.

Bank account : Default bank account.

5. Interest calculation

Available fields in Interest calculation. This group contains fields of company code level G/L account creation.

Interest calculation : To activate or specify account for interest calculation.

6. Joint venture

Available fields in Joint venture. This group contains fields of company code level G/L account creation.

Recovery indicator : To allow booking of incurred costs.

7. Multi currency accounting

Available fields in Multi currency accounting. This group contains fields of company code level G/L account creation.

Multi Currency Accounting Group of Fields

Multi currency accounting : To activate multi-currency accounting.

Did you like this tutorial? Have any questions or comments? We would love to hear your feedback in the comments section below. It’d be a big help for us, and hopefully it’s something we can address for you in improvement of our free SAP FI tutorials.

Navigation Links

Go to next lesson: SAP Field Status Variant

Go to previous lesson: SAP Balance Sheet and P&L Statement Accounts

Go to overview of the course: Free SAP FI Training

2 thoughts on “SAP Account Group of G/L Accounts”

THIS IS AN OUTSTANDING ARTICLE. THANKING THE AUTHOR AND THE ENTIRE SUPPORT TEAM.

Why are the number ranges for account group allowed to overlap?

2065095 - How to Create a Primary Account Assignment For Account Assignment Types

How to Create a Primary Account Assignment for Account Assignment Types.

Environment

SAP Business ByDesign

account assignment type; primary account assignment; cost object type , KBA , AP-ACC , Business ByDesign: Financial Accounting , 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

Account assignment group Table in SAP

CRMC_ACC_MAP Table for Assignment of Account Assignment Group to Account Table Type : TRANSP Package : CRM_LEASING_SRM Module : CRM-LAM-BTX
/DSD/RP_DRVKTOKD Table for Define Account Group as Account Group for Driver Table Type : TRANSP Package : /DSD/RP Module : LE-DSD-RP
TZB27 Table for Assignment of G/L account to account group Table Type : TRANSP Package : FVVD_PAYMENT Module : FS-CML-AC-RPM
ACCRAC Table for Assignment of Acr./Def. G/L Account to Accruals Account Table Type : TRANSP Package : ACCR Module : FI
BKK610 Table for Account Hierarchy: Assignment of Root Account to Tree Number Table Type : TRANSP Package : FKBR Module : IS-B-BCA-MD
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
TIVSCTRANSACC Table for Assignment of Clearing Account to Cost Account Table Type : TRANSP Package : RE_SC_BC Module : RE-FX-SC
CDBC_ACGRPBPT Table for Account Assignment Group Texts: Business Partner Table Type : TRANSP Package : CDB Module : CRM-MSA
CIFVENTYPE Table for Assignment of Vendor Account Group to APO Location Type Table Type : TRANSP Package : CIF Module : SCM-BAS
CRMC_ACGRPBP_T Table for Business Partner Account Assignment Group Table Type : TRANSP Package : CRM_ACCTGRPPROD Module : CRM-MD
FMZUGR Table for Allocation of CO Group to FM Account Assignment Table Type : TRANSP Package : FMCO_CORE Module : FI-FM
IHC_DB_CMGRP1 Table for Cash Management Group: Account Assignment Table Type : TRANSP Package : FIN_IHC Module : FIN-FSCM-IHC
IHC_DB_CMGRP2 Table for Cash Management Group: Account Assignment Table Type : TRANSP Package : FIN_IHC Module : FIN-FSCM-IHC
SMOTVKMT Table for Material: Account Assignment Group Texts Table Type : TRANSP Package : SMO3 Module : CRM-MSA
T036M2 Table for Earmarked Funds: Group Assignment If Account Missing Table Type : TRANSP Package : FF Module : CRM-MD-PCT
TJJ39 Table for IS-M/AM: Account Assignment Group for Booking Unit Table Type : TRANSP Package : JAS Module : IS-M
TJJ40 Table for IS-M/AM: Account Assignment Group for Booking Unit - Text Table Type : TRANSP Package : JAS Module : IS-M
TJJAF Table for IS-M/AM: Account Assignment Group for Sales Agent Contract Table Type : TRANSP Package : JAS Module : IS-M
TJJAG Table for Account Assignment Group for Sales Agent Contract - Text Table Type : TRANSP Package : JAS Module : IS-M
TJL19 Table for IS-M/SD: Expense Account Assignment Group for SC Table Type : TRANSP Package : JSD Module : IS-M
TPAKL Table for Assignment of Partner Function to Account Group Vendor Table Type : TRANSP Package : WLIF Module : CRM
TVKMT Table for Material: Account Assignment Group Texts Table Type : TRANSP Package : VS0CCORE Module : SD-MD-MM
BKK600 Table for Account Hierarchy: Account Relationships 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
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
TACEPSRULET Table for ACE Account Determination: Account Determination Rule Table Type : TRANSP Package : ACE-PS Module : FI-GL-GL-ACE
TACEPSSYM Table for ACE Account Determination: Account Symbol Table Type : TRANSP Package : ACE-PS Module : FI-GL-GL-ACE
TACEPSSYMT Table for ACE Account Determination: Account Symbol Table Type : TRANSP Package : ACE-PS Module : FI-GL-GL-ACE
TICL832 Table for Entity Table: G/L Account (Chart of Accts and Coll.Account) Table Type : TRANSP Package : ICL_LAE Module : FS-CM
TIVEXFIREPSYMB Table for Replacement of Account Symbol with FI Account Table Type : TRANSP Package : RE_EX_FI Module : RE-FX-RA
TJF20 Table for Convert Bank Clearing Account to Interim Account (Bank Rtns) Table Type : TRANSP Package : JSD Module : IS-M
TJL26 Table for IS-M/SD: Conversion of Clearing Account - Real G/L Account Table Type : TRANSP Package : JSD Module : IS-M
TKSKA Table for Account classification for account intervals Table Type : POOL Package : KBAS Module : CRM
TRAC_ACCSYMB Table for Account Determination: Account Symbols Table Type : TRANSP Package : FTR_ACCOUNTING_ADAPTOR Module : FIN-FSCM-TRM-TM-AC
FM_CIACC Table Data element for Assignment of FM account assignment to account is binding
KNTBU Table Data element for Account assignment category: unknown account assignment
EHSWAE_CHKCOOBJ Table Data element for Object Checked as Account Assignment Object for Assignment
FM_COACC Table Data element for Assignment of FM-CO account assignment is binding
KZKON Table Data element for Display or suppress account field/manual account assignment
SMO3KZKON Table Data element for Display or suppress account field/manual account assignment
KONAB Table Data element for Derive preliminary account assignment from G/L account
TPM_ACC_SYMBOL Table Data element for Account Symbol for Account Assignment Reference
UBC_DT_ACT Table Data element for Value of Account Assignment Field (G/L Account, Project,...)
BNKKO Table Data element for Bank account/bank clearing account (G/L account)
UBHKT Table Data element for G/L Account Number for Our Bank Account / Bank Sub-Account
KTGRD Table Data element for Account assignment group for this customer

Account assignment group 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.