MATNR in MARA
Material
MATNR is a field in SAP table MARA (General Material Data). It represents "Material". Data element: MATNR. Available in 137 CDS view(s) as Product, matnr, material.
Business Meaning
| Description (EN) | Material |
|---|---|
| Beschreibung (DE) | Material |
| Data Element | MATNR |
| Key Field | Yes |
CDS Views & Technical Names (137)
MARA.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.
Product
(42 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| E_Product | direct | EXTENSION | Extension view product core (MARA) | |
| E_Productprocurement | direct | EXTENSION | Product Master Procurement Extension | |
| E_Productsales | direct | EXTENSION | Product Master Sales Extension | |
| E_Productstorage | direct | EXTENSION | Product Master Storage Extension | |
| I_ACMMaterialDetails | direct | BASIC | ACM Material Details | |
| I_JITOutbMaterialId | direct | BASIC | JIT S2P - S2L Material ID | |
| I_ProdPlntInptAssistant | direct | BASIC | Input Assistance for Product Plant | |
| I_ProductESPP | direct | BASIC | Product ESPP active core entity | |
| I_Productprocurement | direct | BASIC | Product Procurement | |
| I_ProductSales | direct | BASIC | Product Sales | |
| I_Productscm | direct | BASIC | Product SCM | |
| I_Productstorage | direct | BASIC | Product Storage | |
| I_ProductStorage_2 | direct | BASIC | Product Storage | |
| I_RFM_ProductCharcValue1Txt | direct | BASIC | Product characteristics value 1 | |
| I_RFM_ProductCharcValue2Txt | direct | BASIC | Product characteristics value 2 | |
| I_RFM_ProductCharcValue3Txt | direct | BASIC | Product characteristics value 3 | |
| P_SubscriptionProductPurpose | direct | BASIC | ||
| P_SubscrpnProdWithoutSpec | direct | BASIC | ||
| A_ProductProcurement | via 2 level | COMPOSITE | Basic Procurement Data | |
| A_ProductSales | via 2 level | BASIC | Basic Sales Data | |
| A_ProductStorage | via 2 level | COMPOSITE | Basic Storage Data | |
| C_JITOutbContainerVH | via 2 level | CONSUMPTION | Value help for Container | |
| I_FldLogsRetEWMHandlingUnit | via 2 level | COMPOSITE | FL EWM Handling Units | |
| I_JITOutbPlanningObject | via 2 level | COMPOSITE | JIT S2P - S2L Pegging Area / Material/ Location mapping | |
| I_ProductESPPTP | via 2 level | TRANSACTIONAL | TP View- Product ESPP (draft) | |
| I_Productprocurementwd | via 2 level | TRANSACTIONAL | Composite view-Product Procurement | |
| I_ProductSalesWD | via 2 level | TRANSACTIONAL | Product BO - Sales Node (draft) | |
| I_Productscmwd | via 2 level | TRANSACTIONAL | Product SCM BO View | |
| I_ProductStorageWD | via 2 level | TRANSACTIONAL | Product BO - Product Storage Node (draft) | |
| I_SubscrpnProdWthoutSpecVH | via 2 level | COMPOSITE | Value help view for Subscription Product w/o Specification | |
| P_Productprocurementwd | via 2 level | COMPOSITE | ||
| P_ProductSalesWD | via 2 level | COMPOSITE | ||
| P_ProductStorageWD | via 2 level | COMPOSITE | ||
| R_ACMMaterialDetailsTP | via 2 level | TRANSACTIONAL | ACM Material Details | |
| A_ACMMaterialDetails | via 3 levels | CONSUMPTION | ACM Material Details | |
| C_ProductESPP | via 3 levels | CONSUMPTION | Consumption view for Product ESPP | |
| C_Productprocurement | via 3 levels | CONSUMPTION | Product Master Procurement | |
| C_Productsales | via 3 levels | CONSUMPTION | Product Master Sales | |
| C_Productscm | via 3 levels | CONSUMPTION | Consumption- Product SCM | |
| C_Productstorage | via 3 levels | CONSUMPTION | Product Master Storage | |
| C_SubscrpnProdWthoutSpecVH | via 3 levels | CONSUMPTION | Consumption value help Subscription Product w/o Specific. | |
| I_FldLogsRetEWMHndlgUnitRecord | via 3 levels | COMPOSITE | FL EWM Handling Unit Record |
matnr
(33 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| /dmbe/i_LcfsProgram | direct | LCFS Program | ||
| /dmbe/i_lcfsprogram_Text | direct | LCFS Program Descriptions | ||
| /merp/mm_Material_Plant | direct | CDS View: Material Plant View | ||
| Mbv_Macku | direct | Compatibility view for MACKU view (ML integration) | ||
| Mbv_Srmerp_Css_Mat | direct | Compatibility view for /SRMERP/CCS_MAT view (ML integration) | ||
| Mbv_V_Satz1 | direct | Compatibility view for V_SATZ1 view (ML integration) | ||
| NSDM_E_MA07V | direct | MA07V Compatibility View | ||
| NSDM_E_MA61V | direct | MA61V Compatibility View | ||
| NSDM_E_MAWEV | direct | MAWEV Compatibility View | ||
| NSDM_E_MCON | direct | MCON Compatibility View | ||
| NSDM_E_MFAUF | direct | MFAUF Compatibility View | ||
| NSDM_e_v_OLR3_MARX | direct | V_OLR3_MARX Compatibility View | ||
| P_AdvncdPlngPrdscm_Matkey | direct | BASIC | ||
| P_Prdscm_Matkey_Flcl | direct | BASIC | Redirect for /SAPAPO/MATKEY | |
| P_Prdscm_Matkey_Flcl_Calc | direct | BASIC | Redirect for /SAPAPO/MATKEY | |
| RFM_PP_MBOMConstcyChkMBlkdkSt | direct | |||
| rfm_scc_product_data | direct | Get Product data | ||
| RFM_SD_SEASONS_BASIC_VIEW | direct | RFM Sales Document Seasons Basic View | ||
| ScmPrd_Ndbsmatg16 | direct | Redirect for NDBSMATG16 | ||
| VC_INTEGRATION_MARA | direct | Extraction for MARA | ||
| P_Prdscm_Matkey_Flcl_Union | via 2 level | COMPOSITE | Union view for MATKEY | |
| RFM_SD_SEASONS_AGG_VIEW | via 2 level | RFM Sales Document Seasons Aggregate | ||
| P_Prdscm_Matkey | via 3 levels | Redirect for /SAPAPO/MATKEY | ||
| ScmPrd_Matkey | via 3 levels | Redirect for /SAPAPO/MATKEY | ||
| ScmPrd_V_Bwprdt | via 4 levels | Product Scm redirect for view BWPRDT | ||
| ScmPrd_V_Locmat | via 4 levels | Product Scm Locmat redirect view | ||
| ScmPrd_V_Mat2 | via 4 levels | Product Scm redirect for V_MAT2 | ||
| ScmPrd_V_Mat3 | via 4 levels | Product Scm redirect for V_MAT3 | ||
| ScmPrd_V_Mat4 | via 4 levels | Product Scm redirect for V_MAT4 | ||
| ScmPrd_V_Mat5 | via 4 levels | Product Scm redirect for V_MAT5 | ||
| ScmPrd_V_Mattxt | via 4 levels | Product Scm redirect for V_MATTXT | ||
| ScmPrd_V_Snp4tm | via 4 levels | Product Scm redirect for V_SNP4TM | ||
| ScmPrd_Vsnp4mls | via 4 levels | Product Scm redirect for VSNP4ML |
material
(31 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| /dmbe/i_MaterialBasic | direct | Material Basic View | ||
| F_Mmim_Mathlp_Vh | direct | Help-View for material | ||
| I_ACMMaterialMstrData | direct | BASIC | Material Master Data | |
| I_FldLogsMaterialDetails | direct | BASIC | Material master data from MARA for Field Logistics | |
| I_GHOMaterialMedium | direct | BASIC | Material Medium | |
| I_GHOMaterialVH | direct | BASIC | Material | |
| I_MaterialDescription | direct | BASIC | Material Description | |
| I_MRPPurchasingInfoRecord | direct | BASIC | Basic InfoRecords for SOS | |
| I_PrepaymentMaterial | direct | BASIC | Material Data | |
| P_InvtryMgmtMatlMstrVH | direct | BASIC | ||
| P_InvtryMgmtSuplrInfoRecdVH | direct | BASIC | ||
| P_Mara | direct | BASIC | ||
| P_MaterialInfo | direct | BASIC | ||
| P_Stockmaterial | direct | COMPOSITE | ||
| P_Swlist | direct | BASIC | ||
| RFM_PP_MBOMConstcyChkMaterial | direct | |||
| I_ACMCommodityDetails | via 2 level | COMPOSITE | Interface for Commodity Details | |
| I_ACMMaterialVH | via 2 level | BASIC | Material | |
| I_FldLogsPlntPackggMatl | via 2 level | COMPOSITE | Packaging Material Details for FL Plants | |
| I_InvtryMgmtMatlMstrVH | via 2 level | COMPOSITE | Invtry Management Materials | |
| I_InvtryMgmtSuplrInfoRecdVH | via 2 level | COMPOSITE | Invtry Management Materials | |
| I_MRPPurchasingInfoRecordMPN | via 2 level | COMPOSITE | InfoRecords with MPN details for SOS | |
| I_PpaytDocCmmdtyPrcgData_1 | via 2 level | COMPOSITE | PPMT Document Commodity Pricing data | |
| RFM_PP_MBOMConstcyChkMatlsBOM | via 2 level | |||
| C_ACMMatlVH | via 3 levels | CONSUMPTION | Val hel for material | |
| I_PpaytDocCmmdtyPrcgValInfo | via 3 levels | COMPOSITE | PPMT Document Commodity Pricing Info | |
| RFM_PP_MBOMConstcyChKHdrDetls | via 3 levels | |||
| I_PpaytDocCmmdtyPrcVal_1 | via 4 levels | COMPOSITE | Document Condition Market Prices | |
| RFM_PP_MBOMConstcyChkDetls | via 4 levels | |||
| I_PrepaymentDocFixedValData_1 | via 5 levels | COMPOSITE | PPMT Document Fixed pricing data | |
| I_PpaytDocumentMarketData_1 | via 6 levels | COMPOSITE | Market Value for the Prepayment Document |
AdvancedPlanningProductName
(5 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_ProductStorageDefinition | direct | BASIC | Product Storage Definition | |
| I_PSDProduct | direct | BASIC | PSD Product | |
| C_AdvncdSchedgProductVH | via 2 level | CONSUMPTION | Product for Advanced Planning | |
| R_ProductStorageDefinitionTP | via 2 level | TRANSACTIONAL | Product Storage Definition TP | |
| R_PSDProductTP | via 2 level | TRANSACTIONAL | PSD Product TP |
PackagingMaterial
(5 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| C_EWM_HandlingUnitLabel | direct | CONSUMPTION | Form Data Provider for EWM HU Label | |
| C_EWM_HndlgUnitParamDetermine | direct | CONSUMPTION | Handling Unit Output Management BRF+ Parameter Determination | |
| C_EWM_LoadListHndlgUnit | direct | CONSUMPTION | Form Prvdr for Loading Instruction HUs | |
| C_PackagingMaterialVH | direct | CONSUMPTION | VH for Packaging Materials | |
| C_FldLogsHandlingUnits | via 3 levels | CONSUMPTION | Handling Units |
ProductVariant
(4 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| P_VarConfignXPlantProdVariant | direct | BASIC | ||
| P_SimulationObjectUnion | via 2 level | CONSUMPTION | ||
| P_SimulationObjectSearch | via 3 levels | CONSUMPTION | ||
| C_AdvncdVarConfignSimlnSearch | via 4 levels | CONSUMPTION | Simulation - Simulation Objects Search |
EmbeddedSwHardwareMaterial
(3 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_CstrtHardwareMatl | direct | BASIC | Hardware Material List | |
| C_CstrtHardwareMatlVH | via 2 level | CONSUMPTION | Hardware Material Value Help | |
| I_Matswdoc | via 2 level | BASIC | Get Material Document |
ext_matnr
(3 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| ScmPrd_MatMap_Union | direct | Union of MARA and MATERIALID | ||
| ScmPrd_Matmap | via 2 level | Redirect for /SAPAPO/MATMAP | ||
| ScmPrd_V_Matmap | via 3 levels | Product Scm redirect for V_MATMAP |
ProductID
(2 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_VisualProductIdVH | direct | BASIC | Visual Product id | |
| C_VisualProductIdVH | via 2 level | CONSUMPTION | Visual Product id |
source_id
(2 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| P_MDChgProcProdClAssgmtWthMatl | direct | BASIC | ||
| P_MDChgProcProdValnWthMatlNmbr | direct | BASIC |
ContractMaterial
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_ACMMatlCostRevCkpt | direct | BASIC | Basic Entity for ACM Materials for CRC |
DES_ID
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| P_Rtc_Diff_Item_Matnr | direct | BASIC |
EWAWaste
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_EWAWasteVH | direct | BASIC | Waste Material values |
PPDSMntrRcptProduct
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| R_PPDSMntrRcptProductUoM | direct | BASIC | Product and Unit of Measure |
PPDSProduct
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| R_PPDSMntrRqmtProductUoM | direct | BASIC | Product and Unit of Measure |
ScheduledMaterial
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_TripServiceMaterialVH | direct | BASIC | Value Help for Service Material |
ActiveProduct
(3 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| P_Productprocurementwd | via 2 level | COMPOSITE | ||
| P_ProductSalesWD | via 2 level | COMPOSITE | ||
| P_ProductStorageWD | via 2 level | COMPOSITE |
ProductForEdit
(3 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_Productscmwd | via 2 level | TRANSACTIONAL | Product SCM BO View | |
| P_Productscmwd | via 2 level | COMPOSITE | ||
| C_Productscm | via 3 levels | CONSUMPTION | Consumption- Product SCM |
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