SAP Business Partner Foundation Tables
Are you looking for the right table related to SAP Business Partner Foundation 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 Business Partner Foundation (BC-SRV-BP) module.
Top 10 tables in Business Partner Foundation
| Table | Description |
|---|---|
| BUT021 | BP: Address usages |
| TB008 | Assignment: BP Role -> BP Address Type - OBSOLETE |
| BUT021_FS | Time-Dependent Address Usages |
| TBZ9 | BP relationship categories |
| TBZ9A | BP Relationship Categories: Texts |
| MOM052 | Workplace Addresses |
| BUT050S | BP Relationships/Role Definitions: General Data |
| TB055T | APD Development: Texts |
| TB026 | BP group types: Texts |
| TB036 | Authorization Group Objects |
List of tables in Business Partner Foundation
| Table | Description |
|---|---|
| BUT021 | BP: Address usages |
| TB008 | Assignment: BP Role -> BP Address Type - OBSOLETE |
| BUT021_FS | Time-Dependent Address Usages |
| TBZ9 | BP relationship categories |
| TBZ9A | BP Relationship Categories: Texts |
| MOM052 | Workplace Addresses |
| BUT050S | BP Relationships/Role Definitions: General Data |
| TB055T | APD Development: Texts |
| TB026 | BP group types: Texts |
| TB036 | Authorization Group Objects |
| TB911 | Contact person in standard departments: Texts |
| TB020 | BP legal forms: Texts |
| BUT150 | BP relationship: Attribute table (test different.type TBUKR) |
| TB006 | BP data sources: Text |
| TB004_2 | BP Types Part 2 |
| TB003J | BP Role Grouping Categories |
| BUT0IS | BP: Industries |
| TB915 | Contact person authority: Texts |
| MOM052_FS | Workplace Address Usages |
| TB917 | Contact person VIP indicator: Texts |
| BUT000_TDS | BP: General Data I, Shadow Table Time Dependency |
| TB003T | BP Roles: Texts |
| TB028T | BP occupations/groups: Texts |
| TB003G | BP Role Groupings |
| TB003F | BP Role Exclusion Groups: Permitted Transitions |
| TB905 | BP Relationship Types |
| BUT050_CD | BP Rel./Role Determination:Index Table for Change Doc.Access |
| TB901 | Business Partner Relationship Categories: Properties |
| BUT0BK | BP: Bank Details |
| TB003E | BP Role Exclusion Groups -> BP Roles |
| TB920 | BP Relationship Categories: Assign BP Role Cat. -> BP Roles |
| TB038 | BP Industry Key Systems |
| BUT000_TD | BP: General Data I, Shadow Table Time Dependency |
| TB913 | Positions of contact person: Texts |
| TB003H | BP Role Groupings: Texts |
| TB003I | BP Role Groupings -> BP Roles |
| BUT050 | BP relationships/role definitions: General data |
| BUT021_FSS | Shadow Table: Time-Dependent Address Usages |
| TB009 | BP address types |
| BUT_AUGRP_BLK | Set Authorization Group Value for Blocked BP |
| TB024 | BP industries: Texts (Obsolete ==> TB038A) |
| TB004T | BP Types: Texts |
| BUT100 | BP: Roles |
| TB300 | BP: Control for Reading Addresses via butadrsearch |
| TB508S | BP Address Determination Transactions |
| TB036T | Authorization Group Objects: Texts |
| TB027 | BP marital status |
| TB010 | BP address types: Texts |
| TB003C | BP Role Exclusion Groups |
| TB509 | Address Types of Workplace Addresses |
| BUT051S | Shadow Table BP Relationship: Contact Person Relationship |
| TB037 | Authorization Groups |
| BUT020 | BP: Addresses |
| TB033 | Payment Cards: Type |
| TB510 | BP address types: Texts |
| TB056 | APD Development: Activation |
| BUT000_EBP_G | Table for Lock Object EBP_G |
| BUT0ID | BP: ID Numbers |
| BUT020S | Shadow Table BP: Addresses |
| BUT0CC | BP: Payment Cards |
| BUT052 | BP Relationship: Addresses |
| TB039A | BP ID Types |
| TB005 | BP data sources |
| TB029T | BP legitimation types: Texts |
| BUT052S | Shadow Table BP Relationship: Addresses |
| TB921 | BP Rel.: Restriction of the Relnship to BP Role Categories |
| TB003A | BP role categories |
| TB002 | BP grouping: Texts |
| TB912 | Positions of contact persons |
| TB508U | BP Workplace: Addr. Determ. Process -> Addr.Type Assigment |
| TB003B | BP role categories: Texts |
| TB032T | BP Legal Entity: Texts |
| TB038A | BP Industry Key |
| BUT001 | BP: General data II |
| BUT000 | BP: General data I |
| TB003 | BP Roles |
| TB032 | BP Legal Entity |
| TB001 | BP groupings |
| TB914 | Contact person authority |
| TB008T | BP Address Determination Transactions: Texts |
| TB003K | BP Role Grouping Categories: Texts |
| TB055A | APD Development: Check Modules |
| BUT051 | BP Relationship: Contact Person Relationship |
| TB023 | BP industries (Obsolete ==> TB038A) |
| TB910 | Contact Person Departments |
| TB008S | BP Address Determination Transactions |
| TB039 | BP ID Categories |
| TB027T | BP marital status: Texts |
| TB025 | BP group types |
| SHLP_FILTER_BP | Customizing Table for Filtering Search Helps |
| BUTADRSEARCH | Mass Search Help: Business Partner |
| TCC1 | Payment Cards: Verification Rules for Card Numbers |
| TB055 | APD Development |
| TB004 | BP types |
| TB108 | Field Grouping BP Role |
| TB003D | BP Role Exclusion Groups: Texts |
| TB905T | BP Relationship Types: Texts |
| TB995T | BP Gender : Text |
| TB995 | BP Gender |
| TB901T | Business Partner Roles: Properties, Texts |
| TB019 | BP legal forms |
| TB028 | Occupations |
| TB990 | Differentiation type element like company code |
| TB037T | Authorization Groups: Texts |
| TB029 | BP legitimation types |
| TB508T | BP Address Determination Transactions: Texts |
| TB916 | Contact person VIP indicator |
| TB008U | BP Address Determination Trans.->BP Address Type Assignment |