MATID in /SAPAPO/MATPLSTA
Product ID (DE: Produkt-ID)
MATID is a field in SAP table /SAPAPO/MATPLSTA (Location Product: Specific Planning Status per Application). It represents "Product ID". Data element: /SAPAPO/MATID. Available in 17 CDS view(s) as matid, ProductInternalUUID.
Business Meaning
| Description (EN) | Product ID |
|---|---|
| Beschreibung (DE) | Produkt-ID |
| Data Element | /SAPAPO/MATID |
| Key Field | Yes |
CDS Views & Technical Names (17)
/SAPAPO/MATPLSTA.MATID 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.
matid
(16 views)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| P_Prdscm_Locmap_Marc | direct | Join of MARC, /SAPAPO/LOCMAP | ||
| P_Prdscm_Locmap_Mdma | direct | Join of /SAPAPO/LOCMAP, P_PRDSCM_MDMA_MDLV, MARC | ||
| ScmPrd_Locmap_Marc | direct | Join of MARC, /SAPAPO/LOCMAP | ||
| ScmPrd_Locmap_Mdma | direct | Join of /SAPAPO/LOCMAP, P_PRDSCM_MDMA_MDLV, MARC | ||
| P_Prdscm_Locmap_Union | via 2 level | Union of P_PRDSCM_LOCMAP_MARC and P_PRDSCM_LOCMAP_MDMA | ||
| ScmPrd_Locmap_Union | via 2 level | Union of ScmPrd_Locmap_Marc and ScmPrd_Locmap_Mdma | ||
| P_Prdscm_Matloc | via 3 levels | Redirect for /SAPAPO/MATLOC | ||
| ScmPrd_Matloc | via 3 levels | Redirect for /SAPAPO/MATLOC | ||
| ScmPrd_V_Bwlprd | via 4 levels | Product Scm redirect for V_BWLPRD | ||
| ScmPrd_V_Lp | via 4 levels | Product Scm redirect for V_LP | ||
| ScmPrd_V_Matl_T | via 4 levels | Product Scm redirect for V_MATL_T | ||
| ScmPrd_V_Matl_V | via 4 levels | Product Scm redirect for V_MATL_V | ||
| ScmPrd_V_Matloc | via 4 levels | Product Scm redirect for V_MATLOC | ||
| ScmPrd_V_Ml2 | via 4 levels | Product Scm redirect for V_ML2 | ||
| ScmPrd_V_Ml3 | via 4 levels | Product Scm redirect for V_ML3 | ||
| ScmPrd_V_Ml4 | via 4 levels | Product Scm redirect for V_ML4 |
ProductInternalUUID
(1 view)
| View | Access | VDM | Release | Description |
|---|---|---|---|---|
| I_AdvancedPlanningStatus | direct | BASIC | Specific Planning Status per Application |
Other Tables with Field MATID (24)
| Table | Data Element | Key | Description |
|---|---|---|---|
| /SAPAPO/MATAPN | /SAPAPO/MATID | KEY | Alternative Product Number |
| /SAPAPO/MATGROUP | /SAPAPO/MATID | KEY | Product Grouping |
| /SAPAPO/MATKEY | /SAPAPO/MATID | KEY | Product |
| /SAPAPO/MATLSIM | /SAPAPO/MATID | KEY | Location Product with Planning Version |
| /SAPAPO/MATLSPP | /SAPAPO/MATID | KEY | SPP Relevant Location Product Attributes |
| /SAPAPO/MATLWH | /SAPAPO/MATID | KEY | Location Product for Location Warehouse |
| /SAPAPO/MATLWHST | /SAPAPO/MATID | KEY | Location Product for Location Whse and Subloc. Storage Type |
| /SAPAPO/MATMAP | /SAPAPO/MATID | Mapping Table for Products | |
| /SAPAPO/MATMOD | /SAPAPO/MATID | KEY | Model assignment of location product |
| /SAPAPO/MATPRT | /SAPAPO/SNC_MATID | KEY | Partner Product Master Data |
| /SAPAPO/MATPRTXT | /SAPAPO/SNC_MATID | KEY | Partner product description |
| /SAPAPO/MATSBOD | /SAPAPO/MATID | KEY | Product BOD Assignment with Planning Version |
| /SAPAPO/MATTXT | /SAPAPO/MATID | KEY | Material Descriptions |
| /SAPAPO/PEGKEY | /SAPAPO/MATID | Planning object (material/location/account assignment) | |
| /SAPAPO/RELDHTLM | /SAPAPO/MATID | Mapping table for table /SAPAPO/RELDHTLA | |
| /SAPAPO/TPSCO | /SAPAPO/MATID | Sales Scheduling Agreement | |
| /SAPAPO/TPSRC | /SAPAPO/MATID | Contracts: External Procurement | |
| /SCWM/BINMAT | /SCWM/DE_MATID | KEY | Assignment Table for Fixed Bins - Product |
| /SCWM/ORDIM_CS | /SCWM/DE_MATID | Serial Numbers for Confirmed Warehouse Task Item | |
| /SCWM/ORDIM_HS | /SCWM/DE_MATID | Serial Numbers for HU Item Movements | |
| /SCWM/ORDIM_OS | /SCWM/DE_MATID | Serial Number Items for Open Warehouse Tasks | |
| /SCWM/SERH2 | /SCWM/DE_MATID | KEY | Serial Number Header |
| /SCWM/T_VAL_SPLT | /SCWM/DE_MATID | KEY | Split Valuation Data |
| /SCWM/TPSASTAGE | /SCWM/DE_MATID | KEY | PSA Assignment to Bin by Entitled/Product |
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