Hierarchy Table in SAP

• 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_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

• CRMC_PRCATCNDREL
  Table for Linking of Category Hierarchy / Pricing-Relevant Hierarchy
  Table Type : TRANSP
  Package : CRM_PRCAT_CONDITIONS
  Module : CRM-MD-PRO-CAT
• 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
• 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
• 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
• 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
• A064
  Table for Customer Hierarchy
  Table Type : TRANSP
  Package : VKON
  Module : AP-PRC-PR
• A065
  Table for Customer Hierarchy/Material
  Table Type : TRANSP
  Package : VKON
  Module : AP-PRC-PR
• A107
  Table for Vendor Hierarchy
  Table Type : TRANSP
  Package : VKON
  Module : AP-PRC-PR
• A108
  Table for Vendor Hierarchy / Material
  Table Type : TRANSP
  Package : VKON
  Module : AP-PRC-PR
• A109
  Table for Vendor hierarchy: vendor sub-range
  Table Type : TRANSP
  Package : VKON
  Module : AP-PRC-PR
• A146
  Table for Customer Hierarchy
  Table Type : TRANSP
  Package : VF
  Module : AP-PRC-PR
• A147
  Table for Customer Hierarchy (Sales Deal)
  Table Type : TRANSP
  Package : VF
  Module : AP-PRC-PR
• A148
  Table for Product Hierarchy
  Table Type : TRANSP
  Package : VF
  Module : AP-PRC-PR
• ACCONTEXTHIERDIR
  Table for Alert configuration: system context hierarchy table
  Table Type : TRANSP
  Package : AI_SOLMAN_ALRT_CFG_DIRECTORY
  Module : SV-SMG-MON-ALR-DIR

• ACEVENTHIERDIR
  Table for Alert configuration: event hierarchy directory
  Table Type : TRANSP
  Package : AI_SOLMAN_ALRT_CFG_DIRECTORY
  Module : SV-SMG-MON-ALR-DIR
• ACEVENTHIERREP
  Table for Alert configuration: event hierarchy repository
  Table Type : TRANSP
  Package : AI_SOLMAN_ALRT_CFG_REPOSITORY
  Module : SV-SMG-MON-ALR-CFG
• ACPRODUCTHIERREP
  Table for Alert configuration: product hierarchy repository
  Table Type : TRANSP
  Package : AI_SOLMAN_ALRT_CFG_REPOSITORY
  Module : SV-SMG-MON-ALR-CFG
• AEHI
  Table for Change hierarchy
  Table Type : TRANSP
  Package : CC
  Module : CA-GTF-ECM
• AFWCH_PHDEFALT
  Table for Alternative Portfolio Hierarchy Definition
  Table Type : TRANSP
  Package : CFM_AFWCH
  Module : FIN-FSCM-TRM-AN
• AFWKFRA_KD0
  Table for Key Figures: Positions in Risk Hierarchy
  Table Type : TRANSP
  Package : CFM_AFWKFRA
  Module : FIN-FSCM-TRM-MR
• AFWKFRA_KD0_H
  Table for Key Figures: Items in the Risk Hierarchy
  Table Type : TRANSP
  Package : CFM_AFWKFRA
  Module : FIN-FSCM-TRM-MR
• AFX_TREEDEF
  Table for Hierarchy Tree Definition
  Table Type : TRANSP
  Package : AFX_GENERATOR
  Module : CA-GTF-TS-GMA
• AFX_TREEDEFT
  Table for Hierarchy Tree Definition: Texts
  Table Type : TRANSP
  Package : AFX_GENERATOR
  Module : CA-GTF-TS-GMA
• AGS_EJR_OBJ_HIER
  Table for Object Hierarchy
  Table Type : TRANSP
  Package : AGS_EXTJOB_TEMPLATE
  Module : SV-SMG-PSM
• ALXMBINHERITKEY
  Table for Inheritance Hierarchy for XI Monitor Nodes
  Table Type : TRANSP
  Package : SMOI_XMB
  Module : BC-CCM-MON
• AMRH
  Table for Application Monitor: Hierarchy acc. to TCODE/REPORT
  Table Type : TRANSP
  Package : STUN
  Module : BC-CCM-MON-TUN
• AMYOTREE
  Table for MyObjects Together with Hierarchy
  Table Type : TRANSP
  Package : AMYO
  Module : BC-SRV-GBT
• APTREE
  Table for Application Hierarchy
  Table Type : TRANSP
  Package : SEU
  Module : BC-DWB-UTL-BRR
• APTREET
  Table for Application Hierarchy: Texts
  Table Type : TRANSP
  Package : SEU
  Module : BC-DWB-UTL-BRR
• B221
  Table for Hierarchy Change Type
  Table Type : TRANSP
  Package : JAS
  Module : IS-M
• BBPC_HIER_CTRL
  Table for Control of Hierarchy Display
  Table Type : TRANSP
  Package : BBP_PRODOC_C
  Module : SRM-EBP
• BBPD_PCH_IDX
  Table for Database Table with Hierarchy Index
  Table Type : TRANSP
  Package : BBP_PRODUCT
  Module : CRM-MD-PRO
• BBP_CCM_SEL_HIER
  Table for Selected Hierarchy (Single Line)
  Table Type : TRANSP
  Package : BBP_CT
  Module : SRM-EBP-CMT
• BBP_PDHIER
  Table for Contract Hierarchy Information
  Table Type : TRANSP
  Package : BBP_PRODOC
  Module : SRM-EBP
• BKK40_ENQ_HY
  Table for Dummy Block Table for Accounts for Hierarchy Creation
  Table Type : TRANSP
  Package : FKBK
  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
• BKK620
  Table for Account Hierarchy: Amount Definitions for Cash Concentration
  Table Type : TRANSP
  Package : FKBR
  Module : IS-B-BCA-MD
• BPHI
  Table for Cross-hierarchy Data Controlling obj.
  Table Type : TRANSP
  Package : KABP
  Module : CA-GTF-BS
• BUT_HIER_BW
  Table for SAP BP: Hierarchy Extraction
  Table Type : TRANSP
  Package : BUPA_HIERARCHY_BW
  Module : AP-MD-BP
• BUT_HIER_NODE
  Table for Business Partner Hierarchy Group
  Table Type : TRANSP
  Package : BUPA_HIERARCHY
  Module : AP-MD-BP-GRH
• BKK_HYTYPE
  Table Data element for Account Hierarchy: Hierarchy Type
• BU_HIERARCHY_TYPE_GUID
  Table Data element for GUID for Hierarchy Category of BP Group Hierarchy
• BU_HIERARCHY_TYPE
  Table Data element for Hierarchy Category of BP Group Hierarchy
• HITYP_LH
  Table Data element for Hierarchy category: vendor hierarchy
• IDCN_ALGUSE_TOPACCFLAG
  Table Data element for Account Hierarchy Attribute: Use Top Hierarchy in Groups
• HIETYP
  Table Data element for IS-M: BP Hierarchy Hierarchy Type
• PFO_SEG_LVL
  Table Data element for Hierarchy Level of a Segment in a Hierarchy
• RRXHRYACTIVE
  Table Data element for Flag: Entered hierarchy is active display hierarchy
• BKK_LT_60T
  Table Data element for Account Hierarchy: Long Text for Hierarchy Types
• DHITYP
  Table Data element for IS-M: Hierarchy Type of BP Hierarchy
• HIERDATUM
  Table Data element for Hierarchy Date as Start of Validity of Hierarchy Version
• RSTHEQNODE
  Table Data element for Hierarchy (name) is also hierarchy node (Drilldown)

Hierarchy 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.