SAP Master Data Tables
Are you looking for the right table related to SAP Master Data 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 Master Data (IS-U-MD) module.
Top 10 tables in Master Data
| Table | Description |
|---|---|
| TE185T | Texts: Work Fields for Installer |
| ENOTE | Allocation of Object to Note for Field Service |
| EREWARD | Reward Item |
| EBEVNTC | Business Event Category |
| EPRODDET | IS-U: Product Determination for Owner Move-in |
| ECRM_OBJ_TEMPL | Master Data Templates for CRM Technical Objects |
| ERWRDCATT | Reward Category (Texts) |
| TE130 | IS-U: Struc. Ind. and Cat. of Functional Loc. |
| TETECHINST | Allocation of division and technical installation |
| EVER | IS-U Cont. |
List of tables in Master Data
| Table | Description |
|---|---|
| TE185T | Texts: Work Fields for Installer |
| ENOTE | Allocation of Object to Note for Field Service |
| EREWARD | Reward Item |
| EBEVNTC | Business Event Category |
| EPRODDET | IS-U: Product Determination for Owner Move-in |
| ECRM_OBJ_TEMPL | Master Data Templates for CRM Technical Objects |
| ERWRDCATT | Reward Category (Texts) |
| TE130 | IS-U: Struc. Ind. and Cat. of Functional Loc. |
| TETECHINST | Allocation of division and technical installation |
| EVER | IS-U Cont. |
| EVERH | IS-U Contract History |
| EBEVNTCT | Business Event Category (Texts) |
| TE189T | Texts for Installer License Types |
| EGPLTX | Device Location Details (Language Dependent) |
| TE497 | Operation Type for Lighting Unit |
| TE241T | Franchise Fee Groups (Texts) |
| TE097T | Account Determ. IDs - Texts |
| EBP_ADDR_SERVICE | Search Index for Business Partner Service Addresses |
| TE102 | Premise Types |
| TE241 | Franchise Tax Groups |
| EPROPCA | Additional Activity for Automatic Owner Move-In |
| TE687 | Contract Cat. of Heat. Install. |
| ELOYALPRGT | Loyalty Program (Texts) |
| EAKLASSE | IS-U Billing Classes |
| EPROPC | General Settings for Owner Allocation |
| TE061T | Texts for Installer Status |
| TE13V | Location of Premise |
| TEB037 | Authorization Groups |
| EVBST | Premise: Language-Dependent Part |
| EAKLASSET | IS-U Billing Classes (Texts) |
| TE061 | Installer Status |
| ELOYALPRG | Loyalty Program |
| TECONTRACTCLASS | IS-U Contract Classes |
| TE001 | Alloc. of Co. Code - Division |
| TE645T | Contract Types for Franchise Contr. (Texts) |
| EREWARDT | Reward Item (Texts) |
| EGPLT | Device Location Details (Language Dependent) |
| ETINS | Technical information for the premise |
| TEB036 | Authorization Group Objects |
| ECRM_PROD_TEMPL | Master Data Template for CRM Products (Technical Objects) |
| TE133 | Location |
| EPROPH | Allocation of Inst. to Ownership |
| EKONH | Max. Prices/Quantities |
| EVBS | Premise |
| EPROP | Owner Allocation |
| TECONTRACTCLASST | IS-U Account Cat.Texts |
| EVST | Alloc. of ARCR to Ref. Val. |
| TE677 | Heat.Inst. Description |
| TE643 | Processing Status |
| TE097 | Account Determ. IDs |
| ERWRDCAT | Reward Category |
| ELACCZ | Loyalty Account Line Item |
| TE645 | Contract Types for Franchise Contr. |
| EKONG | Franchise Contributions by Customer/Utility Co. |
| TE183T | Text for Company Types |
| ENOTET | Text Table for Field Service Notes |
| TE13VT | Location of Premise (Texts) |
| EPROPCAT | Additional Activity for Automatic Owner Move-In |
| TE679 | Charging Control of Heat. Inst. |
| ERDMCANCT | Cancellation Reason (Texts) |
| ERDMCANC | Reason for Cancellation |
| EANLH | Install.Time Slice |
| TE759 | Reason for Supply Guarantee |
| TE102T | Premise Types (Texts) |
| EFISEL | Field Selection Control for Address Data |
| EHAUISU | Connect. Obj. |
| EREDEMP | Redemption Document for Loyalty Program |
| TE185 | Work Fields for Installer |
| ELACCTAB | Loyalty Account Display Control (Customizing) |
| TE759T | Reason for Supply Guarantee |
| TE183 | Co. Types |
| ELACC | Loyalty Account Header |
| TE681 | Processing Status of Heat. Inst. Special Agreement |
| TE189 | Installer License Types |
| TE643T | Processing Status Texts |
| ERDMSTAT | Redemption Status |
| TEB037T | Authorization Groups: Texts |
| EANL | Installation |
| ERDMSTATT | Redemption Status (Texts) |
| EKON | Franchise Contract MasterData |
| TEB036T | Authorization Group Objects: Texts |
| TE687T | Texts: Contract Cat. of Heat. Installation |
| TECHSTR | Changes to Street Names |
| EPRODDET_SEL | IS-U: CRM Product Sel Table (for type def, dont populate) |
| TE133T | Texts for Loc. |
| ECRM_TEMP_OBJ | CRM Integration: Clipboard for Technical Objects |
| ECRM_OBJ_MDTDV | Division Dependant MDT |