SAP ABAP Table MMPURUI_MATERIAL_STY (MMPUR_UI_MODEL: Structure for Material)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ MM-PUR (Application Component) Purchasing
     ⤷ MMPUR_UI_MODEL (Package) Model Components for Web Dynpro Applications, Purchasing

Basic Data

Table Category	INTTAB	Structure
Structure	MMPURUI_MATERIAL_STY	Table Relationship Diagram
Short Description	MMPUR_UI_MODEL: Structure for Material

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
2	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
3	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
4	MTART	☐	MTART	MTART	CHAR	4	0	Material type	*
5	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
6	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
7	ERSDA	☐	ERSDA	DATUM	DATS	8	0	Created On
8	EAN11	☐	EAN11	EAN11	CHAR	18	0	International Article Number (EAN/UPC)
9	NUMTP	☐	NUMTP	NUMTP	CHAR	2	0	Category of International Article Number (EAN)	*
10	MFRPN	☐	MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
11	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
12	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	*
13	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
14	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
15	.INCLUDE	☐				0	0	Material Sustainability Powl
16	UUID	☐	SSTN_MGIR_UUID	SYSUUID_C	CHAR	32	0	SSTN UUID
17	LIFNR	☐	LIFNR	LIFNR	CHAR	10	0	Account Number of Vendor or Creditor	*
18	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
19	VALIDITY_START	☐	SSTN_MGIR_VAL_START_DATE	DATUM	DATS	8	0	Validity Start Date
20	VALIDITY_END	☐	SSTN_MGIR_VAL_END_DATE	DATUM	DATS	8	0	Validity End Date
21	WERKS_NAME	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
22	OVERALL_RATING	☐	SSTN_MAT_RATING	SSTN_MAT_PERCENT	NUMC	3	0	Environmental Rating
23	RECYCLED_CONTENT	☐	SSTN_RECYCLED_CONTENT	SSTN_MAT_PERCENT	NUMC	3	0	Recycled Content
24	GHG_SCOPE1	☐	SSTN_MAT_GHGS1	MENG13	QUAN	13	3	Scope 1 Emissions
25	GHG_SCOPE1_UN	☐	SSTN_GHGS1_UNIT	MEINS	UNIT	3	0	Unit for Scope 1 Emissions	T006
26	GHG_SCOPE2	☐	SSTN_MAT_GHGS2	MENG13	QUAN	13	3	Scope 2 Emissions
27	GHG_SCOPE2_UN	☐	SSTN_GHGS2_UNIT	MEINS	UNIT	3	0	Unit For Scope 2 Emissions	T006
28	GHG_SCOPE3	☐	SSTN_MAT_GHGS3	MENG13	QUAN	13	3	Scope 3 Emissions
29	GHG_SCOPE3_UN	☐	SSTN_GHGS3_UNIT	MEINS	UNIT	3	0	Unit for Scope 3 Emissions	T006
30	DIRECT_ENERGY	☐	SSTN_MAT_DIRECT_ENG	MENG13	QUAN	13	3	Energy Consumption
31	DIRECT_ENG_UNIT	☐	SSTN_MAT_DIRECT_ENG_UN	MEINS	UNIT	3	0	Unit for Energy Consumption	T006
32	DIRECT_WATER	☐	SSTN_MAT_WATER_USED	MENG13	QUAN	13	3	Water Consumption
33	DIRECT_WATER_UN	☐	SSTN_MAT_WATER_UNIT	MEINS	UNIT	3	0	Water Consumption Unit	T006
34	DIRECT_WASTE	☐	SSTN_MAT_DIRECT_WASTE	MENG13	QUAN	13	3	Waste Generated
35	DIRECT_WASTE_UN	☐	SSTN_MAT_WASTE_UN	MEINS	UNIT	3	0	Unit for Material Waste Generated	T006

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MMPURUI_MATERIAL_STY	DIRECT_ENG_UNIT	T006	MSEHI
2	MMPURUI_MATERIAL_STY	DIRECT_WASTE_UN	T006	MSEHI
3	MMPURUI_MATERIAL_STY	DIRECT_WATER_UN	T006	MSEHI
4	MMPURUI_MATERIAL_STY	GHG_SCOPE1_UN	T006	MSEHI
5	MMPURUI_MATERIAL_STY	GHG_SCOPE2_UN	T006	MSEHI
6	MMPURUI_MATERIAL_STY	GHG_SCOPE3_UN	T006	MSEHI

History

Last changed by/on	SAP	20110901
SAP Release Created in	600