MGIR_SSTN SAP (Material / Info Record Sustainability table) Table details

Dictionary Type: Table
Description: Material / Info Record Sustainability table




ABAP Code to SELECT data from MGIR_SSTN
Related tables to MGIR_SSTN
Access table MGIR_SSTN




Table field list including key, data, relationships and ABAP select examples

MGIR_SSTN is a standard SAP Table which is used to store Material / Info Record Sustainability table data and is available within R/3 SAP systems depending on the version and release level.

The MGIR_SSTN table consists of various fields, each holding specific information or linking keys about Material / Info Record Sustainability table data available in SAP. These include UUID (SSTN UUID), MATNR_SUST_ID (Material Sustainability ID), CREATED_BY (User name), CREATED_ON (Date).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP MGIR_SSTN table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
UUIDSSTN UUID SSTN_MGIR_UUIDCHAR32SYSUUID_C
MATNR_SUST_IDMaterial Sustainability ID MATNR_SUST_IDCHAR12Assigned to domainSSTN_ID
CREATED_BYUser name USNAMCHAR12Assigned to domainXUBNAMEUSR
CREATED_ONDate DATUMDATS8DATUM
LAST_CHANGED_BYUser name USNAMCHAR12Assigned to domainXUBNAMEUSR
LAST_CHANGED_ONDate DATUMDATS8DATUM
MATNRMaterial Number MATNRCHAR18Assigned to domainMATN1MATNRMATS_MAT1
LIFNRAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
WERKSPlant EWERKCHAR4Assigned to domainWERKSWRK
EKORGPurchasing Organization EKORGCHAR4Assigned to domainEKORGEKO
VALIDITY_STARTValidity Start Date SSTN_MGIR_VAL_START_DATEDATS8DATUM
VALIDITY_ENDValidity End Date SSTN_MGIR_VAL_END_DATEDATS8DATUM
WERKS_NAMEName 1 AD_NAME1CHAR40TEXT40
DEL_FLAGCheckbox XFELDCHAR1XFELD
OVERALL_RATINGEnvironmental Rating SSTN_MAT_RATINGNUMC3SSTN_MAT_PERCENT
RECYCLED_CONTENTRecycled Content SSTN_RECYCLED_CONTENTNUMC3SSTN_MAT_PERCENT
GHG_SCOPE1Scope 1 Emissions SSTN_MAT_GHGS1QUAN13(3) MENG13
GHG_SCOPE1_UNUnit for Scope 1 Emissions SSTN_GHGS1_UNITUNIT3T006CUNITMEINS
GHG_SCOPE2Scope 2 Emissions SSTN_MAT_GHGS2QUAN13(3) MENG13
GHG_SCOPE2_UNUnit For Scope 2 Emissions SSTN_GHGS2_UNITUNIT3T006CUNITMEINS
GHG_SCOPE3Scope 3 Emissions SSTN_MAT_GHGS3QUAN13(3) MENG13
GHG_SCOPE3_UNUnit for Scope 3 Emissions SSTN_GHGS3_UNITUNIT3T006CUNITMEINS
DIRECT_ENERGYEnergy Consumption SSTN_MAT_DIRECT_ENGQUAN13(3) MENG13
DIRECT_ENG_UNITUnit for Energy Consumption SSTN_MAT_DIRECT_ENG_UNUNIT3T006CUNITMEINS
DIRECT_WATERWater Consumption SSTN_MAT_WATER_USEDQUAN13(3) MENG13
DIRECT_WATER_UNWater Consumption Unit SSTN_MAT_WATER_UNITUNIT3T006CUNITMEINS
DIRECT_WASTEWaste Generated SSTN_MAT_DIRECT_WASTEQUAN13(3) MENG13
DIRECT_WASTE_UNUnit for Material Waste Generated SSTN_MAT_WASTE_UNUNIT3T006CUNITMEINS

Key field Non-key field



How do I retrieve data from SAP table MGIR_SSTN using ABAP code

The following ABAP code Example will allow you to do a basic selection on MGIR_SSTN to SELECT all data from the table
DATA: WA_MGIR_SSTN TYPE MGIR_SSTN.

SELECT SINGLE *
FROM MGIR_SSTN
INTO CORRESPONDING FIELDS OF WA_MGIR_SSTN
WHERE...

How to access SAP table MGIR_SSTN

Within an ECC or HANA version of SAP you can also view further information about MGIR_SSTN and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!