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. (CA-MDG-CMP-BP) module.

Top 10 tables in Business Partner.

TableDescription
LFBW_ACTMaster Data Consolidation: Best Record Table for LFBW
BUT000_ACTMaster Data Consolidation: Best Record Table for BUT000
KNVV_STXL_SRCSource Records Of OTC 147, Table KNVV_STXL
KNVA_PRCProcess Records Of OTC 147, Table KNVA
LFA1_PRCMaster Data Consolidation: Process Table for LFA1
LFA1_DRAD_SRCSource Records Of OTC 147, Table LFA1_DRAD
KNVA_SRCSource Records Of OTC 147, Table KNVA
LFA1_STXH_PRCProcess Records Of OTC 147, Table LFA1_STXH
LFBW_PRCMaster Data Consolidation: Process Table for LFBW
MDC_BUT100OBSOLETE: Do not use!

List of tables in Business Partner.

TableDescription
LFBW_ACTMaster Data Consolidation: Best Record Table for LFBW
BUT000_ACTMaster Data Consolidation: Best Record Table for BUT000
KNVV_STXL_SRCSource Records Of OTC 147, Table KNVV_STXL
KNVA_PRCProcess Records Of OTC 147, Table KNVA
LFA1_PRCMaster Data Consolidation: Process Table for LFA1
LFA1_DRAD_SRCSource Records Of OTC 147, Table LFA1_DRAD
KNVA_SRCSource Records Of OTC 147, Table KNVA
LFA1_STXH_PRCProcess Records Of OTC 147, Table LFA1_STXH
LFBW_PRCMaster Data Consolidation: Process Table for LFBW
MDC_BUT100OBSOLETE: Do not use!
KNBK_SRCMaster Data Consolidation: Source Table for KNBK
LFM2_PRCMaster Data Consolidation: Process Table for LFM2
UKMBP_CMS_SRCSource Records Of OTC 147, Table UKMBP_CMS
KNA1_KSSKClassification Classes for Customer (Template Table)
LFA1_KSSKClassification Classes for Supplier (Template Table)
DFKKBPTAXNUM_PRCMaster Data Consolidation: Process Table for DFKKBPTAXNUM
LFA1_ACTMaster Data Consolidation: Best Record Table for LFA1
LFA1_ASSGMNT_PRCProcess Records Of OTC 147, Table LFA1_ASSGMNT
BUT0ID_SRCMaster Data Consolidation: Source Table for BUT0ID
LFM1_STXL_PRCProcess Records Of OTC 147, Table LFM1_STXL
LFB1_STXH_SRCSource Records Of OTC 147, Table LFB1_STXH
UKMBP_CMS_PRCProcess Records Of OTC 147, Table UKMBP_CMS
BUT0BK_SRCMaster Data Consolidation: Source Table for BUT0BK
KNA1_AUSP_PRCProcess Records Of OTC 147, Table KNA1_AUSP
LFB5_SRCMaster Data Consolidation: Source Table for LFB5
KNA1_STXH_SRCSource Records Of OTC 147, Table KNA1_STXH
LFB5_PRCMaster Data Consolidation: Process Table for LFB5
KNVV_STXH_SRCSource Records Of OTC 147, Table KNVV_STXH
WYT1T_PRCMaster Data Consolidation: Process Table for WYT1T
LFA1_DRAD_PRCProcess Records Of OTC 147, Table LFA1_DRAD
KNVV_SRCMaster Data Consolidation: Source Table for KNVV
MDC_IMEXEIM in HANA: Execution ID
LFA1_SRCMaster Data Consolidation: Source Table for LFA1
LFB1_STXL_PRCProcess Records Of OTC 147, Table LFB1_STXL
LFA1_STXL_PRCProcess Records Of OTC 147, Table LFA1_STXL
BUT021_FS_ACTMaster Data Consolidation: Best Record Table for BUT021_FS
DFKKBPTAXNUM_SRCMaster Data Consolidation: Source Table for DFKKBPTAXNUM
WYT1_SRCMaster Data Consolidation: Source Table for WYT1
WYT1_PRCMaster Data Consolidation: Process Table for WYT1
KNVP_SRCMaster Data Consolidation: Source Table for KNVP
KNVP_PRCMaster Data Consolidation: Process Table for KNVP
LFB1_SRCMaster Data Consolidation: Source Table for LFB1
LFA1_KSSK_PRCProcess Records Of OTC 147, Table LFA1_KSSK
BUT000_PRCMaster Data Consolidation: Process Table for BUT000
BUT000_SRCMaster Data Consolidation: Source Table for BUT000
BUT_ADR2_PRCMaster Data Consolidation: Process Table for ADR2
BUT_ADR12_SRCMaster Data Consolidation: Source Table for ADR12
LFB5_ACTMaster Data Consolidation: Best Record Table for LFB5
KNVV_PRCMaster Data Consolidation: Process Table for KNVV
KNA1_SRCMaster Data Consolidation: Source Table for KNA1
KNA1_ASSGMNT_SRCSource Records Of OTC 147, Table KNA1_ASSGMNT
KNVV_ACTMaster Data Consolidation: Best Record Table for KNVV
LFM1_STXH_PRCProcess Records Of OTC 147, Table LFM1_STXH
BUT0BK_PRCMaster Data Consolidation: Process Table for BUT0BK
LFA1_STXL_SRCSource Records Of OTC 147, Table LFA1_STXL
WYT3_ACTMaster Data Consolidation: Best Record Table for WYT3
WYT1T_ACTMaster Data Consolidation: Best Record Table for WYT1T
KNA1_AUSP_SRCSource Records Of OTC 147, Table KNA1_AUSP
KNA1_STXL_SRCSource Records Of OTC 147, Table KNA1_STXL
KNB1_PRCMaster Data Consolidation: Process Table for KNB1
KNB1_ACTMaster Data Consolidation: Best Record Table for KNB1
BUT0BK_ACTMaster Data Consolidation: Best Record Table for BUT0BK
KNA1_KSSK_PRCProcess Records Of OTC 147, Table KNA1_KSSK
KNVI_ACTMaster Data Consolidation: Best Record Table for KNVI
MDC_BP_MTC_IMOUTMaster Data Consolidation: Output Table for BP Match
MDC_BP_MA_MAPBP Multiple Assignment Mapping
LFM1_STXL_SRCSource Records Of OTC 147, Table LFM1_STXL
BUT0ID_PRCMaster Data Consolidation: Process Table for BUT0ID
LFB1_STXH_PRCProcess Records Of OTC 147, Table LFB1_STXH
LFA1_AUSPClassification Characteristics for Supplier (Template Table)
BUT_ADR2_SRCMaster Data Consolidation: Source Table for ADR2
MDC_IM_STD_LOCKLock IM address settings f. manual address validation
KNA1_STXL_PRCProcess Records Of OTC 147, Table KNA1_STXL
BUT000_SRC_STATMaster Data Consolidation: Status of BP Source Records
KNVV_STXH_PRCProcess Records Of OTC 147, Table KNVV_STXH
BUT0IS_ACTMaster Data Consolidation: Best Record Table for BUT0IS
MDC_MTC_BASBAS Matching Configuration
LFM1_ACTMaster Data Consolidation: Best Record Table for LFM1
KNVI_PRCMaster Data Consolidation: Process Table for KNVI
LFAS_SRCMaster Data Consolidation: Source Table for LFAS
LFM2_SRCMaster Data Consolidation: Source Table for LFM2
LFA1_AUSP_SRCSource Records Of OTC 147, Table LFA1_AUSP
KNB1_STXH_SRCSource Records Of OTC 147, Table KNB1_STXH
BUT0IS_PRCMaster Data Consolidation: Process Table for BUT0IS
BUT100_SRCMaster Data Consolidation: Source Table for BUT100
KNVP_ACTMaster Data Consolidation: Best Record Table for KNVP
BUT_ADR6_PRCMaster Data Consolidation: Process Table for ADR12
LFM1_PRCMaster Data Consolidation: Process Table for LFM1
BUT021_FS_PRCMaster Data Consolidation: Process Table for BUT021_FS
KNB1_STXH_PRCProcess Records Of OTC 147, Table KNB1_STXH
BUT_ADRC_PRCMaster Data Consolidation: Process Table for ADRC
BUT_ADR12_PRCMaster Data Consolidation: Process Table for ADR12
WYT3_PRCMaster Data Consolidation: Process Table for WYT3
BUT_ADRC_IMOUTMaster Data Consolidation: Process Table for ADRC
KNA1_PRCMaster Data Consolidation: Process Table for KNA1
BUT_ADRP_ACTMaster Data Consolidation: Best Record Table for ADRP
BUT_ADR6_ACTMaster Data Consolidation: Best Record Table for ADR12
KNA1_KSSK_SRCSource Records Of OTC 147, Table KNA1_KSSK
LFBK_SRCMaster Data Consolidation: Source Table for LFBK
LFA1_STXH_SRCSource Records Of OTC 147, Table LFA1_STXH
BUT0ID_ACTMaster Data Consolidation: Best Record Table for BUT0ID
BUT_ADRC_IMINMaster Data Consolidation: Process Table for ADRC
BUT020_ACTMaster Data Consolidation: Best Record Table for BUT020
BUT_ADRC_ACTMaster Data Consolidation: Best Record Table for ADRC
LFA1_KSSK_SRCSource Records Of OTC 147, Table LFA1_KSSK
KNVV_STXL_PRCProcess Records Of OTC 147, Table KNVV_STXL
KNA1_DRAD_PRCProcess Records Of OTC 147, Table KNA1_DRAD
LFB1_PRCMaster Data Consolidation: Process Table for LFB1
WYT1_ACTMaster Data Consolidation: Best Record Table for WYT1
KNB1_SRCMaster Data Consolidation: Source Table for KNB1
KNA1_ACTMaster Data Consolidation: Best Record Table for KNA1
KNA1_DRAD_SRCSource Records Of OTC 147, Table KNA1_DRAD
LFM1_STXH_SRCSource Records Of OTC 147, Table LFM1_STXH
BUT_ADR3_PRCMaster Data Consolidation: Process Table for ADR3
BUT_ADRP_PRCProcess Records Of OTC 147, Table ADRP
BUT_ADRP_SRCSource Records Of OTC 147, Table ADRP
WYT1T_SRCMaster Data Consolidation: Source Table for WYT1T
LFB1_STXL_SRCSource Records Of OTC 147, Table LFB1_STXL
KNAS_SRCMaster Data Consolidation: Source Table for KNAS
LFBW_SRCMaster Data Consolidation: Source Table for LFBW
BUT_ADR2_ACTMaster Data Consolidation: Best Record Table for ADR2
MDC_BUT000OBSOLETE: Do not use!
MDC_MTC_BAS_TBAS Matching Configuration Description
KNB5_PRCMaster Data Consolidation: Process Table for KNB5
BUT021_FS_SRCMaster Data Consolidation: Source Table for BUT021_FS
LFA1_ASSGMNT_SRCSource Records Of OTC 147, Table LFA1_ASSGMNT
LFA1_AUSP_PRCProcess Records Of OTC 147, Table LFA1_AUSP
WYT3_SRCMaster Data Consolidation: Source Table for WYT3
MDC_MTC_TRACINGMaster Data Consolidation: Match Tracing
BUT_ADR12_ACTMaster Data Consolidation: Best Record Table for ADR12
KNVI_SRCMaster Data Consolidation: Source Table for KNVI
KNBW_SRCMaster Data Consolidation: Source Table for KNBW
LFM1_SRCMaster Data Consolidation: Source Table for LFM1
LFM2_ACTMaster Data Consolidation: Best Record Table for LFM2
MDC_BP_ADDR_MAPBP Address Mapping
BUT0IS_SRCMaster Data Consolidation: Source Table for BUT0IS
LFB1_ACTMaster Data Consolidation: Best Record Table for LFB1
KNBW_PRCMaster Data Consolidation: Process Table for KNBW
KNA1_AUSPClassification Characteristics for Customer (Template Table)
BUT_ADR3_SRCMaster Data Consolidation: Source Table for ADR3
BUT_ADR3_ACTMaster Data Consolidation: Best Record Table for ADR3
DFKKBPTAXNUM_ACTMaster Data Consolidation: Best Record Table DFKKBPTAXNUM
KNBW_ACTMaster Data Consolidation: Best Record Table for KNBW
KNA1_ASSGMNT_PRCProcess Records Of OTC 147, Table KNA1_ASSGMNT
BUT020_PRCMaster Data Consolidation: Process Table for BUT020
KNB5_SRCMaster Data Consolidation: Source Table for KNB5
BUT020_SRCMaster Data Consolidation: Source Table for BUT020
BUT_ADR6_SRCMaster Data Consolidation: Source Table for ADR12
BUT_ADRC_SRCMaster Data Consolidation: Source Table for ADRC
BUT100_ACTMaster Data Consolidation: Best Record Table for BUT100
KNB1_STXL_SRCSource Records Of OTC 147, Table KNB1_STXL
KNB5_ACTMaster Data Consolidation: Best Record Table for KNB5
KNVA_ACTMaster Data Consolidation: Best Record Table for KNVA
KNA1_STXH_PRCProcess Records Of OTC 147, Table KNA1_STXH
BUT100_PRCMaster Data Consolidation: Process Table for BUT100
KNB1_STXL_PRCProcess Records Of OTC 147, Table KNB1_STXL