SAP Material Maintenance Tables
Are you looking for the right table related to SAP Material Maintenance 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 Material Maintenance (SD-MD-MM) module.
Top 10 tables in Material Maintenance
| Table | Description |
|---|---|
| T171T | Customers: Sales districts: Texts |
| TVSGT | Sales Statistics Groups: Texts |
| TPFK | Contact Persons: Functions |
| T151T | Customers: Customer groups: Texts |
| TASSIGN_SD_VKORG | Aux. Table for Status Info SD Maintenance View: Key VKORG |
| TVE1T | Shipping Unit Group 1: Texts |
| TVSDT | Customers: Statistics groups: Texts |
| TVKMT | Material: Account Assignment Group Texts |
| TVKM | Materials: Account Assignment Groups |
| TASSIGN_SD_VKBUR | Help Table for Status Info on SD Maint. Views: Key VKBUR |
List of tables in Material Maintenance
| Table | Description |
|---|---|
| T171T | Customers: Sales districts: Texts |
| TVSGT | Sales Statistics Groups: Texts |
| TPFK | Contact Persons: Functions |
| T151T | Customers: Customer groups: Texts |
| TASSIGN_SD_VKORG | Aux. Table for Status Info SD Maintenance View: Key VKORG |
| TVE1T | Shipping Unit Group 1: Texts |
| TVSDT | Customers: Statistics groups: Texts |
| TVKMT | Material: Account Assignment Group Texts |
| TVKM | Materials: Account Assignment Groups |
| TASSIGN_SD_VKBUR | Help Table for Status Info on SD Maint. Views: Key VKBUR |
| TTXER | Text Processing: Text ID Groups |
| T134G | Organization Unit: Business Area Determination |
| TVE4 | Shipping Unit Group 4 |
| TVE1 | Shipping Unit Group 1 |
| TVE5 | Shipping Unit Group 5 |
| TTGR | Delivery Scheduling: Transportation Groups |
| TVEPT | Sales Documents: Schedule Line Categories: Texts |
| T686C | Contact Person: Responsibilities in Sales and Distribution |
| TMVF | Availability Check Control |
| TVZB | Customers: Terms of payment |
| TVE5T | Shipping Unit Group 5: Texts |
| TKUKL | Customers: Customer Classifications |
| TVE2 | Shipping Unit Group 2 |
| TVSHP | Shipping Parameters at Client-level |
| TVSM | Material statistics groups |
| TPTM | Materials: Item Category Groups in Material Master |
| TTXVR | Text Processing: Copy Control Texts |
| T180Z | Reporting: Display Variants |
| TPFKT | Contact Partner Functions: Texts |
| T188T | Conditions: Groups for Customer Classes: Texts |
| T171 | Customers: Sales Districts |
| TKUKT | Customers: Customer classification: Texts |
| TVE4T | Shipping Unit Group 4: Texts |
| T178 | Conditions: Groups for Materials |
| TVE3T | Shipping Unit Group 3: Texts |
| T151 | Customers: Customer Groups |
| T683C | Batch Search Procedure: Determination in Sales Docs |
| TVE3 | Shipping Unit Group 3 |
| TPAR | Business Partner: Functions |
| T189T | Conditions: Price List Categories: Texts |
| TVIND | Sales Document: Update of Material and Validity Index |
| TTXS | Text Processing: Text Type in Text Proc. -> Access Sequence |
| TTGRT | Shipping Scheduling: Transportation Groups: Texts |
| CFG_SD_SLSORGADR | CBC - DDIC for eCATT /SMB99/SM30_O503_101 |
| T630R | Delivery Scheduling: Pick/Pack Time for Materials |
| TVSD | Customers: Statistics groups |
| T179 | Materials: Product Hierarchies |
| TSABT | Contact Person Departments: Texts |
| CFG_SD_SLSOFFADR | CBC - DDIC for eCatt /SMB99/SM30_O005_J02 |
| TMVFP | Availability Check: Blocks |
| TVZBT | Customers: Terms of Payment Texts |
| TVKDT | Customer Pricing Procedures: Texts |
| T178T | Conditions: Groups for Materials: Texts |
| TVE2T | Shipping Unit Group 2: Texts |
| TTXERN | Text Processing: Text ID Groups covers ttxs & ttxer |
| T181T | Reporting: Screen Texts for Sales |
| T188 | Conditions: Groups for Customer Classifications |
| TVST | Organizational Unit: Shipping Points |
| TPHCNV | Data for Product Hierarchy Conversion |
| TKUPA | Business Partners: Customer Master Groups |
| T189 | Conditions: Price List Types |