MGIR_SSTN SAP table for – Material / Info Record Sustainability table

Here we would like to draw your attention to MGIR_SSTN table in SAP. As we know it is being mainly used with the SAP LO-MD (Logistics Basic Data in LO) component which is coming under LO module (Logistics). MGIR_SSTN is a SAP standard transparent table used for storing Material / Info Record Sustainability table related data in SAP. It comes under the package MG_SSTN.

SAP MGIR_SSTN table

Table MGIR_SSTN technical data

TableMGIR_SSTN
Data storingMaterial / Info Record Sustainability table
ModuleLO
ComponentLO-MD
SAP PackageMG_SSTN
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP MGIR_SSTN Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in MGIR_SSTN table.

  • LIFNR : Vendor’s account number
    Its data type is C (Character String) with field length 10
  • EKORG : Purchasing organization
    Its data type is C (Character String) with field length 4
  • VALIDITY_END
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • DEL_FLAG : Replacement for Real Boolean Type: ‘X’ == True ” == False
    Its data type is C (Character String) with field length 1
  • OVERALL_RATING
    Its data type is N (Character String with Digits Only) with field length 3
  • GHG_SCOPE1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • GHG_SCOPE2
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • GHG_SCOPE3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • DIRECT_ENERGY
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • DIRECT_WATER
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • MATNR_SUST_ID
    Its data type is C (Character String) with field length 12
  • DIRECT_WASTE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • CREATED_ON : UTC Time Stamp in Short Form (YYYYMMDDhhmmss)(with Con.Exit)
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • LAST_CHANGED_BY : Last changed by
    Its data type is C (Character String) with field length 12
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is SSTN_MGIR_ID_STY