SAP Business Partners Tables
Are you looking for the right table related to SAP Business Partners 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 Partners (CRM-MD-BP) module.
Top 10 tables in Business Partners
| Table | Description |
|---|---|
| ISH_RESPNAMEA | Healthcare BPR: Contact Person: Responsible for Name Range |
| CRMC_BUPA_PRPFCT | Assignment Partner Functions to BP Function Proposal Proc. |
| ISH_RESPTYPEC | Responsibility Type |
| CRMM_BUT_SETBC10 | Buying Center entity table |
| CRMC_ATTR10 | Attribute 10 (Business Partner) |
| CRMM_BUT_SET0140 | Business Partner Organization Rule Period |
| ISH_PASSWORDS | BP Passwords, e.g. for Caller Authentication |
| ISH_ATTPHYSA | Healthcare BP: Data of "Health Insurance Provider" Relatnshp |
| ISH_NEG_FOODA | Forbidden Ingredient in Food, e.g. Due to Allergy |
| CRMC_BPMTLNK0100 | CRM Business Partner: Link for Object Status |
List of tables in Business Partners
| Table | Description |
|---|---|
| ISH_RESPNAMEA | Healthcare BPR: Contact Person: Responsible for Name Range |
| CRMC_BUPA_PRPFCT | Assignment Partner Functions to BP Function Proposal Proc. |
| ISH_RESPTYPEC | Responsibility Type |
| CRMM_BUT_SETBC10 | Buying Center entity table |
| CRMC_ATTR10 | Attribute 10 (Business Partner) |
| CRMM_BUT_SET0140 | Business Partner Organization Rule Period |
| ISH_PASSWORDS | BP Passwords, e.g. for Caller Authentication |
| ISH_ATTPHYSA | Healthcare BP: Data of "Health Insurance Provider" Relatnshp |
| ISH_NEG_FOODA | Forbidden Ingredient in Food, e.g. Due to Allergy |
| CRMC_BPMTLNK0100 | CRM Business Partner: Link for Object Status |
| CRMC_BPMTLNK010S | CRM Business Partner: Shadow Table for CRMC_BPMTLNK0010 |
| ISH_RESPTYPET | Responsibility Type - Text Table |
| CRMC_CLEAR_VAR | Select Variants for User Interaction / Background Processing |
| CRMC_BUPA_CDBL | Delivery Blocking Reason: Description |
| CRMM_BUT050 | Dummy table for report BUPTDTRANSMIT (needed for TABKEY) |
| CRMC_BPMTSET0010 | CRM Business Partner: Template for Sales Data |
| CRMC_BUPA_RLTPRP | Assignment BP Function Proposal Procedure to BP Role |
| CRMC_ATTR07 | Attribute 7 (Business Partner) |
| CRMC_TBZ5_AXT | Table entries to map TBZ5 entry to the AXT TABLE NAME |
| CRMC_ATTR03_T | Description: Attribute 3 (Business Partner) |
| CRMC_NIELSEN | Nielsen ID |
| ISH_RESPTYPEA | Healthcare BPR: Contact Person: Responsibility Type |
| CRMC_BPMTLNK0030 | CRM Business Partner: Link Table for FRG0030 Templates |
| CRMC_UI_SSEARCHH | Function Profile Header to control simple search |
| CRMC_ODATA_ENTIT | Customizing: Entity names mapping |
| CRMC_BPMTSET020S | CRM Business Partner: Shadow Table for CRMC_BPMTSET0020 |
| CRMC_MODEL_BUIL | Business Partner Interaction Layer Model |
| CRMC_BUPA_COBL | Order Blocking Reason |
| CRMC_MKP_CHAN_T | Marketing Permission: Communication Channel Text Table |
| CRMC_CLASSIF_T | Description: Customer Classification |
| CRMC_ATTR08_T | Description: Attribute 8 (Business Partner) |
| ISH_PREF_FOODT | Preferred Type of Food - Text Table |
| CRMM_BUT_FRG0070 | Business Partner Excluded Partner Functions List |
| CRMM_BUT_SET0030 | Business Partner: Billing Data |
| CRMC_BPMTLNK020S | CRM Business Partner: Shadow Table for CRMC_BPMTLNK0020 |
| CRMM_BUT_FRG0071 | Business Partner Excluded Partner Functions |
| CRMC_MKP_OPT | Opt-in Definitions for Marketing Permission |
| CRMC_BUPA_CONSUM | Business Partner Consumer Template |
| CRMC_METHOD_BUIL | Executable Methods of an Object |
| CRMC_BPMTSET0020 | CRM Business Partner: Mini-Template for Shipping Data |
| CRMM_BUT_LNK0020 | Business Partner - Shipping Rule List |
| CRMC_BUT_HIER_BW | SAP BP: Hierarchy Extraction |
| CRMC_MKP_ORIGN | Marketing Permission: Form of Consent |
| CRMC_BPMTSET030S | CRM Business Partner: Shadow Table for CRMC_BPMTSET0030 |
| CRMM_BUT_LNKBC10 | Account Buying Center |
| CRMM_BUPA_MKP_BW | Service: Business Partner BW Marketing Permissions |
| CRMC_ATTR01 | Attribute 1 (Business Partner) |
| CRMC_TBZ5F | Table entries in TBZ5F, necessary for BP Merge in CRM system |
| CRMC_MODE_C_BUIL | Business Partner Interaction Layer Model |
| CRMM_BUT_FRG0050 | Business Partner - Status |
| CRMC_ATTR04 | Attribute 4 (Business Partner) |
| ISH_MEMBTYPEC | Member Type |
| CRMC_ATTR06_T | Description: Attribute 6 (Business Partner) |
| CRMC_CLASSIF | Customer Classification |
| CRMC_BUT_CND_GRP | Group for Condition Maintenance |
| CRMC_ATTR05_T | Description: Attribute 5 (Business Partner) |
| CRMC_NIELSEN_T | Description: Nielsen ID |
| CRMMSPL_BP_F0040 | Service Business Partner: Status |
| ISH_PATIENTA | Healthcare BP: Patient Data |
| TB043 | BDT: Assignment Object Part (Role) -> CM Template |
| CRMC_BP_CM | Assignment UI application <-> CM Folder |
| CRMC_BUPA_COBL_T | Order Blocking Reason: Description |
| CRM_ODATA_ENTITY | Entity names mapping |
| CRMC_BP_CLCAT | Service BP Classification Categories |
| CRMC_T077D | Customer account groups |
| CRMC_ATTR01_T | Attribute 1 (Business Partner) |
| CRMC_MKP_OPT_ASG | Country specific opt-in Definitions for Marketing Permission |
| CRMC_BP_UIU_CPRL | Add Contact Person-role while creation of Contact |
| CRMC_BPMTSET0030 | CRM Business Partner: Mini-Templates for Billing Data |
| CRMC_BPMTSET0100 | CRM Business Partner: Template for Blocking Indicator |
| CRMM_BUT_FRG0041 | Business Partner Sales Classification |
| CRMM_BUT_CRMOBJ | Buffer: Which BPs are in Which Systems |
| CRMC_BP_OD_MYACC | CRM BP OData: Rel. Categories which define "myAccounts" |
| CRMC_BP_CATCRIT | Service BP: Assignment Class. Categorie -> Class.-Criteria |
| CRM_ODATA_PROPS | Entity property names mapping |
| CRMC_FUZZY_CUST | Supported object types for duplicate check |
| CRMC_ATTR09_T | Description: Attribute 9 (Business Partner) |
| CRMC_ATTR05 | Attribute 5 (Business Partner) |
| CRMC_ATTR03 | Attribute 3 (Business Partner) |
| ISH_RISKA | Risk Information - Application Table |
| CRMC_OBJI_C_BUIL | Object Table for Gen. IL Sample Component - Impl. classes |
| CRMM_BUT_LNK0140 | Business Partner Organization Rule List |
| CRMM_BUT_FRG0040 | Business Partner Sales Classification List |
| CRMC_ALLO_C_BUIL | Business Partner Interaction Layer Objects |
| CRMC_OBJIMP_BUIL | Object Table for Gen. IL Sample Component - Impl. classes |
| CRMC_BP_CLCRIT | Service BP Classification Criteria |
| CRMM_BUT_SET0010 | Business Partner: Sales Data |
| CRMC_BUPA_OD | Customizing for Business Partner in OData services |
| CRMC_BPMTSET010S | CRM Business Partner: Shadow Table for CRMC_BPMTSET0010 |
| CRMC_BP_CLATTR_T | Service BP Classification Criteria Texts |
| CRMC_BUPA_PRPS | CRM BP Partner Functions, Function Proposal Procedures |
| CRMC_ALLOBJ_BUIL | Business Partner Interaction Layer Objects |
| CRMC_ATTR07_T | Description: Attribute 7 (Business Partner) |
| CRMM_BUT_LNK0141 | Business Partner Organization Rule |
| CRMS4C_TBZ5F | Table entries TBZ5F (BP Merge in S/4 HANA for Customer M.) |
| CRMC_BUPA_CDBL_T | Delivery Blocking Reason: Description |
| CRMC_ATTR02_T | Description: Attribute 2 (Business Partner) |
| CRMC_PRN_CONTR2 | BP Print Control: objects |
| CRMC_ATTR10_T | Description: Attribute 10 (Business Partner) |
| ISH_INSTYPEC | Insurance type |
| CRMM_BUT_LNK0011 | Business Partner - Sales Rule |
| CRMC_BP_CLCRIT_T | Service BP Classification Criteria Texts |
| CRMS4C_TBZ5 | Table entries in TBZ5 (BP Merge in S/4 HANA for Customer M.) |
| CRMC_ATTR08 | Attribute 8 (Business Partner) |
| ISH_PREF_FOODA | Preferred Type of Food - Application Table |
| CRMC_UIU_MSG | Control of Error processing |
| CRMM_BUT_SET0020 | Business Partner: Shipping Data |
| ISH_INSTYPET | Insurance Type - Text Table |
| CRMM_BUPA_MERGE | CRM_BUPA_MERGE |
| CRMC_BPMTLNK0010 | CRM Business Partner: Link Table for FRG0010 Templates |
| CRMC_MKP_ORIGN_T | Marketing Permission: Origin of Permission Text Table |
| ISH_NEG_FOODC | Forbidden Ingredients, e.g. Due to Allergy |
| CRMC_BP_CLCAT_T | Service BP Classification Categories Texts |
| T006EEC | Assignment of Unit of Measurement Family to Country |
| CRMC_BPMTLNK030S | CRM Business Partner: Shadow Table for CRMC_BPMTLNK0030 |
| CRMC_MKP_OPT_T | Marketing Permission: Opt ID Text Table |
| CRMC_BUPA_CBBL | Billing Blocking Reason |
| CRMC_BPMTSET100S | CRM Business Partner: Shadow Table for CRMC_BPMTSET0100 |
| CRMC_BP_RE_MAIN | Global Settings for Rule-Based Assignment of Employees |
| CRMM_BUT_FRG0081 | Business Partner - Sales Area - Partner Function |
| CRMC_BP_CATATTR | Service BP: Assignment Class. Categorie -> Class.-Criteria |
| CRMC_BUP_STATMAP | Service BP: User status conversion to role, mapping table |
| ISH_PREF_FOODC | Preferred Type of Food |
| CRMC_ATTR09 | Attribute 9 (Business Partner) |
| CRMC_BP_UM_EMAIL | Customizing table for email notification in User Mgmt |
| ISH_RISKC | Risk Information - Customizing Table |
| CRM_ODATA_NAV | Navigation property mapping |
| CRMC_ATTR02 | Attribute 2 (Business Partner) |
| CRMM_BUPA_BPGHBW | Business Partner Group Hierarchy - BW Identification |
| CRMC_ATTR06 | Attribute 6 (Business Partner) |
| ICRMS_CONST | Constant Table IS-CRM |
| CRMC_ATTR04_T | Description: Attribute 4 (Business Partner) |
| ISH_PHYSICIANA | Healthcare BP: Physician Data |
| CRMM_BUT_LNK0030 | Business Partner - Billing Rule List |
| CRMC_TBZ5 | Table entries in TBZ5, necessary for BP Merge in CRM system |
| CRMC_BUPA_CBBL_T | Billing Blocking Reason: Description |
| CRMC_BP_CLATTR | Service BP Classification Attributes |
| ISH_RESPREGA | Healthcare BPR: Contact Person: Responsible for PCode Range |
| CRMC_BPMTLNK100S | CRM Business Partner: Shadow Table for CRMC_BPMTLNK00100 |
| CRMC_MKP_CHAN | Marketing Permission: Communication Channel |
| ISH_RISKCT | Risk Information - Customizing Text Table |
| CRMC_BPMTLNK0020 | CRM Business Partner: Link Table for FRG0020 Templates |
| ICRMC_CONST | Constant Table IS-CRM (Customizing) |
| CRMC_PRN_CONTROL | Print Control Table for WebClient |
| CRMM_BUT_FRG0100 | Service Business Partner: Status |
| CRM_TKVST | CO Version Texts |
| CRMC_UI_SSEARHHT | Funciton Profile Header to control simple search - Texts |
| CRMM_BUT_SMIUSER | CRM Business Partner Link to Social Media User |
| CRMC_UI_SSEARCH | Function Profile Details to control simple search |
| T006EER | Assignment of Unit of Measurement Family to Country and Reg. |
| CRMM_BUT_LNK0021 | Business Partner - Shipping Rule |
| CRMM_BUT_MKTPERM | Service: Business Partner Marketing Permission |
| ISH_NEG_FOODT | Forbidden Ingredients in Food - Text Table |
| CRMM_BUT_CLASS | Service Business Partner Classification |
| CRMM_BUT_LNK0031 | Business Partner - Billing Rule |
| CRMC_T077X | Description: Account Groups Customers |
| FRG0080_CD | BP Rel./Prt.Func/Sales Empl.:Index Table for Chng Doc Access |
| CRMM_BUT_FRG0080 | Business Partner - Sales Area - Partner Function List |
| ISH_INSRELA | Healthcare BP: Data of "Health Insurance Provider" Relatnshp |
| CRMM_BUT_LNK0010 | Business Partner - Sales Rule List |
| ICRMS_CONST_T | Constant Table IS-CRM (Text Table) |
| CRMM_BUT_FRG0042 | Business Partner Sales Classification List Order Blocks |
| ISH_MEMBTYPET | Member Type - Text Table |
| CRMC_METH_C_BUIL | Executable Methods of an Object |