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
| Table | Description |
|---|---|
| TVSB | Shipping Conditions |
| KNZA | Permitted Alternative Payer |
| DUEFL_TAB | Fixing of Source Status or DUEFL at Pre Step Time |
| CRMKTOKD | Assign Classification and Grouping R/3 Account Groups |
| TIBAN_WO_ACCNO | Activation of "IBAN without Bank Account Number" |
| TB072_CM | Tax Classification: Mapping R/3 <-> CRM |
| TB071_CM | Tax Classification: Assignment of Tax Groups to Tax Types |
| ERPD_MKTTG_TG_I2 | TG Exchange: Target Group Item (Product Info) |
| TB070T_CM | Tax Classification: Tax Types per Country, Names |
| ERPD_MKTTG_TG_H | TG Exchange: Target Group Header |
List of tables in Customer Master
| Table | Description |
|---|---|
| TVSB | Shipping Conditions |
| KNZA | Permitted Alternative Payer |
| DUEFL_TAB | Fixing of Source Status or DUEFL at Pre Step Time |
| CRMKTOKD | Assign Classification and Grouping R/3 Account Groups |
| TIBAN_WO_ACCNO | Activation of "IBAN without Bank Account Number" |
| TB072_CM | Tax Classification: Mapping R/3 <-> CRM |
| TB071_CM | Tax Classification: Assignment of Tax Groups to Tax Types |
| ERPD_MKTTG_TG_I2 | TG Exchange: Target Group Item (Product Info) |
| TB070T_CM | Tax Classification: Tax Types per Country, Names |
| ERPD_MKTTG_TG_H | TG Exchange: Target Group Header |
| T686D | Contact Person: Responsibilities in SD: Texts |
| TKUNDEBUKRS | Reference Customer per Company Code (Consumer Master) |
| TVGF | Legal Status (Customer Master) |
| TVK1T | Attribute 1 texts (customer master) |
| TVK0 | Attribute 10 (customer master) |
| TVK3T | Attribute 3 texts (customer master) |
| TVRL | Relevance of Bill of Material Items for SD |
| TB077_CM | Assignment of R/3 Field to CRM Tax Type |
| TVBO | Sales Rebate Groups |
| TVK7T | Attribute 7 texts (customer master) |
| TIBAN_APAR | Unconfirmed IBANs and Their Correct Validity Start |
| TVKP | Reference Customer Determination for Consumer(s) |
| TVK1 | Attribute 1 (customer master) |
| CRMCLASSIF | Account Groups in Replication into R/3 |
| TVK6 | Attribute 6 (customer master) |
| T079D | Company code-dependent screen sel.for cust.master |
| TVPRT | Commission Group Texts |
| T078D | Trans.-dependent screen selection for cust.master |
| TVPH | Contact Person: Hobbies |
| TVK2 | Attribute 2 (customer master) |
| TVK9T | Attribute 9 texts (customer master) |
| TVRLT | Relevance of Bill of Material Items for SD |
| TVK6T | Attribute 6 texts (customer master) |
| KNB4 | Customer Payment History |
| TVK7 | Attribute 7 (customer master) |
| TSAVX | Assignment of Key to Tables TSAV and TSADV |
| TVK4 | Attribute 4 (customer master) |
| TBRC | Industry Code (Customer Master) |
| KNVA | Customer Master Unloading Points |
| TVK8 | Attribute 8 (customer master) |
| TKUNDEVTBER | Reference Customer per Sales Area (Consumer Master) |
| TVKGGT | Texts for Customer Condition Groups (Customer Master) |
| TBRCT | Industry code text (customer master) |
| TVK0T | Attribute 10 texts (customer master) |
| TVK9 | Attribute 9 (customer master) |
| CRMKUNNR | Mapping Table Business Partner - Customer |
| TVBZ | Customer region |
| KNVK | Customer Master Contact Partner |
| KNB1 | Customer Master (Company Code) |
| T079V | Customers: Screen Selection according to Sales Org. |
| CRMPARNR | Mapping Table Business Partner Relationship - Contact Person |
| TVK4T | Attribute 4 texts (customer master) |
| TVIP | Contact Person: VIP Indicator |
| TVGFT | Legal status text (customer master) |
| KNAS | Customer master (VAT registration numbers general section) |
| CRMKNVVFIL | Indicator: Completely Filter Customer Data Relating to KNVV |
| TCONV_ADR | Conversion of Old Address Fields to CAM Address Fields |
| KNA1 | General Data in Customer Master |
| T077X | Account Group Names (Table T077D) |
| TVK3 | Attribute 3 (customer master) |
| TVBOT | Sales Rebate Groups: Texts |
| TVK5 | Attribute 5 (customer master) |
| TVWA | Customers: Goods receiving hours (default values) |
| ERPD_MKTTG_TG_I | TG Exchange: Target Group Item (BP Info) |
| TVPV | Contact Person: Decision Authority |
| TVK5T | Attribute 5 texts (customer master) |
| TVPR | Commission Groups |
| KNB5 | Customer master (dunning data) |
| TB078_CM | Assignment of R/3 Field Value to CRM Tax Group |
| TVMS | Materials: Status in Sales and Distribution |
| KNVP | Customer Master Partner Functions |
| TVKGG | Customer Condition Groups (Customer Master) |
| TVWAT | Customers: Goods Receiving Hours: Texts |
| SHLP_FILTER_CV | Customizing Table for Filtering Search Helps |
| TVIPT | Contact Person: Texts for the VIP code |
| ERPD_MKTTG_TG_T | TG Exchange: Target Group Text |
| TVSBT | Shipping Conditions: Texts |
| TVPHT | Contact Person Hobbies: Texts |
| KNVV | Customer Master Sales Data |
| KNBK | Customer Master (Bank Details) |
| TVK8T | Attribute 8 texts (customer master) |
| TVMST | Materials: SD Status: Texts |
| TB070_CM | Tax Classification: Tax Types per Country |
| CRMTEXTID | Mapping of Text IDs Between R/3 and CRM |
| TVK2T | Atribute 2 texts (customer master) |
| TVPVT | Contact Person Decision Authority: Texts |
| T077D | Customer account groups |