group account assignment

TutorialKart
SAP Tutorials
Salesforce Admin
Salesforce Developer
Visualforce
Informatica
Kafka Tutorial
Spark Tutorial
Tomcat Tutorial
Python Tkinter

Programming

Bash Script
Julia Tutorial
CouchDB Tutorial
MongoDB Tutorial
PostgreSQL Tutorial
Android Compose
Flutter Tutorial
Kotlin Android

Web & Server

Selenium Java
SAP FICO Training
SAP FICO Tutorials
SAP FICO - Introduction
SAP Financial Accounting
What is SAP FICO
What is client in SAP
SAP FICO - Enterprise Structure
Define Company in SAP
Define Company Code in SAP
Assign company code to company in SAP
Define business area and consolidation business area in SAP
Assign business area to consolidated business area in SAP
Define credit control area in SAP
Assign company code to credit control area in SAP
Define functional area in SAP
Maintain Financial Management Area in SAP
Assign financial management area to company code in SAP
How to create segments in SAP
SAP FICO - Global Parameters
What is Chart of accounts and how to create COA in SAP?
Assign company code to chart of accounts
What is Fiscal year in SAP?
How to maintain fiscal year variant
Assign company code to fiscal year variant
Define account group in SAP
Define retained earnings account
Define posting period variant (PPV)
Assign variants to company code in SAP
Open and closing posting period variants
Define field status variant and field status groups in FICO
Assign company code to field status variant
Define Tolerance group for G/L accounts
Define Tolerance group for employees
Check company code global parameters
SAP FICO - Foreign Currency Transactions
Check exchange rate types
Define translation ratios for currency translation
How to maintain exchange rates in SAP
Define accounts for exchange rate differences
Define foreign currency valuation methods
Define accounting principles and assign to ledger group
Define valuation areas and assign to accounting principles
SAP FICO - New G/L Accounting
How to activate new G/L accounting?
Define ledgers for general ledger accounting
Define currencies for leading currency
Define & Activate Non-Leading Ledgers
Define Zero-balance clearing account
Define interest calculation types
Define interest indicator
SAP FICO - Accounts Receivable
Define account group for customers
Maintain number ranges for customer account groups
Assign number ranges to customer account groups
Define risk categories
Define tolerance group for Customers
Create sundry debtors accounts
ADVERTISEMENT
Define Customer Master Record
SAP FICO - Accounts Payable
What is Accounts Payable in SAP?
Define vendor account groups
Maintain number range intervals for vendor accounts
Assign number ranges to vendor account groups
Create payment terms
Define accounts for cash discount taken
Define Vendor reconciliation account
Create vendor code
SAP FICO - Tax on Sales and Purchases
What is Sales tax and Purchase tax in SAP?
Define tax calculation procedures
Assign country to calculation procedure
Assign tax codes for non taxable transactions
Maintain tax codes for sales and purchases
Define tax accounts in SAP
SAP FICO - Bank Accounting
What is Bank Accounting in SAP?
Define bank key
Define house bank in SAP
Create check lots
Automatic payment program
SAP FICO - Asset Accounting
What is Asset Accounting in SAP?
Define Chart of Depreciation
Assign chart of depreciation to company code
Specify Account Determination
Number range intervals for Assets
Maintain Asset Classes
SAP Controlling Training
SAP CO Tutorials
SAP FI TCodes
❯ SAP FICO Tutorials
❯ Assign number ranges to customer account groups

Assign Number Ranges to Customer Account Groups in SAP

How to assign number ranges to customer account groups.

In this SAP tutorials, you will learn how to assign number ranges to customer account groups step by step by using transaction code OBAR. In our previous training tutorial, we have learned how to create customer account groups in SAP .

Configuration steps

You can assign number range intervals to customer account groups by using one of the following navigation method.

Transaction code: – OBAR
Menu Path: – SPRO > Financial Accounting (New) -> Accounts Receivable and Accounts Payable –> Customer Accounts —> Master Data —-> Preparations for creating customer master data —–> Assign number ranges to customer account groups.

Assignment Procedure

Step 1) Enter T-Code “OBAR” in the SAP command field and press enter.

Step 2) On change view “Assign Customer Acct Groups –> Number Range overview screen, click on position button and enter customer account group key in the given field. So the customer account group key displays on top of the screen.

Step 3) Now update the customer account group number range interval “TK” in the field number range as shown below.

Assign Number Ranges to Customer Account Groups in SAP

Click on save button to save the details.

Step 4) Now you are prompted for customizing request number, choose the request and save the assigned details.

Successfully we have assigned number ranges to customer account groups in SAP .

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?

