MATNR in PPH_DBVM
Material
MATNR is a field in SAP table PPH_DBVM (Planning File Entry, MRP Area). It represents "Material". Data element: MATNR. Available in 38 CDS view(s) as matnr, Material, MaterialID.
Business Meaning
| Description (EN) | Material |
|---|---|
| Beschreibung (DE) | Material |
| Data Element | MATNR |
| Key Field | Yes |
CDS Views & Technical Names (38)
PPH_DBVM.MATNR is exposed in CDS views under the following technical names. Views reading the table directly are listed first; "via" marks views that pass the field on through intermediate views.
matnr
(20 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| FSH_V_PLANNING_FILE_ENTRIES | direct | Planning File entries for Fashion | ||
| MDCV_E_DBVL | direct | Compatibility View for DBVL | ||
| MDCV_E_DBVM | direct | Compatibility View for DBVM | ||
| P_DD_MAT_ADDLINFO | direct | BASIC | Demand Driven Material information | |
| P_PPH_MRP_ISSUES | direct | BASIC | ||
| P_PPH_MRP_ISSUES_ND | direct | BASIC | Selection for NODISP Materials | |
| P_PPH_MRP_MAT | direct | BASIC | ||
| PPH_DD_MAT_CTRL_0 | direct | DD Materials | ||
| PPH_DDL_MAT_CTRL_0 | direct | View for reading master data | ||
| P_DD_MAT_ADDLINFO1 | via 2 level | BASIC | Demand Driven Material information | |
| PPH_DD_MAT_CTRL_1 | via 2 level | DD Materials | ||
| pph_e_mat_ctrl_1 | via 2 level | View for reading master data | ||
| PPH_DD_MAT_CTRL | via 3 levels | DD Materials | ||
| pph_e_mat_ctrl | via 3 levels | |||
| PPH_DD_MAT | via 4 levels | DD Materials | ||
| pph_e_mat_ctrl_dd | via 4 levels | Material Data for DDMRP | ||
| PPH_ENT_MAT_CTRL_DD | via 4 levels | Material Data for DDMRP | ||
| Pph_MatlocForPlanFileEntry | via 4 levels | ProductSettings for Plan File Entries | ||
| PPH_PICMpnSet | via 5 levels | PIC MPN Sets with NetChange | ||
| PPH_PICSupersessionGroup | via 5 levels | Supersession Materials with NetChange |
Material
(17 views)
Material Number
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_MRPAreaPlanningFileEntry | direct | BASIC | MRP Area Planning File Entry | |
| P_MatlMRPArea | direct | BASIC | ||
| P_MRPMATERIAL | direct | BASIC | ||
| I_MRPMasterDataIssueBasic | via 2 level | BASIC | Master Data Related Issues of an MRP Run | |
| I_MRPMaterial | via 2 level | COMPOSITE | MRP Material | |
| P_MatlMRPAreaStorLoc | via 2 level | BASIC | ||
| A_MRPMaterial | via 3 levels | COMPOSITE | Master Data | |
| C_MRPMaterialCard | via 3 levels | CONSUMPTION | MRP Material | |
| I_MaterialMRPAreaStorLoc | via 3 levels | BASIC | Storage Locations of MRP Area for Material | |
| I_MaterialTimeDependentStock | via 3 levels | COMPOSITE | List of Time Dependent Stock Materials | |
| I_MRPMasterDataIssue | via 3 levels | COMPOSITE | Master data related issue that occurred during an MRP run | |
| P_MRPMasterDataIssueCntMsgType | via 3 levels | COMPOSITE | ||
| P_MRPMasterDataIssueCount | via 3 levels | COMPOSITE | ||
| I_MRPMasterDataIssueTP | via 4 levels | TRANSACTIONAL | Transactional Processing for a MRP Master Data Issue | |
| R_MatlTimeDependentStockTP | via 4 levels | TRANSACTIONAL | Time Dependent Stock Materials | |
| C_MaterialTimeDependentStock | via 5 levels | CONSUMPTION | Material Time Dependent Stock | |
| C_MRPMasterDataIssueTP | via 5 levels | CONSUMPTION |
MaterialID
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| Pphmrp_Error_Mats | direct | Attributes for Displaying Materials with Issues in last MRP |
Other Tables with Field MATNR (50+)
| Table | Data Element | Key | Description |
|---|---|---|---|
| /ACCGO/T_CAS_CAI | MATNR | CA Application Document Item.. | |
| /ACCGO/T_DGR_BBB | MATNR | KEY | DGR Beginning Book Balance |
| /ACCGO/T_EVTREG | MATNR | Settlement Event Registry (Rev/Rec & Purchase Realization) | |
| /ACCGO/T_GRPLIEN | MATNR | Settlement Group Lien Table | |
| /ACCGO/T_SCH_HST | MATNR | KEY | DGR Reporting - Maintained Volume Schedule History |
| /ACCGO/T_SNPIT1 | MATNR | Contract Item | |
| /ACCGO/T_STLITEM | MATNR | Settlement Item Table | |
| /ACCGO/T_STLLIEN | MATNR | Settlement Lien holder table | |
| /ACCGO/T_STRG_QH | MATNR | Comingle: Quantity History for Application Document Item | |
| /ACCGO/T_WASH_I | MATNR | Item table for Non standard washout process | |
| /CEECV/ROCOWNID | MATNR | KEY | SAF-T RO: Owner IDs |
| /CPD/PWS_RCB_BPF | /CPD/PWS_RCB_MATNR | Fixed Price Billing Plan Manager | |
| /CUM/AFCU | MATNR | CU: CU Instances | |
| /DSD/SL_SLD_QBAL | MATNR | KEY | Settlement Document: Quantity Differences |
| /DSD/SL_SLD_QDET | MATNR | KEY | Settlement Document: Quantity Differences, Diff. Reasons |
| /DSD/SV_QUANT | MATNR | DSD SV Truck Stock | |
| /LIME/PI_IT_BIZ | MATNR | Physical Inventory Document Business Key Item Object | |
| /NFM/TVGW | MATNR | KEY | NFK Charge Weights for Materials on Organizational Level |
| /PLMI/ECR_CI_MAT | MATNR | Material change items | |
| /PRA/ACCT_DOC | MATNR | Accounting document (All account types) | |
| /PRA/ACCT_MDOC | MATNR | Account document(JE) details for a Manual | |
| /PRA/DXGP_DOCNGL | MATNR | Document Extraction - Gas Plant NGL Details | |
| /PRA/DXGP_PD_XRF | MATNR | Gas Plant Statement Product Xref | |
| /PRA/FF_CTV_D | MATNR | Contract Volumes Details | |
| /PRA/FF_RESULTSA | MATNR | KEY | Allocation Results - Actual |
| /PRA/FF_RESULTSE | MATNR | KEY | Allocation Results - Entitled |
| /PRA/GA_SHRINK | MATNR | KEY | Shrink Factor details Database table |
| /PRA/PD_AL | MATNR | KEY | Product Allocation Rules Details |
| /PRA/RD_CRH | MATNR | Combined Run Header Table | |
| /PRA/VL_ACC_DOC | MATNR | Temporary Accounting document (All account types) | |
| /PRA/VL_VDOI_MKT | MATNR | KEY | Mkt group allocation decimals for units |
| /SAPAPO/CUSSTKUP | /SAPAPO/MATNR | KEY | Customer Stock Update Information |
| /SAPAPO/IBP_SFST | MATNR | KEY | eSPP - Safety Stock from IBP |
| /SAPAPO/MATKEY | /SAPAPO/MATNR | Product | |
| /SAPAPO/MATMAP | /SAPAPO/MATNR | Mapping Table for Products | |
| /SAPAPO/MATPLSTA | /SAPAPO/MATNR | Location Product: Specific Planning Status per Application | |
| /SAPCEM/VS1 | MATNR | Generated Table for View | |
| /SAPCEM/VS3 | MATNR | Generated Table for View | |
| /SAPSLL/CLDIT | MATNR | Trade Compliance Document: Item Data | |
| /SAPSLL/LCLICM | MATNR | License Master - Materials | |
| /SAPSLL/MARITC | MATNR | Material Trade Classification | |
| /SAPSLL/MARITEC | MATNR | Material Trade Classification with End-Use | |
| /SAPSLL/MARLRG | MATNR | Material Legal Control | |
| /SAPSLL/PRAICA | MATNR | Product Classification AI Attributes | |
| /SAPSLL/PRTCP | MATNR | Product Classification Proposal | |
| /SCWM/BINMAT | /SCWM/DE_MATNR | Assignment Table for Fixed Bins - Product | |
| /SCWM/LDP_HIST | /SCWM/DE_MATNR | Historical workload data | |
| /SCWM/WAVEITM | /SCWM/DE_MATNR | Wave Item | |
| /SMB/BB_PRJ_H | /SMB/MATNR_ALPHA | Scenario Header | |
| /SMB/SIC | /SMB/MATNR_ALPHA | Scope Item Common Data - Header |
Showing the first 50 tables. Search all occurrences →
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA