MATNR in EQUI
Material
MATNR is a field in SAP table EQUI (Equipment master data). It represents "Material". Data element: MATNR. Available in 93 CDS view(s) as Material, matnr.
Business Meaning
| Description (EN) | Material |
|---|---|
| Beschreibung (DE) | Material |
| Data Element | MATNR |
| Key Field | No |
CDS Views & Technical Names (93)
EQUI.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.
Material
(83 views)
Material Number
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| E_EquipMatlSerialNumber | direct | EXTENSION | Material Serial Numbers - Extension | |
| I_Equipment | direct | BASIC | Equipment | |
| A_Equipment | via 2 level | COMPOSITE | Equipment | |
| C_DFS_EquipSerialNumberVH | via 2 level | CONSUMPTION | Equipment By Serial Number Seach Help | |
| C_EquipMaterialSerialNumber2VH | via 2 level | CONSUMPTION | Consumption of Equipment F4 Help | |
| C_EquipmentDataDEX | via 2 level | CONSUMPTION | Equipment Data for Data Product | |
| C_MaintItmEquipMatlSrlNmbrVH | via 2 level | CONSUMPTION | Maintenance Item Equipment | |
| C_RegistrableTestEquipmentVH | via 2 level | CONSUMPTION | All Equipment PRTs | |
| C_SerialNumberObjPage | via 2 level | CONSUMPTION | Serial Number Object Page | |
| C_SerialNumbersForGdsMvtVH | via 2 level | CONSUMPTION | Value Help for Serial numbers for Goods Movement | |
| C_SrlNmbrAvailableForAssyVH | via 2 level | CONSUMPTION | Serial number available for assembly | |
| C_UtilitiesDeviceHistoryDEX | via 2 level | CONSUMPTION | Data Extractor for Device History | |
| ESH_N_MATSLNS | via 2 level | |||
| I_AuthzdActlEquipmentDetails | via 2 level | COMPOSITE | View of Equipments relevant for AAC | |
| I_AvailMaterialSerialNumberVH | via 2 level | COMPOSITE | Available Material Serial Number | |
| I_DFS_MaintMasterEquipDetails | via 2 level | COMPOSITE | Interface view of master equip details | |
| I_DFS_MaintStsBrdEquipment | via 2 level | COMPOSITE | Interface view for Status Board Equip | |
| I_EquipMaterialSerialNumberVH | via 2 level | COMPOSITE | Equipment | |
| I_EquipMatlSerialNumber | via 2 level | COMPOSITE | Material Serial Number | |
| I_EquipmentData | via 2 level | COMPOSITE | Equipment Data | |
| I_MaintOrdActlPlndCostCube | via 2 level | COMPOSITE | Maint Order Actual Planned Cost - Cube | |
| I_MaterialSerialNumberVH | via 2 level | COMPOSITE | Material Serial Number | |
| I_MatlSerialNumberInformation | via 2 level | COMPOSITE | Serial Number Information | |
| I_SerialNumberStockSegment | via 2 level | BASIC | Serial Number Stock Segment | |
| I_SerialNumberValueHelp | via 2 level | BASIC | Selection Help for Serial Numbers | |
| I_SerialNumberWithStkSgmtVH | via 2 level | BASIC | Help-View for serial numbers | |
| I_TechnicalObjectUnion | via 2 level | COMPOSITE | Technical Object Union | |
| P_EquipMatlSerialNumberStatus | via 2 level | COMPOSITE | ||
| P_EquipmentFuncnlLocUnion | via 2 level | COMPOSITE | ||
| P_EquipmentSearch | via 2 level | BASIC | ||
| P_MfgProcgExecAssembledSrlNmbr | via 2 level | COMPOSITE | ||
| P_MfgProcgExecNonAssySrlNmbr | via 2 level | COMPOSITE | ||
| P_UnplndRegnProdnRsceTool | via 2 level | COMPOSITE | ||
| R_EquipmentTP | via 2 level | TRANSACTIONAL | Equipment | |
| C_EquipMaterialSerialNumberVH | via 3 levels | CONSUMPTION | Consumption of Equipment | |
| C_MaterialSerialNumberVH | via 3 levels | CONSUMPTION | List of Material Serial Numbers | |
| C_MatlSerialNumberInformation | via 3 levels | CONSUMPTION | Material Serial Number Information | |
| C_SerialNumberValueHelp | via 3 levels | CONSUMPTION | Selection Help for Serial Numbers | |
| ESH_N_EQUIPMENT | via 3 levels | |||
| ESH_S_MATSLNS | via 3 levels | |||
| I_DFS_EquipmentBasicDEX | via 3 levels | COMPOSITE | Defense Equipment Extractor | |
| I_DFS_MaintEquipment | via 3 levels | COMPOSITE | Interface view of Equipment | |
| I_DFS_MaintStsBrdCriticalEquip | via 3 levels | COMPOSITE | Interface view of Status Board CSEQ | |
| I_DFS_MaintStsBrdMasterEquip | via 3 levels | COMPOSITE | Interface view of Status Board MEQ | |
| I_DFS_MaintStsBrdSiteEquip | via 3 levels | COMPOSITE | Interface for Site Equipment | |
| I_EquipMatlSrlNumberWarranty | via 3 levels | COMPOSITE | Material Serial Number Warranty | |
| I_EquipmentTP | via 3 levels | TRANSACTIONAL | Equipment - TP | |
| I_FldLogsSrlNmbrWithStkSgmtVH | via 3 levels | BASIC | Serialized Material Available in Stocks in Field Logistics | |
| I_ShopFloorItemBatchSerialNmbr | via 3 levels | COMPOSITE | Shop Floor Item Batch and Serial Number | |
| I_TechnicalObject | via 3 levels | COMPOSITE | Technical Object | |
| I_UnplndRegnProdnRsceToolVH | via 3 levels | COMPOSITE | Unplanned Registration PRT | |
| P_EquipMatlSerialNumStatusAggr | via 3 levels | COMPOSITE | ||
| P_SrlNmbrStockDiffSrlStockSgmt | via 3 levels | COMPOSITE | Serial Number Stock Info | |
| R_EquipMatlSerialNumberTP | via 3 levels | TRANSACTIONAL | Material Serial Number - TP | |
| R_EquipMatlSrlNmbrPrtnTP | via 3 levels | TRANSACTIONAL | Partner of Material Serial Number - TP | |
| A_EquipMatlSerialNumber | via 4 levels | CONSUMPTION | Material Serial Number | |
| A_EquipMatlSrlNmbrPartner | via 4 levels | COMPOSITE | Partner for Material Serial Number | |
| C_EquipMaterialSerialNumberTP | via 4 levels | CONSUMPTION | ||
| C_EquipMatlSrlNmbrPrtnTP | via 4 levels | CONSUMPTION | Consumption for Partner | |
| C_MfgProcgExecSFIAndBatch | via 4 levels | CONSUMPTION | Shop Floor Item And Batch | |
| C_ObjPgTechnicalObjectWthDesc | via 4 levels | CONSUMPTION | Obj Page for Technical Object with Desc | |
| C_UnplndRegnProdnRsceToolVH | via 4 levels | CONSUMPTION | Unplanned Registration PRT | |
| ESH_S_EQUIPMENT | via 4 levels | |||
| I_DFS_EquipmentDEX | via 4 levels | COMPOSITE | Defense Equipment Extractor | |
| I_DFS_MaintCritlEquipStructure | via 4 levels | COMPOSITE | Critical Equipment Structure | |
| I_DFS_MaintCritlFuncnlLocStruc | via 4 levels | COMPOSITE | Functional Loc Data for Critical Equip | |
| I_DFS_MaintStatusBoard | via 4 levels | COMPOSITE | Interface View of Status Board | |
| I_EquipMatlSerialNumberTP | via 4 levels | TRANSACTIONAL | Material Serial Number - TP | |
| I_EquipMatlSrlNmbrPrtnTP | via 4 levels | TRANSACTIONAL | Partner of Material Serial Number - TP | |
| I_EquipMatlSrlNumberStatus | via 4 levels | COMPOSITE | Status of Material Serial Number | |
| I_TechnicalObjectNode | via 4 levels | COMPOSITE | Technical Object Node | |
| I_TechnicalobjectTP | via 4 levels | TRANSACTIONAL | Technical Object with Draft | |
| P_SrlNmbrStockDiffSrlNmbrStock | via 4 levels | COMPOSITE | Serial Number Stock Quantity | |
| R_EquipMatlSrlNmbrCustWrntyTP | via 4 levels | TRANSACTIONAL | MatlSrlNmbr Customer Warranty - TP | |
| R_EquipMatlSrlNmbrVndrWrntyTP | via 4 levels | TRANSACTIONAL | MatlSrlNmbr Supplier Warranty - TP | |
| R_EquipMatlSrlNmbrWarrantyTP | via 4 levels | TRANSACTIONAL | Material Serial Number Warranty - TP | |
| A_EquipMatlSrlNmbrCustWrnty | via 5 levels | CONSUMPTION | Material Serial Number Customer Warranty | |
| A_EquipMatlSrlNmbrVndrWrnty | via 5 levels | CONSUMPTION | Material Serial Number Vendor Warranty | |
| C_EquipMatlSrlNmbrCustWrntyTP | via 5 levels | CONSUMPTION | Material Serial Number Customer Warranty | |
| C_EquipMatlSrlNmbrVndrWrntyTP | via 5 levels | CONSUMPTION | Material Serial Number Vendor Warranty | |
| C_TechObjLabelHierarchyVH | via 5 levels | CONSUMPTION | Search by Technical Object Hierarchy | |
| I_EquipMatlSrlNmbrCustWrntyTP | via 5 levels | TRANSACTIONAL | MatlSrlNmbr Customer Warranty - TP | |
| I_EquipMatlSrlNmbrVndrWrntyTP | via 5 levels | TRANSACTIONAL | MatlSrlNmbr Vendor Warranty - TP |
matnr
(10 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| CRMS4_IU_I_DEV | direct | Device | ||
| CRMS4_IU_I_DEVH | direct | Device History | ||
| CRMS4_IU_P_DEVINL | direct | Device by Installation | ||
| CRMS4_IU_C_DEV | via 2 level | Device | ||
| CRMS4_IU_C_DEVH | via 2 level | Device History | ||
| CRMS4_IU_C_DEVINL | via 2 level | Device by Installation | ||
| CRMS4_IU_C_CONVAR_DEVPOD | via 3 levels | Con. Object by Various Fields (Dev, PoD) | ||
| CRMS4_IU_C_REG | via 3 levels | Register | ||
| SHSM_SERMAT | via 3 levels | CDS View replacing M_EQUIO in search help | ||
| SHSM_SERMATKEY | via 3 levels | CDS View for search help |
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