Customer hierarchy and customer account Table in SAP

• IDCN_ALGACCHIER
  Table for Account Level Hierarchy: Account Level Hierarchy (Top Level)
  Table Type : TRANSP
  Package : ID-FI-CN
  Module : FI-LOC
• IDCN_ALG_ASSIGN
  Table for Account Level Hierarchy: Assign Hierarchy to CC and CoA
  Table Type : TRANSP
  Package : ID-FI-CN
  Module : FI-LOC
• CRMC_BPH_CHM_CAT
  Table for Hierarchy Category for the Partner Account Hierarchy
  Table Type : TRANSP
  Package : CRM_CHMIL_HIERARCHY
  Module : CRM-MD-BP-MDF-CPH

• TBKK60
  Table for Account Hierarchy: Hierarchy Types
  Table Type : TRANSP
  Package : FKBR
  Module : IS-B-BCA-MD
• TBKK60T
  Table for Account Hierarchy: Hierarchy Type Texts
  Table Type : TRANSP
  Package : FKBR
  Module : IS-B-BCA-MD
• 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
• 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
• SMOTHIZU
  Table for Customer Hierarchy: Allowed Account Group Assignments
  Table Type : TRANSP
  Package : SMO3
  Module : CRM-MSA
• THIZU
  Table for Customer Hierarchy: Allowed Account Group Assignments
  Table Type : POOL
  Package : VSH
  Module : CRM-BTX-BF-IF
• TZB43
  Table for Account Clearing: Checks at Customer Account Level
  Table Type : TRANSP
  Package : FVVD_PAYMENT
  Module : FS-CML-AC-RPM

• TICL832
  Table for Entity Table: G/L Account (Chart of Accts and Coll.Account)
  Table Type : TRANSP
  Package : ICL_LAE
  Module : FS-CM
• BUT_HIER_STRUCT
  Table for Business Partner Hierarchy Group - Hierarchy Relationship
  Table Type : TRANSP
  Package : BUPA_HIERARCHY
  Module : AP-MD-BP-GRH
• CDBC_PRCATCNDREL
  Table for Linking of Category Hierarchy / Pricing-Relevant Hierarchy
  Table Type : TRANSP
  Package : CDB
  Module : CRM-MSA
• CRMC_PRCATCNDREL
  Table for Linking of Category Hierarchy / Pricing-Relevant Hierarchy
  Table Type : TRANSP
  Package : CRM_PRCAT_CONDITIONS
  Module : CRM-MD-PRO-CAT
• RSDMTP_BAT_HRHDR
  Table for BW Hierarchy Creation - Hierarchy Header Details
  Table Type : TRANSP
  Package : RS_DME_DMP
  Module : BW-EI-DM
• SMOTBH01T
  Table for BP Group Hierarchy Customizing: Hierarchy Categories, Texts
  Table Type : TRANSP
  Package : CDB
  Module : CRM-MSA
• TBH01_T
  Table for BP Group Hierarchy Customizing: Hierarchy Categories, Texts
  Table Type : TRANSP
  Package : BUPA_HIERARCHY
  Module : AP-MD-BP-GRH
• TJJ69
  Table for IS-M/AM: Hierarchy Type for BP Hierarchy
  Table Type : TRANSP
  Package : JAS
  Module : IS-M
• TKKRA
  Table for Hierarchy Summarization (Hierarchy Types)
  Table Type : TRANSP
  Package : KKR
  Module : CRM
• TKKRB
  Table for Hierarchy Summarization (Hierarchy Type Texts)
  Table Type : TRANSP
  Package : KKR
  Module : CRM
• /ISDFPS/CMLILEV
  Table for Customizing: Hierarchy Level for Hierarchy Explosion
  Table Type : TRANSP
  Package : /ISDFPS/FDP
  Module : IS-DFS-OF-FDP
• 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

• BKK620
  Table for Account Hierarchy: Amount Definitions for Cash Concentration
  Table Type : TRANSP
  Package : FKBR
  Module : IS-B-BCA-MD
• CRMC_BPH_OBJTYPE
  Table for Object types in the account hierarchy
  Table Type : TRANSP
  Package : CRM_BUPA_HIERARCHY_IL
  Module : CRM-MD-BP-GRH
• CRMC_FM_LR_LEVEL
  Table for LR Planning Interval Levels for Product & Account Hierarchy
  Table Type : TRANSP
  Package : CRM_FM_LR_CUST
  Module : CRM-FM-LR
• CRMC_FS_AH_CUST
  Table for Account Hierarchy Customizing
  Table Type : TRANSP
  Package : CRM_BUPA_HIER_E
  Module : CRM-MD-BAH
• CRMC_FS_AH_ENABL
  Table for To allow user to enable/disable biling account hierarchy
  Table Type : TRANSP
  Package : CRM_BUPA_HIER_E
  Module : CRM-MD-BAH
• CRMC_FS_AH_ROLE
  Table for Account Hierarchy: Role Customizing
  Table Type : TRANSP
  Package : CRM_BUPA_HIER_E
  Module : CRM-MD-BAH
• CRMM_BPH_NODEOBJ
  Table for Objects assigned to the account hierarchy
  Table Type : TRANSP
  Package : CRM_BUPA_HIERARCHY_IL
  Module : CRM-MD-BP-GRH
• CRMM_FS_ACC_HIER
  Table for Finanical Service: Account Hierarchy
  Table Type : TRANSP
  Package : CRM_BUPA_HIER_E
  Module : CRM-MD-BAH
• CRMM_FS_AH_SP
  Table for Account Hierarchy: Service Profile
  Table Type : TRANSP
  Package : CRM_BUPA_HIER_E
  Module : CRM-MD-BAH
• IDCN_ALGACCLIST
  Table for Account Level Hierarchy: Assigned Child G/L Accounts
  Table Type : TRANSP
  Package : ID-FI-CN
  Module : FI-LOC
• SETHANAHIER0109
  Table for Hierarchy table for Account Groups
  Table Type : TRANSP
  Package : GBSE_HANA
  Module : FI-SL-SL-MD-SE
• TLHIZU
  Table for Vendor hierarchy: allowed account groups
  Table Type : TRANSP
  Package : WLIF
  Module : CRM
• ACCRAC
  Table for Assignment of Acr./Def. G/L Account to Accruals Account
  Table Type : TRANSP
  Package : ACCR
  Module : FI
• 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
• CRMC_ACC_MAP
  Table for Assignment of Account Assignment Group to Account
  Table Type : TRANSP
  Package : CRM_LEASING_SRM
  Module : CRM-LAM-BTX
• 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_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
• RSTHMODE
  Table Data element for BRST Hierarchy mode (comp., target and optional hierarchy)
• BKK_HYTYPE
  Table Data element for Account Hierarchy: Hierarchy Type
• IDCN_ALGUSE_TOPACCFLAG
  Table Data element for Account Hierarchy Attribute: Use Top Hierarchy in Groups
• BKK_LT_60T
  Table Data element for Account Hierarchy: Long Text for Hierarchy Types
• IDCN_ALGADD_RANGEFLAG
  Table Data element for Account Hierarchy Attribute: Add Empty Account Ranges
• SMO3HKTOK
  Table Data element for Account group for higher-level customer hierarchy
• HKTOKD
  Table Data element for Account group for higher-level customer hierarchy
• HKUNNR_KH
  Table Data element for Customer number of the higher-level customer hierarchy
• J_1BACCTYPE
  Table Data element for Account Type for Customer and Vendor
• 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
• KTOCD
  Table Data element for Reference Account Group for One-Time Account (Customer)

Customer hierarchy and customer 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.