SAP MGIR_SSTN Table in S/4 HANA - Material / Info Record Sustainability table
MGIR_SSTN is a standard SAP Table which is used to store Material / Info Record Sustainability table data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the MGIR_SSTN table(ECC)
Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Transparent table
Database Table: MGIR_SSTN
MGIR_SSTN table structure field list
Below is the full MGIR_SSTN field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
MANDT | Client | MANDT | CLNT | 3(0) | Assigned to domain | MANDT | ||||
UUID | SSTN UUID | SSTN_MGIR_UUID | CHAR | 32(0) | SYSUUID_C | |||||
MATNR_SUST_ID | Material Sustainability ID | MATNR_SUST_ID | CHAR | 12(0) | Assigned to domain | SSTN_ID | ||||
CREATED_BY | User Name | USNAM | CHAR | 12(0) | Assigned to domain | XUBNAME | USR | |||
CREATED_ON | Date | DATUM | DATS | 8(0) | DATUM | |||||
LAST_CHANGED_BY | User Name | USNAM | CHAR | 12(0) | Assigned to domain | XUBNAME | USR | |||
LAST_CHANGED_ON | Date | DATUM | DATS | 8(0) | DATUM | |||||
MATNR | Material Number | MATNR | CHAR | 40(0) | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 | MATNR |
LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR | 10(0) | Assigned to domain | ALPHA | LIFNR | LIF | KRED_C | LIFNR |
WERKS | Plant | EWERK | CHAR | 4(0) | Assigned to domain | WERKS | WRK | |||
EKORG | Purchasing organization | EKORG | CHAR | 4(0) | Assigned to domain | EKORG | EKO | |||
VALIDITY_START | Validity Start Date | SSTN_MGIR_VAL_START_DATE | DATS | 8(0) | DATUM | |||||
VALIDITY_END | Validity End Date | SSTN_MGIR_VAL_END_DATE | DATS | 8(0) | DATUM | |||||
WERKS_NAME | Name 1 | AD_NAME1 | CHAR | 40(0) | TEXT40 | |||||
DEL_FLAG | Checkbox | XFELD | CHAR | 1(0) | XFELD | |||||
OVERALL_RATING | Environmental Rating | SSTN_MAT_RATING | NUMC | 3(0) | SSTN_MAT_PERCENT | |||||
RECYCLED_CONTENT | Recycled Content | SSTN_RECYCLED_CONTENT | NUMC | 3(0) | SSTN_MAT_PERCENT | |||||
GHG_SCOPE1 | Scope 1 Emissions | SSTN_MAT_GHGS1 | QUAN | 13(3) | MENG13 | |||||
GHG_SCOPE1_UN | Unit for Scope 1 Emissions | SSTN_GHGS1_UNIT | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
GHG_SCOPE2 | Scope 2 Emissions | SSTN_MAT_GHGS2 | QUAN | 13(3) | MENG13 | |||||
GHG_SCOPE2_UN | Unit For Scope 2 Emissions | SSTN_GHGS2_UNIT | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
GHG_SCOPE3 | Scope 3 Emissions | SSTN_MAT_GHGS3 | QUAN | 13(3) | MENG13 | |||||
GHG_SCOPE3_UN | Unit for Scope 3 Emissions | SSTN_GHGS3_UNIT | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
DIRECT_ENERGY | Energy Consumption | SSTN_MAT_DIRECT_ENG | QUAN | 13(3) | MENG13 | |||||
DIRECT_ENG_UNIT | Unit for Energy Consumption | SSTN_MAT_DIRECT_ENG_UN | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
DIRECT_WATER | Water Consumption | SSTN_MAT_WATER_USED | QUAN | 13(3) | MENG13 | |||||
DIRECT_WATER_UN | Water Consumption Unit | SSTN_MAT_WATER_UNIT | UNIT | 3(0) | T006 | CUNIT | MEINS | |||
DIRECT_WASTE | Waste Generated | SSTN_MAT_DIRECT_WASTE | QUAN | 13(3) | MENG13 | |||||
DIRECT_WASTE_UN | Unit for Material Waste Generated | SSTN_MAT_WASTE_UN | UNIT | 3(0) | T006 | CUNIT | MEINS |
Search for further information about these or an SAP related objects