ETCircle.com SAP FI and CO consultant information

Materials: account assignment groups | ovk5.

In this configuration activity we are able to define account assignment groups for materials used in Sales and Distribution Module ( SD ).

Transaction: OVK5

IMG Path: Sales and Distribution -> Basic Functions -> Account Assignment/Costing -> Revenue Account Determination -> Check Master Data Relevant For Account Assignment

Tables: TVKM, TVKMT

If you use the IMG Menu, you will have to choose the first option on the pre-selection screen.

On the main screen there is a list of Account Assignment Groups for Materials. You can create new here if you need.

Tags Account Assignment OVK5 TVKM TVKMT

About Emiliyan Tanev

Related articles, assign g/l accounts | vkoa, customers: account assignment groups | ovk8, define automatic credit control | ova8, configure automatic postings | omwb.

In this FICO configuration activity we are able to define account determination for automatic postings …

Customer master 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
PSO48 Table for Customer Assignment of BUSAB to Customer Master Record Table Type : TRANSP Package : FMKW Module : PSM-FM-PO
TZB43 Table for Account Clearing: Checks at Customer Account Level Table Type : TRANSP Package : FVVD_PAYMENT Module : FS-CML-AC-RPM
BKK46 Table for Current Account Master Data: Customer Appends Table Type : TRANSP Package : FKBK Module : IS-B-BCA-MD
CNV_20200_KNB1 Table for Differences in customer account master data Table Type : TRANSP Package : CNV_20200_CHECK Module : CA-EUR
MDG_BS_ECC_CUSNR Table for Number Range per Target System and Customer Account Group Table Type : TRANSP Package : MDG_BS_ECC_CUSTOMER_DEBMAS Module : CA-MDG-APP-CUS
SMOTHIZU Table for Customer Hierarchy: Allowed Account Group Assignments Table Type : TRANSP Package : SMO3 Module : CRM-MSA
TFK077D Table for FI-CA: SD/FI-CA Customer Account Group Enhancement Table Type : TRANSP Package : FKKI Module : FI-CA-IN
THIZU Table for Customer Hierarchy: Allowed Account Group Assignments Table Type : POOL Package : VSH Module : CRM-BTX-BF-IF
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
TVKGG Table for Customer Condition Groups (Customer Master) Table Type : TRANSP Package : VS Module : CRM-BF
TVKGGT Table for Texts for Customer Condition Groups (Customer Master) Table Type : TRANSP Package : VS Module : CRM-BF
FAGLFLEX04 Table for General ledger: Customer additional account assignment Table Type : TRANSP Package : FAGL_DB_PERSISTENCY Module : FI-GL
FMGLFLEX04 Table for General ledger: Customer additional account assignment Table Type : TRANSP Package : FMGL Module : PSM-FA
GLFLEX04 Table for General ledger: Customer additional account assignment Table Type : TRANSP Package : GLT0 Module : FI-GL
JVGLFLEX04 Table for General ledger: Customer additional account assignment Table Type : TRANSP Package : GJVA_FAGL Module : CA-JVA
TJL20 Table for IS-M/SD: Texts for Customer Account Assignment Groups for SC Table Type : TRANSP Package : JSD Module : IS-M
ACCRFI Table for Accruals/Deferrals Master Data FI/CO Account Assignment Table Type : TRANSP Package : ACCR Module : FI
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
CRMC_IU_FLDMAP Table for Assignment of Master Data Parameters to Customer Enhancemnts Table Type : TRANSP Package : CRM_IU_IC_6X_SI_CUST Module : CRM-IU-IC
CRMC_IU_FLDMAPT Table for Assignment of Master Data Parameters to Customer Enhancemnts Table Type : TRANSP Package : CRM_IU_IC_6X_SI_API Module : CRM-IU-IC
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
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
CNV_KTOKD_SPEC Table Data element for New customer account group for customer
KTGRD Table Data element for Account assignment group for this customer
SMO3KTGRD Table Data element for Account assignment group for this customer
KTOCD Table Data element for Reference Account Group for One-Time Account (Customer)
KTOKL_077T Table Data element for Account group (customer, vendor, G/L account)
/BEV1/CLKUNNRK Table Data element for Customer's Customer Number at Customer's End
PTRV_TRVCT_R_04 Table Data element for Date for reading master account assignment
PTRV_TRVCT_R_13 Table Data element for Messages during master account assignment check
/SPE/CUST_ACC Table Data element for Indicator: Customer Specific Account Assignment
EHSWAE_CHKCOOBJ Table Data element for Object Checked as Account Assignment Object for Assignment

Customer master 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.