SAP SAP Business Partner Tables
Are you looking for the right table related to SAP SAP Business Partner 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 SAP Business Partner (AP-MD-BP) module.
Top 10 tables in SAP Business Partner
| Table | Description |
|---|---|
| BUTEOPAPP_T | Store the Apllication Description |
| CRMM_BUT_FRG0060 | Business Partner Business Hours |
| BUT0BK_SHD | Shadow table for BUT0BK (IBAN only) |
| TB930T | Business Partner: Marital Property Regime: Texts |
| TBZ0L | BDT Activity Categories: Texts |
| TBZ5A | BDT Object Usage: Assign Context-View Variant |
| TBZ3N | BDT-Screen Sequence Category -> BDT-Screen Seq. Assignment |
| TBZ0T | BDT Object Parts: Texts |
| TBZ4T | BDT GUI Functions: Texts |
| TB990T | Differentiation Type Element Like Company Code: Texts |
List of tables in SAP Business Partner
| Table | Description |
|---|---|
| BUTEOPAPP_T | Store the Apllication Description |
| CRMM_BUT_FRG0060 | Business Partner Business Hours |
| BUT0BK_SHD | Shadow table for BUT0BK (IBAN only) |
| TB930T | Business Partner: Marital Property Regime: Texts |
| TBZ0L | BDT Activity Categories: Texts |
| TBZ5A | BDT Object Usage: Assign Context-View Variant |
| TBZ3N | BDT-Screen Sequence Category -> BDT-Screen Seq. Assignment |
| TBZ0T | BDT Object Parts: Texts |
| TBZ4T | BDT GUI Functions: Texts |
| TB990T | Differentiation Type Element Like Company Code: Texts |
| TBZ1A | BDT Events |
| TBZ3I | Assign BDT Screen -> BDT Sections |
| TB102 | SAP BP Field Grouping, Client-Specific |
| TBZ4 | BDT GUI Functions |
| BUPA_DEBUG | SAP BP: Activate Debugging for Function Module |
| BUP_ADDR3_CD | BP Relationship: Index Table for Change Document Access |
| TBZ3D | BDT Sections: Texts |
| TBZ1I | BDT-External applications |
| TBZ3S | Assign BDT View -> BDT Field Groups |
| TBZ3A_TD | BDT Screens Subscreen Containers |
| TBZ1J | BDT-External applications: Texts |
| TBZ0Q | BDT Data Sets |
| TB071 | Define Business Partner Tax Groups |
| TB210T | Business Partner: Names of Assigned Objects |
| TBZ1H | BDT Tables |
| TBZ3J | BDT: Field Groups Additional FMOD2 Modules |
| TBZ0F | Assign BDT Object Part -> BDT Views |
| TBZ6 | BDT: VCT Usages |
| TB039B | BP ID Types: Texts |
| BUT0VP | BP: Business Partner Assignment and Links |
| TBZ3R_BD | Assign BDT Field Group -> BAPI Fields |
| TBUPA_BIPT | Description of External Business Partner Applications |
| BUT030G | BP Where-Used List: Generic Nodes |
| TB044 | (Obsolete!) Business Partner Roles: Properties |
| COMC_CLEAR_ACT | Data Cleansing: Indicator per Category and Object Class |
| TBZ0O_4 | BDT Field Grouping per Activity (Control) Part 4 |
| TB993 | Differentiation Type Element Like Division |
| TB047 | BP Transactions for Finding Bank Details |
| TB045T | Business Partner: Texts for Variants Deletion Selection |
| TBZ7D | BDT-DC: Templates for Programming Models |
| TBZ4B | BDT GUI Functions: Active per View/Screen Seq.Variant (Obs) |
| BUT053 | BP Relationship: Company Interest |
| TBZ9G | BP Relationship Category->Dyn. Text f. Relationship Overview |
| TBZ0J | Assign BDT Object Part Grouping -> BDT Screen Sequences |
| TB105 | BDT Field Grouping for each Activity Category |
| TB018V | BDT Object Usage: Variant Table |
| TB047T | BP Transactions for Finding Bank Details: Texts |
| TBZ0O | BDT Field Grouping for Each Activity (Control) |
| CRMBP_MAP_BUGRP | Mapping of Business Partner Grouping |
| TBUPA_BIP | Interfaces for External Business Partner Applications |
| BUT_DNC | BP: Telephone Numbers of the "Do Not Call" List |
| TB047U | BP Assignment Transaction -> Usage Type for Bank Details |
| TBZ0N | BDT Activities: Texts |
| TBZ7AT | BDT-DC: Wizard Declaration - Texts |
| CRMC_BUT_CALL_FU | Determining FMs for Data Exchange:BP |
| COMM_CLEAR_DEP | Data Cleansing: Table of Referencing Objects |
| TB041 | BP: Entry Variants for Evaluation Generator |
| TBZ1C | Assign BDT Screen Fields -> BDT Database Fields |
| TB040F | BDT: Selection and Display Fields of Evaluation |
| TB003R | BP Role Category Group -> BP Role Category |
| CRMM_BUT_FRG0061 | Business Partner Business Hours Interval |
| TB108_2 | Field Grouping BP Role(3501-7000) |
| TB030 | BP authorization types |
| TBZ3U | BDT Screen Containers |
| TB048T | BP: Texts of Applications for Distributing Time-Dep. Data |
| TB900 | Field grouping using BP relationship category |
| BUTBWUSSTATGRP | BP: BW Status Object Group for User Status |
| CMD_DC_VIEW_MAIN | Maintain Aggregated View for Data Enrichment |
| BUT_UNBLK_REASON | Reasons of Unblocking Business Partners |
| TISIS_APPL_T | Application Texts |
| T006EE | Systems for Units of Measurement (Entities) |
| TBZ9E | Assign BDT Differentiation Type -> BDT Diff.Type Element |
| TBZ5 | BDT: Where-Used List - Structure Table |
| TB040B | BDT: Link Tables for Indirect Join Relationships |
| TBZ3M | BDT-Screen Sequence Categories: Texts |
| BUT054 | BP Relationship (not used yet) |
| TBZ7BT | BDT-DC: Wizards - Screen Descriptions - Texts |
| TB991 | Differentiation Type Element Like Sales Organization |
| TBZ5F | BDT Object Usage: Variant Table |
| CRMC_BUT_APP_MNT | Appointment Rules: Dialog Form |
| TBZ0K | BDT Activity Categories |
| TB991T | Differentiation Type Element Like Sales Organization: Texts |
| TB994 | Differentiation Type Like Sales Area |
| TB031 | BP Field Groups for Authorization |
| T006E | System for Units of Measurement (Components, Mapping) |
| MDM_SEL_TRANS_PR | MDM: Storage of Selections and Transfer Segments (Copy) |
| TBZ7C | BDT DC: Programming Models |
| TFKTAXNUMTYPE_C | Customer Selection: Business Partner Tax Number Categories |
| BUT_FRG0011 | Business Partner: Tax Classification |
| TBZ5B | BDT Where-Used List: Application Objects |
| TB041T | BP: Texts for Variants of Evaluation Generator |
| TB038T | BP Industry Key Systems: Texts |
| BUTBWSYSTATOBJ | BP: BW Status Objects for System Status |
| TB103_4 | BDT: Field Grouping per Object Part Part4 |
| TBZ3 | BDT Screen Sequences |
| TBZ5ET | BDT Object Usage: Variants, Texts |
| TBZ3R_C | Assign BDT Field Group -> BDT Field |
| T006ET | Systems for Units of Measurement (Entities -> Texts) |
| TBZ7B | BDT-DC: Wizards - Screen Descriptions |
| BUT_UNBLK_AUTO | Status for Automatic Unblocking for HCM Appln |
| TBZ1T | BDT Application Objects: Texts |
| TBZ3K | Assign BDT Screen Sequence -> BDT Screen |
| TB930 | Business Partner: Marital Property Regime |
| TISIS_CNT_TYPE | Contract Categories |
| TB039T | BP ID Categories: Texts |
| TB053 | BP Mass Update: Classes |
| TBZ3E | BDT Views |
| TBZS4 | BDT Search Help: Search Fields |
| BUTEOPARV_T | Stores Apllication Rule Variants Description |
| TB046T | BP Bank Details Types: Texts |
| TBZS1 | BDT Search Help: Tables with Alias Names |
| TBZ3H | Assign BDT Section -> BDT View |
| TB109 | BDT Application Transactions for Appl. Object BUPA |
| BUT0BKU | BP: Bank Details Usages |
| TB004_4 | BP Types Part 4 |
| TBZ3G | BDT-Views: Further checks |
| BUTBWSYSTATGRP | BP: BW Status Object Group for System Status |
| BUPA_IFC_CALL_FU | Determining FMs for Data Exchange:BP |
| TBZ0E | BDT Differentiation Types: Texts |
| TBZ0I | Assign BDT Object Part Grouping-> BDT Object Parts |
| TBZ1K | Assign BDT Direct Input Fields -> BDT Database Fields |
| TB105_3 | BDT Field Grouping per Activity Category Part 3 |
| TBZ1B | BDT Events: Texts |
| BUTBWUSSTATOBJT | BP: BW Status Object for User Status |
| TB070 | Tax Classification: Tax Types per Country |
| TBZ9J | BP relationship cat. -> BP view allocation |
| TCACS_CONTRACT | Partner Contract Categories |
| TBZ0A | BDT Applications |
| TBZ9C | BDT Differentiation Type Elements |
| TB201 | BP: Scheduled Changes for each Role (Time-Dependency) |
| BUTEOPCONS | Store the EOP details of Consolidation system id |
| TBZ5AT | BDT Object Usage: Assign Context-View Variant |
| TB200 | BP Addresses: Seq. Numbers for Planned Commun. Data |
| BUTBWCVSYSTAT | BP: Mapping BW Status/OLTP System Status |
| TB003P | BP role category group |
| TB103_3 | BDT: Field Grouping per Object Part Part3 |
| TB104 | BDT-Field grouping per external application |
| BMDEOP_IDX_TBL | Standard index table |
| TBZ3A | BDT Screens |
| TB104_3 | BDT Field Grouping per External Application Part 3 |
| TBZ9H | BP Relationships: Assign Rel. Category to Database Tables |
| TB052 | Obsolete |
| TB019A | BDT Object Usage: Assign Context-View Variant |
| TCACS_CONTRACT_T | Partner Contract Categories |
| TBZ1G | Assign BDT Application Object-> BDT Differentiation Type |
| COMC_CLEAR_PRIOT | Data Cleansing: Permitted Priorities |
| TBZ3X | BDT Field Groups: Texts |
| TISIS_CNT_TYPE_T | Contract Category Texts |
| TBZ5S | BDT: Where-Used List - Transport Shadow Table |
| TBZ3P_2 | BP Field Grouping: BP Category Part 2 |
| TB210A | Business Partner: Assigned Objects |
| TBZ3P_4 | BP Field Grouping: BP Category Part 4 |
| TB400T | Text Table for Business Partner Fragments |
| TBZ9_CD | BPR: Control for Reading Change Documents for Relationships |
| BUTEOPARV | Define / Store Application Rule Variants for EOP Check |
| TBCALLBY | Value table for Call By |
| TB060R | BDT: Transaction Entry Via Search Screen for Object Parts |
| BUT000_BCS | Persistence of a BAS Address |
| TBZ3L | BDT-Screen Sequence Categories |
| SMDEOP_IDX_TBL | Standard index table |
| BUTEOPAPP | Define / Store Application Names for EOP check. |
| TB102_3 | SAP BP Field Grouping, Client-Dep. Field Group 3501 - 5250 |
| TBZ0 | BDT Object Parts |
| BUT0TP | SAP BP: Template Assignments |
| BUT_TDMISS | BP Non-Distributable Time-Dependent Data (from BUT_TDTRANS) |
| COMM_CLEAR_TARG | Data Cleansing: Target Object List |
| TBZ1D | BDT Setting Transactions |
| BUT030GT | BP Where-Used List: Generic Nodes, Text |
| TCRMBP_REFCUST | Default Sample Customer |
| TBZ6S | BDT: VCT Usages (Shadow Table) |
| TB102_4 | SAP BP Field Grouping, Client-Dep. Field Group 5251 - 7000 |
| BUT_TDAPPLI | BP Non-Distributable Time-Dependent Data (from BUT_TDTRANS) |
| TB105_2 | BDT Field Grouping per Activity Category Part 2 |
| BUTNXTCHK | Customizing table for next check date |
| TB993T | Diff. Type Element Like Division: Texts |
| TB038B | BP Industry Key: Texts |
| TBZ1 | BDT Application Objects |
| TB019AT | BDT Object Usage: Assign Context-View Variant |
| TBZ5T | BDT: Where-Used List - Structure Texts |
| TB210 | Business Partner: Assigned Objects (Entities) |
| TBZ0G | BDT Object Part Grouping |
| TB044T | (Obsolete!) Business Partner Roles: Properties, Texts |
| COMM_CLEAR_STACK | Data Cleansing Cases |
| TB400 | External Key Table for Business Partner Fragments |
| TBZ0H | BDT Object Part Grouping: Texts |
| MDMEXTRHEAD_PREF | MDM Header Table Extractor Metadata (Copy) |
| TBZ3T | BDT Screen Sequence Variants: Texts |
| TBZ3W | BDT Field Groups |
| TBZ0U | Assign BDT Object Part -> BDT Screen Sequences |
| TB992 | Diff. Type Element Like Distribution Channel |
| TBZ5E | BDT Object Usage: Variants |
| TBZ0M | BDT Activities |
| TBZ3F | BDT Views: Texts |
| TBZ3Q | BDT Field Grouping Criteria |
| TBZ3V | BDT Screen Containers: Texts |
| BUTREGSYS_REMOTE | RFC Dest. of systems connected to the Master System |
| TBZ0O_3 | BDT Field Grouping per Activity (Control) Part 3 |
| TBZ0O_2 | BDT Field Grouping per Activity (Control) Part 2 |
| TFKTAXNUMTYPE | Tax Number Categories of Business Partner |
| TB058 | BP: Table for Distributing Time-Dependent Data |
| TBZ1E | BDT Application Transactions |
| BUTBWUSSTATOBJ | BP: BW Status Object for User Status |
| TBZ3A_GEN | BDT Screens to be Regenerated |
| MDMEXTRGRP_PREF | MDM Field Group Extractor Metadata (Copy) |
| TBZ0D | BDT Differentiation Types |
| ISIS_CNT_DUMMY | Dummy Table for Search Help ISIS_CONTRACT_F4_INCL |
| TBZS2 | BDT Search Help: Join Conditions |
| TBZ5BT | BDT Where-Used List: Application Object Texts |
| BUTBWSYSTATGRPT | BP: BW Status Object Group for System Status - Texts |
| TBZ3C | BDT Sections |
| TBZ3P_3 | BP Field Grouping: BP Category Part 3 |
| TBZ3P | BP field grouping: BP cat. |
| BUTBWUSSTATGRPT | BP: BW Status Object Group - Texts |
| TBZ3O | BDT Field Grouping Criteria: Texts |
| TBZ3Z | BDT Field Grouping: Link Rules with Activity |
| TB003V | BP Role Category -> Business Transaction |
| TBZ0S | BDT Object Part -> BDT Data Sets Assignment |
| TBZ1F | Assign BDT Events -> Function Modules |
| BUTBWSYSTATOBJT | BP: BW Status Objects for System Status - Texts |
| TB050 | Screen Config. (Obsolete from Second Edition VCT) |
| BUTRELCHK | store the relationships categories |
| TBZS5 | BDT Search Help: Tree of Tables Containing Search Fields |
| TBZ0R | BDT Data Sets: Texts |
| BUT_UNBLK_REQST | Ublocking Request Data |
| TB040 | BDT: Database Tables of Evaluation |
| TBZS3 | BDT Search Help: Views |
| TISIS_APPL | Applications |
| TBZ7A | BDT-DC: Wizard Declaration |
| COM_BUPA_CALL_FU | Determining Function Modules for Data Exchange: BP |
| TBZ0B | BDT Applications: Texts |
| BUT010 | GP: old, do not use ==> BUT020 |
| TB070T | Tax Classification: Tax Types per Country, Descriptions |
| TBZ9D | BDT Differentiation Type Elements: Texts |
| TB004_3 | BP Types Part 3 |
| TB102_2 | SAP BP Field Grouping, Client-Dep. Field Group 1751 - 3500 |
| TBZ0C | Assign BDT Object Part -> BDT Applications |
| TBZ7CT | BDT-DC: Programming Models - Texts |
| TBZ3Y | BDT Field Grouping: Link Rules for Same Objects |
| TB105_4 | BDT Field Grouping per Activity Category Part 4 |
| TFKTAXNUMTYPE_T | Name: Business Partner Tax Number Categories |
| TBZ9F | BPR: Generic diff.type element per relationship category |
| TBZ9B | BP relationship cat. -> resp. BP application allocation |
| BUT_NOBLK_DUAL | Status of activation of Noblock & Dual Cont for role a group |
| TBZ3R | Assign BDT Field Group -> BDT Field |
| TBZ4A | BDT GUI Functions: Active for Each View |
| COMC_CLEAR_STAT | Data Cleansing: Status and Transition Can Be Selected |
| TBZ5D | BDT Setting Transactions |
| BUTBWCVUSSTAT | Customizing: Mapping BW Status/OLTP User Status |
| TBZ3Y_01 | BDT Field Grouping: Link rules for Different Objects |
| TB050_S | Screen Configuration (Shadow Table) (Obsolete) |
| TBZ3B | BDT Screens: Texts |
| TBZ4C | BDT-GUI Functions: Active per View/Screen Sequence Cat. |
| TB071_T | Define Business Partner Tax Groups |
| TBZ9I | BP relationship cat -> calling application allocation |
| COMC_CLEAR_PRIO | Data Cleansing: Permitted Priorities |
| TB992T | Diff. Type Element Like Distribution Channel: Texts |
| TB103_2 | BDT: Field Grouping per Object Part Part2 |
| CMD_FIELD_MAPPER | Mapper for external data provider |
| BUT030 | BP Where-Used List: Usages |
| HRPADIC | Additional Data PADD2 |
| TB018 | BDT Object Usage: Variants |
| BUTSORT | SORT Details of Business Partners for each Application |
| BUTROLECHK | store the business partner roles |
| BUTEORT | End of Retention Date for Business Partner |
| BUTEOPPRIORITY | Priority table for Function Modules registered for EOP check |
| TB003Q | BP Role Category Group: Text |
| CMDEOP_IDX_TBL | Standard index table |
| TB046 | BP Bank Details Types |
| BUT030T | BP Object Usage: Application Table, Texts |
| TB030T | BP Authorization Types: Texts |
| BUTSORT_CD | Changed SoRT Records with Reasons |
| TB018T | BDT Object Usage: Variants, Texts |
| TB049T | Appointment Rules: Texts for Schedule Types |
| BUT_DUAL_APRJ | Unblocking reference table for four eye principle |
| BUT_TDTRANS | BP: Index Table for Distributing Time-Dependent Data |
| BUT0ID_BIP_NOHIT | Business Information Provider: Logging of non identified BP |
| TB104_2 | BDT Field Grouping per External Application Part 2 |
| TB060 | BDT: Transaction Entry |
| TB045 | Business Partner: Filter Values for Variants Deletion Selecn |
| TB048 | BP: Applications for Distributing Time-Dependent Data |
| BUT_BLK_REQST | Blocking Request Data |
| CRMC_BUPA_DE | Obsolete |
| TB049 | Appointment Rules: Schedule Types |
| TB103 | BDT: Field Grouping for each Object Part |
| TB104_4 | BDT Field Grouping per External Application Part 4 |
| COMC_EXT_SOURCE | External Data Sources |
| BUTEOPFM_UNBLK | Application Function Modules registered for Unblock Check |
| BUTEOPARCH_CHECK | Application Function Modules register for Archiving Check |
| BUT_DNC_OLD | BP: Telephone Numbers of the "Do Not Call" List |
| BUXPRA | Business Partner: XPRA Management Table |
| COMC_EXT_SOURCET | Text Table for External Data Sources |
| BUT_FRG0010 | Business Partner: Tax Classification |
| BUT_HIER_BW | SAP BP: Hierarchy Extraction |
| BUT_UNBLK_RESN_T | Text Table For BUT_UNBLK_REASON |
| BUTEOPFM | Application Function Modules registered for EOP Check |
| MDMEXTRFLD_PREF | MDM Field Table Extractor Metadata (Copy) |