MSEG SAP table for – Document Segment: Material

Here we would like to draw your attention to MSEG table in SAP. As we know it is being mainly used with the SAP MM-IM (Inventory Management in MM) component which is coming under MM module (Material Management). MSEG is a SAP standard transparent table used for storing Document Segment: Material related data in SAP. It comes under the package MB.

SAP MSEG table

Table MSEG technical data

TableMSEG
Data storingDocument Segment: Material
ModuleMM
ComponentMM-IM
SAP PackageMB
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

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

  • BWART : Movement type (inventory management)
    Its data type is C (Character String) with field length 3
  • VSCHN
    Its data type is C (Character String) with field length 1
  • DYPLA
    Its data type is C (Character String) with field length 1
  • TANUM
    Its data type is N (Character String with Digits Only) with field length 10
  • GRUND : Reason for movement
    Its data type is N (Character String with Digits Only) with field length 4
  • EVERE
    Its data type is C (Character String) with field length 2
  • IMKEY : Internal Key for Real Estate Object
    Its data type is C (Character String) with field length 8
  • PRCTR : Profit Center
    Its data type is C (Character String) with field length 10
  • AUFPL : Routing number of operations in the order
    Its data type is N (Character String with Digits Only) with field length 10
  • AUFPS : Order item number
    Its data type is N (Character String with Digits Only) with field length 4
  • VPTNR : Partner account number
    Its data type is C (Character String) with field length 10
  • MATNR : Material Number
    Its data type is C (Character String) with field length 18
  • SAKTO : Cost Element
    Its data type is C (Character String) with field length 10
  • EMLIF
    Its data type is C (Character String) with field length 10
  • VKWRT
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • ZEKKN : Sequential Number of Account Assignment
    Its data type is N (Character String with Digits Only) with field length 2
  • CUOBJ_CH
    Its data type is N (Character String with Digits Only) with field length 18
  • EXVKW
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • RSART : Record type
    Its data type is C (Character String) with field length 1
  • FISTL : Funds Center
    Its data type is C (Character String) with field length 16
  • MATBF
    Its data type is C (Character String) with field length 18
  • UMMAB
    Its data type is C (Character String) with field length 18
  • LGORT : Storage location
    Its data type is C (Character String) with field length 4
  • BUSTW : Posting string for values
    Its data type is C (Character String) with field length 4
  • LBKUM
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • SALK3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • DABRBZ
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • XBEAU
    Its data type is C (Character String) with field length 1
  • LSMNG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • KZBWS : Valuation of Special Stock
    Its data type is C (Character String) with field length 1
  • URZEI
    Its data type is N (Character String with Digits Only) with field length 4
  • J_1BEXBASE
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • TXJCD : Tax Jurisdiction
    Its data type is C (Character String) with field length 15
  • INSMK : Stock Type
    Its data type is C (Character String) with field length 1
  • VKMWS
    Its data type is C (Character String) with field length 2
  • BERKZ : Material Staging Indicator for Production Supply
    Its data type is C (Character String) with field length 1
  • MAT_KDAUF : Sales order number of valuated sales order stock
    Its data type is C (Character String) with field length 10
  • MAT_PSPNR : Valuated customer stock WBS element
    Its data type is N (Character String with Digits Only) with field length 8
  • BEMOT : Accounting Indicator
    Its data type is C (Character String) with field length 2
  • LLIEF : Supplying Vendor
    Its data type is C (Character String) with field length 10
  • XOBEW
    Its data type is C (Character String) with field length 1
  • ZUSTD_T156M
    Its data type is C (Character String) with field length 1
  • KBLPOS : Earmarked Funds: Document Item
    Its data type is N (Character String with Digits Only) with field length 3
  • XMACC
    Its data type is C (Character String) with field length 1
  • ZUSTD
    Its data type is C (Character String) with field length 1
  • BUDAT_MKPF
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • TCODE2_MKPF
    Its data type is C (Character String) with field length 20
  • VBELP_IM
    Its data type is N (Character String with Digits Only) with field length 6
  • /BEV2/ED_KZ_VER
    Its data type is C (Character String) with field length 1
  • /BEV2/ED_USER
    Its data type is C (Character String) with field length 12
  • /BEV2/ED_AEDAT
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • .INCLU–AP : Extension for Joint Venture Accounting
    Its include structure/component is is JVMSEG
  • OICONDCOD : Joint Venture Indicator (Condition Key)
    Its data type is C (Character String) with field length 2
  • MBLNR : Number of Material Document
    Its a key field. Its data type is C (Character String) with field length 10
  • KUNNR : Customer number
    Its data type is C (Character String) with field length 10
  • KDPOS : Item number in Sales Order
    Its data type is N (Character String with Digits Only) with field length 6
  • PLPLA
    Its data type is C (Character String) with field length 10
  • WAERS : Currency Key
    Its data type is C (Character String) with field length 5
  • BNBTR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • SHKUM
    Its data type is C (Character String) with field length 1
  • DMBUM
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • MENGE : Quantity
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • ERFMG : Quantity in unit of entry
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • BPMNG : Quantity in order price quantity unit
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • ZEILE : Item in material or invoice verification document
    Its a key field. Its data type is N (Character String with Digits Only) with field length 4
  • EBELN : Purchasing Document Number
    Its data type is C (Character String) with field length 10
  • LFBJA
    Its data type is N (Character String with Digits Only) with field length 4
  • LFPOS
    Its data type is N (Character String with Digits Only) with field length 4
  • SMBLN : Number of Material Document
    Its data type is C (Character String) with field length 10
  • ELIKZ : “Delivery Completed” Indicator
    Its data type is C (Character String) with field length 1
  • EQUNR : Equipment Number
    Its data type is C (Character String) with field length 18
  • ABLAD : Unloading Point
    Its data type is C (Character String) with field length 25
  • KOKRS : Controlling Area
    Its data type is C (Character String) with field length 4
  • PARBU : Clearing company code
    Its data type is C (Character String) with field length 4
  • PROJN : Work breakdown structure element (WBS element)
    Its data type is C (Character String) with field length 16
  • LINE_ID : Unique identification of document line
    Its data type is N (Character String with Digits Only) with field length 6
  • ANLN1 : Main Asset Number
    Its data type is C (Character String) with field length 12
  • XSKST
    Its data type is C (Character String) with field length 1
  • XSPRO
    Its data type is C (Character String) with field length 1
  • GJAHR : Fiscal Year
    Its data type is N (Character String with Digits Only) with field length 4
  • XRUEJ
    Its data type is C (Character String) with field length 1
  • BELNR : Accounting Document Number
    Its data type is C (Character String) with field length 10
  • BELUM
    Its data type is C (Character String) with field length 10
  • RSNUM : Number of reservation/dependent requirements
    Its data type is N (Character String with Digits Only) with field length 10
  • KZEAR : Final issue for this reservation
    Its data type is C (Character String) with field length 1
  • KZSTR
    Its data type is C (Character String) with field length 1
  • LINE_DEPTH
    Its data type is N (Character String with Digits Only) with field length 2
  • UMWRK
    Its data type is C (Character String) with field length 4
  • UMCHA
    Its data type is C (Character String) with field length 10
  • UMZUS
    Its data type is C (Character String) with field length 1
  • UMSOK
    Its data type is C (Character String) with field length 1
  • KZVBR : Consumption posting
    Its data type is C (Character String) with field length 1
  • WEUNB : Goods Receipt, Non-Valuated
    Its data type is C (Character String) with field length 1
  • LGTYP : Storage Type
    Its data type is C (Character String) with field length 3
  • LGPLA : Storage Bin
    Its data type is C (Character String) with field length 10
  • BWLVS
    Its data type is N (Character String with Digits Only) with field length 3
  • TBPOS
    Its data type is N (Character String with Digits Only) with field length 4