OIIGMMM SAP table for – GMM: Meter/Material assignment

Here we would like to draw your attention to OIIGMMM table in SAP. As we know it is being mainly used with the SAP IS-OIL-DS (Downstream in IS-OIL) component which is coming under IS-OIL module (Oil & Gas). OIIGMMM is a SAP standard transp table used for storing GMM: Meter/Material assignment related data in SAP. It comes under the package OII.

SAP OIIGMMM table

Table OIIGMMM technical data

TableOIIGMMM
Data storingGMM: Meter/Material assignment
ModuleIS-OIL
Sub ModuleIS-OIL-DS-BDR
SAP PackageOII
Delivery ClassA – Application table (master and transaction data)
ComponentIS-OIL
Table CategoryTRANSP

SAP OIIGMMM Table Fields

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • GMMNR : GMM: Number of general meter
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • FTMSTM : From/start time stamp (BDRP)
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 14
  • TTMSTM : To/end timestamp (BDRP)
    Its data type is NUMC (Character String with Digits Only) with field length 14
  • MATNR : Material Number
    Its data type is CHAR (Character String) with field length 18
  • MATKL : Material Group
    Its data type is CHAR (Character String) with field length 9
  • .INCLUDE : Standard status field set (BDRP)
  • ERDAT : Date record created
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • ERZEIT : Time record created
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • ERNAM : User who created record
    Its data type is CHAR (Character String) with field length 12
  • AEDAT : Date record changed
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • AEZEIT : Time record changed
    Its data type is TIMS (Time (Time: HHMMSS)) with field length 6
  • AENAM : User who changed record
    Its data type is CHAR (Character String) with field length 12
  • BLOIND : Blocking indicator
    Its data type is CHAR (Character String) with field length 1
  • DELIND : Deletion indicator
    Its data type is CHAR (Character String) with field length 1