SAP Master Data Tables
Are you looking for the right table related to SAP Master Data Tables to query in an ABAP Program, Class, Function Module and OData API?
There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Master Data (IS-B-BCA-MD) module.
Top 10 tables in Master Data
| Table | Description |
|---|---|
| BKK51 | Subj.Fin.Pay. Balance |
| BKK48 | Control Indicator for Account Balancing |
| BKK_REL_RELEV | Define structures for release process |
| TBKKHYCDA | Table with Clear Texts on Change Actions |
| TBCA_US_H_TYPE | Hold Types Table |
| TBKKE_FOUR_EYES | Limits: Validity of Principle of Dual Control |
| TBKKE1T | Texts for Limit Categories |
| BKK640 | Extension Fields for Comb. Flexible Balances/Hierarchies |
| TBKK_AKT2 | BDT Field Modification According to Account Status Part 2 |
| TBKK_REL_RELEV0 | Switch on applications/data for release process |
List of tables in Master Data
| Table | Description |
|---|---|
| BKK51 | Subj.Fin.Pay. Balance |
| BKK48 | Control Indicator for Account Balancing |
| BKK_REL_RELEV | Define structures for release process |
| TBKKHYCDA | Table with Clear Texts on Change Actions |
| TBCA_US_H_TYPE | Hold Types Table |
| TBKKE_FOUR_EYES | Limits: Validity of Principle of Dual Control |
| TBKKE1T | Texts for Limit Categories |
| BKK640 | Extension Fields for Comb. Flexible Balances/Hierarchies |
| TBKK_AKT2 | BDT Field Modification According to Account Status Part 2 |
| TBKK_REL_RELEV0 | Switch on applications/data for release process |
| BKKOVR_ACCNT | Item Table: Accounts with Tolerated Overdraft |
| BKK622 | Cash Concentration: Balancing Date of Last Execution |
| BKK_RELEASE | Account changes in release |
| BCA_US_HLD2REL | Hold Records which have not been released - Dual Control |
| BKK621 | Cash Concentration: Different Amount Defintions |
| BKKE1 | Current Account: Limits |
| TBKK_AKT | BDT Field Modification According to Account Status |
| BKK_EST_COND | Condition Fixing types |
| TBKK60 | Account Hierarchy: Hierarchy Types |
| BKK42ENQ | Current Account: Block Fields |
| BKK_HY_RELEASE | Track changes to hierachies in release process |
| BKK62_CC | Value Date Transaction Figures for Cash Concentration |
| BKK625 | Assign. of Int. No. to Ext. Root Acct. for Change Document |
| BKK56 | Account Resubmission |
| TBKK47 | Account Status Enhancement |
| TBKK_EST_COND | Text table for Condition Types |
| TBKKHLDAUTH | Amount Authorization/Permanent Holds |
| TBKK_REL_GROUPT | Release Rule - Description |
| BKK623 | Enhancement Fields for Cash Concentration / Hierarchies |
| TBKK_REL_GROUP | Release Rule |
| TBKKE2 | Reference Limits |
| BKK620 | Account Hierarchy: Amount Definitions for Cash Concentration |
| BKK46 | Current Account Master Data: Customer Appends |
| BKK40_ENQ_HY | Dummy Block Table for Accounts for Hierarchy Creation |
| BCA_US_HOLD | Hold Amounts Which Affect Available Balance |
| BKK633 | Enhancement Fields for Cash Pooling / Hierarchies |
| TBKK_HY_REL_CUST | Hierarchy release customizing |
| BKK_ACCL_DC_REAS | Account Closure: Rejection Reasons for Release |
| BKK9B_CC | Value Date Transaction Figures for Cash Concentration |
| BKK45_HISTORY | History Table for Table BKK45 |
| TBKK51 | Reasons for Account Resubmission |
| BKK45 | Relationship: Current Account - Business Partner |
| BKK43 | BCA: Reference Accounts |
| BKK54 | Account Balance of Hierarchies |
| BKK42_CC | BCA Account Master Data: Currency Changeover |
| BKK600 | Account Hierarchy: Account Relationships |
| BKK40 | Current Account Master Data: General |
| BKK42 | Current Account Master Data: Operative Data |
| TBKK61 | Business Transaction Events for Hierarchy Maintenance |
| BKK_4EYES_CLOS | Account Closure Principle of Dual Control |
| BKKOVR_HD | Header Table Administration Accts with Tolerated Overdraft |
| TBKK_AKT1 | BDT Field Modification According to Accouunt Status Part 1 |
| BKK_REL_CHANGES | Field changes for release entry |
| BKK50 | Account balance |
| TBKK_REL_CUST | Release Customizing |
| TBKK43 | Reference Account Category |
| BKK44 | Current Account Master Data: Locks |
| TBKK_REL_RELEV | Define relevant applications/data for release process |
| TBKK43T | Texts for Reference Account Category |
| TBKK65 | Settings for Cash Concentration |
| BKK47 | BCA: Direct Debit Orders |
| BKK_MIN_DEP | Minimum Deposit for Each Product |
| BKK55 | Subject to Final Payment Balance of Hierarchies |
| TBKKE2T | Texts for Reference Limits |
| TBKKE1 | Limit Categories |
| TBKKHYCDT | Text Table for TBKKHYCD - No. of Change Docs Hierarchies |
| BKK615 | Data for External Root Accounts Cash Concentration |
| TBKK47T | Texts for Account Status Enhancements |
| BKK_REL_RULE_LOG | Log of Matching Rules (Release Process) |
| BKK_ACCL_DC_REAT | Account Closure: Texts on Rejection Reasons |
| BKK610 | Account Hierarchy: Assignment of Root Account to Tree Number |
| TBKK51T | Texts on Account Resubmission Reasons |
| TBKK60T | Account Hierarchy: Hierarchy Type Texts |
| TBKKHYCD | Possible View Types Change Documents Account Hierarchies |