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
MANDTClientMANDTCLNT3(0) Assigned to domainMANDT
UUIDSSTN UUIDSSTN_MGIR_UUIDCHAR32(0) SYSUUID_C
MATNR_SUST_IDMaterial Sustainability IDMATNR_SUST_IDCHAR12(0) Assigned to domainSSTN_ID
CREATED_BYUser NameUSNAMCHAR12(0) Assigned to domainXUBNAMEUSR
CREATED_ONDateDATUMDATS8(0) DATUM
LAST_CHANGED_BYUser NameUSNAMCHAR12(0) Assigned to domainXUBNAMEUSR
LAST_CHANGED_ONDateDATUMDATS8(0) DATUM
MATNRMaterial NumberMATNRCHAR40(0) Assigned to domainMATN1MATNRMATS_MAT1MATNR
LIFNRAccount Number of Vendor or CreditorLIFNRCHAR10(0) Assigned to domainALPHALIFNRLIFKRED_CLIFNR
WERKSPlantEWERKCHAR4(0) Assigned to domainWERKSWRK
EKORGPurchasing organizationEKORGCHAR4(0) Assigned to domainEKORGEKO
VALIDITY_STARTValidity Start DateSSTN_MGIR_VAL_START_DATEDATS8(0) DATUM
VALIDITY_ENDValidity End DateSSTN_MGIR_VAL_END_DATEDATS8(0) DATUM
WERKS_NAMEName 1AD_NAME1CHAR40(0) TEXT40
DEL_FLAGCheckboxXFELDCHAR1(0) XFELD
OVERALL_RATINGEnvironmental RatingSSTN_MAT_RATINGNUMC3(0) SSTN_MAT_PERCENT
RECYCLED_CONTENTRecycled ContentSSTN_RECYCLED_CONTENTNUMC3(0) SSTN_MAT_PERCENT
GHG_SCOPE1Scope 1 EmissionsSSTN_MAT_GHGS1QUAN13(3) MENG13
GHG_SCOPE1_UNUnit for Scope 1 EmissionsSSTN_GHGS1_UNITUNIT3(0) T006CUNITMEINS
GHG_SCOPE2Scope 2 EmissionsSSTN_MAT_GHGS2QUAN13(3) MENG13
GHG_SCOPE2_UNUnit For Scope 2 EmissionsSSTN_GHGS2_UNITUNIT3(0) T006CUNITMEINS
GHG_SCOPE3Scope 3 EmissionsSSTN_MAT_GHGS3QUAN13(3) MENG13
GHG_SCOPE3_UNUnit for Scope 3 EmissionsSSTN_GHGS3_UNITUNIT3(0) T006CUNITMEINS
DIRECT_ENERGYEnergy ConsumptionSSTN_MAT_DIRECT_ENGQUAN13(3) MENG13
DIRECT_ENG_UNITUnit for Energy ConsumptionSSTN_MAT_DIRECT_ENG_UNUNIT3(0) T006CUNITMEINS
DIRECT_WATERWater ConsumptionSSTN_MAT_WATER_USEDQUAN13(3) MENG13
DIRECT_WATER_UNWater Consumption UnitSSTN_MAT_WATER_UNITUNIT3(0) T006CUNITMEINS
DIRECT_WASTEWaste GeneratedSSTN_MAT_DIRECT_WASTEQUAN13(3) MENG13
DIRECT_WASTE_UNUnit for Material Waste GeneratedSSTN_MAT_WASTE_UNUNIT3(0) T006CUNITMEINS




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!