SAP Business Partner Tables

Are you looking for the right table related to 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 Business Partner (FS-BP) module.

Top 10 tables in Business Partner

TableDescription
TPZ24BP Role Assignment
RATCE_AGENCYRating Agencies
BKK21Business Partner Aliases
FSBP_CC_CLEANSETable for Customizing Settings
BP1012_SRCSource Records Of OTC 147, Table BP1012
TBD001Business Partner: Assignment of Account Groups and Grouping
BPCC_MIGCS_RULEMerging: Rule Procedure for Clashes
BP3000BP: Additional Data (from Darwin-BP)
TP10Business partner: Loan to Manager Indicator
TD05_AT_FSIS-IS: ÖNB-Target groups

List of tables in Business Partner

TableDescription
TPZ24BP Role Assignment
RATCE_AGENCYRating Agencies
BKK21Business Partner Aliases
FSBP_CC_CLEANSETable for Customizing Settings
BP1012_SRCSource Records Of OTC 147, Table BP1012
TBD001Business Partner: Assignment of Account Groups and Grouping
BPCC_MIGCS_RULEMerging: Rule Procedure for Clashes
BP3000BP: Additional Data (from Darwin-BP)
TP10Business partner: Loan to Manager Indicator
TD05_AT_FSIS-IS: ÖNB-Target groups
TP103BP: Field Modification via BP Role Category
TP019TBusiness Partner: Key for Blank Fields
BP3010Additional Data
MAHNS_DIAccounts blocked by dunning selection
BPCC_MIGCS_MAPAssignment of Rating Procedure/Rating to Institution/Rating
TP23Differentiation Type Criterion
FSBPCC_TAXCRSN_TTax Compliance: Names of Status Reasons
TPZ12Business partner: Application category
TP38Applications
TP43Call Context
BP1012_PRCProcess Records Of OTC 147, Table BP1012
TP16TBusiness Partner: Name of Department
TP23SSetting for Differentiation Type Criterion
TP12TBusiness Partner: Description of Credit Standing Acc. to GBA
TP46TName of Permissible BP Role in Application
TPZ17Business Partner: Archiving of Treasury Data, Tables
BP1020BP: Business Partner - Fiscal Data
BP1012_DQ_RESMaster Data Quality Results of OTC 147, Table BP1012
TP46Roles Permitted in Application
TPU3TConversion: Time Periods (Texts)
BPBPCABPCA for Business Partner
VTBSTC1Components of Payment Details for Standing Instruction
TP15Business Partner: Function
TP19TBusiness Partner Additional Information
TPZ12TBusiness Partner: Application (Text)
TPZ40Protected Applications
TPZ2TBusiness Partner: Name of Grouping
BP2000BP: Business Partner - Business Partner - Relationship
MDM_TESTDATA_1Test Data Directory
TP22Business Partner Additional Information
RATCE_OWNEROwner
TP07TBusiness Partner: Name of Credit Rating Institute
TPZ2Business Partner: Customizing BP Grouping
FSBP_CIF_LOGLog Complex Interface FSBP
FSBP_ID_STATUSStatus Information About Conversion of ID Numbers
RATCE_RATINGRating Procedure
TBDC001BP: Field Grouping Customer/Vendor/Company Code (Obsolete)
TBD002Business Partner: Additional Role Definition
TP38TDescription for Application
FSBPCC_TAXCRSNTax Compliance: Reasons for Status
RATCE_OWNER_TXTDescription of Owner
TPZ20Business Partner Acquisition Data: Information Categories
TP06Business Partner: Rating
TP017Value Table for Liability Risks
MDM_ATTRIBUTES_1Characterization of Attributes
FSBP_CNS_IMAGETable for CNS Image Data
TP09Business Partner: Legal Entity
MDM_OBJECT_IDENTObject Description (Dependent on Business Object and Level)
RATCE_PROCEDURESRating Procedure
TPZ3WBP Field Groups
TPZ38Applications (E-Table)
TPZ20TBusiness Partner Acquisition Data: Information Categories
FSBPC_PRX_CPATHCustomizing Communication Path
TPZ38TDescription for Application (E-Table)
TPR2Partner-Obj. Relationship: Assignment Cat. - Application Cat
TP05Business partner: Employee group
TP04Business Partner: Marital Property Regime
TZEGAAdditional User-Specific Partner Data 10: Text Table
RATCE_SETRating Sets
RATCE_SET_RATINGAssignment of Rating to Rating Set
TP02Business partner: Salutation
BP021Fiscal Year Information
TP14TBusiness Partner: Name of Address ID
BP1012Ratings
RATCE_RATING_TXTTexts for Ratings
RATCE_SET_TXTRating Sets
TZDGIAdditional User-Specific Partner Data 9: Text Table
TP06TBusiness Partner: Rating Description
TPU5Conversion: Define Subprojects and Sequence
BPCE_BOOBSOLETE
TP07Business Partner: Credit Rating Institute
BP3100Additional information
FSBPCC_TAXC_TTax Compliance: Names of Compliance Types
FSBP_PXE_LOGTable for Logging Proxy Events
TPZ5BP: Business Partner - Role category-View - Assignment
TZEG1Value Table 10: Addit. User-Specific Partn.Data (nat. pers.)
TP45TDescription for Role Set
BP002Treasury attributes natural person
BPCE_MOOBSOLETE
VTBSTA4SI for Business Partner: Derived Flows
BPCE_BO_AOOBSOLETE
TPZ11BP: Business Partner - Relationship Type
TBDC002BP: Field Grouping Customer/Vendor
TP45Role Sets
TZDGHAdditional User-Specific Partner Data 8: Text Table
FSBPCC_TAXC2CTRYTax Compliance: Assignment to Country and Region
TP49Total Commitment - UI Linking
TZDGEAdditional User-Specific Partner Data 5: Text Table
TPZ_LZBCountry According to German Federal Bank Country Indicator
TP11TBusiness Partner: Description of Employment Status
TPU3Conversion: Time periods
VTBSTA3SI for Business Partner: Transaction Authorizations
TZDG9Value Table 9: Addit. User-Specific Partn. Data (nat. pers.)
TZDGAAdditional User-Specific Partner Data 1: Text Table
TPZ3YLink Rules for Field Control - BP Role Category
TPZ_CONST_DEF_TFS BP Constants Table: Text for Definition of Constants
BP1040Business partner: Reporting data in company code
TP09TBusiness Partner: Name of Legal Entity
BP1060OBSOLETE: Business Partner: Company Code Control Data
TPZ21Business Partner: Rating Procedure
TP13TBusiness Partner: Name of Partner Grouping (Target Group)
TBC001Business Partner: Assignment of Account Groups and Grouping
TP44Logical Systems
BPCE_AO_VOOBSOLETE
BPCE_BO_LOOBSOLETE
TP08Business Partner: Legal Form
TP43TDescription for Call Context
TD05T_AT_FSIS-IS: Texts for TD05_AT
MDM_OBJECT_METHDObject Methods (Dependent on Business Object / Level)
TP42Assignment of Logical System / ID Number Category
TP01TBusiness Partner: Form of Address Text
BPCONSTANTSFS BP Constants Table: Adopted Values (Internal)
TPZ10BP: Business Partner - Screen View - Assignment
TPZ7BP: Business Partner - Relationship Category
BPCE_BO_TXTOBSOLETE
TPR4Partner-Object Relationship: Event Modules
BPID003_EID Number Category
TP24BP: Partner Grouping Characteristics
TP15TBusiness partner: Name of Function
TVIP_FSContact Person: VIP Indicator
TZEGBAdditional User-Specific Partner Data 11: Text Table
BP1030BP: Business partner - reporting data
TPZ41Use of Protected Applications
TZDG7Value Table 7: Addit. User-Specific Partn.Data (legal pers.)
BPCE_BO_CHANNELOBSOLETE
TZEG2Value Table 11: Addit. User-Specific Partn.Data (nat. pers.)
TPR5Partner Object Relationship: Application Cat. - Role Cat. I
TPZ3RBP Fields -> BP Field group Assignment
TPZ7TBP: Business Partner - Name of Relationship Category
TPR10Partner Object Rel. Assign. BDT Application to Appl. Cat.
TBPIDID Number Category
FSBP_CC_MAP_ADDRTable for Mapping Address IDs in Cleansing Process
RATINGSRatings
TP40Assignment of Selection Variant / Role Set
TPZ18TBusiness Partner: Key for Blank Fields
TPR1Patner-Object Relationship: Assignment Categories
TP016Value for Liability Risks
BP1013Differentiated Attributes
TZDG8Value Table 8: Addit. User-Specific Partn. Data (nat. pers.)
TPR9Partner Object Relation.: Application Category-Role-Grouping
TPZ13Business Partner: Application Role Category - Assignment
FSBP_CC_IMAGETable for CC Image Data
TPZ3BP: Business Partner - Role Category
TP04TBusiness Partner: Description of Marital Property Regime
TP13Business Partner: Partner Grouping (Target Group)
BPTC01Master Data for Total Commitment
FSBP_BP021_STATUStatus Table for the Conversion of BP021 from 4.6C to ABA
BP1010_SRCSource Records Of OTC 147, Table BP1010
BP000Business Partner Master (General Data)
TPU2Conversion: Assignment of Modules to Time Periods
TP16Business Partner: Department
TPZ18Business Partner: Key for Blank Fields
RATCE_PROC_TXTDescription of Rating Procedure
BPTC02Flow Data for Total Commitment
TP019Business Partner: Key for Blank Fields
TPU1TConversion: Conversion Project Texts
TZDGGAdditional User-Specific Partner Data 7: Text Table
BP1000BP: Business Partner - Role
TPZ43Call Context (E-Table)
TPR1TPartner-Object Relationship: Assignment Category Texts
BPCE_LOOBSOLETE
BP030BP: Business partner - address
FSBPCC_TAXCTax Compliance: Compliance Types
BP1070Do Not Use! Liability Risks for Business Partner
FSBPC_PRX_CACHESettings for Cache of Business Partner Proxies
BPCE_MO_TXTOBSOLETE
TP08TBusiness Partner: Description of Legal Form
BPCE_VOOBSOLETE
BPCE_AOOBSOLETE
FSBP_CC_MAP_BKDTTable for Mapping Bank Detail IDs in Cleansing
TZDGBAdditional User-Specific Partner Data 2: Text Table
BP011Employment Data
TPZ3XBP Field Groups: Texts
TZDG4Value Table 4: Addit. User-Specific Partn.Data (legal pers.)
TP41Assignment of Selection Variant / Relationship Category
TP01Business Partner: Form of Address
TP018Customizing Rel. Between Legal Form and Leg. Form of Company
BP1010Creditworthiness Data
TP22TBusiness Partner Additional Information
VTBSTA2Standing Instructions for Correspondence
TPZ3TBP: Business Partner - Name of Role Category
TPU1Conversion: Conversion Projects
FSBP_INFMSG_LOGPersistency for Identifying Transferred BP Changes
TP19Business Partner Additional Information
CCBP_COMM_CUSTCustomizing for Communication Control for FSBP
TPZ4TBP: Business Partner - Description of View
BP001FS-Specific Attributes; Organization
BPCE_MO_POOBSOLETE
TPU4Conversion: Control
TPZ11TBP: Business Partner - Name of Relationship Type
TPZ6TBP: Business Partner - Name of Role Type
TPZ16Business Partner: Archiving of Treasury Data, Tables
TP12Business Partner: Credit Standing Acc. to German Banking Act
MDM_ATTRIBUTES_0Characterization of Attributes
TP24TBP: Name for Partner Grouping Characteristics
TPZ_CONST_VALFS BP Constants Table: Values of Constants (Internal)
FSBPCE_PXE_AGENTCustomizing for Agents
TP03Business partner: Marital status
TPZ21TBusiness Partner: Name of Rating Procedure
TZDG2Value Table 2: Additional User-Specific Partner Data (gen.)
TPZ22Business Partner: Ratings
RATCE_AGENCY_TXTDescription of Rating Agency
TP47Assignment of Role in Application to Role Set
FSBP_CC_MAP_PAYCTable for Mapping Payment Card IDs in Cleansing
TPZ24TBP Role Assignment Text
BPCE_AO_MOOBSOLETE
TP105BP: Field Modification via Activity Category
TPZ43TDescription for Call Context (E-Table)
TZDGDAdditional User-Specific Partner Data 4: Text Table
TPR1_UPatner-Object Relationship: Assignment Categories
FSBP_CC_BPCABusiness Process Assignmnent for Data Cleansing Cases
TPZ3ZBP: Link Rules Activity Category: Field Control
TPU5TConversion: Subprojects (Texts)
FSBP_C_ESA_SVCESA Service Implementations
BP1010_DQ_RESMaster Data Quality Results of OTC 147, Table BP1010
TBC002Business Partner Role: Additional Role Definition
TZDGCAdditional User-Specific Partner Data 3: Text Table
BPCE_CHANNELOBSOLETE
TPZ6BP: Business Partner - Role Type
BPCE_AO_TXTOBSOLETE
BPCE_MO_CDOCOBSOLETE
FSBPCC_T880Company with Description
TP23TDifferentiation Type Criterion: Description
TZDG6Value Table 6: Addit. User-Specific Partn.Data (legal pers.)
FSBP_TEST_CONFIGConfiguration Table for FS-BP Unit Tests
TP03TBusiness Partner: Description of Marital Status
BP1050Business Partner: General Control Data
TP37Activation Status for Total Commitment
TP11Business partner: Employment status
TPZ4BP: Business Partner - Views
TPR6Partner Object Relationship: Application Cat. - Role Cat. II
VTBSTA1Allocation of Payment Details as Standing Instructions
BPTAXCBusiness Partner Tax Compliance
TZDG3Value Table 3: Additional User-Specific Partner Data (gen.)
TP48Business Partner Archiving: Residence Times for Roles
TP05TBusiness Partner: Name of Employee Group
CEXO_BOT_CNSOBSOLETE
TPZ1Business Partner: Find and Replace Strings Phonetic Search
TP016TText for Liability Risks
TPZ14Business Partner: Role Category Text ID - Assignment
BUT0BANKBusiness Partner: Bank Data
TP02TBusiness Partner: Salutation Text
BPUM_CTLBusiness partner: Conversion control
TPZ8BP: Business Partner - Differentiation Category
FSBPCS_ESAMAPCustomizing for SOA Mapping
BPTC03Contract - Role Category Link in Total Commitment
BPCE_MO_VOOBSOLETE
TPZ9TBP: Business Partner - Name of Screen
BPCE_PO_TXTOBSOLETE
UBBP000TR-EDT: Transfer Business Partners
TZDG5Value Table 5: Addit. User-Specific Partn.Data (legal pers.)
TPU6Conversion: Define Fields to be Converted
BPID001Additional Partner Numbers
CEBP_COMM_CUSTCustomizing for Communication Control for FSBP
BPC_DISTCRT_ROLEPartial Distribution: Distribution Criterion Role Category
TZDG1Value Table 1: Additional User-Specific Partner Data (gen.)
TZDGFAdditional User-Specific Partner Data 6: Text Table
TPZ9BP: Business Partner - Screen
TP18TBusiness Partner: Description of Reason for Undesirablitiy
BPID002_TDescription of Identification Number Category
FSBPCC_LGL_PROCBusiness Partner: Status of Legal Proceedings
BPCE_POOBSOLETE
BPC_FIL_ROLETable for Filtering Roles (in Inbound)
BPOBTABPartner-Object Relationship
TP18Business Partner: Reason for Client being Undesirable
BPCE_BO_VOOBSOLETE
TP39Selection Variants
BPFRGOBSOLETE TABLE: Business Partner: Roles for Release
BPRBPCABPCA
BPIDCONVAssignment of ID Categories/Types and ID Number Categories
TPZ22TBusiness Partner: Description of Ratings
BP1010_PRCProcess Records Of OTC 147, Table BP1010
TPZ3SBP View -> BP Field Group Assignment
BPISISBP: Assign Treasury Partner to IS-IS-Partner
BPCE_LO_TXTOBSOLETE
TPZ_CONST_DEFFS BP Constants Table: Definition of Constants (Internal)
FSBPCC_LGL_PROCTBusiness Partner: Name of Status of Legal Proceedings
TP10TBusiness Partner: Name of Loan to Manager
TP39TDescription for Selection Variant