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 (LO-MD-BP) module.
Top 10 tables in Business Partners
| Table | Description |
|---|---|
| CUSCOMPANYCODE_D | I_BUSINESSPARTNERTP I_BUSINESSPARTNERCUSTCOTP |
| BUPA_COMM_D | DRAFT TABLE FOR BP_COMM_D |
| BPADDSWT_D | I_BUSINESSPARTNERTP I_BPADDLSUPLRWHLDTAXTP |
| CMD_NRIV_LOG | change log for NRIV updation |
| BPADDCSA_D | I_BUSINESSPARTNERTP I_BPADDLCUSTSALESAREATP |
| BPADDSWEBURL_D | I_BUSINESSPARTNERTP I_BPADDLSUPLRWEBSITEURLTP |
| MDMCHP | MDM: Change events by incoming IDocs |
| BUPA_TAX_NUM_D | I_BUSINESSPARTNERTP I_BUSINESSPARTNERTAXNUMBERTP |
| BPADDCSAT_D | I_BUSINESSPARTNERTP I_BPADDLCUSTSALESAREATAXTP |
| CFG_MDM_BP_CONT | For ecatt /SMB99/CL_MD_BP_XD01_CONT_O001 |
List of tables in Business Partners
| Table | Description |
|---|---|
| CUSCOMPANYCODE_D | I_BUSINESSPARTNERTP I_BUSINESSPARTNERCUSTCOTP |
| BUPA_COMM_D | DRAFT TABLE FOR BP_COMM_D |
| BPADDSWT_D | I_BUSINESSPARTNERTP I_BPADDLSUPLRWHLDTAXTP |
| CMD_NRIV_LOG | change log for NRIV updation |
| BPADDCSA_D | I_BUSINESSPARTNERTP I_BPADDLCUSTSALESAREATP |
| BPADDSWEBURL_D | I_BUSINESSPARTNERTP I_BPADDLSUPLRWEBSITEURLTP |
| MDMCHP | MDM: Change events by incoming IDocs |
| BUPA_TAX_NUM_D | I_BUSINESSPARTNERTP I_BUSINESSPARTNERTAXNUMBERTP |
| BPADDCSAT_D | I_BUSINESSPARTNERTP I_BPADDLCUSTSALESAREATAXTP |
| CFG_MDM_BP_CONT | For ecatt /SMB99/CL_MD_BP_XD01_CONT_O001 |
| MDG_MLT_AS_REASN | Multiple Assignment Reasons |
| BPADDCEA_D | I_BUSINESSPARTNERTP I_BPADDLCUSTEMAILADDRESSTP |
| BUPA_CCARD_D | I_PAYMENTCARDTYPETP I_PAYMENTCARDTYPETP |
| BUPA_LFAT_D | I_BUSINESSPARTNERTP I_BPSUPPLIERTAXGROUPINGTP |
| BPADDCWT_D | I_BUSINESSPARTNERTP I_BPADDLCUSTWHLDGTAXTP |
| DES_BP_OUTPUT | BP records matched in Mass Data Enrichment |
| BPADDCCC_D | I_BUSINESSPARTNERTP I_BPADDLCUSTCOMPANYCODETP |
| SAPARTNERFUNC_D | I_BUSINESSPARTNERTP I_BUSINESSPARTNERPARTFUNCTP |
| CUSTSA_TEXT_D | I_BUSINESSPARTNERTP I_BPSALESAREATEXTTP |
| BUPA_TELNO_D | I_BUSINESSPARTNERTP I_BPTELEPHONENUMBERTP |
| BUPA_ROLE_D | I_BUSINESSPARTNERTP I_BUSINESSPARTNERROLETP |
| DES_BP_INPUT | Input BP records to perform Mass Data Enrichment |
| BPADDSUPP_D | I_BUSINESSPARTNERTP I_BPADDITIONALSUPPLIERTP |
| BPADDCWEBURL_D | I_BUSINESSPARTNERTP I_BPADDLCUSTWEBSITEURLTP |
| BUPA_ADRU_D | I_BUSINESSPARTNERTP I_BUSINESSPARTNERADDRUSAGETP |
| QCCONTACT_D | I_QUICKCREATECONTACTTP I_QUICKCREATECONTACTTP |
| WTHLD_TAX_D | I_BUSINESSPARTNERTP I_BUSINESSPARTNERWHLDGTAXTP |
| BPADDSTN_D | I_BUSINESSPARTNERTP I_BPADDLSUPLRTELNMBRTP |
| BPADDSWTAX_D | I_BUSINESSPARTNERTP I_BPADDLSUPLRWHLDGTAXTP |
| CMD_DRAFT_DC_MAP | Staging table for persisting DatacloudID and DraftUUID |
| SUPP_GEN_D | I_BUSINESSPARTNERTP I_BUSINESSPARTNERSUPPLIERTP |
| SAPARTNERFUNCTIO | Draft table for Customer Master - Sales Area PartnerFunction |
| BUPA_KNAT_D | I_BUSINESSPARTNERTP I_BPCUSTOMERTAXGROUPINGTP |
| BUPA_ROOT_D | I_BUSINESSPARTNERTP I_BUSINESSPARTNERTP |
| CMD_BS_ECC_CUSCP | Number Range for ERP Contact Person per Target System |
| BPACTION_D | Maintaining action/operation in Customer/Supplier fiori apps |
| BPADDSUPPFD | I_BUSINESSPARTNERTP I_BPADDLSUPLRPARTFUNCTP |
| MDG_MLT_AS_RSN_T | Assignment Reasons Text |
| BUPA_BANK_D | I_BUSINESSPARTNERTP I_BUSINESSPARTNERBANKTP |
| CUST_WTAX_D | I_BUSINESSPARTNERTP I_BUSINESSPARTNERCUSTWHDGTAXTP |
| BUPA_ID_D | I_BUSINESSPARTNERTP I_BUPAIDENTIFICATIONTP |
| DES_KEY_MAP_TEMP | Key mapping table for mass data enrichment |
| BUPA_ADRC_D | I_BUSINESSPARTNERTP I_BUSINESSPARTNERADDRESSTP |
| BPADDSFN_D | I_BUSINESSPARTNERTP I_BPADDLSUPLRFAXNUMBERTP |
| DES_CA_DETAILS | CA Details |
| BUPA_WEBURL_D | I_BUSINESSPARTNERTP I_BPWEBSITEURLTP |
| CUST_DUN_D | I_BUSINESSPARTNERTP I_BPCUSTOMERDUNNINGTP |
| BUPA_FAXNO_D | I_BUSINESSPARTNERTP I_BPFAXNUMBERTP |
| BUPA_BUUT0CC_D | I_BUSINESSPARTNERTP I_PAYMENTCARDTP |
| SATAX_D | I_BUSINESSPARTNERTP I_BUSINESSPARTNERSLSAREATAXTP |
| CUST_TEXT_D | I_BUSINESSPARTNERTP I_BUSINESSPARTNERCUSTOMERTXTTP |
| DES_KEY_MAP | Key mapping table for mass data enrichment |
| BPADDCUST_D | I_BUSINESSPARTNERTP I_BPADDITIONALCUSTOMERTP |
| SALESAREA_D | I_BUSINESSPARTNERTP I_BUSINESSPARTNERSALESAREATP |
| PUR_ORG_D | I_BUSINESSPARTNERTP I_BUSINESSPARTNERPURGORGTP |
| BPADDCTN_D | I_BUSINESSPARTNERTP I_BPADDLCUSTTELNMBRTP |
| BPADDSDUN_D | I_BUSINESSPARTNERTP I_BPADDLSUPLRDUNNINGTP |
| BPADDCSAPF_D | I_BUSINESSPARTNERTP I_BPADDLCUSTPARTFUNCTP |
| BPADDCFN_D | I_BUSINESSPARTNERTP I_BPADDLCUSTFAXNUMBERTP |
| CFG_MDM_BP_XK01 | For ecatts /SMB99/CL_MD_BP_XK01_O001_J01 |
| CMD_DES_MAPPER | CMD & Data Enrichment Mapper Table for BP |
| CFG_MDM_BP_XD01 | For ecatt /SMB99/CL_MD_BP_XD01_O001_J01 |
| SUPLR_TEXT_D | I_BUSINESSPARTNERTP I_BUSINESSPARTNERSUPPLIERTXTTP |
| MDMCLASSIF | Account groups for vendor coming from MDS |
| BPADDSPO_D | I_BUSINESSPARTNERTP I_BPADDLSUPLRPURGORGTP |
| MANT_CHECKS_REF | Mandatory checks data |
| MDG_MLT_AS_CAT_T | Assignment categories text |
| MDG_MLT_ASSGMNT | Multiple Assignments |
| CMD_BS_ECC_CUSNR | Number Range per Target System and Customer Account Group |
| BUPA_IND_D | I_BUSINESSPARTNERTP I_BUPAINDUSTRYTP |
| SUPP_DUN_D | I_BUSINESSPARTNERTP I_BPSUPPLIERDUNNINGTP |
| BUPA_GRH_D | I_BUSINESSPARTNERTP I_BPGOODSRECEIVINGHOURSTP |
| BUPA_MOBILEPH_D | I_BUSINESSPARTNERTP I_BPMOBILEPHONENUMBERTP |
| DES_UPDATE_INPUT | Input BP records to perform Update |
| BUPA_EMAIL_D | I_BUSINESSPARTNERTP I_BPEMAILADDRESSTP |
| DES_DP_ID_TYPE | Mapper from Data provider to Id type for DE |
| CMD_PCI_RESPONSE | Staging table for payment hub response |
| SUPLRCC_TEXT_D | I_BUSINESSPARTNERTP I_BPSUPPLIERCOMPANYCODETEXTTP |
| DES_MAPPER | External & Data Enrichment Mapper Table for BP |
| CMD_BS_ECC_VENNR | Number Range per Target System and Vendor Account Group |
| CCARD_ROOT_D | I_PAYMENTCARDMASTERTP I_PAYMENTCARDMASTERTP |
| BUPA_KNVA_D | I_BUSINESSPARTNERTP I_BPUNLOADINGPOINTTP |
| DES_DESTINATION | Maintain destination details for Data Enrichment services |
| DES_BATCH_INPUT | Records batched for Input in Mass enrichment |
| CMD_DUPCHK_TMSTP | Timestamp of last execution of duplicate check |
| BPSUPL_PF_D | I_BUSINESSPARTNERTP I_BPSUPPLIERPARTNERFUNCTIONTP |
| BUPA_CONTACT_D | I_BUSINESSPARTNERTP I_BUSINESSPARTNERCONTACTTP |
| BPADDCDUN_D | I_BUSINESSPARTNERTP I_BPADDLCUSTDUNNINGTP |
| SUPP_CC_D | I_BUSINESSPARTNERTP I_BUSINESSPARTNERSUPLRCOTP |
| DES_JOB_DETAILS | Job realted details for mass data enrichment |
| BPADDSCC_D | I_BUSINESSPARTNERTP I_BPADDLSUPLRCOMPANYCODETP |
| CMD_CSVC_LOCK | Object that is locked due to cross system veto check |
| BPADDSMPN_D | I_BUSINESSPARTNERTP I_BPADDLSUPLRMBLPHNUMBERTP |
| SUPLRPO_TEXT_D | I_BUSINESSPARTNERTP I_BPSUPPLIERPURCHASINGORGTXTTP |
| DES_ERROR_CODES | Error code and descriptions for Mass Data Enrichment |
| CUSTCC_TEXT_D | I_BUSINESSPARTNERTP I_BUSINESSPARTNERCUSTCOTEXTTP |
| BPADDSEA_D | I_BUSINESSPARTNERTP I_BPADDLSUPLREMAILADDRESSTP |
| MDG_MLT_AS_CAT | Assignment Categories |
| BPHCM_FLD_STATUS | Business Partner and HCM integration Field Group statuses |
| BPADDCMPN_D | I_BUSINESSPARTNERTP I_BPADDLCUSTMBLPHNUMBERTP |
| CUSTOMER_D | I_BUSINESSPARTNERTP I_BUSINESSPARTNERCUSTOMERTP |
| DES_BUS_SYST | Maintain business system for Data Enrichment |
| SUPP_PF_D | I_SUPPLIERPARTNERFUNCTIONTP I_SUPPLIERPARTNERFUNCTIONTP |