MATNR in MAPL
Material
MATNR is a field in SAP table MAPL (Assignment of Task Lists to Materials). It represents "Material". Data element: MATNR. Available in 50 CDS view(s) as Material, Product, MaterialForEdit.
Business Meaning
| Description (EN) | Material |
|---|---|
| Beschreibung (DE) | Material |
| Data Element | MATNR |
| Key Field | Yes |
CDS Views & Technical Names (50)
MAPL.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
(30 views)
Material Number
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_BOOMaterialAssgmtChangeState | direct | BASIC | Change State of Material Assgmt to BOO | |
| I_BOOMaterialAssignment | direct | BASIC | Material assgmt to Bill of Operations | |
| I_RoutingMaterialSearchModel | direct | BASIC | Material assgmt. to BOO | |
| C_BOOMatlAssgmtChgStDEX | via 2 level | CONSUMPTION | Change State of Material Assgmt to BOO | |
| C_ChangeRecordPlngRtgVH | via 2 level | CONSUMPTION | Planning Routing Value Help | |
| C_ChangeRecordProdnRoutingVH_2 | via 2 level | CONSUMPTION | Production Routing in Change Record V4 | |
| C_ChgRecdEquipTskListMatVH | via 2 level | CONSUMPTION | Material for Equipment Task List | |
| C_ChgRecdFuncLocTskListMatVH | via 2 level | CONSUMPTION | Material for Functional Loc Task List | |
| C_ChgRecdMaintTskListMatVH | via 2 level | CONSUMPTION | Material for Maintenance Task List | |
| C_ChgRecdRateRtgTskListMatVH | via 2 level | CONSUMPTION | Material for Rate Rtg Task List | |
| C_ChgRecdRefOpSetTskListMatVH | via 2 level | CONSUMPTION | Material for Ref Op Set Task List | |
| C_ProdnVersTaskListVH | via 2 level | CONSUMPTION | Task List | |
| C_ProductsByWorkCenter | via 2 level | CONSUMPTION | Products by work center | |
| I_BOOMaterialAssignmentStdVH | via 2 level | COMPOSITE | Material assgmt. to Bill of Operations | |
| I_BOOMaterialAssignmentVH | via 2 level | COMPOSITE | Material Assignment to Bill of Operations | |
| I_BOOPlngBOMAssignment | via 2 level | BASIC | PBOM assigned to Planning Routing | |
| I_InspPlnMatlAssgmtVersion | via 2 level | BASIC | Version of Plan-Material assignment | |
| I_InspPlnMatlAssgmtVersion_2 | via 2 level | BASIC | Version of Material Assgmt in Insp Plan | |
| I_ProdnVersTaskListVH | via 2 level | BASIC | Task List | |
| P_ProductsByWorkCenter | via 2 level | COMPOSITE | Products by work center | |
| A_InspPlanMaterialAssgmt | via 3 levels | COMPOSITE | Material Assignments | |
| C_ChgImpactPlngRoutingMBOM | via 3 levels | CONSUMPTION | Planning Routing MBOM Details | |
| I_InspPlanMaterialAssgmtTP | via 3 levels | TRANSACTIONAL | Insp Plan Version-Material Assignment | |
| I_MasterRecipeMaterialAssgmt | via 3 levels | BASIC | Master Recipe Material Assignment Details | |
| I_RoutingMaterialAssignment | via 3 levels | BASIC | Routing Material Assignment Details | |
| R_InspPlanMatlAssgmtVersionTP | via 3 levels | TRANSACTIONAL | Inspection Plan Material Assignment Version | |
| C_InspPlanMatlAssgmt | via 4 levels | CONSUMPTION | Insp Plan Version-Material Assignment | |
| I_InspPlanMatlAssgmtVersTP_2 | via 4 levels | TRANSACTIONAL | Inspection Plan Material Assignment Version - TP | |
| I_MasterRecipeComponentAlloc | via 4 levels | COMPOSITE | Master Recipe Component Allocation Details | |
| I_RoutingComponentAlloc | via 4 levels | COMPOSITE | Routing Component Allocation details |
Product
(20 views)
Material Number
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| P_ProdnRoutingMatlAssgmtDEX | direct | BASIC | Production Routing Material Assignment | |
| I_MfgBOOMaterialAssgmtChgSt | via 2 level | BASIC | Change State of Material Assgmt to Manufacturing BOO | |
| I_MfgBOOMaterialAssignment | via 2 level | BASIC | Material Assignment to Manufacturing Bill of Operations | |
| I_ProdnRoutingMatlAssgmtDEX | via 2 level | BASIC | Production Routing Material Assignment | |
| /VSCEW/A_Rou | via 3 levels | TRANSACTIONAL | Routing | |
| /VSCEW/A_Rou_Alternative | via 3 levels | Routing Alternatives | ||
| I_MfgBOOMatlAssgmtWrkCtrGrpg | via 3 levels | COMPOSITE | Material Assignment Work Center Grouping | |
| I_MasterRecipeMaterialAssgmtTP | via 4 levels | TRANSACTIONAL | Master Recipe - Material Assignment | |
| I_ProdnRoutingMatlAssgmtTP | via 4 levels | TRANSACTIONAL | Transaction View for Production Routing Material Assignment | |
| I_ProdnRtgMatlAssgmtToHeader | via 4 levels | COMPOSITE | Prodn Rtg Material Assignment to Header | |
| R_ProdnRoutingMatlAssgmtTP_2 | via 4 levels | TRANSACTIONAL | Production Routing Material Assignment | |
| A_MasterRecipeMaterialAssgmt | via 5 levels | CONSUMPTION | Material Assignment | |
| A_ProdnRoutingMatlAssgmt_2 | via 5 levels | CONSUMPTION | Material Assignment | |
| A_ProdnRoutingMatlAssgmt_3 | via 5 levels | CONSUMPTION | Material Assignment | |
| A_ProductionRoutingMatlAssgmt | via 5 levels | CONSUMPTION | Material Assignment | |
| C_MasterRecipeMaterialAssgmt | via 5 levels | CONSUMPTION | Master Recipe Material Assignment | |
| C_ProdnRoutingMatlAssgmt | via 5 levels | CONSUMPTION | Production Routing Material Assignment | |
| I_ProdnRoutingMatlAssgmtTP_2 | via 5 levels | TRANSACTIONAL | Interface for BO ProductionRouting Material Assignment - TP | |
| P_MasterRecipeMaterialAssgmt | via 5 levels | COMPOSITE | Master Recipe - Material Assignment | |
| P_ProdnRoutingMatlAssgmt | via 5 levels | COMPOSITE | Production Routing Material Assignment |
MaterialForEdit
(2 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_InspPlanMaterialAssgmtTP | via 3 levels | TRANSACTIONAL | Insp Plan Version-Material Assignment | |
| C_InspPlanMatlAssgmt | via 4 levels | CONSUMPTION | Insp Plan Version-Material Assignment |
Other Tables with Field MATNR (50+)
| Table | Data Element | Key | Description |
|---|---|---|---|
| /1FE/00SAP0IT | MATNR40 | Items for Class 0SAP - Raw Data | |
| /1FE/00SAP1IT | MATNR40 | Items for Class 0SAP - Raw Exceptions | |
| /1FE/00SAP2IT | MATNR40 | Items for Class 0SAP - Billable | |
| /1FE/00SAP3IT | MATNR40 | Items for Class 0SAP - Exceptions | |
| /1FE/00SAP4IT00 | MATNR40 | Items for Class 0SAP - Billed | |
| /1FE/00SAP4ITS0 | MATNR40 | Items for Class 0SAP - Simulated Billed | |
| /CEECV/ROCOWNID | MATNR | KEY | SAF-T RO: Owner IDs |
| /CPD/PWS_RCB_BPF | /CPD/PWS_RCB_MATNR | Fixed Price Billing Plan Manager | |
| /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 | |
| /SAPAPO/MATKEY | /SAPAPO/MATNR | Product | |
| /SAPAPO/MATMAP | /SAPAPO/MATNR | Mapping Table for Products | |
| /SAPAPO/MATPLSTA | /SAPAPO/MATNR | Location Product: Specific Planning Status per Application | |
| /SAPSLL/PRAICA | MATNR | Product Classification AI Attributes | |
| /SAPSLL/PRTCP | MATNR | Product Classification Proposal | |
| /SAPSLL/PRTCT | MATNR | Product trade classification task | |
| /SCWM/BINMAT | /SCWM/DE_MATNR | Assignment Table for Fixed Bins - Product | |
| A017 | MATNR | KEY | Material Info Record (Plant-Specific) |
| A018 | MATNR | KEY | Material Info Record |
| A066 | MATNR | KEY | Info record per order unit |
| A067 | MATNR | KEY | Plant Info Record per Order Unit |
| A163 | MATNR | KEY | Number/Material |
| A304 | MATNR | KEY | Material with release status |
| ACCBD | MATNR | Universal Component Breakdown | |
| ACDOCA_M_EXTRACT | MATNR | ACDOCA Extract Table for Material Ledger | |
| ACES_POSTING | MATNR | GTT for Accruals Posting | |
| AFFW | MATNR | Goods Movements with Errors from Confirmations | |
| ANEK | MATNR | Belegkopf Anlagenbuchung | |
| ATP_HIGHRUNNER | MATNR | KEY | Statistics and identification of ATP high runners |
| ATP_TQA_PAC | MATNR | KEY | Temporary Quantity Assigments for PAC |
| ATPNETCHGFILTER | MATNR | Availability Change Log | |
| ATPTSINLIVECACHE | MATNR | KEY | ATP timeseries that are active in Livecache |
| AUFM | MATNR | Goods movements for order | |
| AUPO | MATNR | Allocation Table Document Item | |
| BLPK | MATNR | REM Confirmation Header | |
| BSEG | MATNR | Belegsegment Buchhaltung | |
| BSEG_ADD | MATNR | Erfassungssicht Buchhaltungsbeleg für zusätzliche Ledger | |
| CABN_EXCL | MATNR | KEY | Characteristics That Are Excluded for Type Matching |
| CCREG | MATNR | Simplified Consignment Register Diary Table | |
| CHVW | MATNR | KEY | Table CHVW for Batch Where-Used List |
| CKIS | MATNR | Positionen Einzelkalkulation/Einzelnachweis Erz.kalkulatio | |
| CKMLMV_AUX_KALNR | MATNR | Kalkulationsnummern für bewertete Objekte im MGV | |
| CKMLMV001 | MATNR | Beschaffungsalternativen | |
| CKMLMV005 | MATNR | Verbrauchsalternativen | |
| CNVPACK | CNV_MATNR | Conversion: Conversion packages | |
| COBRB | MATNR | Distribution Rules Settlement Rule Order Settlement | |
| COCH | PI_MATNR | Process Management: Control Recipe Header | |
| COOI | MATNR | Obligoverwaltung: Einzelposten | |
| CRVM_A | MATNR | KEY | Link of PRT data to a material |
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