SAP Material Tables
Are you looking for the right table related to SAP Material 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 (PS-MAT) module.
Top 10 tables in Material
| Table | Description |
|---|---|
| TCNRFPT | Language Dependent Description of Reference Point |
| TCNIFPT | Language Dependent Text for BOM Transfer Profile |
| TCNIP01 | Control stock/account assignment for interface EBOM/PS |
| RSDBS | Index of purchasing documents for individual customer stock |
| PEGQTY | Assigned quantity of pegging objects |
| TCNMFT | Language dependent text table for TCNMF |
| PEGOB | Peg (master data of the CO object) |
| TPGPRF | Profile for static pegging and data distribution |
| MPE_BOM_PS_REL | SFI for end-item and major assembly |
| RCNIP03 | Specification of data fields for reference field |
List of tables in Material
| Table | Description |
|---|---|
| TCNRFPT | Language Dependent Description of Reference Point |
| TCNIFPT | Language Dependent Text for BOM Transfer Profile |
| TCNIP01 | Control stock/account assignment for interface EBOM/PS |
| RSDBS | Index of purchasing documents for individual customer stock |
| PEGQTY | Assigned quantity of pegging objects |
| TCNMFT | Language dependent text table for TCNMF |
| PEGOB | Peg (master data of the CO object) |
| TPGPRF | Profile for static pegging and data distribution |
| MPE_BOM_PS_REL | SFI for end-item and major assembly |
| RCNIP03 | Specification of data fields for reference field |
| TCNMF | Material flow in the network |
| LFINFX | Assignment delivery information to Project System objects |
| LFINF | Delivery information Project System |
| TPGPRFT | Text table for pegging profile |
| TCNIFP | Profile for BOM transfer |
| TCNRFP | Reference Point for BOM transfer |
| TCNIF | Assembly item/WBS element assignment BOM transfer |
| RSADD | Additional fields for reservation |
| GRPGV | Validity of grouping WBS elements for plant/MRP group |
| PGWIL | Work item list for static pegging |
| GRPGA | Assignment of WBS elements to MRP WBS elements |
| RSPSP | Index: Reservations for WBS elements/Sales order items |