FAGL_MIG_OPITEMS SAP table for – Open Items from Period 0 (Creation of Split Information)

Here we would like to draw your attention to FAGL_MIG_OPITEMS table in SAP. As we know it is being mainly used with the SAP FI-GL (General Ledger Accounting in FI) component which is coming under FI module (Financial Accounting). FAGL_MIG_OPITEMS is a SAP standard transp table used for storing Open Items from Period 0 (Creation of Split Information) related data in SAP. It comes under the package FAGL_MIG_CONVERSION.

SAP FAGL_MIG_OPITEMS table

Table FAGL_MIG_OPITEMS technical data

TableFAGL_MIG_OPITEMS
Data storingOpen Items from Period 0 (Creation of Split Information)
ModuleFI
Sub ModuleFI-GL
SAP PackageFAGL_MIG_CONVERSION
Delivery ClassL – Table for storing temporary data
ComponentSAP_FIN
Table CategoryTRANSP

SAP FAGL_MIG_OPITEMS 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 FAGL_MIG_OPITEMS table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • MGPLN : Migration Plan
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • BUKRS : Company Code
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • BELNR : Accounting Document Number
    Its a key field. Its data type is CHAR (Character String) with field length 10
  • GJAHR : Fiscal Year
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 4
  • BUZEI : Number of Line Item Within Accounting Document
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 3
  • .INCLUDE : Structure of Accounts for Open Item Migration
  • HKONT : General Ledger Account
    Its data type is CHAR (Character String) with field length 10
  • .INCLUDE : Status Fields of FAGL_MIG_OPITEMS
  • STATUS_OPITEM : Migration Status for an Open Item
    Its data type is CHAR (Character String) with field length 2
  • MSGID : Class of a Message for a Migration Object
    Its data type is CHAR (Character String) with field length 20
  • MSGNO : Number of Message for a Migration Object
    Its data type is NUMC (Character String with Digits Only) with field length 3
  • MSGTY : Type of Message for a Migration Object
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Extended Message Fields
  • MSGV1 : Message Variable
    Its data type is CHAR (Character String) with field length 50
  • MSGV2 : Message Variable
    Its data type is CHAR (Character String) with field length 50
  • MSGV3 : Message Variable
    Its data type is CHAR (Character String) with field length 50
  • MSGV4 : Message Variable
    Its data type is CHAR (Character String) with field length 50
  • TIMESTAMP : Time of Status Change in Worklist
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 15