SAP Customer Master Tables

Are you looking for the right table related to SAP Customer Master 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 Customer Master (LO-MD-BP-CM) module.

Top 10 tables in Customer Master

TableDescription
TVSBShipping Conditions
KNZAPermitted Alternative Payer
DUEFL_TABFixing of Source Status or DUEFL at Pre Step Time
CRMKTOKDAssign Classification and Grouping R/3 Account Groups
TIBAN_WO_ACCNOActivation of "IBAN without Bank Account Number"
TB072_CMTax Classification: Mapping R/3 <-> CRM
TB071_CMTax Classification: Assignment of Tax Groups to Tax Types
ERPD_MKTTG_TG_I2TG Exchange: Target Group Item (Product Info)
TB070T_CMTax Classification: Tax Types per Country, Names
ERPD_MKTTG_TG_HTG Exchange: Target Group Header

List of SAP tables for Customer Master

TableDescription
TVSBShipping Conditions
KNZAPermitted Alternative Payer
DUEFL_TABFixing of Source Status or DUEFL at Pre Step Time
CRMKTOKDAssign Classification and Grouping R/3 Account Groups
TIBAN_WO_ACCNOActivation of "IBAN without Bank Account Number"
TB072_CMTax Classification: Mapping R/3 <-> CRM
TB071_CMTax Classification: Assignment of Tax Groups to Tax Types
ERPD_MKTTG_TG_I2TG Exchange: Target Group Item (Product Info)
TB070T_CMTax Classification: Tax Types per Country, Names
ERPD_MKTTG_TG_HTG Exchange: Target Group Header
T686DContact Person: Responsibilities in SD: Texts
TKUNDEBUKRSReference Customer per Company Code (Consumer Master)
TVGFLegal Status (Customer Master)
TVK1TAttribute 1 texts (customer master)
TVK0Attribute 10 (customer master)
TVK3TAttribute 3 texts (customer master)
TVRLRelevance of Bill of Material Items for SD
TB077_CMAssignment of R/3 Field to CRM Tax Type
TVBOSales Rebate Groups
TVK7TAttribute 7 texts (customer master)
TIBAN_APARUnconfirmed IBANs and Their Correct Validity Start
TVKPReference Customer Determination for Consumer(s)
TVK1Attribute 1 (customer master)
CRMCLASSIFAccount Groups in Replication into R/3
TVK6Attribute 6 (customer master)
T079DCompany code-dependent screen sel.for cust.master
TVPRTCommission Group Texts
T078DTrans.-dependent screen selection for cust.master
TVPHContact Person: Hobbies
TVK2Attribute 2 (customer master)
TVK9TAttribute 9 texts (customer master)
TVRLTRelevance of Bill of Material Items for SD
TVK6TAttribute 6 texts (customer master)
KNB4Customer Payment History
TVK7Attribute 7 (customer master)
TSAVXAssignment of Key to Tables TSAV and TSADV
TVK4Attribute 4 (customer master)
TBRCIndustry Code (Customer Master)
KNVACustomer Master Unloading Points
TVK8Attribute 8 (customer master)
TKUNDEVTBERReference Customer per Sales Area (Consumer Master)
TVKGGTTexts for Customer Condition Groups (Customer Master)
TBRCTIndustry code text (customer master)
TVK0TAttribute 10 texts (customer master)
TVK9Attribute 9 (customer master)
CRMKUNNRMapping Table Business Partner - Customer
TVBZCustomer region
KNVKCustomer Master Contact Partner
KNB1Customer Master (Company Code)
T079VCustomers: Screen Selection according to Sales Org.
CRMPARNRMapping Table Business Partner Relationship - Contact Person
TVK4TAttribute 4 texts (customer master)
TVIPContact Person: VIP Indicator
TVGFTLegal status text (customer master)
KNASCustomer master (VAT registration numbers general section)
CRMKNVVFILIndicator: Completely Filter Customer Data Relating to KNVV
TCONV_ADRConversion of Old Address Fields to CAM Address Fields
KNA1General Data in Customer Master
T077XAccount Group Names (Table T077D)
TVK3Attribute 3 (customer master)
TVBOTSales Rebate Groups: Texts
TVK5Attribute 5 (customer master)
TVWACustomers: Goods receiving hours (default values)
ERPD_MKTTG_TG_ITG Exchange: Target Group Item (BP Info)
TVPVContact Person: Decision Authority
TVK5TAttribute 5 texts (customer master)
TVPRCommission Groups
KNB5Customer master (dunning data)
TB078_CMAssignment of R/3 Field Value to CRM Tax Group
TVMSMaterials: Status in Sales and Distribution
KNVPCustomer Master Partner Functions
TVKGGCustomer Condition Groups (Customer Master)
TVWATCustomers: Goods Receiving Hours: Texts
SHLP_FILTER_CVCustomizing Table for Filtering Search Helps
TVIPTContact Person: Texts for the VIP code
ERPD_MKTTG_TG_TTG Exchange: Target Group Text
TVSBTShipping Conditions: Texts
TVPHTContact Person Hobbies: Texts
KNVVCustomer Master Sales Data
KNBKCustomer Master (Bank Details)
TVK8TAttribute 8 texts (customer master)
TVMSTMaterials: SD Status: Texts
TB070_CMTax Classification: Tax Types per Country
CRMTEXTIDMapping of Text IDs Between R/3 and CRM
TVK2TAtribute 2 texts (customer master)
TVPVTContact Person Decision Authority: Texts
T077DCustomer account groups