sap customer account assignment table

Customer master account group Table in SAP

• /DSD/RP_DRVKTOKD Table for Define Account Group as Account Group for Driver Table Type : TRANSP Package : /DSD/RP Module : LE-DSD-RP
• TZB43 Table for Account Clearing: Checks at Customer Account Level Table Type : TRANSP Package : FVVD_PAYMENT Module : FS-CML-AC-RPM
• 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
• 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
• PSO48 Table for Customer Assignment of BUSAB to Customer Master Record Table Type : TRANSP Package : FMKW Module : PSM-FM-PO
• 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
• 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
• 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
• TIVSCTRANSACC Table for Assignment of Clearing Account to Cost Account Table Type : TRANSP Package : RE_SC_BC Module : RE-FX-SC
• 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
• WRFT_PREPAY_ACCT Table for Account Determination: Prepayment Clearing Account Table Type : TRANSP Package : WRF_INVOICEVERIFICATION_PREPAY Module : MM-IV-LIV
• BPREP_DIM_ASS_C Table for Assign Account Assignments - Customer-Specific Assignments Table Type : TRANSP Package : BPREP_BWRET Module : PSM-FM
• CACSSE_ACS01 Table for Stt.Type Account Assignments for Customer Settlement System Table Type : TRANSP Package : CACSS0 Module : ICM
• CNV_20800_T077D Table for CNV table that states which customer account groups match Table Type : TRANSP Package : CNV_20800 Module : CA-GTF-BS
• CRMC_T077D Table for Customer account groups Table Type : TRANSP Package : CRM_BUPA_FRG0040 Module : CRM-MD-BP
• CNV_KTOKD_SPEC Table Data element for New customer account group for 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
• WSVD_ACCNT_GRP_CRT Table Data element for SAP Retail Store: Account Group for Parking Vendor Master
• DEBITED_ACCT Table Data element for Account to be Debited: G/L Account/Customer/Vendor
• XKART_KK Table Data element for Account is managed as a customer or vendor account
• 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
• KTOKD Table Data element for Customer Account Group
• CNV_20900_KTOKD_MM Table Data element for Default value for customer account group

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

Popular Table Searches

Latest table searches.

Defining Default Account Assignments

After completing this lesson, you will be able to:

• Introduce posting controls
• Describe the account assignment settings
• Create a default account assignment
• Analyze the impact of the assignment during journal entry

Posting Controls

Meet Chris, an experienced management accounting employee at Bike Company SE. He's skilled at using SAP S/4HANA, having extensive knowledge of his department's processes and a comprehensive understanding of the company's operations. Apart from maintaining crucial applications that streamline work for others, Chris also acts as an administrator and business process configuration expert. He is the contact person for establishing and managing Overhead Cost Accounting processes within the company.

Chris loves discovering and utilizing new features and helping other users. Recently, Sarah, a colleague from the financial accounting department, sought his expertise for support and assistance. This is what they talked about:

Let’s now take a closer look at the tools that help streamline accounting data.

You'll learn how to define default values for cost assignment. In the next lessons, you will also delve into more sophisticated features like validation and substitution rules that can identify inconsistencies in account assignment objects and ensure precise postings.

We'll start with an in-depth exploration of the default account assignment.

Default Account Assignment

Application area.

The default account assignment is a tool that automatically proposes specific cost assignment objects, such as cost centers or profit centers during journal entry. You can determine which management accounting object is defaulted for each line item based on the combination of primary cost and revenue G/L account and company code.

As an example, consider recurring utility expenses, which should be charged to the Utilities cost center. For this purpose, a default account assignment can be established as shown in the figure below.

First, the cost element for Utilities for the relevant Company Code is connected to the respective cost center in the default account assignment configuration.

Now whenever you enter a utility expense in Financial Accounting, the system automatically proposes the Utilities cost center. You still have the option to manually overwrite the cost center if necessary.

This leads to a more efficient accounting workflow, as the account assignment object is entered automatically during the posting process, minimizing the need for manual input.

Default account assignments are especially useful when line items are automatically posted, such as when posting exchange rate differences and discounts in Financial Accounting, or price differences in Material Management.

In addition to cost centers, you can also indicate profit centers or profitability segments for allocating costs and revenues to.

In summary, the default account assignment establishes a default value for the controlling objects when posting costs or revenues, ensuring that these are automatically charged to the right entities.

Configuration

To configure a default account assignment, you perform the following steps:

• For each cost assignment, enter the company code and the cost element that should be included in the account assignment.
• Enter the corresponding account assignment object (cost center or profit center). If you want the system to determine a profitability segment instead, you can use the PrfSeg checkbox. This is used when transferring data, such as price differences, to Margin Analysis.
• You have the option to specify detailed account assignments, which can be differentiated by valuation area or profit center. To do this, enter the following values in the "Acct assignmt detail" column: 1 for valuation area or 3 for profit center. Then select the corresponding entry in the Dialog structure on the left and enter the relevant cost assignment.

Define a Default Account Assignment

Overall benefits.

The default account assignment feature suggests default values for specific accounts, improving the accuracy of financial data and streamlining the process through automatic assignment. This reduces the likelihood of errors in manual data entry and saves a considerable amount of time that would otherwise be spent repeatedly assigning these costs.

Log in to track your progress & complete quizzes